PREVIEW / stock_1hour / 2000-09-15

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-09-15.parquet
  size:    310 KB
  rows:    15,817
  symbols: 1,231

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-09-15 08:00:00	AAPL	Stock	1.0151	1.0201	1.0151	1.0179	515200.0
2000-09-15 09:00:00	AAPL	Stock	1.0156	1.0357	1.0156	1.0346	50965600.0
2000-09-15 10:00:00	AAPL	Stock	1.0335	1.0391	1.0156	1.0179	48036800.0
2000-09-15 11:00:00	AAPL	Stock	1.0179	1.029	1.0145	1.029	19734400.0
2000-09-15 12:00:00	AAPL	Stock	1.0279	1.029	1.0134	1.0134	16727200.0
2000-09-15 13:00:00	AAPL	Stock	1.0145	1.0145	1.0045	1.0067	22472800.0
2000-09-15 14:00:00	AAPL	Stock	1.0067	1.0067	0.9688	0.9777	67300800.0
2000-09-15 15:00:00	AAPL	Stock	0.9788	0.9877	0.9766	0.9855	82818400.0
2000-09-15 16:00:00	AAPL	Stock	0.9821	0.9911	0.9799	0.9861	15265600.0
2000-09-15 17:00:00	AAPL	Stock	0.9861	0.9861	0.9821	0.9844	184800.0
2000-09-15 08:00:00	MSFT	Stock	32.9375	33.0	32.6875	32.75	264000.0
2000-09-15 09:00:00	MSFT	Stock	32.6875	32.8125	32.3125	32.375	25416000.0
2000-09-15 10:00:00	MSFT	Stock	32.3438	32.375	31.9688	32.0938	16585200.0
2000-09-15 11:00:00	MSFT	Stock	32.0938	32.25	31.875	32.125	8396200.0
2000-09-15 12:00:00	MSFT	Stock	32.0938	32.1875	31.9375	32.0625	6115400.0
2000-09-15 13:00:00	MSFT	Stock	32.0625	32.125	31.8125	31.875	5513000.0
2000-09-15 14:00:00	MSFT	Stock	31.8438	31.9688	31.6562	31.9375	10790200.0
2000-09-15 15:00:00	MSFT	Stock	31.9062	32.2344	31.7188	32.0938	10412200.0
2000-09-15 16:00:00	MSFT	Stock	32.0312	32.7188	31.7812	32.0938	5454200.0
2000-09-15 17:00:00	MSFT	Stock	32.0938	32.0938	31.875	31.875	9600.0
2000-09-15 18:00:00	MSFT	Stock	31.9375	32.0938	31.875	32.0	3600.0
2000-09-15 08:00:00	NVDA	Stock	0.2938	0.2938	0.2906	0.2906	264000.0
2000-09-15 09:00:00	NVDA	Stock	0.2893	0.2953	0.2854	0.2922	26400000.0
2000-09-15 10:00:00	NVDA	Stock	0.2919	0.2943	0.2917	0.2935	20160000.0
2000-09-15 11:00:00	NVDA	Stock	0.2938	0.2995	0.2935	0.2948	22584000.0
2000-09-15 12:00:00	NVDA	Stock	0.2947	0.2948	0.2911	0.2919	18864000.0
2000-09-15 13:00:00	NVDA	Stock	0.2919	0.2923	0.2911	0.2911	27936000.0
2000-09-15 14:00:00	NVDA	Stock	0.2917	0.2922	0.2914	0.2919	22152000.0
2000-09-15 15:00:00	NVDA	Stock	0.2919	0.2958	0.2854	0.2956	63912000.0
2000-09-15 16:00:00	NVDA	Stock	0.2953	0.2958	0.2915	0.2952	22608000.0
2000-09-15 17:00:00	NVDA	Stock	0.2948	0.2948	0.2917	0.2917	48000.0
2000-09-15 08:00:00	AMZN	Stock	2.2562	2.2562	2.15	2.2	1710000.0
2000-09-15 09:00:00	AMZN	Stock	2.2	2.2719	2.2	2.225	19862000.0
2000-09-15 10:00:00	AMZN	Stock	2.225	2.2516	2.2031	2.2063	17360000.0
2000-09-15 11:00:00	AMZN	Stock	2.2094	2.2125	2.1438	2.1688	20258000.0
2000-09-15 12:00:00	AMZN	Stock	2.1656	2.1844	2.1438	2.175	12330000.0
2000-09-15 13:00:00	AMZN	Stock	2.175	2.1812	2.1562	2.175	5794000.0
2000-09-15 14:00:00	AMZN	Stock	2.1688	2.2094	2.1562	2.1875	10398000.0
2000-09-15 15:00:00	AMZN	Stock	2.1906	2.2031	2.1656	2.1844	18168000.0
2000-09-15 16:00:00	AMZN	Stock	2.1844	2.2	2.1688	2.1906	2638000.0
2000-09-15 17:00:00	AMZN	Stock	2.2	2.2	2.1875	2.1875	28000.0
2000-09-15 18:00:00	AMZN	Stock	2.1875	2.1875	2.1875	2.1875	10000.0
2000-09-15 09:00:00	CL	Stock	23.625	23.875	23.4375	23.6562	3721000.0
2000-09-15 10:00:00	CL	Stock	23.6562	23.875	23.4375	23.5625	7383600.0
2000-09-15 11:00:00	CL	Stock	23.5625	23.5938	23.3438	23.4688	1745200.0
2000-09-15 12:00:00	CL	Stock	23.4688	23.75	23.4375	23.5	3342200.0
2000-09-15 13:00:00	CL	Stock	23.5312	23.5938	23.25	23.3125	2688200.0
2000-09-15 14:00:00	CL	Stock	23.2812	23.4062	23.0312	23.375	1253400.0
2000-09-15 15:00:00	CL	Stock	23.3438	23.4375	23.125	23.2812	1293600.0
2000-09-15 16:00:00	CL	Stock	23.2812	23.2812	23.25	23.2812	421800.0

> showing 50 of 15,817 rows — these rows as CSV

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