PREVIEW / stock_1hour / 2016-04-15

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-04-15.parquet
  size:    1.0 MB
  rows:    48,810
  symbols: 3,329

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2016-04-15 04:00:00	AAPL	Stock	27.95	27.9575	27.95	27.9575	7952.0
2016-04-15 05:00:00	AAPL	Stock	27.95	27.97	27.95	27.97	5180.0
2016-04-15 06:00:00	AAPL	Stock	27.945	27.95	27.945	27.95	2800.0
2016-04-15 07:00:00	AAPL	Stock	27.9525	28.025	27.945	27.9525	39424.0
2016-04-15 08:00:00	AAPL	Stock	27.9575	28.045	27.955	27.995	144256.0
2016-04-15 09:00:00	AAPL	Stock	27.9975	28.075	27.91	27.945	20416956.0
2016-04-15 10:00:00	AAPL	Stock	27.945	27.99	27.8775	27.98	12099112.0
2016-04-15 11:00:00	AAPL	Stock	27.98	28.0175	27.96	27.9955	7390488.0
2016-04-15 12:00:00	AAPL	Stock	27.995	28.0	27.94	27.941	5434252.0
2016-04-15 13:00:00	AAPL	Stock	27.9415	27.95	27.445	27.5875	55213276.0
2016-04-15 14:00:00	AAPL	Stock	27.5875	27.6125	27.445	27.57	19977652.0
2016-04-15 15:00:00	AAPL	Stock	27.5675	27.57	27.4325	27.4535	33321048.0
2016-04-15 16:00:00	AAPL	Stock	27.4625	27.9082	27.4375	27.4425	11915108.0
2016-04-15 17:00:00	AAPL	Stock	27.45	27.4625	27.3775	27.3975	1312628.0
2016-04-15 18:00:00	AAPL	Stock	27.3875	27.405	27.3825	27.3975	60480.0
2016-04-15 19:00:00	AAPL	Stock	27.4	27.4	27.39	27.4	68912.0
2016-04-15 07:00:00	MSFT	Stock	55.36	55.36	55.36	55.36	100.0
2016-04-15 08:00:00	MSFT	Stock	55.1	55.37	55.1	55.27	6500.0
2016-04-15 09:00:00	MSFT	Stock	55.26	55.79	55.11	55.77	6598664.0
2016-04-15 10:00:00	MSFT	Stock	55.769	55.92	55.725	55.795	3334292.0
2016-04-15 11:00:00	MSFT	Stock	55.79	55.805	55.68	55.73	2310593.0
2016-04-15 12:00:00	MSFT	Stock	55.74	55.81	55.695	55.75	1442845.0
2016-04-15 13:00:00	MSFT	Stock	55.75	55.76	55.49	55.52	1716028.0
2016-04-15 14:00:00	MSFT	Stock	55.524	55.57	55.39	55.465	2278243.0
2016-04-15 15:00:00	MSFT	Stock	55.467	55.69	55.42	55.64	5112871.0
2016-04-15 16:00:00	MSFT	Stock	55.65	55.65	55.54	55.55	2992326.0
2016-04-15 17:00:00	MSFT	Stock	55.55	55.75	55.55	55.65	324410.0
2016-04-15 18:00:00	MSFT	Stock	55.67	55.69	55.63	55.63	3316.0
2016-04-15 19:00:00	MSFT	Stock	55.65	55.65	55.63	55.65	2580.0
2016-04-15 08:00:00	NVDA	Stock	0.9255	0.9258	0.9135	0.9135	22000.0
2016-04-15 09:00:00	NVDA	Stock	0.9182	0.9352	0.9178	0.9351	56671880.0
2016-04-15 10:00:00	NVDA	Stock	0.9351	0.9365	0.9252	0.9298	52818960.0
2016-04-15 11:00:00	NVDA	Stock	0.9298	0.9348	0.9293	0.93	51134880.0
2016-04-15 12:00:00	NVDA	Stock	0.9298	0.93	0.9275	0.928	41441360.0
2016-04-15 13:00:00	NVDA	Stock	0.9283	0.9294	0.9254	0.9265	54538480.0
2016-04-15 14:00:00	NVDA	Stock	0.9265	0.9273	0.9244	0.9258	33128800.0
2016-04-15 15:00:00	NVDA	Stock	0.9258	0.9288	0.9255	0.9283	90691520.0
2016-04-15 16:00:00	NVDA	Stock	0.9283	0.93	0.9283	0.93	17348840.0
2016-04-15 17:00:00	NVDA	Stock	0.93	0.93	0.93	0.93	12000.0
2016-04-15 18:00:00	NVDA	Stock	0.93	0.93	0.93	0.93	7000.0
2016-04-15 07:00:00	AMZN	Stock	31.0	31.0	30.95	30.97	21720.0
2016-04-15 08:00:00	AMZN	Stock	30.982	31.0375	30.95	31.0375	68920.0
2016-04-15 09:00:00	AMZN	Stock	31.025	31.1088	30.9055	31.093	9687860.0
2016-04-15 10:00:00	AMZN	Stock	31.097	31.2115	31.0805	31.157	8644440.0
2016-04-15 11:00:00	AMZN	Stock	31.152	31.1975	31.0725	31.1115	5536100.0
2016-04-15 12:00:00	AMZN	Stock	31.1035	31.1645	31.095	31.144	2505500.0
2016-04-15 13:00:00	AMZN	Stock	31.147	31.153	31.0805	31.1075	2507680.0
2016-04-15 14:00:00	AMZN	Stock	31.1135	31.249	31.109	31.248	6362640.0
2016-04-15 15:00:00	AMZN	Stock	31.2481	31.3385	31.226	31.299	11598120.0
2016-04-15 16:00:00	AMZN	Stock	31.2945	31.33	31.0422	31.3175	3610600.0

> showing 50 of 48,810 rows — these rows as CSV

> unlock the full archive -- $79 one-time