PREVIEW / stock_1hour / 2017-03-06

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-03-06.parquet
  size:    1.1 MB
  rows:    50,081
  symbols: 3,097

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-03-06 04:00:00	AAPL	Stock	34.85	34.8725	34.845	34.8725	3828.0
2017-03-06 05:00:00	AAPL	Stock	34.8125	34.86	34.8125	34.86	3632.0
2017-03-06 06:00:00	AAPL	Stock	34.875	34.885	34.84	34.84	7112.0
2017-03-06 07:00:00	AAPL	Stock	34.85	34.8625	34.815	34.8375	49916.0
2017-03-06 08:00:00	AAPL	Stock	34.825	34.8675	34.825	34.8575	126192.0
2017-03-06 09:00:00	AAPL	Stock	34.8575	34.9425	34.7712	34.8175	12199892.0
2017-03-06 10:00:00	AAPL	Stock	34.8182	34.8182	34.665	34.67	12924696.0
2017-03-06 11:00:00	AAPL	Stock	34.6725	34.73	34.65	34.6775	6729820.0
2017-03-06 12:00:00	AAPL	Stock	34.676	34.7225	34.649	34.715	5763300.0
2017-03-06 13:00:00	AAPL	Stock	34.7162	34.8375	34.715	34.8225	8565748.0
2017-03-06 14:00:00	AAPL	Stock	34.822	34.8575	34.8025	34.8375	4765112.0
2017-03-06 15:00:00	AAPL	Stock	34.8375	34.885	34.815	34.83	9373024.0
2017-03-06 16:00:00	AAPL	Stock	34.835	34.8625	34.835	34.8425	7965288.0
2017-03-06 17:00:00	AAPL	Stock	34.84	34.84	34.8325	34.835	25720.0
2017-03-06 18:00:00	AAPL	Stock	34.82	34.835	34.82	34.835	8456.0
2017-03-06 19:00:00	AAPL	Stock	34.83	34.85	34.82	34.8375	15576.0
2017-03-06 04:00:00	MSFT	Stock	64.0	64.0	64.0	64.0	500.0
2017-03-06 07:00:00	MSFT	Stock	64.19	64.19	64.15	64.15	2904.0
2017-03-06 08:00:00	MSFT	Stock	64.02	64.15	64.02	64.02	1818.0
2017-03-06 09:00:00	MSFT	Stock	64.04	64.35	63.81	64.24	1897171.0
2017-03-06 10:00:00	MSFT	Stock	64.24	64.31	64.045	64.17	2020897.0
2017-03-06 11:00:00	MSFT	Stock	64.17	64.3	64.13	64.27	1182300.0
2017-03-06 12:00:00	MSFT	Stock	64.27	64.44	64.24	64.37	1719260.0
2017-03-06 13:00:00	MSFT	Stock	64.38	64.56	64.37	64.455	1785980.0
2017-03-06 14:00:00	MSFT	Stock	64.46	64.48	64.42	64.45	1481679.0
2017-03-06 15:00:00	MSFT	Stock	64.45	64.48	64.25	64.27	3460270.0
2017-03-06 16:00:00	MSFT	Stock	64.27	64.4	64.25	64.34	2678884.0
2017-03-06 17:00:00	MSFT	Stock	64.26	64.26	64.24	64.24	200.0
2017-03-06 18:00:00	MSFT	Stock	64.24	64.25	64.24	64.25	1689.0
2017-03-06 19:00:00	MSFT	Stock	64.22	64.22	64.22	64.22	200.0
2017-03-06 04:00:00	NVDA	Stock	2.4425	2.4425	2.4425	2.4425	8000.0
2017-03-06 06:00:00	NVDA	Stock	2.44	2.44	2.4378	2.4378	24000.0
2017-03-06 07:00:00	NVDA	Stock	2.435	2.4425	2.435	2.4375	518040.0
2017-03-06 08:00:00	NVDA	Stock	2.4372	2.4462	2.4338	2.434	1606120.0
2017-03-06 09:00:00	NVDA	Stock	2.4343	2.4368	2.393	2.4096	153840120.0
2017-03-06 10:00:00	NVDA	Stock	2.409	2.422	2.3902	2.3992	185826200.0
2017-03-06 11:00:00	NVDA	Stock	2.3992	2.4025	2.3793	2.391	115726840.0
2017-03-06 12:00:00	NVDA	Stock	2.391	2.3992	2.3853	2.3932	76938680.0
2017-03-06 13:00:00	NVDA	Stock	2.3936	2.4137	2.3914	2.4123	87282480.0
2017-03-06 14:00:00	NVDA	Stock	2.4118	2.4283	2.4115	2.4239	77572600.0
2017-03-06 15:00:00	NVDA	Stock	2.4238	2.4525	2.4208	2.4415	161437800.0
2017-03-06 16:00:00	NVDA	Stock	2.4418	2.4425	2.4375	2.4398	1643400.0
2017-03-06 17:00:00	NVDA	Stock	2.4378	2.442	2.4378	2.44	318240.0
2017-03-06 18:00:00	NVDA	Stock	2.4388	2.44	2.4388	2.44	127800.0
2017-03-06 19:00:00	NVDA	Stock	2.4388	2.4388	2.4375	2.4375	102600.0
2017-03-06 07:00:00	AMZN	Stock	42.4	42.4	42.4	42.4	2000.0
2017-03-06 08:00:00	AMZN	Stock	42.3535	42.4	42.3125	42.35	53840.0
2017-03-06 09:00:00	AMZN	Stock	42.351	42.4245	42.199	42.237	8228980.0
2017-03-06 10:00:00	AMZN	Stock	42.235	42.2645	42.075	42.1255	7982260.0
2017-03-06 11:00:00	AMZN	Stock	42.1295	42.13	42.056	42.0975	5249160.0

> showing 50 of 50,081 rows — these rows as CSV

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