PREVIEW / stock_1hour / 2004-11-18

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-11-18.parquet
  size:    527 KB
  rows:    24,789
  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-18 08:00:00	AAPL	Stock	0.9784	0.9804	0.9768	0.9768	82264.0
2004-11-18 09:00:00	AAPL	Stock	0.9782	0.9873	0.9695	0.9827	69677328.0
2004-11-18 10:00:00	AAPL	Stock	0.9829	0.9902	0.9811	0.9875	122142720.0
2004-11-18 11:00:00	AAPL	Stock	0.9875	0.9902	0.9846	0.9875	65394448.0
2004-11-18 12:00:00	AAPL	Stock	0.9877	0.9888	0.9848	0.9868	28097608.0
2004-11-18 13:00:00	AAPL	Stock	0.9866	0.9896	0.9836	0.9891	39906384.0
2004-11-18 14:00:00	AAPL	Stock	0.9891	0.9902	0.9864	0.988	33232024.0
2004-11-18 15:00:00	AAPL	Stock	0.9879	0.99	0.987	0.9893	73646384.0
2004-11-18 16:00:00	AAPL	Stock	0.9893	0.99	0.987	0.9895	4384800.0
2004-11-18 17:00:00	AAPL	Stock	0.9891	0.9911	0.9884	0.9911	2258200.0
2004-11-18 18:00:00	AAPL	Stock	0.9913	0.9916	0.9913	0.9916	17360.0
2004-11-18 08:00:00	MSFT	Stock	27.15	27.18	27.08	27.11	32514.0
2004-11-18 09:00:00	MSFT	Stock	27.11	27.17	27.06	27.09	6941430.0
2004-11-18 10:00:00	MSFT	Stock	27.09	27.12	27.0198	27.11	10305366.0
2004-11-18 11:00:00	MSFT	Stock	27.12	27.13	27.02	27.03	8774666.0
2004-11-18 12:00:00	MSFT	Stock	27.03	27.06	27.02	27.03	4481742.0
2004-11-18 13:00:00	MSFT	Stock	27.04	27.06	27.03	27.05	3561402.0
2004-11-18 14:00:00	MSFT	Stock	27.05	27.1	27.02	27.08	6986633.0
2004-11-18 15:00:00	MSFT	Stock	27.09	27.11	27.03	27.06	7890794.0
2004-11-18 16:00:00	MSFT	Stock	27.07	27.083	27.04	27.04	985813.0
2004-11-18 17:00:00	MSFT	Stock	27.07	27.18	27.04	27.04	2136465.0
2004-11-18 18:00:00	MSFT	Stock	27.05	27.06	27.04	27.04	3975.0
2004-11-18 08:00:00	NVDA	Stock	0.155	0.155	0.1537	0.1537	381000.0
2004-11-18 09:00:00	NVDA	Stock	0.1546	0.1565	0.1532	0.1553	100132440.0
2004-11-18 10:00:00	NVDA	Stock	0.1553	0.1579	0.1546	0.1578	96833640.0
2004-11-18 11:00:00	NVDA	Stock	0.1579	0.1582	0.1567	0.1574	63304080.0
2004-11-18 12:00:00	NVDA	Stock	0.1573	0.1575	0.1567	0.1571	33089160.0
2004-11-18 13:00:00	NVDA	Stock	0.1571	0.158	0.1562	0.1578	44393880.0
2004-11-18 14:00:00	NVDA	Stock	0.1577	0.1583	0.1575	0.1582	47550240.0
2004-11-18 15:00:00	NVDA	Stock	0.1582	0.1585	0.1564	0.1573	129983760.0
2004-11-18 16:00:00	NVDA	Stock	0.1573	0.1578	0.1568	0.1572	5948760.0
2004-11-18 17:00:00	NVDA	Stock	0.1574	0.1579	0.1569	0.1574	1140240.0
2004-11-18 18:00:00	NVDA	Stock	0.1577	0.1579	0.1577	0.1579	492000.0
2004-11-18 08:00:00	AMZN	Stock	1.975	1.9825	1.975	1.9775	144860.0
2004-11-18 09:00:00	AMZN	Stock	1.9825	2.0125	1.9795	2.0125	18184660.0
2004-11-18 10:00:00	AMZN	Stock	2.0115	2.043	2.006	2.039	31728840.0
2004-11-18 11:00:00	AMZN	Stock	2.04	2.048	2.0325	2.038	20375980.0
2004-11-18 12:00:00	AMZN	Stock	2.0375	2.038	2.014	2.016	14483320.0
2004-11-18 13:00:00	AMZN	Stock	2.0155	2.0255	2.009	2.0245	10496540.0
2004-11-18 14:00:00	AMZN	Stock	2.024	2.032	2.0175	2.0285	8176140.0
2004-11-18 15:00:00	AMZN	Stock	2.03	2.033	2.016	2.018	19275940.0
2004-11-18 16:00:00	AMZN	Stock	2.0175	2.019	1.9375	1.9785	4448260.0
2004-11-18 17:00:00	AMZN	Stock	2.0185	2.0244	1.96	1.9655	2273940.0
2004-11-18 18:00:00	AMZN	Stock	1.966	1.9685	1.9655	1.9685	177000.0
2004-11-18 09:00:00	CL	Stock	23.75	23.88	23.7	23.75	1178400.0
2004-11-18 10:00:00	CL	Stock	23.745	23.9	23.675	23.83	2166800.0
2004-11-18 11:00:00	CL	Stock	23.825	23.825	23.6	23.61	1804600.0
2004-11-18 12:00:00	CL	Stock	23.605	23.635	23.46	23.48	1006200.0
2004-11-18 13:00:00	CL	Stock	23.48	23.515	23.435	23.445	819200.0
2004-11-18 14:00:00	CL	Stock	23.44	23.485	23.33	23.48	1350600.0

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

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