PREVIEW / stock_1hour / 2022-03-07

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-03-07.parquet
  size:    1.5 MB
  rows:    68,099
  symbols: 2,565

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-07 04:00:00	AAPL	Stock	161.78	161.78	159.71	160.09	84771.0
2022-03-07 05:00:00	AAPL	Stock	160.09	160.45	159.88	160.0	31259.0
2022-03-07 06:00:00	AAPL	Stock	160.0	160.8	159.6	160.74	21043.0
2022-03-07 07:00:00	AAPL	Stock	160.85	162.3	160.67	161.86	156420.0
2022-03-07 08:00:00	AAPL	Stock	162.01	162.9	161.05	162.7024	360830.0
2022-03-07 09:00:00	AAPL	Stock	162.74	165.02	162.58	162.65	10461666.0
2022-03-07 10:00:00	AAPL	Stock	162.65	162.94	161.38	162.37	10664564.0
2022-03-07 11:00:00	AAPL	Stock	162.37	164.0	162.27	163.0675	9277964.0
2022-03-07 12:00:00	AAPL	Stock	163.06	163.08	161.3157	161.57	8392792.0
2022-03-07 13:00:00	AAPL	Stock	161.56	162.19	160.9	161.15	7480511.0
2022-03-07 14:00:00	AAPL	Stock	161.155	161.68	160.19	160.4	7333057.0
2022-03-07 15:00:00	AAPL	Stock	160.41	160.585	159.04	159.31	16014062.0
2022-03-07 16:00:00	AAPL	Stock	159.31	159.52	158.49	158.58	11449785.0
2022-03-07 17:00:00	AAPL	Stock	158.57	158.64	158.25	158.35	98528.0
2022-03-07 18:00:00	AAPL	Stock	158.35	158.72	158.02	158.36	67510.0
2022-03-07 19:00:00	AAPL	Stock	158.42	159.3	158.4	158.75	119582.0
2022-03-07 04:00:00	MSFT	Stock	285.25	287.0	284.14	284.85	13998.0
2022-03-07 05:00:00	MSFT	Stock	284.71	285.27	284.3	284.3	6426.0
2022-03-07 06:00:00	MSFT	Stock	284.46	285.49	284.0	285.49	4780.0
2022-03-07 07:00:00	MSFT	Stock	285.49	287.69	285.0	286.83	31365.0
2022-03-07 08:00:00	MSFT	Stock	287.2	288.939	284.28	288.63	64920.0
2022-03-07 09:00:00	MSFT	Stock	288.3334	289.69	283.36	283.6	3060142.0
2022-03-07 10:00:00	MSFT	Stock	283.51	283.76	279.0	280.2518	5451447.0
2022-03-07 11:00:00	MSFT	Stock	280.23	284.45	280.09	282.7165	3216748.0
2022-03-07 12:00:00	MSFT	Stock	282.71	282.97	280.9	281.6606	2605824.0
2022-03-07 13:00:00	MSFT	Stock	281.63	284.18	281.22	283.2	2608193.0
2022-03-07 14:00:00	MSFT	Stock	283.21	284.3669	281.19	281.705	2488990.0
2022-03-07 15:00:00	MSFT	Stock	281.74	282.01	278.53	278.91	5204313.0
2022-03-07 16:00:00	MSFT	Stock	278.9	279.35	277.32	278.6	5327733.0
2022-03-07 17:00:00	MSFT	Stock	278.55	278.91	277.68	277.99	28299.0
2022-03-07 18:00:00	MSFT	Stock	277.89	278.65	277.72	277.77	20285.0
2022-03-07 19:00:00	MSFT	Stock	277.9	279.0	277.77	278.99	35216.0
2022-03-07 04:00:00	NVDA	Stock	22.45	22.45	22.181	22.22	206510.0
2022-03-07 05:00:00	NVDA	Stock	22.227	22.316	22.2	22.252	70510.0
2022-03-07 06:00:00	NVDA	Stock	22.25	22.521	22.224	22.51	173920.0
2022-03-07 07:00:00	NVDA	Stock	22.434	22.717	22.408	22.575	487860.0
2022-03-07 08:00:00	NVDA	Stock	22.6005	22.698	22.209	22.52	1717890.0
2022-03-07 09:00:00	NVDA	Stock	22.52	23.033	22.304	22.306	51653630.0
2022-03-07 10:00:00	NVDA	Stock	22.303	22.405	21.701	21.8432	57627830.0
2022-03-07 11:00:00	NVDA	Stock	21.84	22.216	21.763	21.957	46741960.0
2022-03-07 12:00:00	NVDA	Stock	21.958	22.108	21.8169	21.914	32277820.0
2022-03-07 13:00:00	NVDA	Stock	21.911	22.08	21.804	21.891	28101990.0
2022-03-07 14:00:00	NVDA	Stock	21.888	21.964	21.6	21.65	28289030.0
2022-03-07 15:00:00	NVDA	Stock	21.65	21.686	21.33	21.339	57501850.0
2022-03-07 16:00:00	NVDA	Stock	21.339	21.368	21.0	21.051	25458120.0
2022-03-07 17:00:00	NVDA	Stock	21.041	21.097	21.016	21.03	429520.0
2022-03-07 18:00:00	NVDA	Stock	21.016	21.099	21.015	21.025	351510.0
2022-03-07 19:00:00	NVDA	Stock	21.03	21.1	21.01	21.02	608580.0
2022-03-07 04:00:00	AMZN	Stock	143.15	143.15	143.15	143.15	2000.0
2022-03-07 07:00:00	AMZN	Stock	143.5	144.6795	143.5	144.251	42380.0

> showing 50 of 68,099 rows — these rows as CSV

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