PREVIEW / stock_1hour / 2004-07-29

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-07-29.parquet
  size:    502 KB
  rows:    23,556
  symbols: 1,813

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-29 08:00:00	AAPL	Stock	0.5786	0.5786	0.5764	0.5764	168000.0
2004-07-29 09:00:00	AAPL	Stock	0.5798	0.5821	0.5796	0.5802	23515632.0
2004-07-29 10:00:00	AAPL	Stock	0.5805	0.5813	0.5738	0.5779	41802600.0
2004-07-29 11:00:00	AAPL	Stock	0.5777	0.5786	0.5743	0.5746	16518488.0
2004-07-29 12:00:00	AAPL	Stock	0.5746	0.583	0.5741	0.5821	28417760.0
2004-07-29 13:00:00	AAPL	Stock	0.5823	0.5861	0.5818	0.5821	33312608.0
2004-07-29 14:00:00	AAPL	Stock	0.5821	0.5832	0.5795	0.5832	24988768.0
2004-07-29 15:00:00	AAPL	Stock	0.5832	0.5857	0.5809	0.583	39395048.0
2004-07-29 16:00:00	AAPL	Stock	0.583	0.5841	0.5821	0.5827	2348976.0
2004-07-29 17:00:00	AAPL	Stock	0.5827	0.583	0.582	0.583	253680.0
2004-07-29 08:00:00	MSFT	Stock	28.62	28.74	28.595	28.73	76382.0
2004-07-29 09:00:00	MSFT	Stock	28.72	28.8	28.7	28.779	3689802.0
2004-07-29 10:00:00	MSFT	Stock	28.78	28.78	28.47	28.57	8746622.0
2004-07-29 11:00:00	MSFT	Stock	28.57	28.62	28.46	28.52	6005770.0
2004-07-29 12:00:00	MSFT	Stock	28.52	28.63	28.47	28.53	6057810.0
2004-07-29 13:00:00	MSFT	Stock	28.53	28.61	28.449	28.45	5186245.0
2004-07-29 14:00:00	MSFT	Stock	28.45	28.46	28.25	28.42	10929890.0
2004-07-29 15:00:00	MSFT	Stock	28.42	28.5	28.29	28.47	15324942.0
2004-07-29 16:00:00	MSFT	Stock	28.47	28.54	28.29	28.49	811470.0
2004-07-29 17:00:00	MSFT	Stock	28.5	28.51	28.45	28.45	42400.0
2004-07-29 18:00:00	MSFT	Stock	28.45	28.46	28.45	28.46	2300.0
2004-07-29 08:00:00	NVDA	Stock	0.1196	0.1202	0.1192	0.1202	1680000.0
2004-07-29 09:00:00	NVDA	Stock	0.1212	0.1297	0.12	0.128	170973360.0
2004-07-29 10:00:00	NVDA	Stock	0.1281	0.1282	0.1255	0.1271	164687880.0
2004-07-29 11:00:00	NVDA	Stock	0.1271	0.128	0.1265	0.1271	76768560.0
2004-07-29 12:00:00	NVDA	Stock	0.1269	0.1297	0.1265	0.1292	64720680.0
2004-07-29 13:00:00	NVDA	Stock	0.1292	0.1302	0.1286	0.1286	65900880.0
2004-07-29 14:00:00	NVDA	Stock	0.1286	0.1287	0.1262	0.1277	70607760.0
2004-07-29 15:00:00	NVDA	Stock	0.1277	0.1287	0.1266	0.1272	94996560.0
2004-07-29 16:00:00	NVDA	Stock	0.1272	0.1272	0.1267	0.1267	1686720.0
2004-07-29 17:00:00	NVDA	Stock	0.1271	0.1275	0.1271	0.1275	226800.0
2004-07-29 18:00:00	NVDA	Stock	0.1278	0.1283	0.1278	0.1282	120000.0
2004-07-29 08:00:00	AMZN	Stock	1.9	1.9125	1.898	1.9065	192220.0
2004-07-29 09:00:00	AMZN	Stock	1.91	1.9265	1.907	1.9235	23096740.0
2004-07-29 10:00:00	AMZN	Stock	1.9235	1.9255	1.901	1.9225	27421880.0
2004-07-29 11:00:00	AMZN	Stock	1.9225	1.9475	1.9165	1.922	25848660.0
2004-07-29 12:00:00	AMZN	Stock	1.922	1.9475	1.9205	1.94	18979060.0
2004-07-29 13:00:00	AMZN	Stock	1.9405	1.948	1.9215	1.922	12629440.0
2004-07-29 14:00:00	AMZN	Stock	1.922	1.9345	1.913	1.9345	17920280.0
2004-07-29 15:00:00	AMZN	Stock	1.935	1.941	1.923	1.934	25779920.0
2004-07-29 16:00:00	AMZN	Stock	1.929	1.934	1.9195	1.929	1837700.0
2004-07-29 17:00:00	AMZN	Stock	1.929	1.929	1.929	1.929	25400.0
2004-07-29 18:00:00	AMZN	Stock	1.93	1.93	1.93	1.93	7000.0
2004-07-29 09:00:00	CL	Stock	26.8	26.81	26.68	26.68	411400.0
2004-07-29 10:00:00	CL	Stock	26.705	26.725	26.63	26.665	495200.0
2004-07-29 11:00:00	CL	Stock	26.67	26.74	26.625	26.68	347000.0
2004-07-29 12:00:00	CL	Stock	26.675	26.769	26.67	26.68	271200.0
2004-07-29 13:00:00	CL	Stock	26.675	26.69	26.61	26.615	289200.0
2004-07-29 14:00:00	CL	Stock	26.615	26.625	26.505	26.555	370000.0
2004-07-29 15:00:00	CL	Stock	26.55	26.69	26.545	26.65	774600.0

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

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