PREVIEW / stock_1hour / 2004-07-22

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-07-22.parquet
  size:    518 KB
  rows:    24,493
  symbols: 1,802

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-07-22 08:00:00	AAPL	Stock	0.5646	0.5648	0.5643	0.5648	95200.0
2004-07-22 09:00:00	AAPL	Stock	0.5643	0.5643	0.5563	0.5613	56372232.0
2004-07-22 10:00:00	AAPL	Stock	0.5614	0.5634	0.5598	0.5616	74871216.0
2004-07-22 11:00:00	AAPL	Stock	0.5614	0.5614	0.5546	0.5573	39703720.0
2004-07-22 12:00:00	AAPL	Stock	0.5573	0.5627	0.5563	0.5595	29803032.0
2004-07-22 13:00:00	AAPL	Stock	0.5591	0.5616	0.558	0.5602	20732152.0
2004-07-22 14:00:00	AAPL	Stock	0.5604	0.565	0.5596	0.5636	27085520.0
2004-07-22 15:00:00	AAPL	Stock	0.5634	0.5666	0.5614	0.565	55448176.0
2004-07-22 16:00:00	AAPL	Stock	0.5657	0.5661	0.5605	0.5657	7451640.0
2004-07-22 17:00:00	AAPL	Stock	0.5657	0.567	0.5657	0.567	1204000.0
2004-07-22 18:00:00	AAPL	Stock	0.5646	0.5646	0.5646	0.5646	16800.0
2004-07-22 08:00:00	MSFT	Stock	29.0	29.1	28.87	28.92	200904.0
2004-07-22 09:00:00	MSFT	Stock	28.91	29.3	28.9	29.09	20616860.0
2004-07-22 10:00:00	MSFT	Stock	29.08	29.21	28.94	28.98	18870827.0
2004-07-22 11:00:00	MSFT	Stock	28.99	29.04	28.859	28.93	14516472.0
2004-07-22 12:00:00	MSFT	Stock	28.92	29.1	28.88	28.97	12458299.0
2004-07-22 13:00:00	MSFT	Stock	28.97	29.07	28.83	28.85	7268497.0
2004-07-22 14:00:00	MSFT	Stock	28.849	29.04	28.84	28.96	12128506.0
2004-07-22 15:00:00	MSFT	Stock	28.97	29.05	28.85	29.0	18343421.0
2004-07-22 16:00:00	MSFT	Stock	29.02	29.38	27.34	27.81	13421766.0
2004-07-22 17:00:00	MSFT	Stock	27.82	29.05	27.64	28.4	6021712.0
2004-07-22 18:00:00	MSFT	Stock	28.38	28.4	28.22	28.35	554959.0
2004-07-22 08:00:00	NVDA	Stock	0.1233	0.1233	0.1227	0.1233	168000.0
2004-07-22 09:00:00	NVDA	Stock	0.1233	0.1258	0.1221	0.1236	73058640.0
2004-07-22 10:00:00	NVDA	Stock	0.1236	0.124	0.1215	0.1222	94844040.0
2004-07-22 11:00:00	NVDA	Stock	0.1222	0.1225	0.12	0.1213	81064560.0
2004-07-22 12:00:00	NVDA	Stock	0.1213	0.1231	0.1212	0.123	55269720.0
2004-07-22 13:00:00	NVDA	Stock	0.1231	0.1234	0.1216	0.1227	47403960.0
2004-07-22 14:00:00	NVDA	Stock	0.1227	0.1247	0.1227	0.1244	59568480.0
2004-07-22 15:00:00	NVDA	Stock	0.1244	0.1258	0.1232	0.1252	94139520.0
2004-07-22 16:00:00	NVDA	Stock	0.1254	0.1255	0.124	0.1246	5368080.0
2004-07-22 17:00:00	NVDA	Stock	0.124	0.1254	0.124	0.124	1698120.0
2004-07-22 18:00:00	NVDA	Stock	0.1246	0.1246	0.1246	0.1246	12000.0
2004-07-22 08:00:00	AMZN	Stock	2.165	2.2385	2.1625	2.185	862500.0
2004-07-22 09:00:00	AMZN	Stock	2.18	2.2475	2.167	2.1905	44200880.0
2004-07-22 10:00:00	AMZN	Stock	2.1905	2.2195	2.1875	2.204	33726920.0
2004-07-22 11:00:00	AMZN	Stock	2.2045	2.212	2.1925	2.2025	21445320.0
2004-07-22 12:00:00	AMZN	Stock	2.203	2.2445	2.2025	2.226	42226900.0
2004-07-22 13:00:00	AMZN	Stock	2.226	2.2395	2.215	2.23	19190200.0
2004-07-22 14:00:00	AMZN	Stock	2.231	2.2825	2.229	2.2685	44733920.0
2004-07-22 15:00:00	AMZN	Stock	2.2695	2.3035	2.256	2.291	48113080.0
2004-07-22 16:00:00	AMZN	Stock	2.2885	2.3	2.125	2.1735	59727480.0
2004-07-22 17:00:00	AMZN	Stock	2.1735	2.289	2.162	2.1785	6677040.0
2004-07-22 18:00:00	AMZN	Stock	2.176	2.187	2.175	2.185	494220.0
2004-07-22 08:00:00	CL	Stock	27.5	27.5	27.5	27.5	2000.0
2004-07-22 09:00:00	CL	Stock	27.2	27.205	26.8	26.805	731200.0
2004-07-22 10:00:00	CL	Stock	26.81	27.045	26.8	27.04	957800.0
2004-07-22 11:00:00	CL	Stock	27.045	27.065	26.925	26.955	862600.0
2004-07-22 12:00:00	CL	Stock	26.955	27.005	26.915	26.94	848400.0
2004-07-22 13:00:00	CL	Stock	26.94	26.95	26.85	26.85	316200.0

> showing 50 of 24,493 rows — these rows as CSV

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