PREVIEW / stock_1hour / 2002-03-27

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-03-27.parquet
  size:    391 KB
  rows:    18,777
  symbols: 1,394

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-03-27 08:00:00	AAPL	Stock	0.4188	0.4188	0.4188	0.4188	56000.0
2002-03-27 09:00:00	AAPL	Stock	0.4188	0.4193	0.4168	0.4179	23066400.0
2002-03-27 10:00:00	AAPL	Stock	0.4182	0.4229	0.4179	0.4218	28812000.0
2002-03-27 11:00:00	AAPL	Stock	0.4218	0.4236	0.4191	0.4211	12219200.0
2002-03-27 12:00:00	AAPL	Stock	0.4214	0.4218	0.4184	0.4198	12885600.0
2002-03-27 13:00:00	AAPL	Stock	0.42	0.4213	0.4175	0.4179	7526400.0
2002-03-27 14:00:00	AAPL	Stock	0.4177	0.4191	0.4154	0.4182	16027200.0
2002-03-27 15:00:00	AAPL	Stock	0.4188	0.42	0.4168	0.4193	19247200.0
2002-03-27 16:00:00	AAPL	Stock	0.4195	0.4198	0.4191	0.4191	5437600.0
2002-03-27 17:00:00	AAPL	Stock	0.4191	0.4191	0.4191	0.4191	812000.0
2002-03-27 08:00:00	MSFT	Stock	29.6	29.6	29.4	29.475	42800.0
2002-03-27 09:00:00	MSFT	Stock	29.45	29.705	29.295	29.455	6363200.0
2002-03-27 10:00:00	MSFT	Stock	29.455	29.575	29.335	29.515	8170000.0
2002-03-27 11:00:00	MSFT	Stock	29.525	29.9	29.5	29.89	6753000.0
2002-03-27 12:00:00	MSFT	Stock	29.885	29.89	29.6935	29.8445	4462400.0
2002-03-27 13:00:00	MSFT	Stock	29.845	29.895	29.725	29.8255	4317800.0
2002-03-27 14:00:00	MSFT	Stock	29.825	29.84	29.58	29.66	6228200.0
2002-03-27 15:00:00	MSFT	Stock	29.6605	29.87	29.63	29.725	7294200.0
2002-03-27 16:00:00	MSFT	Stock	29.725	29.82	29.405	29.72	2179000.0
2002-03-27 17:00:00	MSFT	Stock	29.72	29.75	29.7	29.7	169200.0
2002-03-27 08:00:00	NVDA	Stock	0.3909	0.3909	0.3833	0.3875	948000.0
2002-03-27 09:00:00	NVDA	Stock	0.3903	0.3904	0.3817	0.3866	140040000.0
2002-03-27 10:00:00	NVDA	Stock	0.3867	0.3935	0.3844	0.3851	178416000.0
2002-03-27 11:00:00	NVDA	Stock	0.3851	0.3893	0.3838	0.3882	93780000.0
2002-03-27 12:00:00	NVDA	Stock	0.3882	0.3886	0.3792	0.3823	133896000.0
2002-03-27 13:00:00	NVDA	Stock	0.3823	0.3827	0.3725	0.3755	174756000.0
2002-03-27 14:00:00	NVDA	Stock	0.3751	0.3777	0.373	0.3772	102084000.0
2002-03-27 15:00:00	NVDA	Stock	0.3773	0.3807	0.3737	0.3792	162024000.0
2002-03-27 16:00:00	NVDA	Stock	0.3795	0.3816	0.3767	0.3781	55872000.0
2002-03-27 17:00:00	NVDA	Stock	0.3792	0.38	0.3779	0.38	1308000.0
2002-03-27 18:00:00	NVDA	Stock	0.3792	0.3792	0.3792	0.3792	192000.0
2002-03-27 08:00:00	AMZN	Stock	0.7165	0.7415	0.705	0.7075	1208000.0
2002-03-27 09:00:00	AMZN	Stock	0.7085	0.73	0.685	0.7085	58924000.0
2002-03-27 10:00:00	AMZN	Stock	0.708	0.7175	0.705	0.7135	37044000.0
2002-03-27 11:00:00	AMZN	Stock	0.713	0.715	0.7085	0.7115	20972000.0
2002-03-27 12:00:00	AMZN	Stock	0.7125	0.713	0.7085	0.711	7890000.0
2002-03-27 13:00:00	AMZN	Stock	0.711	0.7115	0.703	0.706	9572000.0
2002-03-27 14:00:00	AMZN	Stock	0.705	0.709	0.705	0.708	7408000.0
2002-03-27 15:00:00	AMZN	Stock	0.708	0.714	0.705	0.713	14226000.0
2002-03-27 16:00:00	AMZN	Stock	0.7125	0.715	0.7063	0.7135	1822000.0
2002-03-27 17:00:00	AMZN	Stock	0.7125	0.713	0.7125	0.713	158000.0
2002-03-27 18:00:00	AMZN	Stock	0.7125	0.7125	0.7125	0.7125	10000.0
2002-03-27 09:00:00	CL	Stock	28.425	28.505	28.36	28.455	251000.0
2002-03-27 10:00:00	CL	Stock	28.475	28.515	28.3	28.3	263400.0
2002-03-27 11:00:00	CL	Stock	28.33	28.425	28.3	28.39	253800.0
2002-03-27 12:00:00	CL	Stock	28.38	28.6	28.365	28.6	225200.0
2002-03-27 13:00:00	CL	Stock	28.63	28.645	28.505	28.605	244200.0
2002-03-27 14:00:00	CL	Stock	28.6	28.625	28.505	28.605	385000.0
2002-03-27 15:00:00	CL	Stock	28.605	28.75	28.58	28.68	1025000.0
2002-03-27 16:00:00	CL	Stock	28.675	28.68	28.57	28.575	297000.0

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

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