PREVIEW / stock_1hour / 2004-11-17

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-11-17.parquet
  size:    533 KB
  rows:    25,003
  symbols: 1,880

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-11-17 08:00:00	AAPL	Stock	0.9864	0.9893	0.9821	0.9893	435680.0
2004-11-17 09:00:00	AAPL	Stock	0.9893	0.9911	0.9796	0.9814	48795712.0
2004-11-17 10:00:00	AAPL	Stock	0.9814	0.9896	0.9804	0.9857	81162760.0
2004-11-17 11:00:00	AAPL	Stock	0.9861	0.9902	0.985	0.9886	47941208.0
2004-11-17 12:00:00	AAPL	Stock	0.9886	0.99	0.9861	0.9877	33367488.0
2004-11-17 13:00:00	AAPL	Stock	0.9879	0.9889	0.98	0.98	36866928.0
2004-11-17 14:00:00	AAPL	Stock	0.9802	0.9802	0.9682	0.9791	75084744.0
2004-11-17 15:00:00	AAPL	Stock	0.9795	0.9821	0.9718	0.9804	59158232.0
2004-11-17 16:00:00	AAPL	Stock	0.9805	0.9805	0.9782	0.9804	2280376.0
2004-11-17 17:00:00	AAPL	Stock	0.9752	0.9811	0.9752	0.9811	983808.0
2004-11-17 18:00:00	AAPL	Stock	0.978	0.978	0.9779	0.9779	36960.0
2004-11-17 08:00:00	MSFT	Stock	27.27	27.39	27.21	27.28	356395.0
2004-11-17 09:00:00	MSFT	Stock	27.28	27.36	27.13	27.18	8836788.0
2004-11-17 10:00:00	MSFT	Stock	27.18	27.341	27.16	27.25	11016049.0
2004-11-17 11:00:00	MSFT	Stock	27.25	27.33	27.23	27.25	7155502.0
2004-11-17 12:00:00	MSFT	Stock	27.261	27.3	27.25	27.28	5392262.0
2004-11-17 13:00:00	MSFT	Stock	27.285	27.29	27.22	27.23	4268567.0
2004-11-17 14:00:00	MSFT	Stock	27.225	27.23	27.06	27.15	10786425.0
2004-11-17 15:00:00	MSFT	Stock	27.15	27.18	27.09	27.15	8159013.0
2004-11-17 16:00:00	MSFT	Stock	27.16	27.2	27.13	27.14	790088.0
2004-11-17 17:00:00	MSFT	Stock	27.18	27.2363	27.12	27.15	258353.0
2004-11-17 18:00:00	MSFT	Stock	27.14	27.15	27.12	27.12	4338.0
2004-11-17 08:00:00	NVDA	Stock	0.1538	0.1546	0.1538	0.1546	1044000.0
2004-11-17 09:00:00	NVDA	Stock	0.1542	0.1554	0.1534	0.1551	72820680.0
2004-11-17 10:00:00	NVDA	Stock	0.1552	0.1571	0.1549	0.157	110628720.0
2004-11-17 11:00:00	NVDA	Stock	0.1571	0.1582	0.1568	0.1582	71236920.0
2004-11-17 12:00:00	NVDA	Stock	0.1582	0.1592	0.1581	0.1587	74938080.0
2004-11-17 13:00:00	NVDA	Stock	0.1587	0.1587	0.1569	0.1572	38376600.0
2004-11-17 14:00:00	NVDA	Stock	0.1572	0.1572	0.1535	0.1555	124090320.0
2004-11-17 15:00:00	NVDA	Stock	0.1554	0.1557	0.1535	0.1552	102945840.0
2004-11-17 16:00:00	NVDA	Stock	0.1552	0.1568	0.1549	0.1552	2248320.0
2004-11-17 17:00:00	NVDA	Stock	0.1545	0.1556	0.1539	0.1556	987600.0
2004-11-17 18:00:00	NVDA	Stock	0.1559	0.1559	0.1559	0.1559	12000.0
2004-11-17 08:00:00	AMZN	Stock	2.005	2.0275	2.004	2.015	199380.0
2004-11-17 09:00:00	AMZN	Stock	2.017	2.0295	1.984	1.9845	19917720.0
2004-11-17 10:00:00	AMZN	Stock	1.984	2.025	1.9825	2.0125	37582000.0
2004-11-17 11:00:00	AMZN	Stock	2.012	2.019	2.003	2.012	12946880.0
2004-11-17 12:00:00	AMZN	Stock	2.0115	2.015	1.9995	2.0035	11508260.0
2004-11-17 13:00:00	AMZN	Stock	2.0035	2.012	1.9925	1.9935	10090220.0
2004-11-17 14:00:00	AMZN	Stock	1.993	1.9931	1.977	1.991	22438180.0
2004-11-17 15:00:00	AMZN	Stock	1.991	1.994	1.98	1.991	19454040.0
2004-11-17 16:00:00	AMZN	Stock	1.994	1.995	1.99	1.99	1115540.0
2004-11-17 17:00:00	AMZN	Stock	1.99	1.995	1.985	1.9875	570280.0
2004-11-17 18:00:00	AMZN	Stock	1.9875	1.9885	1.987	1.9885	12000.0
2004-11-17 09:00:00	CL	Stock	24.2	24.24	24.16	24.19	452400.0
2004-11-17 10:00:00	CL	Stock	24.185	24.3	24.185	24.29	694400.0
2004-11-17 11:00:00	CL	Stock	24.285	24.34	24.28	24.34	694400.0
2004-11-17 12:00:00	CL	Stock	24.345	24.45	24.315	24.445	844800.0
2004-11-17 13:00:00	CL	Stock	24.445	24.45	24.32	24.34	1159600.0
2004-11-17 14:00:00	CL	Stock	24.34	24.345	24.275	24.335	901400.0

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

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