PREVIEW / stock_1hour / 2002-09-30

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-09-30.parquet
  size:    418 KB
  rows:    19,613
  symbols: 1,495

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
2002-09-30 08:00:00	AAPL	Stock	0.2623	0.2623	0.258	0.2591	44800.0
2002-09-30 09:00:00	AAPL	Stock	0.2589	0.2589	0.2561	0.2561	20612872.0
2002-09-30 10:00:00	AAPL	Stock	0.2562	0.2562	0.2525	0.2554	40399016.0
2002-09-30 11:00:00	AAPL	Stock	0.2554	0.2566	0.2539	0.2552	16370536.0
2002-09-30 12:00:00	AAPL	Stock	0.2548	0.2563	0.2545	0.2549	15538264.0
2002-09-30 13:00:00	AAPL	Stock	0.255	0.2568	0.2545	0.2557	22085336.0
2002-09-30 14:00:00	AAPL	Stock	0.2559	0.2575	0.2545	0.2571	22043896.0
2002-09-30 15:00:00	AAPL	Stock	0.2571	0.2602	0.2559	0.2588	63506072.0
2002-09-30 16:00:00	AAPL	Stock	0.2589	0.2593	0.2573	0.2589	13583808.0
2002-09-30 17:00:00	AAPL	Stock	0.2565	0.2589	0.2565	0.2589	3164000.0
2002-09-30 08:00:00	MSFT	Stock	22.5	22.625	22.385	22.43	146030.0
2002-09-30 09:00:00	MSFT	Stock	22.43	22.625	21.945	21.9805	15680294.0
2002-09-30 10:00:00	MSFT	Stock	21.955	22.03	21.5585	21.805	22162202.0
2002-09-30 11:00:00	MSFT	Stock	21.805	21.948	21.63	21.842	16410506.0
2002-09-30 12:00:00	MSFT	Stock	21.835	21.92	21.7	21.855	7809356.0
2002-09-30 13:00:00	MSFT	Stock	21.8595	22.08	21.725	22.034	8306702.0
2002-09-30 14:00:00	MSFT	Stock	22.035	22.185	21.785	22.105	11376454.0
2002-09-30 15:00:00	MSFT	Stock	22.105	22.395	21.681	21.865	23456682.0
2002-09-30 16:00:00	MSFT	Stock	21.84	21.995	21.805	21.925	8606786.0
2002-09-30 17:00:00	MSFT	Stock	21.949	21.949	21.695	21.94	12522.0
2002-09-30 18:00:00	MSFT	Stock	21.945	21.95	21.935	21.95	13000.0
2002-09-30 08:00:00	NVDA	Stock	0.0717	0.0717	0.0706	0.0708	846360.0
2002-09-30 09:00:00	NVDA	Stock	0.0708	0.0713	0.0705	0.0708	86097120.0
2002-09-30 10:00:00	NVDA	Stock	0.0707	0.0714	0.0696	0.0713	102837600.0
2002-09-30 11:00:00	NVDA	Stock	0.0713	0.074	0.0708	0.0733	107997840.0
2002-09-30 12:00:00	NVDA	Stock	0.0731	0.0744	0.0712	0.0721	71884080.0
2002-09-30 13:00:00	NVDA	Stock	0.0721	0.0728	0.0716	0.0722	37015440.0
2002-09-30 14:00:00	NVDA	Stock	0.0722	0.0733	0.071	0.0726	51876600.0
2002-09-30 15:00:00	NVDA	Stock	0.0727	0.0735	0.071	0.0713	100218240.0
2002-09-30 16:00:00	NVDA	Stock	0.0712	0.0733	0.0709	0.0713	16005360.0
2002-09-30 17:00:00	NVDA	Stock	0.0717	0.0719	0.0713	0.0719	720000.0
2002-09-30 08:00:00	AMZN	Stock	0.83	0.839	0.825	0.835	194700.0
2002-09-30 09:00:00	AMZN	Stock	0.835	0.8505	0.8	0.801	33050220.0
2002-09-30 10:00:00	AMZN	Stock	0.8005	0.815	0.7925	0.8115	44135660.0
2002-09-30 11:00:00	AMZN	Stock	0.8115	0.8205	0.8076	0.8175	14726280.0
2002-09-30 12:00:00	AMZN	Stock	0.817	0.818	0.806	0.812	14348060.0
2002-09-30 13:00:00	AMZN	Stock	0.81	0.8165	0.807	0.811	21646840.0
2002-09-30 14:00:00	AMZN	Stock	0.811	0.818	0.807	0.8159	8965300.0
2002-09-30 15:00:00	AMZN	Stock	0.816	0.822	0.7985	0.799	34274440.0
2002-09-30 16:00:00	AMZN	Stock	0.799	0.8045	0.7955	0.7995	5771500.0
2002-09-30 17:00:00	AMZN	Stock	0.7995	0.8	0.7995	0.8	6000.0
2002-09-30 18:00:00	AMZN	Stock	0.8045	0.8045	0.7965	0.7965	524000.0
2002-09-30 09:00:00	CL	Stock	27.1	27.105	26.88	27.01	843600.0
2002-09-30 10:00:00	CL	Stock	27.0	27.195	26.875	27.17	735400.0
2002-09-30 11:00:00	CL	Stock	27.195	27.375	27.01	27.295	720400.0
2002-09-30 12:00:00	CL	Stock	27.295	27.295	26.865	27.06	546000.0
2002-09-30 13:00:00	CL	Stock	27.045	27.145	26.945	27.005	564000.0
2002-09-30 14:00:00	CL	Stock	27.0	27.135	26.95	27.1	634200.0
2002-09-30 15:00:00	CL	Stock	27.11	27.25	26.905	26.91	1236200.0
2002-09-30 16:00:00	CL	Stock	26.91	27.2	26.91	27.05	335800.0

> showing 50 of 19,613 rows — these rows as CSV

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