PREVIEW / stock_1hour / 2003-09-15

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-09-15.parquet
  size:    449 KB
  rows:    21,072
  symbols: 1,617

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-15 08:00:00	AAPL	Stock	0.4034	0.4098	0.4018	0.4089	144200.0
2003-09-15 09:00:00	AAPL	Stock	0.407	0.4125	0.4054	0.4068	25296824.0
2003-09-15 10:00:00	AAPL	Stock	0.4068	0.4075	0.4039	0.4045	31985296.0
2003-09-15 11:00:00	AAPL	Stock	0.4045	0.4046	0.3993	0.4002	27020896.0
2003-09-15 12:00:00	AAPL	Stock	0.3998	0.4021	0.3975	0.4009	19658856.0
2003-09-15 13:00:00	AAPL	Stock	0.4011	0.4027	0.3975	0.3989	21210336.0
2003-09-15 14:00:00	AAPL	Stock	0.3989	0.4002	0.395	0.3968	36194928.0
2003-09-15 15:00:00	AAPL	Stock	0.3968	0.3993	0.3959	0.3968	34527584.0
2003-09-15 16:00:00	AAPL	Stock	0.3968	0.3988	0.3955	0.3988	2650088.0
2003-09-15 17:00:00	AAPL	Stock	0.4	0.4009	0.4	0.4009	44800.0
2003-09-15 08:00:00	MSFT	Stock	28.45	28.539	28.42	28.42	39850.0
2003-09-15 09:00:00	MSFT	Stock	28.42	28.59	28.36	28.5	6563507.0
2003-09-15 10:00:00	MSFT	Stock	28.5	28.61	28.47	28.5	5954858.0
2003-09-15 11:00:00	MSFT	Stock	28.5	28.503	28.399	28.42	5988133.0
2003-09-15 12:00:00	MSFT	Stock	28.42	28.521	28.359	28.491	4604786.0
2003-09-15 13:00:00	MSFT	Stock	28.5	28.55	28.41	28.43	2210855.0
2003-09-15 14:00:00	MSFT	Stock	28.43	28.48	28.33	28.38	4999637.0
2003-09-15 15:00:00	MSFT	Stock	28.38	28.52	28.33	28.36	6164604.0
2003-09-15 16:00:00	MSFT	Stock	28.35	28.5204	28.02	28.32	374047.0
2003-09-15 17:00:00	MSFT	Stock	28.32	28.37	28.3	28.3	13300.0
2003-09-15 18:00:00	MSFT	Stock	28.3	28.32	28.28	28.28	8200.0
2003-09-15 08:00:00	NVDA	Stock	0.1617	0.1632	0.1617	0.1624	1340400.0
2003-09-15 09:00:00	NVDA	Stock	0.1622	0.1634	0.1591	0.1598	134184480.0
2003-09-15 10:00:00	NVDA	Stock	0.1599	0.1621	0.1592	0.1594	122207040.0
2003-09-15 11:00:00	NVDA	Stock	0.1594	0.1606	0.1588	0.1601	75939840.0
2003-09-15 12:00:00	NVDA	Stock	0.16	0.1602	0.1596	0.1596	36838440.0
2003-09-15 13:00:00	NVDA	Stock	0.1596	0.1608	0.1593	0.1598	59359080.0
2003-09-15 14:00:00	NVDA	Stock	0.1597	0.16	0.1585	0.1588	51051120.0
2003-09-15 15:00:00	NVDA	Stock	0.1587	0.1594	0.158	0.1585	59794680.0
2003-09-15 16:00:00	NVDA	Stock	0.1585	0.1587	0.1581	0.1581	4015200.0
2003-09-15 17:00:00	NVDA	Stock	0.1582	0.1582	0.1581	0.1582	859800.0
2003-09-15 18:00:00	NVDA	Stock	0.1582	0.1582	0.1582	0.1582	12000.0
2003-09-15 08:00:00	AMZN	Stock	2.275	2.275	2.27	2.27	51000.0
2003-09-15 09:00:00	AMZN	Stock	2.27	2.284	2.2615	2.2695	14212620.0
2003-09-15 10:00:00	AMZN	Stock	2.2695	2.2885	2.2675	2.2745	16629940.0
2003-09-15 11:00:00	AMZN	Stock	2.275	2.2765	2.2615	2.2705	10068860.0
2003-09-15 12:00:00	AMZN	Stock	2.2718	2.282	2.268	2.279	6913840.0
2003-09-15 13:00:00	AMZN	Stock	2.2805	2.288	2.2775	2.281	7101460.0
2003-09-15 14:00:00	AMZN	Stock	2.2815	2.285	2.265	2.274	12056560.0
2003-09-15 15:00:00	AMZN	Stock	2.274	2.275	2.2625	2.274	12201140.0
2003-09-15 16:00:00	AMZN	Stock	2.274	2.279	2.2645	2.2755	1501140.0
2003-09-15 17:00:00	AMZN	Stock	2.2725	2.2755	2.2675	2.2675	59500.0
2003-09-15 18:00:00	AMZN	Stock	2.2725	2.2725	2.2725	2.2725	24000.0
2003-09-15 09:00:00	CL	Stock	27.825	27.905	27.7562	27.82	530600.0
2003-09-15 10:00:00	CL	Stock	27.815	27.855	27.74	27.74	600800.0
2003-09-15 11:00:00	CL	Stock	27.745	27.745	27.625	27.715	534200.0
2003-09-15 12:00:00	CL	Stock	27.72	27.775	27.699	27.74	413200.0
2003-09-15 13:00:00	CL	Stock	27.735	27.805	27.73	27.8	313000.0
2003-09-15 14:00:00	CL	Stock	27.795	27.8	27.7	27.74	358400.0
2003-09-15 15:00:00	CL	Stock	27.74	27.775	27.665	27.685	770400.0

> showing 50 of 21,072 rows — these rows as CSV

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