PREVIEW / stock_1hour / 2004-06-04

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-06-04.parquet
  size:    483 KB
  rows:    23,245
  symbols: 1,777

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
2004-06-04 08:00:00	AAPL	Stock	0.5132	0.5132	0.5107	0.5107	84000.0
2004-06-04 09:00:00	AAPL	Stock	0.5107	0.5216	0.5091	0.5193	57306144.0
2004-06-04 10:00:00	AAPL	Stock	0.5189	0.5207	0.5161	0.518	82395432.0
2004-06-04 11:00:00	AAPL	Stock	0.5179	0.5188	0.517	0.5184	30093784.0
2004-06-04 12:00:00	AAPL	Stock	0.5182	0.5223	0.5175	0.5202	44076984.0
2004-06-04 13:00:00	AAPL	Stock	0.5202	0.5211	0.5182	0.5201	29538712.0
2004-06-04 14:00:00	AAPL	Stock	0.5207	0.5211	0.5186	0.5196	28667744.0
2004-06-04 15:00:00	AAPL	Stock	0.52	0.5204	0.5143	0.5143	71569904.0
2004-06-04 16:00:00	AAPL	Stock	0.5143	0.5179	0.5136	0.5136	6818560.0
2004-06-04 17:00:00	AAPL	Stock	0.5141	0.5179	0.5132	0.5179	4431616.0
2004-06-04 08:00:00	MSFT	Stock	26.09	26.13	26.05	26.12	142700.0
2004-06-04 09:00:00	MSFT	Stock	26.12	26.15	25.9	26.07	5930601.0
2004-06-04 10:00:00	MSFT	Stock	26.07	26.14	26.03	26.111	7787436.0
2004-06-04 11:00:00	MSFT	Stock	26.11	26.134	26.05	26.09	3506488.0
2004-06-04 12:00:00	MSFT	Stock	26.1	26.23	26.08	26.1916	7104566.0
2004-06-04 13:00:00	MSFT	Stock	26.19	26.24	26.09	26.1099	5517251.0
2004-06-04 14:00:00	MSFT	Stock	26.1	26.13	26.02	26.08	4457810.0
2004-06-04 15:00:00	MSFT	Stock	26.08	26.12	25.94	25.95	10111832.0
2004-06-04 16:00:00	MSFT	Stock	25.94	26.01	25.91	26.0	689817.0
2004-06-04 17:00:00	MSFT	Stock	25.9573	25.99	25.9573	25.96	549718.0
2004-06-04 18:00:00	MSFT	Stock	26.0	26.0	26.0	26.0	1000.0
2004-06-04 08:00:00	NVDA	Stock	0.1881	0.1896	0.1881	0.1892	1728000.0
2004-06-04 09:00:00	NVDA	Stock	0.1892	0.1906	0.1852	0.1858	76268640.0
2004-06-04 10:00:00	NVDA	Stock	0.1857	0.1857	0.1839	0.1844	117522840.0
2004-06-04 11:00:00	NVDA	Stock	0.1843	0.1855	0.1839	0.1852	77991240.0
2004-06-04 12:00:00	NVDA	Stock	0.1851	0.1857	0.1847	0.185	99151320.0
2004-06-04 13:00:00	NVDA	Stock	0.185	0.1855	0.1837	0.1848	109328520.0
2004-06-04 14:00:00	NVDA	Stock	0.1848	0.1849	0.1837	0.1842	71873160.0
2004-06-04 15:00:00	NVDA	Stock	0.1842	0.1844	0.1824	0.1824	82730520.0
2004-06-04 16:00:00	NVDA	Stock	0.1824	0.1826	0.1817	0.1817	4270800.0
2004-06-04 17:00:00	NVDA	Stock	0.1826	0.1826	0.1825	0.1825	3442200.0
2004-06-04 08:00:00	AMZN	Stock	2.481	2.51	2.481	2.51	525200.0
2004-06-04 09:00:00	AMZN	Stock	2.5085	2.549	2.5	2.546	32501900.0
2004-06-04 10:00:00	AMZN	Stock	2.545	2.571	2.5295	2.5555	64897680.0
2004-06-04 11:00:00	AMZN	Stock	2.5555	2.5615	2.5355	2.54	31517100.0
2004-06-04 12:00:00	AMZN	Stock	2.5395	2.5625	2.538	2.56	24364100.0
2004-06-04 13:00:00	AMZN	Stock	2.56	2.564	2.547	2.554	14408200.0
2004-06-04 14:00:00	AMZN	Stock	2.554	2.5755	2.553	2.567	29682340.0
2004-06-04 15:00:00	AMZN	Stock	2.5675	2.569	2.5405	2.5465	36703500.0
2004-06-04 16:00:00	AMZN	Stock	2.5445	2.55	2.5435	2.5487	3317280.0
2004-06-04 17:00:00	AMZN	Stock	2.5482	2.5482	2.5465	2.5475	1016820.0
2004-06-04 18:00:00	AMZN	Stock	2.5485	2.549	2.5485	2.5485	14000.0
2004-06-04 09:00:00	CL	Stock	28.655	28.71	28.545	28.58	430200.0
2004-06-04 10:00:00	CL	Stock	28.57	28.57	28.28	28.295	674800.0
2004-06-04 11:00:00	CL	Stock	28.3	28.43	28.3	28.405	283800.0
2004-06-04 12:00:00	CL	Stock	28.41	28.55	28.365	28.5	461400.0
2004-06-04 13:00:00	CL	Stock	28.485	28.51	28.42	28.49	247400.0
2004-06-04 14:00:00	CL	Stock	28.485	28.49	28.39	28.455	269200.0
2004-06-04 15:00:00	CL	Stock	28.455	28.5	28.345	28.455	737800.0
2004-06-04 16:00:00	CL	Stock	28.46	28.46	28.46	28.46	10000.0

> showing 50 of 23,245 rows — these rows as CSV

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