PREVIEW / stock_1hour / 2002-01-23

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-01-23.parquet
  size:    384 KB
  rows:    18,486
  symbols: 1,337

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-01-23 08:00:00	AAPL	Stock	0.3893	0.3929	0.3893	0.3911	308000.0
2002-01-23 09:00:00	AAPL	Stock	0.3911	0.3929	0.3855	0.3905	37833600.0
2002-01-23 10:00:00	AAPL	Stock	0.3902	0.3973	0.3877	0.3973	58693600.0
2002-01-23 11:00:00	AAPL	Stock	0.3966	0.4057	0.3962	0.4018	87808000.0
2002-01-23 12:00:00	AAPL	Stock	0.4027	0.4036	0.3996	0.4032	38320800.0
2002-01-23 13:00:00	AAPL	Stock	0.4032	0.4104	0.4025	0.4089	56599200.0
2002-01-23 14:00:00	AAPL	Stock	0.4088	0.4107	0.4078	0.4084	72262400.0
2002-01-23 15:00:00	AAPL	Stock	0.408	0.4114	0.4069	0.4107	59813600.0
2002-01-23 16:00:00	AAPL	Stock	0.4107	0.4143	0.4021	0.4111	17533600.0
2002-01-23 17:00:00	AAPL	Stock	0.412	0.412	0.4111	0.412	543200.0
2002-01-23 08:00:00	MSFT	Stock	32.35	32.4	32.18	32.18	37800.0
2002-01-23 09:00:00	MSFT	Stock	32.18	32.235	31.6745	31.73	11059600.0
2002-01-23 10:00:00	MSFT	Stock	31.735	31.945	31.63	31.945	13953800.0
2002-01-23 11:00:00	MSFT	Stock	31.95	31.95	31.62	31.8	8809000.0
2002-01-23 12:00:00	MSFT	Stock	31.805	31.9455	31.625	31.89	7271200.0
2002-01-23 13:00:00	MSFT	Stock	31.895	32.35	31.705	32.1475	10811000.0
2002-01-23 14:00:00	MSFT	Stock	32.14	32.275	31.83	31.9	11315400.0
2002-01-23 15:00:00	MSFT	Stock	31.9	32.06	31.73	31.865	10972200.0
2002-01-23 16:00:00	MSFT	Stock	31.85	32.2262	31.76	31.855	2537200.0
2002-01-23 17:00:00	MSFT	Stock	31.855	31.92	31.775	31.825	209200.0
2002-01-23 18:00:00	MSFT	Stock	31.8	31.945	31.755	31.945	5800.0
2002-01-23 08:00:00	NVDA	Stock	0.5245	0.525	0.5229	0.5229	564000.0
2002-01-23 09:00:00	NVDA	Stock	0.5225	0.5268	0.5141	0.5199	102456000.0
2002-01-23 10:00:00	NVDA	Stock	0.5198	0.5204	0.5127	0.5198	159960000.0
2002-01-23 11:00:00	NVDA	Stock	0.5193	0.5223	0.5133	0.5163	94644000.0
2002-01-23 12:00:00	NVDA	Stock	0.5163	0.52	0.5146	0.5173	70164000.0
2002-01-23 13:00:00	NVDA	Stock	0.517	0.5318	0.5158	0.5291	151896000.0
2002-01-23 14:00:00	NVDA	Stock	0.5286	0.5296	0.5253	0.5261	116736000.0
2002-01-23 15:00:00	NVDA	Stock	0.5262	0.5294	0.5239	0.5279	136488000.0
2002-01-23 16:00:00	NVDA	Stock	0.528	0.5281	0.5219	0.5275	39240000.0
2002-01-23 17:00:00	NVDA	Stock	0.5278	0.5281	0.5262	0.5267	864000.0
2002-01-23 18:00:00	NVDA	Stock	0.5267	0.5287	0.5158	0.5287	60000.0
2002-01-23 08:00:00	AMZN	Stock	0.639	0.641	0.62	0.62	1574000.0
2002-01-23 09:00:00	AMZN	Stock	0.6175	0.63	0.6095	0.613	74586000.0
2002-01-23 10:00:00	AMZN	Stock	0.6135	0.6145	0.595	0.6105	98400000.0
2002-01-23 11:00:00	AMZN	Stock	0.6105	0.6265	0.6075	0.6195	38734000.0
2002-01-23 12:00:00	AMZN	Stock	0.62	0.6295	0.613	0.6265	40486000.0
2002-01-23 13:00:00	AMZN	Stock	0.627	0.6295	0.6225	0.6255	30776000.0
2002-01-23 14:00:00	AMZN	Stock	0.6255	0.6265	0.6135	0.6155	23256000.0
2002-01-23 15:00:00	AMZN	Stock	0.6155	0.6265	0.615	0.624	31120000.0
2002-01-23 16:00:00	AMZN	Stock	0.624	0.624	0.6164	0.6205	5028000.0
2002-01-23 17:00:00	AMZN	Stock	0.623	0.6235	0.6205	0.6235	206000.0
2002-01-23 18:00:00	AMZN	Stock	0.62	0.621	0.62	0.62	48000.0
2002-01-23 09:00:00	CL	Stock	28.2	28.325	28.155	28.265	202000.0
2002-01-23 10:00:00	CL	Stock	28.3	28.375	28.05	28.165	394000.0
2002-01-23 11:00:00	CL	Stock	28.155	28.175	27.965	27.98	644600.0
2002-01-23 12:00:00	CL	Stock	28.0	28.025	27.86	28.02	291000.0
2002-01-23 13:00:00	CL	Stock	28.02	28.05	27.925	27.99	288000.0
2002-01-23 14:00:00	CL	Stock	27.975	28.0	27.875	27.985	445200.0
2002-01-23 15:00:00	CL	Stock	27.985	28.205	27.95	28.135	901000.0

> showing 50 of 18,486 rows — these rows as CSV

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