PREVIEW / stock_1hour / 2017-08-24

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-08-24.parquet
  size:    1.0 MB
  rows:    46,976
  symbols: 2,962

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-08-24 04:00:00	AAPL	Stock	39.95	40.005	39.95	40.005	2000.0
2017-08-24 06:00:00	AAPL	Stock	40.0475	40.0475	40.0475	40.0475	400.0
2017-08-24 07:00:00	AAPL	Stock	40.05	40.1625	40.0375	40.145	61196.0
2017-08-24 08:00:00	AAPL	Stock	40.145	40.1725	40.0375	40.155	203468.0
2017-08-24 09:00:00	AAPL	Stock	40.15	40.185	39.7925	39.85	11216876.0
2017-08-24 10:00:00	AAPL	Stock	39.8475	40.03	39.805	39.935	11535356.0
2017-08-24 11:00:00	AAPL	Stock	39.9375	39.96	39.6375	39.765	13571692.0
2017-08-24 12:00:00	AAPL	Stock	39.7625	39.835	39.705	39.7885	6386668.0
2017-08-24 13:00:00	AAPL	Stock	39.785	39.9025	39.7625	39.8575	6135876.0
2017-08-24 14:00:00	AAPL	Stock	39.8575	39.8825	39.7325	39.8725	5590364.0
2017-08-24 15:00:00	AAPL	Stock	39.87	39.91	39.775	39.8275	10097316.0
2017-08-24 16:00:00	AAPL	Stock	39.82	39.85	39.78	39.8375	5987332.0
2017-08-24 17:00:00	AAPL	Stock	39.8375	39.8725	39.8175	39.85	118320.0
2017-08-24 18:00:00	AAPL	Stock	39.85	39.85	39.84	39.85	10216.0
2017-08-24 19:00:00	AAPL	Stock	39.85	39.85	39.83	39.83	8260.0
2017-08-24 04:00:00	MSFT	Stock	72.72	72.72	72.72	72.72	100.0
2017-08-24 07:00:00	MSFT	Stock	73.05	73.05	73.05	73.05	100.0
2017-08-24 08:00:00	MSFT	Stock	72.91	72.98	72.91	72.98	2703.0
2017-08-24 09:00:00	MSFT	Stock	72.97	72.97	72.57	72.625	1792304.0
2017-08-24 10:00:00	MSFT	Stock	72.63	72.77	72.47	72.68	1711200.0
2017-08-24 11:00:00	MSFT	Stock	72.69	72.725	72.07	72.3	1922946.0
2017-08-24 12:00:00	MSFT	Stock	72.295	72.395	72.145	72.375	1036405.0
2017-08-24 13:00:00	MSFT	Stock	72.37	72.62	72.34	72.57	926429.0
2017-08-24 14:00:00	MSFT	Stock	72.56	72.7	72.48	72.66	1164333.0
2017-08-24 15:00:00	MSFT	Stock	72.665	72.78	72.55	72.7	2448005.0
2017-08-24 16:00:00	MSFT	Stock	72.69	72.8	72.65	72.69	3997392.0
2017-08-24 17:00:00	MSFT	Stock	72.75	72.75	72.75	72.75	300.0
2017-08-24 18:00:00	MSFT	Stock	72.8	72.8	72.8	72.8	140.0
2017-08-24 19:00:00	MSFT	Stock	72.8	72.8	72.75	72.75	575.0
2017-08-24 04:00:00	NVDA	Stock	4.1398	4.152	4.1398	4.152	59840.0
2017-08-24 05:00:00	NVDA	Stock	4.1542	4.1542	4.1542	4.1542	4000.0
2017-08-24 06:00:00	NVDA	Stock	4.1625	4.1625	4.1625	4.1625	16000.0
2017-08-24 07:00:00	NVDA	Stock	4.1612	4.1672	4.16	4.1625	208480.0
2017-08-24 08:00:00	NVDA	Stock	4.165	4.18	4.16	4.179	2714640.0
2017-08-24 09:00:00	NVDA	Stock	4.1798	4.182	4.1258	4.1343	89235600.0
2017-08-24 10:00:00	NVDA	Stock	4.1352	4.1675	4.1328	4.14	78484720.0
2017-08-24 11:00:00	NVDA	Stock	4.1403	4.1452	4.103	4.1263	82252280.0
2017-08-24 12:00:00	NVDA	Stock	4.127	4.1398	4.1085	4.1305	38364880.0
2017-08-24 13:00:00	NVDA	Stock	4.129	4.1425	4.124	4.1314	32213560.0
2017-08-24 14:00:00	NVDA	Stock	4.1308	4.1566	4.1255	4.1539	49608200.0
2017-08-24 15:00:00	NVDA	Stock	4.1532	4.1545	4.1265	4.13	67467560.0
2017-08-24 16:00:00	NVDA	Stock	4.1298	4.134	4.113	4.1275	15499480.0
2017-08-24 17:00:00	NVDA	Stock	4.125	4.1298	4.1225	4.123	323360.0
2017-08-24 18:00:00	NVDA	Stock	4.125	4.1298	4.124	4.1298	267560.0
2017-08-24 19:00:00	NVDA	Stock	4.1255	4.1298	4.1153	4.1153	303680.0
2017-08-24 07:00:00	AMZN	Stock	47.95	48.0055	47.95	48.0055	8000.0
2017-08-24 08:00:00	AMZN	Stock	48.0365	48.075	47.975	48.0	239820.0
2017-08-24 09:00:00	AMZN	Stock	48.0395	48.075	47.4005	47.4743	15922000.0
2017-08-24 10:00:00	AMZN	Stock	47.47	47.6	47.176	47.5012	12496760.0
2017-08-24 11:00:00	AMZN	Stock	47.492	47.5035	47.057	47.132	10944860.0

> showing 50 of 46,976 rows — these rows as CSV

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