PREVIEW / stock_1hour / 2004-07-07

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-07-07.parquet
  size:    496 KB
  rows:    23,618
  symbols: 1,796

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-07 08:00:00	AAPL	Stock	0.5529	0.5529	0.5529	0.5529	476000.0
2004-07-07 09:00:00	AAPL	Stock	0.5534	0.56	0.5496	0.5563	44445520.0
2004-07-07 10:00:00	AAPL	Stock	0.5563	0.5586	0.5482	0.5493	47420800.0
2004-07-07 11:00:00	AAPL	Stock	0.5493	0.5495	0.5396	0.5414	88498592.0
2004-07-07 12:00:00	AAPL	Stock	0.5416	0.542	0.538	0.5413	48244840.0
2004-07-07 13:00:00	AAPL	Stock	0.5413	0.5438	0.5405	0.5423	25026960.0
2004-07-07 14:00:00	AAPL	Stock	0.5425	0.5427	0.5389	0.5404	44376528.0
2004-07-07 15:00:00	AAPL	Stock	0.5404	0.5427	0.5388	0.5423	78996288.0
2004-07-07 16:00:00	AAPL	Stock	0.5404	0.545	0.5375	0.5375	4936008.0
2004-07-07 17:00:00	AAPL	Stock	0.5368	0.5427	0.5357	0.5357	1058400.0
2004-07-07 08:00:00	MSFT	Stock	28.0	28.1	27.7	27.79	146078.0
2004-07-07 09:00:00	MSFT	Stock	27.79	28.06	27.55	28.01	15053850.0
2004-07-07 10:00:00	MSFT	Stock	28.01	28.1	27.9	27.95	8830109.0
2004-07-07 11:00:00	MSFT	Stock	27.94	28.0	27.82	27.96	8578826.0
2004-07-07 12:00:00	MSFT	Stock	27.96	28.03	27.92	27.96	5184902.0
2004-07-07 13:00:00	MSFT	Stock	27.97	28.28	27.96	28.24	7341738.0
2004-07-07 14:00:00	MSFT	Stock	28.24	28.32	28.19	28.26	7646640.0
2004-07-07 15:00:00	MSFT	Stock	28.26	28.31	28.08	28.1	10719056.0
2004-07-07 16:00:00	MSFT	Stock	28.1	28.16	27.33	27.36	822800.0
2004-07-07 17:00:00	MSFT	Stock	27.42	28.12	27.42	27.68	144901.0
2004-07-07 18:00:00	MSFT	Stock	27.68	27.74	27.64	27.73	21080.0
2004-07-07 08:00:00	NVDA	Stock	0.152	0.1521	0.152	0.1521	600000.0
2004-07-07 09:00:00	NVDA	Stock	0.151	0.155	0.151	0.1547	74101560.0
2004-07-07 10:00:00	NVDA	Stock	0.1547	0.1562	0.1518	0.1518	66992760.0
2004-07-07 11:00:00	NVDA	Stock	0.152	0.1534	0.1513	0.1533	30609120.0
2004-07-07 12:00:00	NVDA	Stock	0.1533	0.1541	0.1526	0.1527	24130440.0
2004-07-07 13:00:00	NVDA	Stock	0.1528	0.1537	0.1514	0.1536	48765480.0
2004-07-07 14:00:00	NVDA	Stock	0.1536	0.1542	0.1532	0.154	17556000.0
2004-07-07 15:00:00	NVDA	Stock	0.1539	0.1539	0.1511	0.1518	67668000.0
2004-07-07 16:00:00	NVDA	Stock	0.1521	0.1522	0.1497	0.15	4491960.0
2004-07-07 17:00:00	NVDA	Stock	0.1531	0.1531	0.1487	0.15	2086800.0
2004-07-07 18:00:00	NVDA	Stock	0.15	0.15	0.1496	0.1496	240000.0
2004-07-07 08:00:00	AMZN	Stock	2.5595	2.5625	2.5375	2.5395	467000.0
2004-07-07 09:00:00	AMZN	Stock	2.5375	2.588	2.531	2.577	19392380.0
2004-07-07 10:00:00	AMZN	Stock	2.577	2.6015	2.5415	2.55	26602560.0
2004-07-07 11:00:00	AMZN	Stock	2.55	2.5505	2.512	2.5295	17212600.0
2004-07-07 12:00:00	AMZN	Stock	2.5295	2.542	2.521	2.535	8881780.0
2004-07-07 13:00:00	AMZN	Stock	2.535	2.555	2.5335	2.5495	10716640.0
2004-07-07 14:00:00	AMZN	Stock	2.5495	2.5515	2.533	2.544	10921840.0
2004-07-07 15:00:00	AMZN	Stock	2.5435	2.5585	2.534	2.55	24159620.0
2004-07-07 16:00:00	AMZN	Stock	2.548	2.5505	2.396	2.41	7298200.0
2004-07-07 17:00:00	AMZN	Stock	2.4075	2.5507	2.382	2.4055	3320960.0
2004-07-07 18:00:00	AMZN	Stock	2.4075	2.4075	2.3915	2.399	355000.0
2004-07-07 09:00:00	CL	Stock	29.125	29.245	29.105	29.21	160400.0
2004-07-07 10:00:00	CL	Stock	29.205	29.34	29.205	29.27	324800.0
2004-07-07 11:00:00	CL	Stock	29.275	29.3	29.13	29.23	565200.0
2004-07-07 12:00:00	CL	Stock	29.23	29.275	29.21	29.225	303600.0
2004-07-07 13:00:00	CL	Stock	29.225	29.275	29.21	29.22	327800.0
2004-07-07 14:00:00	CL	Stock	29.225	29.225	29.115	29.14	541400.0
2004-07-07 15:00:00	CL	Stock	29.14	29.155	29.04	29.06	383800.0

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

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