PREVIEW / stock_1hour / 2017-01-11

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-01-11.parquet
  size:    1.0 MB
  rows:    47,900
  symbols: 3,128

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
2017-01-11 04:00:00	AAPL	Stock	29.7775	29.7775	29.7175	29.7175	2000.0
2017-01-11 06:00:00	AAPL	Stock	29.695	29.7375	29.695	29.7375	4284.0
2017-01-11 07:00:00	AAPL	Stock	29.7125	29.7225	29.6875	29.6875	65576.0
2017-01-11 08:00:00	AAPL	Stock	29.715	29.745	29.6875	29.705	123944.0
2017-01-11 09:00:00	AAPL	Stock	29.7025	29.84	29.655	29.7888	14775032.0
2017-01-11 10:00:00	AAPL	Stock	29.7882	29.79	29.7075	29.7425	10074068.0
2017-01-11 11:00:00	AAPL	Stock	29.7425	29.7875	29.6525	29.7638	11769260.0
2017-01-11 12:00:00	AAPL	Stock	29.765	29.7725	29.66	29.74	9067024.0
2017-01-11 13:00:00	AAPL	Stock	29.7375	29.75	29.65	29.73	9378712.0
2017-01-11 14:00:00	AAPL	Stock	29.7318	29.9595	29.7275	29.956	18372060.0
2017-01-11 15:00:00	AAPL	Stock	29.9555	29.9825	29.9062	29.9325	19021672.0
2017-01-11 16:00:00	AAPL	Stock	29.9375	29.95	29.925	29.9425	9779828.0
2017-01-11 17:00:00	AAPL	Stock	29.945	29.9475	29.9375	29.9425	22216.0
2017-01-11 18:00:00	AAPL	Stock	29.9375	29.94	29.925	29.935	21896.0
2017-01-11 19:00:00	AAPL	Stock	29.925	29.9375	29.925	29.9375	34140.0
2017-01-11 04:00:00	MSFT	Stock	62.7	62.7	62.7	62.7	100.0
2017-01-11 05:00:00	MSFT	Stock	62.61	62.61	62.61	62.61	162.0
2017-01-11 08:00:00	MSFT	Stock	62.77	62.78	62.62	62.78	1878.0
2017-01-11 09:00:00	MSFT	Stock	62.78	62.95	62.43	62.925	2029478.0
2017-01-11 10:00:00	MSFT	Stock	62.925	63.11	62.76	63.09	2805837.0
2017-01-11 11:00:00	MSFT	Stock	63.1	63.145	62.73	63.105	2769781.0
2017-01-11 12:00:00	MSFT	Stock	63.11	63.19	62.92	63.03	1846878.0
2017-01-11 13:00:00	MSFT	Stock	63.035	63.036	62.715	62.94	2140590.0
2017-01-11 14:00:00	MSFT	Stock	62.94	63.23	62.92	63.15	1621496.0
2017-01-11 15:00:00	MSFT	Stock	63.14	63.19	63.08	63.16	4020590.0
2017-01-11 16:00:00	MSFT	Stock	63.19	63.19	63.12	63.12	2916713.0
2017-01-11 17:00:00	MSFT	Stock	63.12	63.19	63.12	63.19	19500.0
2017-01-11 18:00:00	MSFT	Stock	63.1	63.1	63.1	63.1	1600.0
2017-01-11 19:00:00	MSFT	Stock	63.11	63.11	63.1	63.1	400.0
2017-01-11 07:00:00	NVDA	Stock	2.6628	2.6628	2.6628	2.6628	13280.0
2017-01-11 08:00:00	NVDA	Stock	2.6588	2.665	2.65	2.6648	783680.0
2017-01-11 09:00:00	NVDA	Stock	2.6648	2.665	2.6062	2.6398	95103120.0
2017-01-11 10:00:00	NVDA	Stock	2.6413	2.655	2.6233	2.645	85985600.0
2017-01-11 11:00:00	NVDA	Stock	2.6455	2.651	2.6255	2.6442	62847400.0
2017-01-11 12:00:00	NVDA	Stock	2.6438	2.6485	2.6318	2.6388	34229560.0
2017-01-11 13:00:00	NVDA	Stock	2.6388	2.6392	2.6038	2.6149	61084040.0
2017-01-11 14:00:00	NVDA	Stock	2.615	2.6223	2.6095	2.6197	48801800.0
2017-01-11 15:00:00	NVDA	Stock	2.6192	2.6318	2.6173	2.629	72030600.0
2017-01-11 16:00:00	NVDA	Stock	2.629	2.629	2.625	2.6275	6939480.0
2017-01-11 17:00:00	NVDA	Stock	2.6275	2.631	2.6275	2.629	182840.0
2017-01-11 18:00:00	NVDA	Stock	2.6303	2.6303	2.6288	2.629	36000.0
2017-01-11 19:00:00	NVDA	Stock	2.629	2.629	2.624	2.624	344000.0
2017-01-11 06:00:00	AMZN	Stock	39.825	39.825	39.825	39.825	6000.0
2017-01-11 08:00:00	AMZN	Stock	39.805	39.8315	39.725	39.765	95160.0
2017-01-11 09:00:00	AMZN	Stock	39.7575	39.8295	39.533	39.5895	6064920.0
2017-01-11 10:00:00	AMZN	Stock	39.5895	39.699	39.4775	39.6324	8960460.0
2017-01-11 11:00:00	AMZN	Stock	39.6285	39.75	39.4755	39.7404	8104400.0
2017-01-11 12:00:00	AMZN	Stock	39.741	39.825	39.627	39.682	5178040.0
2017-01-11 13:00:00	AMZN	Stock	39.6836	39.7615	39.5785	39.7145	4230580.0
2017-01-11 14:00:00	AMZN	Stock	39.7145	39.975	39.6825	39.94	5404700.0

> showing 50 of 47,900 rows — these rows as CSV

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