PREVIEW / stock_1hour / 2023-11-07

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-11-07.parquet
  size:    1.3 MB
  rows:    58,484
  symbols: 1,341

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-11-07 04:00:00	AAPL	Stock	178.88	178.88	178.47	178.5	5258.0
2023-11-07 05:00:00	AAPL	Stock	178.4	178.68	178.4	178.49	3658.0
2023-11-07 06:00:00	AAPL	Stock	178.5	178.5	178.22	178.41	29030.0
2023-11-07 07:00:00	AAPL	Stock	178.5	178.69	178.33	178.66	22954.0
2023-11-07 08:00:00	AAPL	Stock	178.48	178.97	178.36	178.85	97259.0
2023-11-07 09:00:00	AAPL	Stock	178.85	180.53	178.65	180.195	7512638.0
2023-11-07 10:00:00	AAPL	Stock	180.19	181.27	180.14	181.215	7977995.0
2023-11-07 11:00:00	AAPL	Stock	181.215	181.64	181.08	181.47	5297786.0
2023-11-07 12:00:00	AAPL	Stock	181.48	181.59	180.52	181.575	6160948.0
2023-11-07 13:00:00	AAPL	Stock	181.58	182.44	181.525	182.37	6114261.0
2023-11-07 14:00:00	AAPL	Stock	182.3702	182.43	181.9	182.0401	4050078.0
2023-11-07 15:00:00	AAPL	Stock	182.05	182.34	181.55	181.88	9363063.0
2023-11-07 16:00:00	AAPL	Stock	181.89	181.94	181.71	181.84	9129105.0
2023-11-07 17:00:00	AAPL	Stock	181.86	181.94	181.82	181.83	87163.0
2023-11-07 18:00:00	AAPL	Stock	181.83	181.94	181.73	181.89	18481.0
2023-11-07 19:00:00	AAPL	Stock	181.86	182.3	181.75	182.22	33867.0
2023-11-07 04:00:00	MSFT	Stock	357.37	357.37	357.13	357.25	2968.0
2023-11-07 05:00:00	MSFT	Stock	357.1	357.4	357.07	357.22	1161.0
2023-11-07 06:00:00	MSFT	Stock	357.3	357.31	356.8	356.8	1958.0
2023-11-07 07:00:00	MSFT	Stock	356.83	358.89	356.83	358.65	59718.0
2023-11-07 08:00:00	MSFT	Stock	357.45	359.0	355.46	359.0	52899.0
2023-11-07 09:00:00	MSFT	Stock	359.05	359.99	357.63	359.28	2785048.0
2023-11-07 10:00:00	MSFT	Stock	359.27	362.08	358.74	361.44	2985007.0
2023-11-07 11:00:00	MSFT	Stock	361.435	362.38	360.93	361.735	1553945.0
2023-11-07 12:00:00	MSFT	Stock	361.73	361.97	360.76	361.63	1366925.0
2023-11-07 13:00:00	MSFT	Stock	361.62	362.46	361.47	362.25	1206124.0
2023-11-07 14:00:00	MSFT	Stock	362.24	362.43	361.37	361.475	1107721.0
2023-11-07 15:00:00	MSFT	Stock	361.475	361.89	359.94	360.5	2964167.0
2023-11-07 16:00:00	MSFT	Stock	360.53	360.61	360.11	360.2	5436225.0
2023-11-07 17:00:00	MSFT	Stock	360.2	360.26	359.7505	360.18	8811.0
2023-11-07 18:00:00	MSFT	Stock	360.18	360.3	360.0	360.14	10881.0
2023-11-07 19:00:00	MSFT	Stock	360.15	360.3	360.01	360.3	9562.0
2023-11-07 04:00:00	NVDA	Stock	45.5	45.531	45.425	45.45	77400.0
2023-11-07 05:00:00	NVDA	Stock	45.421	45.51	45.353	45.435	97100.0
2023-11-07 06:00:00	NVDA	Stock	45.458	45.459	45.305	45.358	89980.0
2023-11-07 07:00:00	NVDA	Stock	45.371	45.54	45.341	45.54	397000.0
2023-11-07 08:00:00	NVDA	Stock	45.3585	45.68	45.32	45.68	1279180.0
2023-11-07 09:00:00	NVDA	Stock	45.694	45.973	45.1575	45.5183	48170710.0
2023-11-07 10:00:00	NVDA	Stock	45.523	46.218	45.4165	46.114	58680270.0
2023-11-07 11:00:00	NVDA	Stock	46.116	46.172	45.88	45.9745	33490610.0
2023-11-07 12:00:00	NVDA	Stock	45.978	46.062	45.786	46.0155	28212390.0
2023-11-07 13:00:00	NVDA	Stock	46.021	46.1637	45.969	46.113	23267680.0
2023-11-07 14:00:00	NVDA	Stock	46.115	46.215	45.968	46.017	23450790.0
2023-11-07 15:00:00	NVDA	Stock	46.022	46.132	45.873	45.954	35649490.0
2023-11-07 16:00:00	NVDA	Stock	45.955	45.98	45.905	45.925	16083300.0
2023-11-07 17:00:00	NVDA	Stock	45.92	45.935	45.902	45.925	342410.0
2023-11-07 18:00:00	NVDA	Stock	45.925	46.048	45.923	46.04	291630.0
2023-11-07 19:00:00	NVDA	Stock	46.025	46.04	45.976	45.99	238830.0
2023-11-07 04:00:00	AMZN	Stock	139.55	139.62	139.25	139.25	3993.0
2023-11-07 05:00:00	AMZN	Stock	139.22	139.38	139.0	139.32	4921.0

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

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