PREVIEW / stock_1hour / 2004-07-27

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-07-27.parquet
  size:    502 KB
  rows:    23,530
  symbols: 1,810

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-27 08:00:00	AAPL	Stock	0.5657	0.5741	0.5657	0.5709	1341368.0
2004-07-27 09:00:00	AAPL	Stock	0.5705	0.5707	0.5638	0.5654	31938424.0
2004-07-27 10:00:00	AAPL	Stock	0.565	0.5757	0.565	0.5705	110477360.0
2004-07-27 11:00:00	AAPL	Stock	0.5705	0.5759	0.5688	0.5752	49363216.0
2004-07-27 12:00:00	AAPL	Stock	0.5754	0.5782	0.5736	0.578	26590984.0
2004-07-27 13:00:00	AAPL	Stock	0.578	0.5784	0.573	0.5752	23986312.0
2004-07-27 14:00:00	AAPL	Stock	0.5752	0.5838	0.5732	0.5838	46912768.0
2004-07-27 15:00:00	AAPL	Stock	0.5838	0.5848	0.5784	0.5791	83660304.0
2004-07-27 16:00:00	AAPL	Stock	0.5791	0.5793	0.5768	0.5791	10233496.0
2004-07-27 17:00:00	AAPL	Stock	0.5786	0.5788	0.5784	0.5788	39200.0
2004-07-27 08:00:00	MSFT	Stock	28.77	29.67	28.65	28.75	325962.0
2004-07-27 09:00:00	MSFT	Stock	28.76	28.77	28.47	28.54	5697409.0
2004-07-27 10:00:00	MSFT	Stock	28.54	28.59	28.15	28.17	13990216.0
2004-07-27 11:00:00	MSFT	Stock	28.17	28.4	28.13	28.38	10093572.0
2004-07-27 12:00:00	MSFT	Stock	28.38	28.5	28.38	28.43	6338547.0
2004-07-27 13:00:00	MSFT	Stock	28.43	28.45	28.29	28.33	4645519.0
2004-07-27 14:00:00	MSFT	Stock	28.34	28.46	28.27	28.39	7207181.0
2004-07-27 15:00:00	MSFT	Stock	28.381	28.59	28.38	28.46	10967944.0
2004-07-27 16:00:00	MSFT	Stock	28.47	28.5	28.35	28.49	6358311.0
2004-07-27 17:00:00	MSFT	Stock	28.46	28.506	28.38	28.38	40183.0
2004-07-27 18:00:00	MSFT	Stock	28.4	28.43	28.38	28.39	5500.0
2004-07-27 08:00:00	NVDA	Stock	0.1167	0.1184	0.1152	0.1174	2625720.0
2004-07-27 09:00:00	NVDA	Stock	0.1172	0.1185	0.116	0.1167	49644240.0
2004-07-27 10:00:00	NVDA	Stock	0.1167	0.1191	0.1164	0.1167	54965400.0
2004-07-27 11:00:00	NVDA	Stock	0.1167	0.1181	0.1153	0.1181	52060200.0
2004-07-27 12:00:00	NVDA	Stock	0.1181	0.1182	0.1172	0.1175	67907880.0
2004-07-27 13:00:00	NVDA	Stock	0.1175	0.1197	0.1171	0.1187	194275200.0
2004-07-27 14:00:00	NVDA	Stock	0.1187	0.1207	0.118	0.1207	158772960.0
2004-07-27 15:00:00	NVDA	Stock	0.1207	0.1227	0.1207	0.1224	141276960.0
2004-07-27 16:00:00	NVDA	Stock	0.1223	0.1226	0.1211	0.1217	20914680.0
2004-07-27 17:00:00	NVDA	Stock	0.1223	0.1223	0.1215	0.1215	180000.0
2004-07-27 18:00:00	NVDA	Stock	0.1218	0.1219	0.1218	0.1219	72000.0
2004-07-27 08:00:00	AMZN	Stock	1.94	1.9525	1.94	1.95	49900.0
2004-07-27 09:00:00	AMZN	Stock	1.95	1.969	1.949	1.967	20151720.0
2004-07-27 10:00:00	AMZN	Stock	1.967	1.9955	1.96	1.965	45832200.0
2004-07-27 11:00:00	AMZN	Stock	1.966	1.974	1.9415	1.9545	27025520.0
2004-07-27 12:00:00	AMZN	Stock	1.955	1.9605	1.94	1.9495	24039300.0
2004-07-27 13:00:00	AMZN	Stock	1.9495	1.963	1.9445	1.9615	15712540.0
2004-07-27 14:00:00	AMZN	Stock	1.9615	1.9825	1.955	1.9817	21047500.0
2004-07-27 15:00:00	AMZN	Stock	1.9812	1.989	1.9535	1.9575	43169640.0
2004-07-27 16:00:00	AMZN	Stock	1.9575	1.9585	1.942	1.9585	2409340.0
2004-07-27 17:00:00	AMZN	Stock	1.957	1.957	1.9565	1.9565	6000.0
2004-07-27 18:00:00	AMZN	Stock	1.956	1.956	1.956	1.956	20000.0
2004-07-27 09:00:00	CL	Stock	26.445	26.565	26.29	26.55	236800.0
2004-07-27 10:00:00	CL	Stock	26.55	26.615	26.485	26.595	418400.0
2004-07-27 11:00:00	CL	Stock	26.595	26.64	26.425	26.44	509800.0
2004-07-27 12:00:00	CL	Stock	26.44	26.54	26.355	26.355	319600.0
2004-07-27 13:00:00	CL	Stock	26.36	26.36	26.25	26.255	525400.0
2004-07-27 14:00:00	CL	Stock	26.255	26.48	26.215	26.47	420600.0
2004-07-27 15:00:00	CL	Stock	26.465	26.57	26.435	26.53	821200.0

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

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