PREVIEW / stock_1hour / 2022-03-22

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-03-22.parquet
  size:    1.4 MB
  rows:    64,704
  symbols: 2,514

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
2022-03-22 04:00:00	AAPL	Stock	165.69	165.93	165.0	165.72	17658.0
2022-03-22 05:00:00	AAPL	Stock	165.79	166.11	165.7	165.7	13935.0
2022-03-22 06:00:00	AAPL	Stock	165.62	165.9	165.4	165.76	16433.0
2022-03-22 07:00:00	AAPL	Stock	165.8	165.8	165.4	165.49	53363.0
2022-03-22 08:00:00	AAPL	Stock	165.7199	165.95	164.99	165.59	296737.0
2022-03-22 09:00:00	AAPL	Stock	165.59	166.7811	164.91	166.14	8516273.0
2022-03-22 10:00:00	AAPL	Stock	166.16	168.79	166.155	168.4	14146173.0
2022-03-22 11:00:00	AAPL	Stock	168.4	169.12	168.27	168.6163	8420152.0
2022-03-22 12:00:00	AAPL	Stock	168.62	168.9535	168.18	168.85	6204379.0
2022-03-22 13:00:00	AAPL	Stock	168.85	169.42	168.49	169.305	5801793.0
2022-03-22 14:00:00	AAPL	Stock	169.31	169.37	168.32	168.6062	6102657.0
2022-03-22 15:00:00	AAPL	Stock	168.6	169.25	168.49	168.83	11798690.0
2022-03-22 16:00:00	AAPL	Stock	168.83	169.18	168.81	168.95	8234117.0
2022-03-22 17:00:00	AAPL	Stock	168.895	168.97	168.7501	168.88	24176.0
2022-03-22 18:00:00	AAPL	Stock	168.85	168.97	168.71	168.94	26313.0
2022-03-22 19:00:00	AAPL	Stock	168.93	168.95	168.85	168.95	28264.0
2022-03-22 04:00:00	MSFT	Stock	299.0	300.3	299.0	300.3	2272.0
2022-03-22 05:00:00	MSFT	Stock	300.5	300.8	300.0	300.21	5228.0
2022-03-22 06:00:00	MSFT	Stock	300.0	300.46	300.0	300.21	3755.0
2022-03-22 07:00:00	MSFT	Stock	300.2	300.2	299.16	299.37	20072.0
2022-03-22 08:00:00	MSFT	Stock	299.62	300.29	298.69	299.52	43139.0
2022-03-22 09:00:00	MSFT	Stock	299.48	301.3458	298.62	299.91	2148742.0
2022-03-22 10:00:00	MSFT	Stock	299.94	304.22	299.94	303.34	2818506.0
2022-03-22 11:00:00	MSFT	Stock	303.37	305.0	302.9	303.73	1988566.0
2022-03-22 12:00:00	MSFT	Stock	303.75	304.15	302.46	303.18	1598031.0
2022-03-22 13:00:00	MSFT	Stock	303.15	303.54	302.3	303.435	1363394.0
2022-03-22 14:00:00	MSFT	Stock	303.438	303.5295	302.34	303.04	1290510.0
2022-03-22 15:00:00	MSFT	Stock	303.04	304.44	303.02	304.17	3382673.0
2022-03-22 16:00:00	MSFT	Stock	304.16	304.31	303.52	304.0	4294981.0
2022-03-22 17:00:00	MSFT	Stock	303.96	304.0	303.8	303.89	4029.0
2022-03-22 18:00:00	MSFT	Stock	303.8	304.25	303.73	304.22	6799.0
2022-03-22 19:00:00	MSFT	Stock	304.29	304.5	303.86	304.31	7370.0
2022-03-22 04:00:00	NVDA	Stock	26.72	26.997	26.72	26.879	176510.0
2022-03-22 05:00:00	NVDA	Stock	26.9	26.94	26.864	26.869	45320.0
2022-03-22 06:00:00	NVDA	Stock	26.87	26.87	26.794	26.825	185590.0
2022-03-22 07:00:00	NVDA	Stock	26.81	26.835	26.675	26.722	455230.0
2022-03-22 08:00:00	NVDA	Stock	26.734	26.8892	26.425	26.874	1569810.0
2022-03-22 09:00:00	NVDA	Stock	26.86	26.95	26.421	26.667	44974780.0
2022-03-22 10:00:00	NVDA	Stock	26.679	27.187	26.679	27.083	63379880.0
2022-03-22 11:00:00	NVDA	Stock	27.087	27.238	26.855	26.86	45880270.0
2022-03-22 12:00:00	NVDA	Stock	26.858	26.946	26.607	26.772	43982140.0
2022-03-22 13:00:00	NVDA	Stock	26.767	26.928	26.701	26.873	42089130.0
2022-03-22 14:00:00	NVDA	Stock	26.87	26.989	26.072	26.563	73234510.0
2022-03-22 15:00:00	NVDA	Stock	26.564	26.666	26.351	26.529	77472300.0
2022-03-22 16:00:00	NVDA	Stock	26.524	26.524	26.362	26.366	16217900.0
2022-03-22 17:00:00	NVDA	Stock	26.367	26.414	26.335	26.414	388690.0
2022-03-22 18:00:00	NVDA	Stock	26.409	26.488	26.38	26.468	397010.0
2022-03-22 19:00:00	NVDA	Stock	26.474	26.475	26.38	26.429	311030.0
2022-03-22 05:00:00	AMZN	Stock	162.0	162.0	162.0	162.0	12000.0
2022-03-22 07:00:00	AMZN	Stock	161.6	161.6	161.6	161.6	2000.0

> showing 50 of 64,704 rows — these rows as CSV

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