PREVIEW / stock_1hour / 2023-09-28

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-09-28.parquet
  size:    1.3 MB
  rows:    58,145
  symbols: 1,396

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-28 04:00:00	AAPL	Stock	170.2	170.25	169.8	169.81	15549.0
2023-09-28 05:00:00	AAPL	Stock	169.81	170.15	169.61	170.15	31013.0
2023-09-28 06:00:00	AAPL	Stock	170.19	170.29	169.94	170.18	10729.0
2023-09-28 07:00:00	AAPL	Stock	170.18	170.23	169.73	169.75	44376.0
2023-09-28 08:00:00	AAPL	Stock	170.0	170.5	169.41	169.6799	321645.0
2023-09-28 09:00:00	AAPL	Stock	169.72	169.95	167.62	169.61	8350062.0
2023-09-28 10:00:00	AAPL	Stock	169.61	170.27	168.69	170.249	7912027.0
2023-09-28 11:00:00	AAPL	Stock	170.24	171.6181	169.8	171.6	7183498.0
2023-09-28 12:00:00	AAPL	Stock	171.6	172.03	171.03	171.13	4721189.0
2023-09-28 13:00:00	AAPL	Stock	171.135	171.53	170.43	170.86	4298276.0
2023-09-28 14:00:00	AAPL	Stock	170.86	171.165	170.31	170.75	3990899.0
2023-09-28 15:00:00	AAPL	Stock	170.75	171.68	170.44	170.69	7278392.0
2023-09-28 16:00:00	AAPL	Stock	170.66	171.03	170.55	171.0	4248579.0
2023-09-28 17:00:00	AAPL	Stock	171.0	171.0	170.69	170.95	21691.0
2023-09-28 18:00:00	AAPL	Stock	170.97	171.24	170.95	170.95	40892.0
2023-09-28 19:00:00	AAPL	Stock	170.97	171.01	170.8	170.8	14941.0
2023-09-28 04:00:00	MSFT	Stock	312.97	313.17	312.81	313.1	1177.0
2023-09-28 05:00:00	MSFT	Stock	312.55	313.1	311.65	313.09	1832.0
2023-09-28 06:00:00	MSFT	Stock	312.94	313.1	312.24	312.5	6326.0
2023-09-28 07:00:00	MSFT	Stock	312.28	312.28	310.3	310.35	29749.0
2023-09-28 08:00:00	MSFT	Stock	310.4	313.35	310.3	311.3798	70253.0
2023-09-28 09:00:00	MSFT	Stock	311.4	311.75	309.45	311.57	2053079.0
2023-09-28 10:00:00	MSFT	Stock	311.57	312.1189	309.88	311.45	2027467.0
2023-09-28 11:00:00	MSFT	Stock	311.445	314.124	310.8	313.86	1996459.0
2023-09-28 12:00:00	MSFT	Stock	313.86	315.48	313.73	314.22	1481888.0
2023-09-28 13:00:00	MSFT	Stock	314.24	314.67	313.09	313.37	859727.0
2023-09-28 14:00:00	MSFT	Stock	313.41	314.52	312.72	313.48	758481.0
2023-09-28 15:00:00	MSFT	Stock	313.4816	314.65	312.81	313.67	1968079.0
2023-09-28 16:00:00	MSFT	Stock	313.62	314.29	313.35	313.9	2007480.0
2023-09-28 17:00:00	MSFT	Stock	313.93	314.42	313.64	313.95	13693.0
2023-09-28 18:00:00	MSFT	Stock	313.95	314.42	313.95	314.4	4336.0
2023-09-28 19:00:00	MSFT	Stock	314.23	314.4	313.81	313.83	4806.0
2023-09-28 04:00:00	NVDA	Stock	42.52	42.52	42.328	42.364	178200.0
2023-09-28 05:00:00	NVDA	Stock	42.35	42.4	42.201	42.4	140800.0
2023-09-28 06:00:00	NVDA	Stock	42.385	42.4	42.311	42.398	144540.0
2023-09-28 07:00:00	NVDA	Stock	42.382	42.4	42.3	42.38	397820.0
2023-09-28 08:00:00	NVDA	Stock	42.398	42.734	42.3	42.438	1833790.0
2023-09-28 09:00:00	NVDA	Stock	42.454	42.895	42.115	42.7801	55484450.0
2023-09-28 10:00:00	NVDA	Stock	42.785	43.028	42.381	42.8195	69266440.0
2023-09-28 11:00:00	NVDA	Stock	42.819	43.4463	42.6464	43.3895	51011950.0
2023-09-28 12:00:00	NVDA	Stock	43.387	43.439	43.106	43.182	33837830.0
2023-09-28 13:00:00	NVDA	Stock	43.18	43.321	42.963	43.151	32819950.0
2023-09-28 14:00:00	NVDA	Stock	43.1495	43.286	42.787	43.041	39509750.0
2023-09-28 15:00:00	NVDA	Stock	43.042	43.316	42.955	43.068	46245080.0
2023-09-28 16:00:00	NVDA	Stock	43.064	43.185	43.06	43.175	11717080.0
2023-09-28 17:00:00	NVDA	Stock	43.16	43.174	43.122	43.15	314440.0
2023-09-28 18:00:00	NVDA	Stock	43.167	43.342	43.16	43.28	479610.0
2023-09-28 19:00:00	NVDA	Stock	43.275	43.288	43.256	43.26	339190.0
2023-09-28 04:00:00	AMZN	Stock	126.26	126.3	125.84	126.04	4331.0
2023-09-28 05:00:00	AMZN	Stock	125.81	125.98	125.47	125.98	8651.0

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

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