PREVIEW / stock_1hour / 2016-02-10

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-02-10.parquet
  size:    1.0 MB
  rows:    48,222
  symbols: 3,350

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-02-10 04:00:00	AAPL	Stock	23.93	23.9875	23.785	23.9625	5900.0
2016-02-10 05:00:00	AAPL	Stock	23.9625	24.0575	23.9525	23.9525	19772.0
2016-02-10 06:00:00	AAPL	Stock	23.95	24.05	23.95	24.0	12080.0
2016-02-10 07:00:00	AAPL	Stock	24.0225	24.0375	23.97	24.03	58080.0
2016-02-10 08:00:00	AAPL	Stock	24.0175	24.1675	24.005	24.0325	1083280.0
2016-02-10 09:00:00	AAPL	Stock	24.045	24.0538	23.8398	24.04	17851120.0
2016-02-10 10:00:00	AAPL	Stock	24.04	24.0875	23.805	23.8375	27517596.0
2016-02-10 11:00:00	AAPL	Stock	23.84	23.9075	23.745	23.815	19916488.0
2016-02-10 12:00:00	AAPL	Stock	23.815	23.9075	23.7875	23.8975	16003760.0
2016-02-10 13:00:00	AAPL	Stock	23.9	23.95	23.78	23.79	13840500.0
2016-02-10 14:00:00	AAPL	Stock	23.79	23.86	23.6925	23.7125	23523968.0
2016-02-10 15:00:00	AAPL	Stock	23.7125	23.8075	23.525	23.5675	30576504.0
2016-02-10 16:00:00	AAPL	Stock	23.5675	23.7398	23.535	23.5475	8213080.0
2016-02-10 17:00:00	AAPL	Stock	23.5375	23.585	23.5375	23.5625	85440.0
2016-02-10 18:00:00	AAPL	Stock	23.58	23.58	23.525	23.53	38584.0
2016-02-10 19:00:00	AAPL	Stock	23.5475	23.5475	23.5	23.5	83424.0
2016-02-10 04:00:00	MSFT	Stock	49.8	49.8	49.8	49.8	600.0
2016-02-10 05:00:00	MSFT	Stock	49.99	50.0	49.99	50.0	1100.0
2016-02-10 06:00:00	MSFT	Stock	49.99	49.99	49.99	49.99	100.0
2016-02-10 07:00:00	MSFT	Stock	49.93	50.04	49.74	50.04	14491.0
2016-02-10 08:00:00	MSFT	Stock	49.99	50.1	49.75	49.88	16433.0
2016-02-10 09:00:00	MSFT	Stock	49.88	50.34	49.65	50.305	6341723.0
2016-02-10 10:00:00	MSFT	Stock	50.3	50.39	49.72	49.83	6878331.0
2016-02-10 11:00:00	MSFT	Stock	49.84	50.04	49.72	49.94	4258459.0
2016-02-10 12:00:00	MSFT	Stock	49.95	50.23	49.79	50.2	3661605.0
2016-02-10 13:00:00	MSFT	Stock	50.21	50.34	50.02	50.215	3054420.0
2016-02-10 14:00:00	MSFT	Stock	50.22	50.36	49.89	49.98	3093057.0
2016-02-10 15:00:00	MSFT	Stock	49.985	50.25	49.52	49.69	6441304.0
2016-02-10 16:00:00	MSFT	Stock	49.71	49.86	49.63	49.66	1677511.0
2016-02-10 17:00:00	MSFT	Stock	49.71	49.75	49.67	49.67	1100.0
2016-02-10 18:00:00	MSFT	Stock	49.7	49.75	49.58	49.58	2593.0
2016-02-10 19:00:00	MSFT	Stock	49.69	49.69	49.54	49.65	1550.0
2016-02-10 04:00:00	NVDA	Stock	0.6372	0.6412	0.6188	0.6412	160280.0
2016-02-10 05:00:00	NVDA	Stock	0.642	0.65	0.642	0.65	124000.0
2016-02-10 07:00:00	NVDA	Stock	0.65	0.65	0.65	0.65	8000.0
2016-02-10 08:00:00	NVDA	Stock	0.645	0.645	0.6438	0.6438	69920.0
2016-02-10 09:00:00	NVDA	Stock	0.6423	0.6465	0.6322	0.6455	39546800.0
2016-02-10 10:00:00	NVDA	Stock	0.6452	0.6598	0.641	0.6423	90862920.0
2016-02-10 11:00:00	NVDA	Stock	0.6425	0.645	0.6358	0.6378	39380600.0
2016-02-10 12:00:00	NVDA	Stock	0.6379	0.6448	0.6343	0.644	27487240.0
2016-02-10 13:00:00	NVDA	Stock	0.6442	0.6458	0.6368	0.6385	25494040.0
2016-02-10 14:00:00	NVDA	Stock	0.6385	0.6458	0.6378	0.6383	33601640.0
2016-02-10 15:00:00	NVDA	Stock	0.6385	0.6418	0.633	0.6362	61203840.0
2016-02-10 16:00:00	NVDA	Stock	0.6362	0.6362	0.6345	0.6345	6671400.0
2016-02-10 04:00:00	AMZN	Stock	24.474	24.4745	24.474	24.4745	6560.0
2016-02-10 05:00:00	AMZN	Stock	24.5865	24.5965	24.5865	24.5965	4000.0
2016-02-10 06:00:00	AMZN	Stock	24.604	24.62	24.555	24.605	20080.0
2016-02-10 07:00:00	AMZN	Stock	24.555	24.6	24.525	24.5855	189920.0
2016-02-10 08:00:00	AMZN	Stock	24.5555	24.626	24.4165	24.4985	435080.0
2016-02-10 09:00:00	AMZN	Stock	24.4605	24.84	24.3	24.789	17378180.0

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

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