PREVIEW / stock_1hour / 2004-09-21

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-09-21.parquet
  size:    506 KB
  rows:    24,269
  symbols: 1,832

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-09-21 08:00:00	AAPL	Stock	0.6741	0.6741	0.6741	0.6741	46480.0
2004-09-21 09:00:00	AAPL	Stock	0.6757	0.6795	0.6705	0.6746	35077336.0
2004-09-21 10:00:00	AAPL	Stock	0.6745	0.6786	0.6689	0.6782	42486192.0
2004-09-21 11:00:00	AAPL	Stock	0.6779	0.6823	0.6773	0.68	34312376.0
2004-09-21 12:00:00	AAPL	Stock	0.6802	0.6805	0.677	0.6784	14934864.0
2004-09-21 13:00:00	AAPL	Stock	0.6786	0.6843	0.678	0.6843	36664152.0
2004-09-21 14:00:00	AAPL	Stock	0.6839	0.6929	0.6829	0.6925	81535832.0
2004-09-21 15:00:00	AAPL	Stock	0.6923	0.6941	0.6836	0.6868	121668400.0
2004-09-21 16:00:00	AAPL	Stock	0.6871	0.6886	0.6788	0.6846	12748568.0
2004-09-21 17:00:00	AAPL	Stock	0.6836	0.6855	0.6832	0.6832	115920.0
2004-09-21 08:00:00	MSFT	Stock	27.54	27.54	27.44	27.52	39600.0
2004-09-21 09:00:00	MSFT	Stock	27.54	27.55	27.4	27.42	7530964.0
2004-09-21 10:00:00	MSFT	Stock	27.42	27.42	27.35	27.39	8539536.0
2004-09-21 11:00:00	MSFT	Stock	27.3993	27.43	27.36	27.36	6731689.0
2004-09-21 12:00:00	MSFT	Stock	27.36	27.38	27.32	27.36	5202823.0
2004-09-21 13:00:00	MSFT	Stock	27.37	27.39	27.319	27.36	5388616.0
2004-09-21 14:00:00	MSFT	Stock	27.361	27.48	27.32	27.46	13426911.0
2004-09-21 15:00:00	MSFT	Stock	27.46	27.53	27.27	27.29	17765102.0
2004-09-21 16:00:00	MSFT	Stock	27.29	27.5	27.25	27.26	7956900.0
2004-09-21 17:00:00	MSFT	Stock	27.27	27.3	27.26	27.3	27066.0
2004-09-21 18:00:00	MSFT	Stock	27.29	27.3	27.28	27.3	10094.0
2004-09-21 08:00:00	NVDA	Stock	0.1229	0.123	0.1229	0.123	24000.0
2004-09-21 09:00:00	NVDA	Stock	0.1238	0.1265	0.1238	0.1253	125858880.0
2004-09-21 10:00:00	NVDA	Stock	0.1253	0.1257	0.124	0.1242	86787960.0
2004-09-21 11:00:00	NVDA	Stock	0.1241	0.1251	0.1241	0.1242	47500560.0
2004-09-21 12:00:00	NVDA	Stock	0.1242	0.1244	0.1235	0.1242	40762680.0
2004-09-21 13:00:00	NVDA	Stock	0.1242	0.1247	0.1238	0.1246	24498960.0
2004-09-21 14:00:00	NVDA	Stock	0.1246	0.1257	0.1237	0.1257	68474520.0
2004-09-21 15:00:00	NVDA	Stock	0.1256	0.1258	0.1247	0.1253	96656640.0
2004-09-21 16:00:00	NVDA	Stock	0.1252	0.1255	0.1245	0.125	7556400.0
2004-09-21 08:00:00	AMZN	Stock	2.175	2.175	2.17	2.17	80000.0
2004-09-21 09:00:00	AMZN	Stock	2.17	2.1885	2.1435	2.1505	25427520.0
2004-09-21 10:00:00	AMZN	Stock	2.15	2.1815	2.1385	2.1675	25622580.0
2004-09-21 11:00:00	AMZN	Stock	2.167	2.175	2.1575	2.1675	10077160.0
2004-09-21 12:00:00	AMZN	Stock	2.1685	2.1695	2.15	2.151	9381040.0
2004-09-21 13:00:00	AMZN	Stock	2.15	2.17	2.15	2.1695	8033100.0
2004-09-21 14:00:00	AMZN	Stock	2.169	2.1775	2.1515	2.1755	24215360.0
2004-09-21 15:00:00	AMZN	Stock	2.1755	2.178	2.1535	2.1645	27114660.0
2004-09-21 16:00:00	AMZN	Stock	2.1645	2.1646	2.159	2.162	2287400.0
2004-09-21 17:00:00	AMZN	Stock	2.1625	2.163	2.162	2.163	67000.0
2004-09-21 08:00:00	CL	Stock	24.25	24.255	24.15	24.255	4600.0
2004-09-21 09:00:00	CL	Stock	24.23	24.23	23.66	23.725	3690400.0
2004-09-21 10:00:00	CL	Stock	23.735	23.76	23.4	23.4	7939800.0
2004-09-21 11:00:00	CL	Stock	23.405	23.405	23.065	23.165	6174600.0
2004-09-21 12:00:00	CL	Stock	23.165	23.225	23.025	23.065	4092400.0
2004-09-21 13:00:00	CL	Stock	23.065	23.11	22.88	23.025	4521600.0
2004-09-21 14:00:00	CL	Stock	23.025	23.075	22.905	23.03	5910400.0
2004-09-21 15:00:00	CL	Stock	23.03	23.075	22.95	23.02	5829600.0
2004-09-21 16:00:00	CL	Stock	23.02	23.05	22.925	23.05	89000.0
2004-09-21 17:00:00	CL	Stock	23.05	23.075	23.05	23.075	2400.0

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

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