PREVIEW / stock_1hour / 2004-10-20

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-10-20.parquet
  size:    523 KB
  rows:    24,723
  symbols: 1,839

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-10-20 08:00:00	AAPL	Stock	0.842	0.8465	0.842	0.842	1780968.0
2004-10-20 09:00:00	AAPL	Stock	0.8439	0.8491	0.84	0.8486	62518848.0
2004-10-20 10:00:00	AAPL	Stock	0.8486	0.85	0.833	0.84	106307096.0
2004-10-20 11:00:00	AAPL	Stock	0.8404	0.8477	0.8398	0.8427	90242824.0
2004-10-20 12:00:00	AAPL	Stock	0.8427	0.8446	0.8366	0.843	64622544.0
2004-10-20 13:00:00	AAPL	Stock	0.843	0.8438	0.8359	0.8363	49070056.0
2004-10-20 14:00:00	AAPL	Stock	0.8363	0.8454	0.8363	0.8418	62977152.0
2004-10-20 15:00:00	AAPL	Stock	0.842	0.8491	0.842	0.848	93536128.0
2004-10-20 16:00:00	AAPL	Stock	0.848	0.8482	0.8444	0.8477	3963064.0
2004-10-20 17:00:00	AAPL	Stock	0.85	0.85	0.8477	0.8477	10806880.0
2004-10-20 18:00:00	AAPL	Stock	0.8498	0.85	0.8482	0.85	165200.0
2004-10-20 08:00:00	MSFT	Stock	28.0	28.29	28.0	28.22	79500.0
2004-10-20 09:00:00	MSFT	Stock	28.24	28.26	28.0955	28.25	5371600.0
2004-10-20 10:00:00	MSFT	Stock	28.25	28.49	28.21	28.47	12527370.0
2004-10-20 11:00:00	MSFT	Stock	28.48	28.59	28.44	28.57	12900360.0
2004-10-20 12:00:00	MSFT	Stock	28.57	28.75	28.54	28.67	11474494.0
2004-10-20 13:00:00	MSFT	Stock	28.67	28.71	28.51	28.52	7682713.0
2004-10-20 14:00:00	MSFT	Stock	28.52	28.62	28.49	28.57	7368442.0
2004-10-20 15:00:00	MSFT	Stock	28.58	28.7	28.52	28.7	8079582.0
2004-10-20 16:00:00	MSFT	Stock	28.71	28.8	28.5515	28.8	752312.0
2004-10-20 17:00:00	MSFT	Stock	28.77	28.83	28.5013	28.8	84779.0
2004-10-20 18:00:00	MSFT	Stock	28.75	28.83	28.74	28.83	4725.0
2004-10-20 08:00:00	NVDA	Stock	0.1125	0.1126	0.1125	0.1126	432000.0
2004-10-20 09:00:00	NVDA	Stock	0.1127	0.1149	0.1113	0.1134	54211440.0
2004-10-20 10:00:00	NVDA	Stock	0.1132	0.1136	0.1121	0.1128	68131080.0
2004-10-20 11:00:00	NVDA	Stock	0.113	0.1143	0.1129	0.1138	84124800.0
2004-10-20 12:00:00	NVDA	Stock	0.1139	0.1144	0.1137	0.1144	93812160.0
2004-10-20 13:00:00	NVDA	Stock	0.1144	0.1144	0.1139	0.1142	49197720.0
2004-10-20 14:00:00	NVDA	Stock	0.1142	0.1143	0.1137	0.1138	81009240.0
2004-10-20 15:00:00	NVDA	Stock	0.1139	0.1145	0.1137	0.1145	95948280.0
2004-10-20 16:00:00	NVDA	Stock	0.1145	0.1152	0.1141	0.1144	3353520.0
2004-10-20 17:00:00	NVDA	Stock	0.1141	0.1147	0.1141	0.1142	312000.0
2004-10-20 18:00:00	NVDA	Stock	0.1146	0.1147	0.1146	0.1147	132000.0
2004-10-20 08:00:00	AMZN	Stock	1.915	1.915	1.91	1.91	92200.0
2004-10-20 09:00:00	AMZN	Stock	1.9075	1.9295	1.893	1.9255	21006560.0
2004-10-20 10:00:00	AMZN	Stock	1.926	1.9275	1.9075	1.916	22877560.0
2004-10-20 11:00:00	AMZN	Stock	1.9155	1.924	1.9085	1.9125	19117800.0
2004-10-20 12:00:00	AMZN	Stock	1.9115	1.917	1.907	1.913	12519460.0
2004-10-20 13:00:00	AMZN	Stock	1.913	1.9165	1.9065	1.907	12744120.0
2004-10-20 14:00:00	AMZN	Stock	1.907	1.913	1.8975	1.9005	14157360.0
2004-10-20 15:00:00	AMZN	Stock	1.9005	1.918	1.8895	1.9165	28403980.0
2004-10-20 16:00:00	AMZN	Stock	1.9165	1.95	1.888	1.9355	3625860.0
2004-10-20 17:00:00	AMZN	Stock	1.9325	1.9465	1.9175	1.945	530000.0
2004-10-20 18:00:00	AMZN	Stock	1.9445	1.95	1.9435	1.9495	128400.0
2004-10-20 08:00:00	CL	Stock	21.64	21.64	21.64	21.64	200.0
2004-10-20 09:00:00	CL	Stock	21.85	22.375	21.85	22.18	2376400.0
2004-10-20 10:00:00	CL	Stock	22.185	22.225	22.0	22.075	3089400.0
2004-10-20 11:00:00	CL	Stock	22.08	22.15	22.005	22.1	2367600.0
2004-10-20 12:00:00	CL	Stock	22.105	22.18	22.045	22.17	1412400.0
2004-10-20 13:00:00	CL	Stock	22.175	22.47	22.12	22.425	2043200.0

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

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