PREVIEW / stock_1hour / 2017-09-05

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-09-05.parquet
  size:    1.1 MB
  rows:    48,618
  symbols: 2,992

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-09-05 04:00:00	AAPL	Stock	41.0	41.01	40.9375	41.0	52972.0
2017-09-05 05:00:00	AAPL	Stock	40.9825	41.02	40.9825	41.02	7980.0
2017-09-05 06:00:00	AAPL	Stock	40.955	40.955	40.8925	40.8925	18008.0
2017-09-05 07:00:00	AAPL	Stock	40.8925	40.9625	40.8925	40.9475	48040.0
2017-09-05 08:00:00	AAPL	Stock	40.9375	41.0975	40.7875	40.855	469772.0
2017-09-05 09:00:00	AAPL	Stock	40.8625	41.0625	40.83	41.0125	13235192.0
2017-09-05 10:00:00	AAPL	Stock	41.0125	41.0425	40.8912	40.91	13419064.0
2017-09-05 11:00:00	AAPL	Stock	40.91	40.913	40.66	40.7262	12246616.0
2017-09-05 12:00:00	AAPL	Stock	40.725	40.725	40.15	40.2975	24899372.0
2017-09-05 13:00:00	AAPL	Stock	40.2925	40.495	40.14	40.4875	13813064.0
2017-09-05 14:00:00	AAPL	Stock	40.485	40.57	40.4427	40.485	9209720.0
2017-09-05 15:00:00	AAPL	Stock	40.4825	40.5675	40.4	40.52	13769960.0
2017-09-05 16:00:00	AAPL	Stock	40.52	40.5875	40.52	40.58	6233820.0
2017-09-05 17:00:00	AAPL	Stock	40.56	40.5725	40.5025	40.52	97080.0
2017-09-05 18:00:00	AAPL	Stock	40.5375	40.545	40.505	40.5125	46620.0
2017-09-05 19:00:00	AAPL	Stock	40.5225	40.5225	40.505	40.5075	54728.0
2017-09-05 04:00:00	MSFT	Stock	73.78	74.33	73.58	73.88	692.0
2017-09-05 06:00:00	MSFT	Stock	73.82	73.82	73.82	73.82	2779.0
2017-09-05 07:00:00	MSFT	Stock	73.73	73.8	73.73	73.73	1586.0
2017-09-05 08:00:00	MSFT	Stock	73.75	73.75	73.62	73.7	8858.0
2017-09-05 09:00:00	MSFT	Stock	73.68	73.89	73.22	73.84	3264460.0
2017-09-05 10:00:00	MSFT	Stock	73.84	73.89	73.511	73.605	2877710.0
2017-09-05 11:00:00	MSFT	Stock	73.61	73.7	73.455	73.65	1658572.0
2017-09-05 12:00:00	MSFT	Stock	73.66	73.66	73.02	73.29	2950268.0
2017-09-05 13:00:00	MSFT	Stock	73.28	73.35	72.98	73.35	1816861.0
2017-09-05 14:00:00	MSFT	Stock	73.35	73.55	73.32	73.43	1420170.0
2017-09-05 15:00:00	MSFT	Stock	73.43	73.76	73.37	73.63	4276645.0
2017-09-05 16:00:00	MSFT	Stock	73.63	73.69	73.6	73.65	1949056.0
2017-09-05 17:00:00	MSFT	Stock	73.65	73.65	73.62	73.65	3050.0
2017-09-05 18:00:00	MSFT	Stock	73.62	73.62	73.62	73.62	2200.0
2017-09-05 19:00:00	MSFT	Stock	73.62	73.63	73.62	73.63	996.0
2017-09-05 04:00:00	NVDA	Stock	4.2275	4.2458	4.2248	4.2368	145000.0
2017-09-05 05:00:00	NVDA	Stock	4.2288	4.2292	4.2225	4.2225	54280.0
2017-09-05 06:00:00	NVDA	Stock	4.2248	4.2248	4.2055	4.2095	59120.0
2017-09-05 07:00:00	NVDA	Stock	4.2125	4.22	4.2072	4.22	447240.0
2017-09-05 08:00:00	NVDA	Stock	4.2235	4.2712	4.2008	4.2138	3400880.0
2017-09-05 09:00:00	NVDA	Stock	4.2145	4.2175	4.1605	4.2025	126205080.0
2017-09-05 10:00:00	NVDA	Stock	4.2025	4.2138	4.1788	4.183	100670960.0
2017-09-05 11:00:00	NVDA	Stock	4.182	4.1823	4.1628	4.1702	67357720.0
2017-09-05 12:00:00	NVDA	Stock	4.1702	4.1702	4.089	4.12	172747120.0
2017-09-05 13:00:00	NVDA	Stock	4.12	4.1358	4.107	4.1343	60877440.0
2017-09-05 14:00:00	NVDA	Stock	4.1335	4.1509	4.1208	4.1471	63219040.0
2017-09-05 15:00:00	NVDA	Stock	4.1465	4.156	4.1377	4.148	78572240.0
2017-09-05 16:00:00	NVDA	Stock	4.1478	4.153	4.1438	4.15	11927040.0
2017-09-05 17:00:00	NVDA	Stock	4.15	4.1525	4.15	4.1512	270120.0
2017-09-05 18:00:00	NVDA	Stock	4.1523	4.1538	4.15	4.1512	412360.0
2017-09-05 19:00:00	NVDA	Stock	4.1512	4.1538	4.1512	4.1538	104800.0
2017-09-05 04:00:00	AMZN	Stock	48.8945	48.8945	48.866	48.866	6020.0
2017-09-05 06:00:00	AMZN	Stock	48.8895	48.8895	48.8895	48.8895	2920.0
2017-09-05 08:00:00	AMZN	Stock	49.015	49.015	48.7375	48.7895	69060.0

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

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