PREVIEW / stock_1hour / 2004-10-27

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-10-27.parquet
  size:    551 KB
  rows:    25,815
  symbols: 1,851

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-27 08:00:00	AAPL	Stock	0.8679	0.8679	0.8616	0.8634	1128400.0
2004-10-27 09:00:00	AAPL	Stock	0.8643	0.8748	0.8577	0.8618	123012120.0
2004-10-27 10:00:00	AAPL	Stock	0.8618	0.8754	0.8611	0.8748	181031144.0
2004-10-27 11:00:00	AAPL	Stock	0.8748	0.892	0.873	0.8852	212701944.0
2004-10-27 12:00:00	AAPL	Stock	0.8852	0.8929	0.8841	0.8871	88604992.0
2004-10-27 13:00:00	AAPL	Stock	0.8873	0.8927	0.8871	0.892	88672640.0
2004-10-27 14:00:00	AAPL	Stock	0.892	0.8955	0.89	0.8934	206628968.0
2004-10-27 15:00:00	AAPL	Stock	0.8934	0.9039	0.8929	0.8988	205982896.0
2004-10-27 16:00:00	AAPL	Stock	0.8986	0.8996	0.8786	0.8982	21666568.0
2004-10-27 17:00:00	AAPL	Stock	0.8973	0.8982	0.8973	0.8982	3160864.0
2004-10-27 18:00:00	AAPL	Stock	0.8566	0.9	0.8566	0.9	2098600.0
2004-10-27 08:00:00	MSFT	Stock	27.93	27.93	27.82	27.85	19045.0
2004-10-27 09:00:00	MSFT	Stock	27.88	27.96	27.83	27.84	5509650.0
2004-10-27 10:00:00	MSFT	Stock	27.84	28.12	27.83	28.109	11382995.0
2004-10-27 11:00:00	MSFT	Stock	28.11	28.351	28.1	28.27	12415328.0
2004-10-27 12:00:00	MSFT	Stock	28.269	28.31	28.17	28.2	7075354.0
2004-10-27 13:00:00	MSFT	Stock	28.19	28.33	28.14	28.21	7204179.0
2004-10-27 14:00:00	MSFT	Stock	28.21	28.27	28.13	28.18	11342051.0
2004-10-27 15:00:00	MSFT	Stock	28.18	28.29	28.04	28.13	12910456.0
2004-10-27 16:00:00	MSFT	Stock	28.13	28.25	28.1	28.14	2302427.0
2004-10-27 17:00:00	MSFT	Stock	28.14	28.15	28.06	28.06	790715.0
2004-10-27 18:00:00	MSFT	Stock	27.9	28.13	27.9	28.13	226048.0
2004-10-27 08:00:00	NVDA	Stock	0.1209	0.1209	0.1188	0.1188	1298880.0
2004-10-27 09:00:00	NVDA	Stock	0.1189	0.1229	0.1186	0.1215	123261360.0
2004-10-27 10:00:00	NVDA	Stock	0.1219	0.1249	0.1212	0.1248	168125280.0
2004-10-27 11:00:00	NVDA	Stock	0.1249	0.1263	0.1248	0.1249	163380480.0
2004-10-27 12:00:00	NVDA	Stock	0.1249	0.1252	0.1237	0.1241	109628640.0
2004-10-27 13:00:00	NVDA	Stock	0.1241	0.1247	0.1239	0.1242	84564960.0
2004-10-27 14:00:00	NVDA	Stock	0.1242	0.125	0.1238	0.1243	97700520.0
2004-10-27 15:00:00	NVDA	Stock	0.1243	0.125	0.1235	0.1238	250314000.0
2004-10-27 16:00:00	NVDA	Stock	0.1238	0.1243	0.1234	0.1241	11405520.0
2004-10-27 17:00:00	NVDA	Stock	0.1237	0.1241	0.1225	0.1225	30010320.0
2004-10-27 18:00:00	NVDA	Stock	0.1207	0.1234	0.1207	0.1234	1514520.0
2004-10-27 08:00:00	AMZN	Stock	1.6915	1.6915	1.6915	1.6915	7000.0
2004-10-27 09:00:00	AMZN	Stock	1.692	1.7075	1.681	1.7055	21309100.0
2004-10-27 10:00:00	AMZN	Stock	1.706	1.73	1.705	1.728	49094920.0
2004-10-27 11:00:00	AMZN	Stock	1.7285	1.7315	1.721	1.723	38714820.0
2004-10-27 12:00:00	AMZN	Stock	1.7235	1.724	1.714	1.719	14841220.0
2004-10-27 13:00:00	AMZN	Stock	1.7185	1.729	1.715	1.722	11458720.0
2004-10-27 14:00:00	AMZN	Stock	1.7215	1.726	1.7135	1.719	14780040.0
2004-10-27 15:00:00	AMZN	Stock	1.7185	1.7255	1.71	1.7125	25393880.0
2004-10-27 16:00:00	AMZN	Stock	1.7125	1.714	1.705	1.705	2063880.0
2004-10-27 17:00:00	AMZN	Stock	1.707	1.715	1.706	1.706	499600.0
2004-10-27 18:00:00	AMZN	Stock	1.6915	1.7115	1.6915	1.7115	363760.0
2004-10-27 09:00:00	CL	Stock	22.69	22.695	22.4	22.555	552800.0
2004-10-27 10:00:00	CL	Stock	22.555	22.59	22.46	22.53	516800.0
2004-10-27 11:00:00	CL	Stock	22.53	22.701	22.53	22.595	848600.0
2004-10-27 12:00:00	CL	Stock	22.6	22.65	22.59	22.65	555000.0
2004-10-27 13:00:00	CL	Stock	22.645	22.69	22.635	22.655	660200.0
2004-10-27 14:00:00	CL	Stock	22.65	22.68	22.625	22.66	1025000.0

> showing 50 of 25,815 rows — these rows as CSV

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