PREVIEW / stock_1hour / 2024-05-08

all stock 1-hour files

  file:    by_date/stock_1hour/2024/2024-05-08.parquet
  size:    1.3 MB
  rows:    58,139
  symbols: 976

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
2024-05-08 04:00:00	AAPL	Stock	182.3	183.75	182.3	183.34	57169.0
2024-05-08 05:00:00	AAPL	Stock	183.24	183.24	183.06	183.12	8736.0
2024-05-08 06:00:00	AAPL	Stock	182.98	183.5	182.86	183.1	20189.0
2024-05-08 07:00:00	AAPL	Stock	183.0	183.0	182.5	182.7	26224.0
2024-05-08 08:00:00	AAPL	Stock	182.96	183.0	181.98	182.65	115033.0
2024-05-08 09:00:00	AAPL	Stock	182.7	182.96	181.84	182.1	5324294.0
2024-05-08 10:00:00	AAPL	Stock	182.1	182.38	181.45	182.0485	5129055.0
2024-05-08 11:00:00	AAPL	Stock	182.042	182.38	181.85	182.25	3381340.0
2024-05-08 12:00:00	AAPL	Stock	182.2487	182.61	182.055	182.16	3378093.0
2024-05-08 13:00:00	AAPL	Stock	182.17	182.72	182.03	182.65	3110117.0
2024-05-08 14:00:00	AAPL	Stock	182.645	182.99	182.48	182.805	3341957.0
2024-05-08 15:00:00	AAPL	Stock	182.805	183.07	182.61	182.75	6387514.0
2024-05-08 16:00:00	AAPL	Stock	182.74	182.86	182.03	182.4114	6183122.0
2024-05-08 17:00:00	AAPL	Stock	182.41	182.74	182.41	182.57	34684.0
2024-05-08 18:00:00	AAPL	Stock	182.57	182.64	182.45	182.64	7844.0
2024-05-08 19:00:00	AAPL	Stock	182.63	182.63	182.4	182.46	8239.0
2024-05-08 04:00:00	MSFT	Stock	410.46	410.93	410.26	410.6	1612.0
2024-05-08 05:00:00	MSFT	Stock	410.75	411.0	410.75	411.0	975.0
2024-05-08 06:00:00	MSFT	Stock	410.93	410.93	410.02	410.51	1611.0
2024-05-08 07:00:00	MSFT	Stock	410.37	410.52	409.5	410.1	6869.0
2024-05-08 08:00:00	MSFT	Stock	410.58	410.69	408.44	408.7	33500.0
2024-05-08 09:00:00	MSFT	Stock	408.65	409.15	406.7132	408.38	1126544.0
2024-05-08 10:00:00	MSFT	Stock	408.38	412.03	408.26	411.7241	1156291.0
2024-05-08 11:00:00	MSFT	Stock	411.715	412.23	411.16	411.61	573169.0
2024-05-08 12:00:00	MSFT	Stock	411.61	412.1	410.82	411.11	411275.0
2024-05-08 13:00:00	MSFT	Stock	411.14	411.93	410.555	411.85	364637.0
2024-05-08 14:00:00	MSFT	Stock	411.835	411.97	410.94	411.29	443054.0
2024-05-08 15:00:00	MSFT	Stock	411.28	411.28	409.86	410.47	1045923.0
2024-05-08 16:00:00	MSFT	Stock	410.54	410.54	409.0	409.69	1996947.0
2024-05-08 17:00:00	MSFT	Stock	409.68	410.1	409.65	410.0	9460.0
2024-05-08 18:00:00	MSFT	Stock	409.96	410.1	409.8	409.8069	1920.0
2024-05-08 19:00:00	MSFT	Stock	410.05	410.13	409.8	410.0	1197.0
2024-05-08 04:00:00	NVDA	Stock	90.5	90.5	90.155	90.212	49430.0
2024-05-08 05:00:00	NVDA	Stock	90.183	90.395	90.18	90.395	9560.0
2024-05-08 06:00:00	NVDA	Stock	90.28	90.445	90.28	90.445	10000.0
2024-05-08 07:00:00	NVDA	Stock	90.38	90.443	89.88	90.0	427140.0
2024-05-08 08:00:00	NVDA	Stock	90.33	90.443	89.38	89.5	2018150.0
2024-05-08 09:00:00	NVDA	Stock	89.467	90.96	89.41	90.844	42317150.0
2024-05-08 10:00:00	NVDA	Stock	90.888	91.194	90.287	90.676	45787150.0
2024-05-08 11:00:00	NVDA	Stock	90.678	90.898	89.532	89.662	40554970.0
2024-05-08 12:00:00	NVDA	Stock	89.634	90.36	89.634	90.221	24897410.0
2024-05-08 13:00:00	NVDA	Stock	90.225	90.52	89.861	90.2755	20581390.0
2024-05-08 14:00:00	NVDA	Stock	90.2755	90.578	90.13	90.243	17530450.0
2024-05-08 15:00:00	NVDA	Stock	90.223	90.55	90.06	90.317	25590870.0
2024-05-08 16:00:00	NVDA	Stock	90.412	90.43	89.742	89.973	17810910.0
2024-05-08 17:00:00	NVDA	Stock	89.95	89.99	89.907	89.963	252350.0
2024-05-08 18:00:00	NVDA	Stock	89.965	89.98	89.87	89.87	357250.0
2024-05-08 19:00:00	NVDA	Stock	89.88	89.987	89.85	89.865	388910.0
2024-05-08 04:00:00	AMZN	Stock	188.76	188.76	188.63	188.63	2873.0
2024-05-08 05:00:00	AMZN	Stock	188.7	188.91	188.65	188.8	3862.0

> showing 50 of 58,139 rows — these rows as CSV

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