PREVIEW / stock_1hour / 2019-01-16

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-01-16.parquet
  size:    1.1 MB
  rows:    49,867
  symbols: 2,684

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
2019-01-16 04:00:00	AAPL	Stock	38.375	38.415	38.275	38.275	13272.0
2019-01-16 05:00:00	AAPL	Stock	38.3025	38.3025	38.235	38.235	7788.0
2019-01-16 06:00:00	AAPL	Stock	38.205	38.2375	38.15	38.2375	10888.0
2019-01-16 07:00:00	AAPL	Stock	38.2475	38.35	38.195	38.3	161048.0
2019-01-16 08:00:00	AAPL	Stock	38.275	38.345	38.2	38.23	553840.0
2019-01-16 09:00:00	AAPL	Stock	38.2325	38.97	38.19	38.8125	20859160.0
2019-01-16 10:00:00	AAPL	Stock	38.813	38.9375	38.5825	38.73	21340036.0
2019-01-16 11:00:00	AAPL	Stock	38.7325	38.8475	38.5975	38.6862	12850944.0
2019-01-16 12:00:00	AAPL	Stock	38.6875	38.7925	38.625	38.7775	7616776.0
2019-01-16 13:00:00	AAPL	Stock	38.7775	38.8375	38.6825	38.8175	7362396.0
2019-01-16 14:00:00	AAPL	Stock	38.816	38.8525	38.75	38.79	8319380.0
2019-01-16 15:00:00	AAPL	Stock	38.79	38.845	38.6475	38.73	16447952.0
2019-01-16 16:00:00	AAPL	Stock	38.735	38.755	38.3725	38.665	10090588.0
2019-01-16 17:00:00	AAPL	Stock	38.6625	38.707	38.625	38.707	29700.0
2019-01-16 18:00:00	AAPL	Stock	38.6725	38.675	38.655	38.655	33388.0
2019-01-16 19:00:00	AAPL	Stock	38.655	38.6625	38.5875	38.6125	42040.0
2019-01-16 04:00:00	MSFT	Stock	105.21	105.21	104.85	104.85	1595.0
2019-01-16 05:00:00	MSFT	Stock	105.0	105.2	105.0	105.14	800.0
2019-01-16 06:00:00	MSFT	Stock	104.98	104.98	104.98	104.98	400.0
2019-01-16 07:00:00	MSFT	Stock	105.04	105.35	104.99	105.2	20862.0
2019-01-16 08:00:00	MSFT	Stock	104.9	105.35	104.9	105.2	76381.0
2019-01-16 09:00:00	MSFT	Stock	105.2	106.11	105.2	106.1	4287281.0
2019-01-16 10:00:00	MSFT	Stock	106.105	106.255	104.99	105.119	5055805.0
2019-01-16 11:00:00	MSFT	Stock	105.12	105.71	104.96	105.25	2863322.0
2019-01-16 12:00:00	MSFT	Stock	105.26	105.472	104.99	105.4	2226622.0
2019-01-16 13:00:00	MSFT	Stock	105.395	105.406	105.09	105.2	1735552.0
2019-01-16 14:00:00	MSFT	Stock	105.209	105.59	105.07	105.35	1943381.0
2019-01-16 15:00:00	MSFT	Stock	105.344	105.64	105.22	105.38	4402437.0
2019-01-16 16:00:00	MSFT	Stock	105.38	105.51	105.1	105.23	3622920.0
2019-01-16 17:00:00	MSFT	Stock	105.23	105.49	105.18	105.3	6884.0
2019-01-16 18:00:00	MSFT	Stock	105.3	105.31	105.15	105.15	2276.0
2019-01-16 19:00:00	MSFT	Stock	105.15	105.15	105.01	105.11	3531.0
2019-01-16 04:00:00	NVDA	Stock	3.75	3.7755	3.75	3.7622	109960.0
2019-01-16 05:00:00	NVDA	Stock	3.7645	3.7645	3.7612	3.7612	53160.0
2019-01-16 07:00:00	NVDA	Stock	3.765	3.7752	3.7562	3.775	420000.0
2019-01-16 08:00:00	NVDA	Stock	3.76	3.78	3.7468	3.7662	1445840.0
2019-01-16 09:00:00	NVDA	Stock	3.7708	3.8055	3.7432	3.7905	77693880.0
2019-01-16 10:00:00	NVDA	Stock	3.7915	3.8075	3.7502	3.765	80146400.0
2019-01-16 11:00:00	NVDA	Stock	3.765	3.775	3.742	3.7458	57100680.0
2019-01-16 12:00:00	NVDA	Stock	3.7462	3.755	3.7328	3.7375	44327760.0
2019-01-16 13:00:00	NVDA	Stock	3.737	3.742	3.7228	3.7327	36048120.0
2019-01-16 14:00:00	NVDA	Stock	3.7325	3.7505	3.7202	3.7217	37173120.0
2019-01-16 15:00:00	NVDA	Stock	3.7215	3.7432	3.7154	3.721	66578240.0
2019-01-16 16:00:00	NVDA	Stock	3.721	3.7265	3.7075	3.7163	11044120.0
2019-01-16 17:00:00	NVDA	Stock	3.7153	3.7198	3.715	3.715	40560.0
2019-01-16 18:00:00	NVDA	Stock	3.715	3.7208	3.715	3.7175	190840.0
2019-01-16 19:00:00	NVDA	Stock	3.716	3.7175	3.7035	3.7035	537320.0
2019-01-16 04:00:00	AMZN	Stock	83.94	83.985	83.94	83.985	6000.0
2019-01-16 05:00:00	AMZN	Stock	83.86	83.885	83.86	83.885	14780.0
2019-01-16 07:00:00	AMZN	Stock	83.9255	84.315	83.9255	84.2665	379080.0

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

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