PREVIEW / stock_1hour / 2004-11-12

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-11-12.parquet
  size:    536 KB
  rows:    24,930
  symbols: 1,864

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-12 08:00:00	AAPL	Stock	0.9882	0.9898	0.9832	0.9871	230160.0
2004-11-12 09:00:00	AAPL	Stock	0.9864	0.9884	0.9793	0.9868	50203104.0
2004-11-12 10:00:00	AAPL	Stock	0.9871	0.9945	0.9836	0.9875	96251456.0
2004-11-12 11:00:00	AAPL	Stock	0.9877	0.9884	0.983	0.9839	41690600.0
2004-11-12 12:00:00	AAPL	Stock	0.9841	0.988	0.9827	0.9859	24023608.0
2004-11-12 13:00:00	AAPL	Stock	0.9859	0.9898	0.9857	0.9889	49737240.0
2004-11-12 14:00:00	AAPL	Stock	0.9889	0.9902	0.9864	0.9879	55888168.0
2004-11-12 15:00:00	AAPL	Stock	0.9879	0.9909	0.9866	0.9907	46295368.0
2004-11-12 16:00:00	AAPL	Stock	0.9907	0.9916	0.9893	0.9911	13023192.0
2004-11-12 17:00:00	AAPL	Stock	0.9911	0.9923	0.988	0.988	221648.0
2004-11-12 08:00:00	MSFT	Stock	30.15	30.3	30.02	30.29	662917.0
2004-11-12 09:00:00	MSFT	Stock	30.28	30.31	29.91	29.93	26790907.0
2004-11-12 10:00:00	MSFT	Stock	29.921	29.97	29.8	29.94	25116483.0
2004-11-12 11:00:00	MSFT	Stock	29.94	30.0	29.9	29.91	17083577.0
2004-11-12 12:00:00	MSFT	Stock	29.91	29.93	29.81	29.88	14794851.0
2004-11-12 13:00:00	MSFT	Stock	29.89	29.97	29.88	29.92	12356763.0
2004-11-12 14:00:00	MSFT	Stock	29.92	29.98	29.8899	29.92	17547826.0
2004-11-12 15:00:00	MSFT	Stock	29.93	29.99	29.85	29.99	33905229.0
2004-11-12 16:00:00	MSFT	Stock	29.98	30.04	29.91	30.0	7502829.0
2004-11-12 17:00:00	MSFT	Stock	29.99	30.0205	29.97	30.01	355078.0
2004-11-12 18:00:00	MSFT	Stock	30.02	30.12	30.0	30.02	67251.0
2004-11-12 08:00:00	NVDA	Stock	0.152	0.1521	0.1512	0.1517	218400.0
2004-11-12 09:00:00	NVDA	Stock	0.1521	0.1533	0.1493	0.1503	87232920.0
2004-11-12 10:00:00	NVDA	Stock	0.1503	0.1527	0.1495	0.1516	101130600.0
2004-11-12 11:00:00	NVDA	Stock	0.1517	0.1527	0.1511	0.1513	73124760.0
2004-11-12 12:00:00	NVDA	Stock	0.1514	0.1519	0.1497	0.15	59484000.0
2004-11-12 13:00:00	NVDA	Stock	0.15	0.1507	0.1497	0.15	37998360.0
2004-11-12 14:00:00	NVDA	Stock	0.15	0.1512	0.1497	0.1504	82177440.0
2004-11-12 15:00:00	NVDA	Stock	0.1503	0.1509	0.1499	0.1507	169889400.0
2004-11-12 16:00:00	NVDA	Stock	0.1507	0.1509	0.1503	0.1506	17372280.0
2004-11-12 17:00:00	NVDA	Stock	0.1508	0.1508	0.1497	0.1505	625200.0
2004-11-12 18:00:00	NVDA	Stock	0.1507	0.1507	0.1507	0.1507	60000.0
2004-11-12 08:00:00	AMZN	Stock	1.9445	1.955	1.9445	1.95	344300.0
2004-11-12 09:00:00	AMZN	Stock	1.95	1.9785	1.948	1.9745	20576140.0
2004-11-12 10:00:00	AMZN	Stock	1.975	2.0	1.958	1.989	41585740.0
2004-11-12 11:00:00	AMZN	Stock	1.989	1.9965	1.985	1.9905	20247100.0
2004-11-12 12:00:00	AMZN	Stock	1.9905	2.005	1.99	2.003	23221240.0
2004-11-12 13:00:00	AMZN	Stock	2.0035	2.023	2.0015	2.0205	29193240.0
2004-11-12 14:00:00	AMZN	Stock	2.0205	2.047	2.0185	2.0245	40577860.0
2004-11-12 15:00:00	AMZN	Stock	2.027	2.03	2.017	2.0245	43530800.0
2004-11-12 16:00:00	AMZN	Stock	2.0255	2.0285	1.999	2.028	2414320.0
2004-11-12 17:00:00	AMZN	Stock	2.028	2.0284	2.02	2.02	256800.0
2004-11-12 18:00:00	AMZN	Stock	2.021	2.021	2.021	2.021	2000.0
2004-11-12 09:00:00	CL	Stock	24.045	24.12	23.635	23.72	626000.0
2004-11-12 10:00:00	CL	Stock	23.72	23.75	23.63	23.655	755800.0
2004-11-12 11:00:00	CL	Stock	23.655	23.76	23.655	23.7	757200.0
2004-11-12 12:00:00	CL	Stock	23.695	23.705	23.66	23.665	306800.0
2004-11-12 13:00:00	CL	Stock	23.67	23.7	23.655	23.69	416000.0
2004-11-12 14:00:00	CL	Stock	23.69	23.74	23.685	23.725	621400.0
2004-11-12 15:00:00	CL	Stock	23.71	23.79	23.71	23.79	1023800.0

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

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