PREVIEW / stock_1hour / 2017-08-23

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-08-23.parquet
  size:    1.0 MB
  rows:    47,347
  symbols: 2,955

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-23 05:00:00	AAPL	Stock	39.965	39.965	39.9375	39.9375	4528.0
2017-08-23 06:00:00	AAPL	Stock	39.8875	39.8875	39.805	39.805	3200.0
2017-08-23 07:00:00	AAPL	Stock	39.8625	39.91	39.8025	39.8025	99348.0
2017-08-23 08:00:00	AAPL	Stock	39.8125	39.8725	39.75	39.785	429912.0
2017-08-23 09:00:00	AAPL	Stock	39.75	40.0625	39.6975	40.0425	11963668.0
2017-08-23 10:00:00	AAPL	Stock	40.04	40.04	39.8825	39.9525	10398004.0
2017-08-23 11:00:00	AAPL	Stock	39.9525	40.105	39.91	40.0808	8928928.0
2017-08-23 12:00:00	AAPL	Stock	40.08	40.1175	39.9525	39.9675	5433772.0
2017-08-23 13:00:00	AAPL	Stock	39.9675	39.98	39.85	39.905	6457472.0
2017-08-23 14:00:00	AAPL	Stock	39.905	40.05	39.9025	40.0325	6916356.0
2017-08-23 15:00:00	AAPL	Stock	40.0338	40.0825	39.9825	39.9975	9719444.0
2017-08-23 16:00:00	AAPL	Stock	39.995	39.995	39.95	39.9825	7363724.0
2017-08-23 17:00:00	AAPL	Stock	39.98	39.995	39.925	39.9375	65968.0
2017-08-23 18:00:00	AAPL	Stock	39.9675	39.9675	39.83	39.83	40448.0
2017-08-23 19:00:00	AAPL	Stock	39.875	39.935	39.8525	39.8525	20296.0
2017-08-23 05:00:00	MSFT	Stock	73.25	73.25	73.1	73.1	1915.0
2017-08-23 06:00:00	MSFT	Stock	73.1	73.1	73.1	73.1	1928.0
2017-08-23 07:00:00	MSFT	Stock	72.96	72.96	72.96	72.96	350.0
2017-08-23 08:00:00	MSFT	Stock	73.0	73.09	72.84	72.88	5192.0
2017-08-23 09:00:00	MSFT	Stock	72.9	73.15	72.79	73.07	1460612.0
2017-08-23 10:00:00	MSFT	Stock	73.07	73.12	72.694	72.71	1895914.0
2017-08-23 11:00:00	MSFT	Stock	72.71	72.91	72.63	72.72	1346200.0
2017-08-23 12:00:00	MSFT	Stock	72.72	72.755	72.55	72.65	872565.0
2017-08-23 13:00:00	MSFT	Stock	72.655	72.68	72.53	72.62	838210.0
2017-08-23 14:00:00	MSFT	Stock	72.61	72.91	72.61	72.85	862402.0
2017-08-23 15:00:00	MSFT	Stock	72.859	72.935	72.71	72.73	2087163.0
2017-08-23 16:00:00	MSFT	Stock	72.72	72.72	72.6	72.72	2611497.0
2017-08-23 17:00:00	MSFT	Stock	72.65	72.65	72.65	72.65	841.0
2017-08-23 18:00:00	MSFT	Stock	72.65	72.65	72.65	72.65	201.0
2017-08-23 19:00:00	MSFT	Stock	72.59	72.59	72.59	72.59	1650.0
2017-08-23 04:00:00	NVDA	Stock	4.0715	4.0715	4.05	4.0635	27000.0
2017-08-23 06:00:00	NVDA	Stock	4.0505	4.0505	4.0505	4.0505	10000.0
2017-08-23 07:00:00	NVDA	Stock	4.0435	4.045	4.025	4.025	410680.0
2017-08-23 08:00:00	NVDA	Stock	4.025	4.045	4.02	4.024	2350920.0
2017-08-23 09:00:00	NVDA	Stock	4.0238	4.0935	4.02	4.087	84510000.0
2017-08-23 10:00:00	NVDA	Stock	4.0875	4.115	4.06	4.1004	112106240.0
2017-08-23 11:00:00	NVDA	Stock	4.1006	4.1358	4.1	4.1302	82596480.0
2017-08-23 12:00:00	NVDA	Stock	4.131	4.137	4.1212	4.1335	46123120.0
2017-08-23 13:00:00	NVDA	Stock	4.134	4.136	4.1085	4.1175	35590680.0
2017-08-23 14:00:00	NVDA	Stock	4.1175	4.1418	4.1172	4.1338	48377840.0
2017-08-23 15:00:00	NVDA	Stock	4.1332	4.1562	4.1305	4.1445	80059800.0
2017-08-23 16:00:00	NVDA	Stock	4.145	4.145	4.1377	4.142	35099040.0
2017-08-23 17:00:00	NVDA	Stock	4.1398	4.143	4.1375	4.1375	228160.0
2017-08-23 18:00:00	NVDA	Stock	4.139	4.1392	4.13	4.1318	480640.0
2017-08-23 19:00:00	NVDA	Stock	4.135	4.1362	4.1268	4.1268	398480.0
2017-08-23 04:00:00	AMZN	Stock	48.2125	48.2125	48.2125	48.2125	8000.0
2017-08-23 05:00:00	AMZN	Stock	48.292	48.292	48.292	48.292	3300.0
2017-08-23 06:00:00	AMZN	Stock	48.191	48.2	48.158	48.163	31240.0
2017-08-23 07:00:00	AMZN	Stock	48.175	48.175	47.95	48.0	45080.0
2017-08-23 08:00:00	AMZN	Stock	48.0	48.1745	47.9	47.9005	152740.0

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

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