PREVIEW / stock_1hour / 2000-01-07

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-01-07.parquet
  size:    275 KB
  rows:    14,283
  symbols: 1,132

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
2000-01-07 09:00:00	AAPL	Stock	0.8616	0.8873	0.8616	0.8856	74580800.0
2000-01-07 10:00:00	AAPL	Stock	0.8845	0.9018	0.8795	0.8806	79374400.0
2000-01-07 11:00:00	AAPL	Stock	0.8806	0.885	0.8571	0.8672	61555200.0
2000-01-07 12:00:00	AAPL	Stock	0.8661	0.8694	0.8527	0.8571	42985600.0
2000-01-07 13:00:00	AAPL	Stock	0.8571	0.8739	0.8549	0.8691	45024000.0
2000-01-07 14:00:00	AAPL	Stock	0.8689	0.885	0.8594	0.8705	61051200.0
2000-01-07 15:00:00	AAPL	Stock	0.8705	0.8906	0.865	0.8873	59292800.0
2000-01-07 16:00:00	AAPL	Stock	0.8884	0.8884	0.8873	0.8884	884800.0
2000-01-07 09:00:00	MSFT	Stock	54.3125	54.875	53.9062	54.0	7901600.0
2000-01-07 10:00:00	MSFT	Stock	54.0	56.125	53.75	55.4688	13273200.0
2000-01-07 11:00:00	MSFT	Stock	55.5	55.625	54.2812	54.4062	6880000.0
2000-01-07 12:00:00	MSFT	Stock	54.375	54.7812	53.9375	53.9375	4631800.0
2000-01-07 13:00:00	MSFT	Stock	53.9688	54.7188	53.7812	54.1875	6269800.0
2000-01-07 14:00:00	MSFT	Stock	54.25	54.5938	53.6562	54.3125	7810400.0
2000-01-07 15:00:00	MSFT	Stock	54.4062	55.75	54.2812	55.75	10513600.0
2000-01-07 16:00:00	MSFT	Stock	55.6562	55.75	55.625	55.7188	77400.0
2000-01-07 09:00:00	NVDA	Stock	0.0854	0.0875	0.0844	0.0852	7440000.0
2000-01-07 10:00:00	NVDA	Stock	0.0844	0.0868	0.0841	0.0866	16704000.0
2000-01-07 11:00:00	NVDA	Stock	0.0868	0.088	0.0859	0.0859	15888000.0
2000-01-07 12:00:00	NVDA	Stock	0.088	0.088	0.0859	0.0878	8736000.0
2000-01-07 13:00:00	NVDA	Stock	0.0865	0.0875	0.0865	0.0872	4848000.0
2000-01-07 14:00:00	NVDA	Stock	0.0872	0.0875	0.0871	0.0874	6000000.0
2000-01-07 15:00:00	NVDA	Stock	0.0878	0.0882	0.0865	0.0872	8448000.0
2000-01-07 16:00:00	NVDA	Stock	0.0872	0.0872	0.0872	0.0872	1872000.0
2000-01-07 09:00:00	AMZN	Stock	3.35	3.4062	3.3094	3.375	33674000.0
2000-01-07 10:00:00	AMZN	Stock	3.375	3.525	3.3625	3.4156	47424000.0
2000-01-07 11:00:00	AMZN	Stock	3.4156	3.4219	3.3625	3.4062	28082000.0
2000-01-07 12:00:00	AMZN	Stock	3.4062	3.4438	3.3812	3.3938	20968000.0
2000-01-07 13:00:00	AMZN	Stock	3.3906	3.45	3.375	3.4188	9642000.0
2000-01-07 14:00:00	AMZN	Stock	3.4188	3.5	3.4125	3.4469	16870000.0
2000-01-07 15:00:00	AMZN	Stock	3.4469	3.4938	3.425	3.4812	26910000.0
2000-01-07 16:00:00	AMZN	Stock	3.4781	3.4875	3.4781	3.4781	318000.0
2000-01-07 09:00:00	CL	Stock	29.5625	29.8125	29.25	29.25	699000.0
2000-01-07 10:00:00	CL	Stock	29.0	29.875	29.0	29.8125	971200.0
2000-01-07 11:00:00	CL	Stock	29.7812	29.7812	29.4375	29.7188	1065800.0
2000-01-07 12:00:00	CL	Stock	29.75	29.875	29.7188	29.7812	568000.0
2000-01-07 13:00:00	CL	Stock	29.8125	29.9688	29.75	29.9062	616400.0
2000-01-07 14:00:00	CL	Stock	29.875	30.4688	29.875	30.375	738800.0
2000-01-07 15:00:00	CL	Stock	30.375	31.1562	30.25	30.9375	797200.0
2000-01-07 16:00:00	CL	Stock	30.9375	30.9688	30.9375	30.9688	66800.0

> showing 40 of 14,283 rows — these rows as CSV

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