PREVIEW / stock_1hour / 2020-12-01

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-12-01.parquet
  size:    1.4 MB
  rows:    62,044
  symbols: 2,620

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-12-01 04:00:00	AAPL	Stock	120.84	121.01	119.95	120.76	87748.0
2020-12-01 05:00:00	AAPL	Stock	120.7	121.45	120.6	121.27	47634.0
2020-12-01 06:00:00	AAPL	Stock	121.27	121.83	120.98	121.1	82264.0
2020-12-01 07:00:00	AAPL	Stock	121.11	121.66	121.04	121.45	339468.0
2020-12-01 08:00:00	AAPL	Stock	121.27	121.66	120.88	121.09	711938.0
2020-12-01 09:00:00	AAPL	Stock	121.1	122.6	120.01	122.39	20579044.0
2020-12-01 10:00:00	AAPL	Stock	122.388	122.96	121.62	122.46	21508571.0
2020-12-01 11:00:00	AAPL	Stock	122.46	123.25	122.09	123.099	16064069.0
2020-12-01 12:00:00	AAPL	Stock	123.1	123.469	122.56	122.581	11232979.0
2020-12-01 13:00:00	AAPL	Stock	122.585	123.29	122.565	122.775	7935622.0
2020-12-01 14:00:00	AAPL	Stock	122.775	123.22	122.62	122.788	8498053.0
2020-12-01 15:00:00	AAPL	Stock	122.785	122.96	122.06	122.7	15117331.0
2020-12-01 16:00:00	AAPL	Stock	122.72	123.15	122.318	122.87	9412913.0
2020-12-01 17:00:00	AAPL	Stock	122.87	122.99	122.59	122.65	146598.0
2020-12-01 18:00:00	AAPL	Stock	122.65	122.91	122.52	122.85	210037.0
2020-12-01 19:00:00	AAPL	Stock	122.88	122.88	122.2	122.36	225656.0
2020-12-01 04:00:00	MSFT	Stock	214.73	214.96	214.5	214.66	2576.0
2020-12-01 05:00:00	MSFT	Stock	214.75	215.34	214.75	215.34	3935.0
2020-12-01 06:00:00	MSFT	Stock	215.19	215.86	215.19	215.5	23495.0
2020-12-01 07:00:00	MSFT	Stock	215.1	215.5	215.1	215.5	17875.0
2020-12-01 08:00:00	MSFT	Stock	215.29	215.52	213.54	215.0	45988.0
2020-12-01 09:00:00	MSFT	Stock	214.92	215.08	213.35	213.72	3311545.0
2020-12-01 10:00:00	MSFT	Stock	213.715	214.29	213.402	213.91	3507983.0
2020-12-01 11:00:00	MSFT	Stock	213.92	214.72	213.65	214.68	2763501.0
2020-12-01 12:00:00	MSFT	Stock	214.68	215.89	214.62	215.46	2604545.0
2020-12-01 13:00:00	MSFT	Stock	215.46	216.98	215.41	216.685	2228308.0
2020-12-01 14:00:00	MSFT	Stock	216.685	217.32	216.48	216.82	2212191.0
2020-12-01 15:00:00	MSFT	Stock	216.83	216.83	215.56	216.21	3529973.0
2020-12-01 16:00:00	MSFT	Stock	216.21	216.31	215.75	215.75	3223829.0
2020-12-01 17:00:00	MSFT	Stock	215.75	216.21	215.71	215.71	10160.0
2020-12-01 18:00:00	MSFT	Stock	215.75	215.9	215.52	215.71	10556.0
2020-12-01 19:00:00	MSFT	Stock	215.7	215.8	215.4	215.55	12315.0
2020-12-01 04:00:00	NVDA	Stock	13.4875	13.495	13.4795	13.4795	26480.0
2020-12-01 05:00:00	NVDA	Stock	13.4625	13.4625	13.4482	13.4625	45080.0
2020-12-01 06:00:00	NVDA	Stock	13.4708	13.4728	13.4708	13.4728	15800.0
2020-12-01 07:00:00	NVDA	Stock	13.4628	13.5	13.4625	13.5	375920.0
2020-12-01 08:00:00	NVDA	Stock	13.4975	13.521	13.4786	13.5	1525040.0
2020-12-01 09:00:00	NVDA	Stock	13.5	13.5243	13.2653	13.3578	41818360.0
2020-12-01 10:00:00	NVDA	Stock	13.3532	13.4428	13.2282	13.3168	44320080.0
2020-12-01 11:00:00	NVDA	Stock	13.3195	13.5288	13.3172	13.513	52100800.0
2020-12-01 12:00:00	NVDA	Stock	13.5128	13.5128	13.404	13.409	23980240.0
2020-12-01 13:00:00	NVDA	Stock	13.4095	13.454	13.3605	13.444	18003240.0
2020-12-01 14:00:00	NVDA	Stock	13.4405	13.459	13.4035	13.451	12503000.0
2020-12-01 15:00:00	NVDA	Stock	13.4532	13.4532	13.362	13.39	31471520.0
2020-12-01 16:00:00	NVDA	Stock	13.39	13.395	13.3625	13.385	3835560.0
2020-12-01 17:00:00	NVDA	Stock	13.39	13.39	13.3875	13.3875	60800.0
2020-12-01 18:00:00	NVDA	Stock	13.39	13.3938	13.3833	13.3938	248680.0
2020-12-01 19:00:00	NVDA	Stock	13.3925	13.395	13.3725	13.3825	204560.0
2020-12-01 04:00:00	AMZN	Stock	159.2	159.5	159.2	159.5	13300.0
2020-12-01 05:00:00	AMZN	Stock	159.4885	159.7395	159.4885	159.7395	14340.0

> showing 50 of 62,044 rows — these rows as CSV

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