PREVIEW / stock_1hour / 2004-11-15

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-11-15.parquet
  size:    546 KB
  rows:    25,505
  symbols: 1,875

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-15 08:00:00	AAPL	Stock	0.9911	0.9913	0.9868	0.9868	5242552.0
2004-11-15 09:00:00	AAPL	Stock	0.9866	0.9911	0.9779	0.9882	60133864.0
2004-11-15 10:00:00	AAPL	Stock	0.9884	0.9891	0.9795	0.9818	91726320.0
2004-11-15 11:00:00	AAPL	Stock	0.9816	0.9818	0.9704	0.9773	65830520.0
2004-11-15 12:00:00	AAPL	Stock	0.9773	0.9834	0.9754	0.9829	38226944.0
2004-11-15 13:00:00	AAPL	Stock	0.9829	0.983	0.9777	0.9793	27118896.0
2004-11-15 14:00:00	AAPL	Stock	0.9793	0.983	0.9773	0.9804	28910672.0
2004-11-15 15:00:00	AAPL	Stock	0.98	0.9866	0.9798	0.9864	50150856.0
2004-11-15 16:00:00	AAPL	Stock	0.9859	0.9866	0.9836	0.9864	3823008.0
2004-11-15 17:00:00	AAPL	Stock	0.9818	0.9848	0.981	0.9811	210000.0
2004-11-15 08:00:00	MSFT	Stock	27.24	29.0	27.12	27.21	1001717.0
2004-11-15 09:00:00	MSFT	Stock	27.21	27.5	27.16	27.29	23284950.0
2004-11-15 10:00:00	MSFT	Stock	27.28	27.35	27.25	27.32	16286959.0
2004-11-15 11:00:00	MSFT	Stock	27.321	27.35	27.27	27.33	10482794.0
2004-11-15 12:00:00	MSFT	Stock	27.34	27.34	27.27	27.32	10565883.0
2004-11-15 13:00:00	MSFT	Stock	27.319	27.33	27.29	27.29	5855569.0
2004-11-15 14:00:00	MSFT	Stock	27.29	27.33	27.259	27.3	9298622.0
2004-11-15 15:00:00	MSFT	Stock	27.3	27.39	27.29	27.38	17984411.0
2004-11-15 16:00:00	MSFT	Stock	27.38	27.4	27.27	27.36	1604327.0
2004-11-15 17:00:00	MSFT	Stock	27.36	27.39	27.318	27.34	271730.0
2004-11-15 18:00:00	MSFT	Stock	27.36	27.36	27.34	27.35	3605.0
2004-11-15 09:00:00	NVDA	Stock	0.1507	0.1522	0.1484	0.1512	70519680.0
2004-11-15 10:00:00	NVDA	Stock	0.1512	0.1525	0.1512	0.1522	68638560.0
2004-11-15 11:00:00	NVDA	Stock	0.1522	0.1525	0.1506	0.152	85545120.0
2004-11-15 12:00:00	NVDA	Stock	0.152	0.1541	0.1517	0.1538	61666440.0
2004-11-15 13:00:00	NVDA	Stock	0.1538	0.1538	0.1522	0.1522	34536960.0
2004-11-15 14:00:00	NVDA	Stock	0.1522	0.1535	0.1513	0.1527	59647200.0
2004-11-15 15:00:00	NVDA	Stock	0.1527	0.1542	0.1527	0.1538	132407160.0
2004-11-15 16:00:00	NVDA	Stock	0.1538	0.1541	0.1531	0.1531	12342960.0
2004-11-15 17:00:00	NVDA	Stock	0.1529	0.1531	0.1527	0.1527	420600.0
2004-11-15 08:00:00	AMZN	Stock	2.0255	2.03	2.015	2.027	168000.0
2004-11-15 09:00:00	AMZN	Stock	2.025	2.0625	2.009	2.054	38112360.0
2004-11-15 10:00:00	AMZN	Stock	2.0545	2.075	2.0535	2.059	51528940.0
2004-11-15 11:00:00	AMZN	Stock	2.059	2.059	2.0335	2.041	32865640.0
2004-11-15 12:00:00	AMZN	Stock	2.0409	2.063	2.0345	2.0575	18542520.0
2004-11-15 13:00:00	AMZN	Stock	2.0585	2.0625	2.049	2.0535	11025120.0
2004-11-15 14:00:00	AMZN	Stock	2.0535	2.0545	2.038	2.04	15384780.0
2004-11-15 15:00:00	AMZN	Stock	2.0395	2.05	2.0335	2.044	31316680.0
2004-11-15 16:00:00	AMZN	Stock	2.046	2.048	2.044	2.0445	839400.0
2004-11-15 17:00:00	AMZN	Stock	2.044	2.0445	2.0385	2.0385	90000.0
2004-11-15 09:00:00	CL	Stock	23.94	23.94	23.83	23.9	487600.0
2004-11-15 10:00:00	CL	Stock	23.9	23.99	23.885	23.98	557400.0
2004-11-15 11:00:00	CL	Stock	23.98	24.045	23.965	24.02	702200.0
2004-11-15 12:00:00	CL	Stock	24.02	24.04	23.94	23.98	433000.0
2004-11-15 13:00:00	CL	Stock	23.985	23.99	23.85	23.855	414400.0
2004-11-15 14:00:00	CL	Stock	23.85	23.97	23.795	23.97	621600.0
2004-11-15 15:00:00	CL	Stock	23.97	24.015	23.95	23.97	927200.0
2004-11-15 16:00:00	CL	Stock	23.86	23.95	23.86	23.95	37000.0

> showing 48 of 25,505 rows — these rows as CSV

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