PREVIEW / stock_1hour / 2018-03-19

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-03-19.parquet
  size:    1.1 MB
  rows:    49,319
  symbols: 2,883

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
2018-03-19 04:00:00	AAPL	Stock	44.25	44.25	43.8	43.8725	30592.0
2018-03-19 05:00:00	AAPL	Stock	43.9125	43.9825	43.9125	43.9125	8864.0
2018-03-19 06:00:00	AAPL	Stock	43.8825	43.9575	43.8775	43.9575	6044.0
2018-03-19 07:00:00	AAPL	Stock	43.9675	44.215	43.9375	44.175	323816.0
2018-03-19 08:00:00	AAPL	Stock	44.005	44.36	43.96	44.3075	470264.0
2018-03-19 09:00:00	AAPL	Stock	44.305	44.3675	44.0725	44.2025	13339540.0
2018-03-19 10:00:00	AAPL	Stock	44.2025	44.22	43.895	43.96	14053740.0
2018-03-19 11:00:00	AAPL	Stock	43.9575	44.0075	43.6275	43.6675	15344300.0
2018-03-19 12:00:00	AAPL	Stock	43.67	43.8475	43.5075	43.63	15743060.0
2018-03-19 13:00:00	AAPL	Stock	43.6275	43.6872	43.415	43.6275	12889776.0
2018-03-19 14:00:00	AAPL	Stock	43.625	43.72	43.4575	43.66	11630256.0
2018-03-19 15:00:00	AAPL	Stock	43.6548	43.855	43.58	43.83	21564332.0
2018-03-19 16:00:00	AAPL	Stock	43.8275	43.97	43.815	43.935	12074448.0
2018-03-19 17:00:00	AAPL	Stock	43.925	43.925	43.845	43.875	78232.0
2018-03-19 18:00:00	AAPL	Stock	43.875	43.875	43.83	43.83	40456.0
2018-03-19 19:00:00	AAPL	Stock	43.85	43.85	43.6875	43.6875	43060.0
2018-03-19 04:00:00	MSFT	Stock	94.06	94.06	93.53	93.53	2000.0
2018-03-19 06:00:00	MSFT	Stock	93.64	93.64	93.55	93.57	1489.0
2018-03-19 07:00:00	MSFT	Stock	93.68	93.7	93.2	93.6	40106.0
2018-03-19 08:00:00	MSFT	Stock	93.4	93.77	93.26	93.67	14480.0
2018-03-19 09:00:00	MSFT	Stock	93.65	93.96	93.19	93.52	3401534.0
2018-03-19 10:00:00	MSFT	Stock	93.525	93.6	92.735	92.845	3173587.0
2018-03-19 11:00:00	MSFT	Stock	92.84	92.95	92.42	92.59	3424470.0
2018-03-19 12:00:00	MSFT	Stock	92.59	92.9	92.44	92.774	3189499.0
2018-03-19 13:00:00	MSFT	Stock	92.77	92.88	92.24	92.492	2954653.0
2018-03-19 14:00:00	MSFT	Stock	92.5	92.75	92.11	92.585	2807286.0
2018-03-19 15:00:00	MSFT	Stock	92.585	93.08	92.45	92.96	6716561.0
2018-03-19 16:00:00	MSFT	Stock	92.89	93.54	92.89	93.24	3479196.0
2018-03-19 17:00:00	MSFT	Stock	93.24	93.35	93.15	93.18	5493.0
2018-03-19 18:00:00	MSFT	Stock	93.15	93.15	93.06	93.15	2902.0
2018-03-19 19:00:00	MSFT	Stock	93.05	93.15	92.85	92.89	9955.0
2018-03-19 04:00:00	NVDA	Stock	6.2248	6.225	6.1873	6.1875	111400.0
2018-03-19 05:00:00	NVDA	Stock	6.1875	6.195	6.17	6.1708	179360.0
2018-03-19 06:00:00	NVDA	Stock	6.1722	6.1788	6.1528	6.1562	71200.0
2018-03-19 07:00:00	NVDA	Stock	6.1625	6.18	6.15	6.18	692240.0
2018-03-19 08:00:00	NVDA	Stock	6.165	6.2025	6.1513	6.1988	1589720.0
2018-03-19 09:00:00	NVDA	Stock	6.1962	6.2338	6.1583	6.2025	63132760.0
2018-03-19 10:00:00	NVDA	Stock	6.2008	6.214	6.117	6.1393	59993440.0
2018-03-19 11:00:00	NVDA	Stock	6.1369	6.145	6.0025	6.0195	100014200.0
2018-03-19 12:00:00	NVDA	Stock	6.0187	6.0562	5.944	6.0026	98674800.0
2018-03-19 13:00:00	NVDA	Stock	6.0025	6.0132	5.9475	6.0025	62135720.0
2018-03-19 14:00:00	NVDA	Stock	6.0018	6.0138	5.925	5.9765	60492040.0
2018-03-19 15:00:00	NVDA	Stock	5.9762	6.0305	5.9578	6.0248	80124920.0
2018-03-19 16:00:00	NVDA	Stock	6.025	6.05	6.024	6.0485	25667160.0
2018-03-19 17:00:00	NVDA	Stock	6.0472	6.0472	6.0375	6.0438	282560.0
2018-03-19 18:00:00	NVDA	Stock	6.0362	6.0375	6.025	6.025	1058280.0
2018-03-19 19:00:00	NVDA	Stock	6.025	6.025	6.0075	6.0075	160760.0
2018-03-19 04:00:00	AMZN	Stock	77.4155	77.49	77.4155	77.49	4140.0
2018-03-19 05:00:00	AMZN	Stock	77.7445	77.7445	77.642	77.699	15760.0
2018-03-19 06:00:00	AMZN	Stock	77.699	77.75	77.575	77.6	54260.0

> showing 50 of 49,319 rows — these rows as CSV

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