PREVIEW / stock_1hour / 2003-09-12

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-09-12.parquet
  size:    446 KB
  rows:    20,868
  symbols: 1,609

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
2003-09-12 08:00:00	AAPL	Stock	0.402	0.4029	0.402	0.4029	319200.0
2003-09-12 09:00:00	AAPL	Stock	0.4023	0.403	0.3984	0.3989	17014256.0
2003-09-12 10:00:00	AAPL	Stock	0.3989	0.4036	0.3984	0.4013	17714200.0
2003-09-12 11:00:00	AAPL	Stock	0.4011	0.4038	0.4009	0.4029	29281224.0
2003-09-12 12:00:00	AAPL	Stock	0.4027	0.4043	0.4023	0.403	11292960.0
2003-09-12 13:00:00	AAPL	Stock	0.403	0.4061	0.4028	0.4038	25546416.0
2003-09-12 14:00:00	AAPL	Stock	0.4038	0.4125	0.4036	0.4116	25764536.0
2003-09-12 15:00:00	AAPL	Stock	0.4116	0.413	0.4104	0.413	39094104.0
2003-09-12 16:00:00	AAPL	Stock	0.4123	0.4173	0.4121	0.4166	1032976.0
2003-09-12 17:00:00	AAPL	Stock	0.4132	0.4132	0.4132	0.4132	14000.0
2003-09-12 08:00:00	MSFT	Stock	27.6	28.42	27.2	27.46	2772155.0
2003-09-12 09:00:00	MSFT	Stock	27.47	27.84	27.37	27.56	8921653.0
2003-09-12 10:00:00	MSFT	Stock	27.56	27.89	27.539	27.82	8517714.0
2003-09-12 11:00:00	MSFT	Stock	27.83	28.01	27.79	27.93	6908251.0
2003-09-12 12:00:00	MSFT	Stock	27.93	27.95	27.78	27.93	4270146.0
2003-09-12 13:00:00	MSFT	Stock	27.93	27.99	27.87	27.94	3941387.0
2003-09-12 14:00:00	MSFT	Stock	27.95	28.25	27.93	28.181	6011263.0
2003-09-12 15:00:00	MSFT	Stock	28.18	28.4	28.1	28.34	8018513.0
2003-09-12 16:00:00	MSFT	Stock	28.34	28.45	27.8619	28.44	806704.0
2003-09-12 17:00:00	MSFT	Stock	28.44	28.5	28.38	28.38	26859.0
2003-09-12 18:00:00	MSFT	Stock	28.38	28.4	28.38	28.38	2916.0
2003-09-12 08:00:00	NVDA	Stock	0.1572	0.1587	0.1567	0.1571	1164000.0
2003-09-12 09:00:00	NVDA	Stock	0.1571	0.1599	0.1556	0.1586	138286560.0
2003-09-12 10:00:00	NVDA	Stock	0.1586	0.1647	0.1582	0.1628	354396840.0
2003-09-12 11:00:00	NVDA	Stock	0.1627	0.1637	0.1594	0.1604	184079280.0
2003-09-12 12:00:00	NVDA	Stock	0.1604	0.1611	0.159	0.1597	96222600.0
2003-09-12 13:00:00	NVDA	Stock	0.1598	0.1611	0.1589	0.1609	90354000.0
2003-09-12 14:00:00	NVDA	Stock	0.161	0.1625	0.1602	0.1619	88650720.0
2003-09-12 15:00:00	NVDA	Stock	0.162	0.1623	0.1602	0.1613	131987760.0
2003-09-12 16:00:00	NVDA	Stock	0.1612	0.1617	0.1611	0.1611	4325400.0
2003-09-12 17:00:00	NVDA	Stock	0.1611	0.1617	0.161	0.1617	1158840.0
2003-09-12 08:00:00	AMZN	Stock	2.25	2.2555	2.24	2.248	86000.0
2003-09-12 09:00:00	AMZN	Stock	2.245	2.27	2.2365	2.252	25623800.0
2003-09-12 10:00:00	AMZN	Stock	2.251	2.28	2.251	2.26	32013560.0
2003-09-12 11:00:00	AMZN	Stock	2.2605	2.2665	2.257	2.2655	13517440.0
2003-09-12 12:00:00	AMZN	Stock	2.2655	2.2665	2.251	2.2535	9494200.0
2003-09-12 13:00:00	AMZN	Stock	2.2535	2.259	2.2485	2.251	9678760.0
2003-09-12 14:00:00	AMZN	Stock	2.2505	2.28	2.25	2.2735	13990300.0
2003-09-12 15:00:00	AMZN	Stock	2.2735	2.289	2.273	2.284	18469240.0
2003-09-12 16:00:00	AMZN	Stock	2.284	2.2845	2.279	2.279	652820.0
2003-09-12 17:00:00	AMZN	Stock	2.284	2.284	2.2775	2.284	204000.0
2003-09-12 18:00:00	AMZN	Stock	2.279	2.2845	2.279	2.2845	30000.0
2003-09-12 09:00:00	CL	Stock	28.125	28.185	28.02	28.09	165000.0
2003-09-12 10:00:00	CL	Stock	28.08	28.115	28.0	28.05	378600.0
2003-09-12 11:00:00	CL	Stock	28.05	28.15	28.04	28.08	187800.0
2003-09-12 12:00:00	CL	Stock	28.085	28.1	27.895	27.925	520400.0
2003-09-12 13:00:00	CL	Stock	27.92	27.935	27.875	27.895	247800.0
2003-09-12 14:00:00	CL	Stock	27.9	27.985	27.89	27.985	325800.0
2003-09-12 15:00:00	CL	Stock	27.99	28.075	27.98	28.065	376000.0
2003-09-12 16:00:00	CL	Stock	28.06	28.06	28.06	28.06	44800.0

> showing 50 of 20,868 rows — these rows as CSV

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