PREVIEW / stock_1hour / 2004-08-03

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-08-03.parquet
  size:    514 KB
  rows:    24,613
  symbols: 1,817

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-08-03 08:00:00	AAPL	Stock	0.5634	0.5634	0.5634	0.5634	5600.0
2004-08-03 09:00:00	AAPL	Stock	0.5625	0.5648	0.56	0.5611	26815656.0
2004-08-03 10:00:00	AAPL	Stock	0.5609	0.562	0.5563	0.5589	35680232.0
2004-08-03 11:00:00	AAPL	Stock	0.5589	0.5629	0.5571	0.5627	25391632.0
2004-08-03 12:00:00	AAPL	Stock	0.5627	0.5664	0.56	0.5609	26040392.0
2004-08-03 13:00:00	AAPL	Stock	0.5609	0.5625	0.56	0.562	19146960.0
2004-08-03 14:00:00	AAPL	Stock	0.562	0.5621	0.5577	0.5611	21209888.0
2004-08-03 15:00:00	AAPL	Stock	0.5611	0.5634	0.5577	0.5595	46546024.0
2004-08-03 16:00:00	AAPL	Stock	0.5593	0.5595	0.5564	0.5588	1979432.0
2004-08-03 17:00:00	AAPL	Stock	0.5588	0.5588	0.5586	0.5586	162232.0
2004-08-03 18:00:00	AAPL	Stock	0.5563	0.5575	0.5563	0.5575	22400.0
2004-08-03 08:00:00	MSFT	Stock	28.31	28.47	27.0	28.47	500.0
2004-08-03 09:00:00	MSFT	Stock	28.5	28.5	28.31	28.33	5201956.0
2004-08-03 10:00:00	MSFT	Stock	28.32	28.36	28.23	28.28	7760346.0
2004-08-03 11:00:00	MSFT	Stock	28.28	28.31	28.24	28.25	4658777.0
2004-08-03 12:00:00	MSFT	Stock	28.25	28.281	28.2	28.24	3483649.0
2004-08-03 13:00:00	MSFT	Stock	28.24	28.26	28.19	28.239	3978354.0
2004-08-03 14:00:00	MSFT	Stock	28.24	28.24	28.0	28.03	11673134.0
2004-08-03 15:00:00	MSFT	Stock	28.03	28.15	28.029	28.09	13481066.0
2004-08-03 16:00:00	MSFT	Stock	28.09	28.23	28.01	28.03	898211.0
2004-08-03 17:00:00	MSFT	Stock	28.12	28.12	28.02	28.05	72630.0
2004-08-03 18:00:00	MSFT	Stock	28.05	28.05	28.04	28.05	2500.0
2004-08-03 08:00:00	NVDA	Stock	0.1303	0.1303	0.1302	0.1302	3216000.0
2004-08-03 09:00:00	NVDA	Stock	0.1305	0.1308	0.1271	0.1271	96044400.0
2004-08-03 10:00:00	NVDA	Stock	0.1272	0.1272	0.1246	0.1262	184703760.0
2004-08-03 11:00:00	NVDA	Stock	0.1262	0.1267	0.1249	0.1251	103060080.0
2004-08-03 12:00:00	NVDA	Stock	0.1251	0.1254	0.1248	0.1251	75886320.0
2004-08-03 13:00:00	NVDA	Stock	0.1251	0.1253	0.1246	0.1248	42173160.0
2004-08-03 14:00:00	NVDA	Stock	0.1249	0.1249	0.1225	0.1234	94549680.0
2004-08-03 15:00:00	NVDA	Stock	0.1234	0.1237	0.1224	0.1232	113562000.0
2004-08-03 16:00:00	NVDA	Stock	0.1232	0.1246	0.1222	0.1225	6139200.0
2004-08-03 17:00:00	NVDA	Stock	0.1225	0.1234	0.1222	0.1222	722280.0
2004-08-03 18:00:00	NVDA	Stock	0.1225	0.1225	0.1225	0.1225	228000.0
2004-08-03 08:00:00	AMZN	Stock	1.9105	1.9145	1.895	1.9095	68960.0
2004-08-03 09:00:00	AMZN	Stock	1.9095	1.954	1.908	1.9315	25930780.0
2004-08-03 10:00:00	AMZN	Stock	1.931	1.933	1.891	1.9085	30588460.0
2004-08-03 11:00:00	AMZN	Stock	1.908	1.9165	1.8965	1.9025	14778160.0
2004-08-03 12:00:00	AMZN	Stock	1.9025	1.9045	1.895	1.895	9851620.0
2004-08-03 13:00:00	AMZN	Stock	1.8955	1.897	1.882	1.8935	19175500.0
2004-08-03 14:00:00	AMZN	Stock	1.8935	1.898	1.8685	1.877	15009060.0
2004-08-03 15:00:00	AMZN	Stock	1.8775	1.8925	1.8655	1.8805	30892360.0
2004-08-03 16:00:00	AMZN	Stock	1.8805	1.8825	1.871	1.8807	2495420.0
2004-08-03 17:00:00	AMZN	Stock	1.8725	1.8805	1.87	1.87	242180.0
2004-08-03 18:00:00	AMZN	Stock	1.8625	1.8963	1.8625	1.87	646000.0
2004-08-03 09:00:00	CL	Stock	26.595	26.61	26.5	26.575	142000.0
2004-08-03 10:00:00	CL	Stock	26.57	26.655	26.555	26.605	257000.0
2004-08-03 11:00:00	CL	Stock	26.6	26.73	26.59	26.695	150000.0
2004-08-03 12:00:00	CL	Stock	26.695	26.73	26.66	26.715	152600.0
2004-08-03 13:00:00	CL	Stock	26.705	26.71	26.6	26.625	227600.0
2004-08-03 14:00:00	CL	Stock	26.615	26.62	26.52	26.58	279000.0

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

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