PREVIEW / stock_1hour / 2023-03-17

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-03-17.parquet
  size:    1.4 MB
  rows:    61,512
  symbols: 1,728

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
2023-03-17 04:00:00	AAPL	Stock	155.83	156.26	155.83	156.01	11358.0
2023-03-17 05:00:00	AAPL	Stock	156.11	156.16	155.85	156.05	6475.0
2023-03-17 06:00:00	AAPL	Stock	156.11	156.14	155.91	156.06	7534.0
2023-03-17 07:00:00	AAPL	Stock	156.0	156.13	155.76	156.08	54725.0
2023-03-17 08:00:00	AAPL	Stock	156.0009	156.19	155.3	155.74	245902.0
2023-03-17 09:00:00	AAPL	Stock	155.76	156.88	155.079	155.81	21219743.0
2023-03-17 10:00:00	AAPL	Stock	155.81	156.74	154.4201	155.04	10125956.0
2023-03-17 11:00:00	AAPL	Stock	155.05	155.37	154.28	155.05	5776495.0
2023-03-17 12:00:00	AAPL	Stock	155.06	155.71	154.9	155.27	4696392.0
2023-03-17 13:00:00	AAPL	Stock	155.275	155.85	155.24	155.7995	4223586.0
2023-03-17 14:00:00	AAPL	Stock	155.8	156.0299	154.67	154.92	5092200.0
2023-03-17 15:00:00	AAPL	Stock	154.93	155.43	154.39	155.005	9839608.0
2023-03-17 16:00:00	AAPL	Stock	155.06	155.18	154.89	154.97	21958388.0
2023-03-17 17:00:00	AAPL	Stock	154.9797	155.05	154.8	154.84	289743.0
2023-03-17 18:00:00	AAPL	Stock	154.81	154.83	154.56	154.6	43428.0
2023-03-17 19:00:00	AAPL	Stock	154.65	154.77	154.52	154.6	12168.0
2023-03-17 04:00:00	MSFT	Stock	276.4	278.0	276.4	277.43	36448.0
2023-03-17 05:00:00	MSFT	Stock	277.6	277.7	276.32	276.92	9668.0
2023-03-17 06:00:00	MSFT	Stock	276.93	278.0	276.5	277.21	19214.0
2023-03-17 07:00:00	MSFT	Stock	277.4	278.26	276.81	278.21	59847.0
2023-03-17 08:00:00	MSFT	Stock	277.75	278.87	276.2	277.32	173239.0
2023-03-17 09:00:00	MSFT	Stock	277.3205	281.89	277.31	281.52	13647109.0
2023-03-17 10:00:00	MSFT	Stock	281.545	283.33	279.2155	280.55	7595453.0
2023-03-17 11:00:00	MSFT	Stock	280.59	280.59	276.3201	277.475	4842515.0
2023-03-17 12:00:00	MSFT	Stock	277.49	279.11	276.88	278.5351	2921112.0
2023-03-17 13:00:00	MSFT	Stock	278.56	280.87	278.56	280.59	3434759.0
2023-03-17 14:00:00	MSFT	Stock	280.6	281.21	276.89	278.1	3342072.0
2023-03-17 15:00:00	MSFT	Stock	278.13	279.52	277.39	279.42	5819204.0
2023-03-17 16:00:00	MSFT	Stock	279.285	279.68	279.26	279.46	13115565.0
2023-03-17 17:00:00	MSFT	Stock	279.46	279.53	279.34	279.39	39010.0
2023-03-17 18:00:00	MSFT	Stock	279.39	279.55	279.12	279.14	6183.0
2023-03-17 19:00:00	MSFT	Stock	279.29	279.38	279.06	279.38	11501.0
2023-03-17 04:00:00	NVDA	Stock	25.757	25.92	25.5	25.77	301090.0
2023-03-17 05:00:00	NVDA	Stock	25.79	25.92	25.769	25.899	181700.0
2023-03-17 06:00:00	NVDA	Stock	25.899	25.95	25.887	25.919	319240.0
2023-03-17 07:00:00	NVDA	Stock	25.918	26.14	25.918	26.0	2048680.0
2023-03-17 08:00:00	NVDA	Stock	26.085	26.14	25.623	25.89	3917260.0
2023-03-17 09:00:00	NVDA	Stock	25.89	26.349	25.829	26.1247	127528630.0
2023-03-17 10:00:00	NVDA	Stock	26.127	26.399	25.754	25.9745	110262600.0
2023-03-17 11:00:00	NVDA	Stock	25.9787	26.02	25.668	25.85	71903070.0
2023-03-17 12:00:00	NVDA	Stock	25.8499	26.059	25.706	25.7745	53849030.0
2023-03-17 13:00:00	NVDA	Stock	25.778	26.018	25.73	25.952	46427600.0
2023-03-17 14:00:00	NVDA	Stock	25.956	26.027	25.755	25.883	42993260.0
2023-03-17 15:00:00	NVDA	Stock	25.884	26.104	25.713	25.713	74490210.0
2023-03-17 16:00:00	NVDA	Stock	25.725	25.763	25.7171	25.74	153772990.0
2023-03-17 17:00:00	NVDA	Stock	25.733	25.75	25.71	25.7155	440230.0
2023-03-17 18:00:00	NVDA	Stock	25.714	25.714	25.601	25.622	842370.0
2023-03-17 19:00:00	NVDA	Stock	25.615	25.66	25.61	25.64	380960.0
2023-03-17 04:00:00	AMZN	Stock	100.03	100.28	99.83	99.85	10640.0
2023-03-17 05:00:00	AMZN	Stock	99.85	100.02	99.66	100.01	14693.0

> showing 50 of 61,512 rows — these rows as CSV

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