PREVIEW / stock_1hour / 2021-11-24

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-11-24.parquet
  size:    1.4 MB
  rows:    65,041
  symbols: 2,619

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
2021-11-24 04:00:00	AAPL	Stock	161.5	161.5	160.9	161.1	33742.0
2021-11-24 05:00:00	AAPL	Stock	161.08	161.24	160.67	160.86	5915.0
2021-11-24 06:00:00	AAPL	Stock	160.7	161.23	160.59	160.81	17629.0
2021-11-24 07:00:00	AAPL	Stock	160.98	161.0	160.73	160.74	86786.0
2021-11-24 08:00:00	AAPL	Stock	160.92	161.19	160.25	160.5	484018.0
2021-11-24 09:00:00	AAPL	Stock	160.53	161.4827	159.71	159.9604	9288011.0
2021-11-24 10:00:00	AAPL	Stock	159.96	161.115	159.64	161.09	10688176.0
2021-11-24 11:00:00	AAPL	Stock	161.08	161.98	160.7	161.2623	8481581.0
2021-11-24 12:00:00	AAPL	Stock	161.26	161.63	160.92	161.51	5479983.0
2021-11-24 13:00:00	AAPL	Stock	161.5	161.74	160.91	160.9987	4942698.0
2021-11-24 14:00:00	AAPL	Stock	160.9901	161.298	160.4905	161.0	5854371.0
2021-11-24 15:00:00	AAPL	Stock	161.0	162.14	160.8	161.94	10182228.0
2021-11-24 16:00:00	AAPL	Stock	162.08	162.08	161.67	161.82	4438643.0
2021-11-24 17:00:00	AAPL	Stock	161.87	162.16	161.86	162.04	36965.0
2021-11-24 18:00:00	AAPL	Stock	162.05	162.06	161.85	161.94	26941.0
2021-11-24 19:00:00	AAPL	Stock	161.94	162.2	161.94	162.2	35330.0
2021-11-24 04:00:00	MSFT	Stock	336.65	337.46	336.0	336.35	2400.0
2021-11-24 05:00:00	MSFT	Stock	337.08	337.1	336.14	336.14	1704.0
2021-11-24 06:00:00	MSFT	Stock	335.98	337.31	335.98	337.01	3753.0
2021-11-24 07:00:00	MSFT	Stock	337.04	337.11	336.16	336.91	7590.0
2021-11-24 08:00:00	MSFT	Stock	336.6	337.75	335.8	335.95	25426.0
2021-11-24 09:00:00	MSFT	Stock	335.94	336.93	333.911	335.075	1768375.0
2021-11-24 10:00:00	MSFT	Stock	335.01	336.44	334.04	335.46	2236707.0
2021-11-24 11:00:00	MSFT	Stock	335.45	336.73	334.71	335.93	1459064.0
2021-11-24 12:00:00	MSFT	Stock	335.92	336.62	335.8	336.28	854368.0
2021-11-24 13:00:00	MSFT	Stock	336.29	336.56	335.99	336.33	699895.0
2021-11-24 14:00:00	MSFT	Stock	336.33	336.98	335.48	336.4919	1045183.0
2021-11-24 15:00:00	MSFT	Stock	336.49	338.16	336.31	337.9	1768768.0
2021-11-24 16:00:00	MSFT	Stock	337.91	338.16	337.72	337.85	3262796.0
2021-11-24 17:00:00	MSFT	Stock	337.85	338.0	337.62	337.9	3560.0
2021-11-24 18:00:00	MSFT	Stock	337.73	338.0	337.36	337.36	21776.0
2021-11-24 19:00:00	MSFT	Stock	337.35	337.7	337.18	337.7	14841.0
2021-11-24 04:00:00	NVDA	Stock	31.89	31.912	31.62	31.694	232980.0
2021-11-24 05:00:00	NVDA	Stock	31.654	31.732	31.462	31.484	103060.0
2021-11-24 06:00:00	NVDA	Stock	31.458	31.8	31.458	31.7	98360.0
2021-11-24 07:00:00	NVDA	Stock	31.691	31.79	31.585	31.6	527080.0
2021-11-24 08:00:00	NVDA	Stock	31.6256	31.8	31.275	31.344	1146130.0
2021-11-24 09:00:00	NVDA	Stock	31.364	31.577	30.928	31.45	51510890.0
2021-11-24 10:00:00	NVDA	Stock	31.45	32.172	31.32	32.128	65397440.0
2021-11-24 11:00:00	NVDA	Stock	32.131	32.561	31.94	32.4763	48168580.0
2021-11-24 12:00:00	NVDA	Stock	32.476	32.599	32.293	32.451	30802600.0
2021-11-24 13:00:00	NVDA	Stock	32.443	32.66	32.353	32.427	21411310.0
2021-11-24 14:00:00	NVDA	Stock	32.419	32.576	32.203	32.531	27755650.0
2021-11-24 15:00:00	NVDA	Stock	32.53	32.855	32.4	32.673	45360720.0
2021-11-24 16:00:00	NVDA	Stock	32.674	32.743	32.6	32.668	42155320.0
2021-11-24 17:00:00	NVDA	Stock	32.668	32.72	32.65	32.714	181090.0
2021-11-24 18:00:00	NVDA	Stock	32.7	32.72	32.7	32.705	106470.0
2021-11-24 19:00:00	NVDA	Stock	32.71	32.78	32.706	32.775	233220.0
2021-11-24 06:00:00	AMZN	Stock	178.7505	178.7505	178.7505	178.7505	2000.0
2021-11-24 07:00:00	AMZN	Stock	178.615	178.75	178.2005	178.3	21880.0

> showing 50 of 65,041 rows — these rows as CSV

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