PREVIEW / stock_1hour / 2023-09-20

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-09-20.parquet
  size:    1.3 MB
  rows:    58,180
  symbols: 1,433

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-09-20 04:00:00	AAPL	Stock	178.98	179.36	178.85	179.29	14350.0
2023-09-20 05:00:00	AAPL	Stock	179.33	179.45	179.25	179.35	5989.0
2023-09-20 06:00:00	AAPL	Stock	179.36	179.4	179.16	179.3	10124.0
2023-09-20 07:00:00	AAPL	Stock	179.25	179.39	178.52	178.65	73337.0
2023-09-20 08:00:00	AAPL	Stock	179.32	179.38	178.31	179.28	206066.0
2023-09-20 09:00:00	AAPL	Stock	179.25	179.695	177.98	178.41	5965111.0
2023-09-20 10:00:00	AAPL	Stock	178.4	178.425	177.26	177.43	6902611.0
2023-09-20 11:00:00	AAPL	Stock	177.43	177.58	176.86	177.55	4849163.0
2023-09-20 12:00:00	AAPL	Stock	177.56	177.76	177.32	177.725	2591629.0
2023-09-20 13:00:00	AAPL	Stock	177.72	177.7951	177.1752	177.7951	3126291.0
2023-09-20 14:00:00	AAPL	Stock	177.79	177.79	176.58	177.14	8585460.0
2023-09-20 15:00:00	AAPL	Stock	177.13	177.31	175.4	175.49	10013927.0
2023-09-20 16:00:00	AAPL	Stock	175.49	175.66	175.33	175.51	5140386.0
2023-09-20 17:00:00	AAPL	Stock	175.55	175.62	175.45	175.59	716296.0
2023-09-20 18:00:00	AAPL	Stock	175.6	175.65	175.32	175.42	29332.0
2023-09-20 19:00:00	AAPL	Stock	175.4	175.56	175.0	175.0	45329.0
2023-09-20 04:00:00	MSFT	Stock	328.5	328.95	328.22	328.95	5056.0
2023-09-20 05:00:00	MSFT	Stock	329.0	329.11	329.0	329.11	225.0
2023-09-20 06:00:00	MSFT	Stock	329.19	329.19	329.01	329.05	650.0
2023-09-20 07:00:00	MSFT	Stock	329.25	329.39	329.05	329.05	3366.0
2023-09-20 08:00:00	MSFT	Stock	329.6	330.2	328.25	330.16	21019.0
2023-09-20 09:00:00	MSFT	Stock	329.87	330.3839	327.9	328.9	1527083.0
2023-09-20 10:00:00	MSFT	Stock	328.9	329.16	327.2	327.28	1434051.0
2023-09-20 11:00:00	MSFT	Stock	327.28	327.36	325.03	327.2	1088378.0
2023-09-20 12:00:00	MSFT	Stock	327.19	327.2282	326.22	326.65	818171.0
2023-09-20 13:00:00	MSFT	Stock	326.65	326.65	325.535	325.76	713830.0
2023-09-20 14:00:00	MSFT	Stock	325.63	326.6271	323.75	324.13	2068254.0
2023-09-20 15:00:00	MSFT	Stock	324.09	324.67	320.51	320.75	3200182.0
2023-09-20 16:00:00	MSFT	Stock	320.76	320.92	320.11	320.49	2730112.0
2023-09-20 17:00:00	MSFT	Stock	320.5	320.77	320.42	320.5145	262417.0
2023-09-20 18:00:00	MSFT	Stock	320.65	320.81	320.05	320.29	12492.0
2023-09-20 19:00:00	MSFT	Stock	320.11	320.45	320.0	320.0	15580.0
2023-09-20 04:00:00	NVDA	Stock	43.5	43.5	42.905	43.21	231130.0
2023-09-20 05:00:00	NVDA	Stock	43.22	43.251	43.176	43.212	80050.0
2023-09-20 06:00:00	NVDA	Stock	43.22	43.22	43.15	43.15	53960.0
2023-09-20 07:00:00	NVDA	Stock	43.178	43.491	43.178	43.38	490970.0
2023-09-20 08:00:00	NVDA	Stock	43.199	43.699	43.185	43.68	1601370.0
2023-09-20 09:00:00	NVDA	Stock	43.674	43.903	43.2833	43.7515	41820620.0
2023-09-20 10:00:00	NVDA	Stock	43.752	43.759	43.379	43.419	40312220.0
2023-09-20 11:00:00	NVDA	Stock	43.4162	43.547	43.266	43.546	31003300.0
2023-09-20 12:00:00	NVDA	Stock	43.5405	43.596	43.461	43.49	16326320.0
2023-09-20 13:00:00	NVDA	Stock	43.495	43.5	43.11	43.237	24314070.0
2023-09-20 14:00:00	NVDA	Stock	43.235	43.388	42.913	43.0715	47091040.0
2023-09-20 15:00:00	NVDA	Stock	43.061	43.156	42.223	42.231	65475710.0
2023-09-20 16:00:00	NVDA	Stock	42.231	42.241	41.952	42.087	16553350.0
2023-09-20 17:00:00	NVDA	Stock	42.09	42.239	42.018	42.075	2965170.0
2023-09-20 18:00:00	NVDA	Stock	42.072	42.15	42.03	42.035	514670.0
2023-09-20 19:00:00	NVDA	Stock	42.03	42.065	42.01	42.034	475320.0
2023-09-20 04:00:00	AMZN	Stock	137.6	137.9	137.6	137.9	17995.0
2023-09-20 05:00:00	AMZN	Stock	137.99	138.19	137.81	138.19	6546.0

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

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