PREVIEW / stock_1hour / 2020-11-09

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-11-09.parquet
  size:    1.4 MB
  rows:    63,610
  symbols: 2,558

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
2020-11-09 04:00:00	AAPL	Stock	121.2	121.6	120.7	120.9	120171.0
2020-11-09 05:00:00	AAPL	Stock	120.97	121.68	120.97	121.38	51677.0
2020-11-09 06:00:00	AAPL	Stock	121.38	121.96	120.51	121.06	135286.0
2020-11-09 07:00:00	AAPL	Stock	120.98	121.29	117.93	119.79	1550695.0
2020-11-09 08:00:00	AAPL	Stock	119.75	121.4	117.9	120.09	2259731.0
2020-11-09 09:00:00	AAPL	Stock	120.17	121.69	118.48	119.743	21496809.0
2020-11-09 10:00:00	AAPL	Stock	119.73	121.99	119.67	120.63	22172010.0
2020-11-09 11:00:00	AAPL	Stock	120.64	121.68	119.72	120.56	14827305.0
2020-11-09 12:00:00	AAPL	Stock	120.57	120.95	120.0	120.81	11733411.0
2020-11-09 13:00:00	AAPL	Stock	120.81	121.0	119.38	119.64	11055419.0
2020-11-09 14:00:00	AAPL	Stock	119.63	119.82	118.2	118.523	13186991.0
2020-11-09 15:00:00	AAPL	Stock	118.54	118.94	116.05	116.32	22783383.0
2020-11-09 16:00:00	AAPL	Stock	116.32	117.0	116.03	116.79	11208820.0
2020-11-09 17:00:00	AAPL	Stock	116.8	117.24	116.56	117.11	205719.0
2020-11-09 18:00:00	AAPL	Stock	117.13	117.7	117.05	117.18	284738.0
2020-11-09 19:00:00	AAPL	Stock	117.2	117.24	116.43	116.88	221154.0
2020-11-09 04:00:00	MSFT	Stock	227.5	228.47	226.88	227.4	10742.0
2020-11-09 05:00:00	MSFT	Stock	227.5	228.19	227.5	228.19	10743.0
2020-11-09 06:00:00	MSFT	Stock	228.07	229.0	225.72	226.0	35464.0
2020-11-09 07:00:00	MSFT	Stock	225.55	226.0	217.87	220.77	406506.0
2020-11-09 08:00:00	MSFT	Stock	225.5	226.01	218.0	222.75	356214.0
2020-11-09 09:00:00	MSFT	Stock	223.0	226.55	221.7	224.81	4222767.0
2020-11-09 10:00:00	MSFT	Stock	224.78	228.12	223.8	224.7	4943996.0
2020-11-09 11:00:00	MSFT	Stock	224.69	226.09	223.46	224.91	2974500.0
2020-11-09 12:00:00	MSFT	Stock	224.91	225.58	223.81	224.78	2256149.0
2020-11-09 13:00:00	MSFT	Stock	224.76	225.17	222.336	222.91	2443340.0
2020-11-09 14:00:00	MSFT	Stock	222.883	223.08	220.78	222.0	2838630.0
2020-11-09 15:00:00	MSFT	Stock	222.01	222.64	217.88	218.38	5158565.0
2020-11-09 16:00:00	MSFT	Stock	218.39	219.23	217.95	218.79	5533464.0
2020-11-09 17:00:00	MSFT	Stock	218.55	219.46	218.39	219.35	18879.0
2020-11-09 18:00:00	MSFT	Stock	219.31	219.98	218.73	219.5	11386.0
2020-11-09 19:00:00	MSFT	Stock	219.32	219.4	218.15	218.78	40429.0
2020-11-09 04:00:00	NVDA	Stock	14.8255	15.008	14.8255	14.875	710960.0
2020-11-09 05:00:00	NVDA	Stock	14.9062	14.937	14.9062	14.937	77880.0
2020-11-09 06:00:00	NVDA	Stock	14.9012	14.975	14.75	14.75	436840.0
2020-11-09 07:00:00	NVDA	Stock	14.75	14.8	14.2972	14.575	6956640.0
2020-11-09 08:00:00	NVDA	Stock	14.575	14.8375	14.3028	14.675	6255760.0
2020-11-09 09:00:00	NVDA	Stock	14.6725	14.75	13.9628	14.25	84194720.0
2020-11-09 10:00:00	NVDA	Stock	14.25	14.6915	14.2425	14.4205	98452840.0
2020-11-09 11:00:00	NVDA	Stock	14.4288	14.4732	14.2532	14.3416	44911440.0
2020-11-09 12:00:00	NVDA	Stock	14.349	14.3785	14.111	14.151	43152040.0
2020-11-09 13:00:00	NVDA	Stock	14.155	14.196	14.032	14.0672	31037680.0
2020-11-09 14:00:00	NVDA	Stock	14.0696	14.078	13.789	13.839	60930240.0
2020-11-09 15:00:00	NVDA	Stock	13.8403	13.94	13.6108	13.6352	88865400.0
2020-11-09 16:00:00	NVDA	Stock	13.6308	13.725	13.6258	13.675	8821720.0
2020-11-09 17:00:00	NVDA	Stock	13.6895	13.8372	13.6308	13.8112	614600.0
2020-11-09 18:00:00	NVDA	Stock	13.8	13.8425	13.8	13.8	595640.0
2020-11-09 19:00:00	NVDA	Stock	13.8	13.8245	13.6898	13.75	823280.0
2020-11-09 04:00:00	AMZN	Stock	168.715	169.2325	168.715	168.8	53060.0
2020-11-09 06:00:00	AMZN	Stock	168.8	169.4	164.3885	164.95	308180.0

> showing 50 of 63,610 rows — these rows as CSV

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