PREVIEW / stock_1hour / 2000-09-05

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-09-05.parquet
  size:    306 KB
  rows:    15,817
  symbols: 1,220

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-05 08:00:00	AAPL	Stock	1.1328	1.1362	1.1205	1.1228	72800.0
2000-09-05 09:00:00	AAPL	Stock	1.1228	1.1451	1.1172	1.1395	42655200.0
2000-09-05 10:00:00	AAPL	Stock	1.1395	1.1429	1.1339	1.1406	43657600.0
2000-09-05 11:00:00	AAPL	Stock	1.1406	1.1429	1.1317	1.135	20776000.0
2000-09-05 12:00:00	AAPL	Stock	1.1339	1.1384	1.1295	1.1339	24438400.0
2000-09-05 13:00:00	AAPL	Stock	1.1345	1.135	1.1261	1.1323	24752000.0
2000-09-05 14:00:00	AAPL	Stock	1.1323	1.1328	1.1295	1.13	88653600.0
2000-09-05 15:00:00	AAPL	Stock	1.1295	1.1317	1.1116	1.1161	38444000.0
2000-09-05 16:00:00	AAPL	Stock	1.1161	1.1244	1.1071	1.1071	6440000.0
2000-09-05 17:00:00	AAPL	Stock	1.1161	1.1161	1.115	1.115	22400.0
2000-09-05 18:00:00	AAPL	Stock	1.1228	1.1295	1.1228	1.1295	22400.0
2000-09-05 08:00:00	MSFT	Stock	34.9062	35.25	34.9062	35.125	56400.0
2000-09-05 09:00:00	MSFT	Stock	35.0625	35.125	34.9062	35.0312	5004400.0
2000-09-05 10:00:00	MSFT	Stock	35.0312	35.1562	34.9062	35.1562	10255800.0
2000-09-05 11:00:00	MSFT	Stock	35.125	35.1875	35.0312	35.0312	7115000.0
2000-09-05 12:00:00	MSFT	Stock	35.0312	35.125	35.0312	35.0938	7880000.0
2000-09-05 13:00:00	MSFT	Stock	35.125	35.3438	35.0625	35.3125	5692400.0
2000-09-05 14:00:00	MSFT	Stock	35.3125	35.3438	35.0625	35.0938	5682800.0
2000-09-05 15:00:00	MSFT	Stock	35.125	35.1562	35.0	35.0625	5993800.0
2000-09-05 16:00:00	MSFT	Stock	35.0625	35.1719	35.0312	35.0312	1512200.0
2000-09-05 17:00:00	MSFT	Stock	35.125	35.125	35.0	35.0	86400.0
2000-09-05 18:00:00	MSFT	Stock	34.9375	35.0	34.9375	35.0	400.0
2000-09-05 08:00:00	NVDA	Stock	0.3405	0.3405	0.3405	0.3405	24000.0
2000-09-05 09:00:00	NVDA	Stock	0.3333	0.3398	0.3315	0.3349	39120000.0
2000-09-05 10:00:00	NVDA	Stock	0.3349	0.3367	0.3313	0.3352	35736000.0
2000-09-05 11:00:00	NVDA	Stock	0.3346	0.3391	0.3339	0.3362	25656000.0
2000-09-05 12:00:00	NVDA	Stock	0.3362	0.3375	0.3344	0.3367	44880000.0
2000-09-05 13:00:00	NVDA	Stock	0.3365	0.338	0.3359	0.337	17400000.0
2000-09-05 14:00:00	NVDA	Stock	0.3367	0.3372	0.3344	0.3359	24504000.0
2000-09-05 15:00:00	NVDA	Stock	0.3357	0.337	0.3313	0.3315	38856000.0
2000-09-05 16:00:00	NVDA	Stock	0.3318	0.3344	0.3313	0.3344	5688000.0
2000-09-05 17:00:00	NVDA	Stock	0.3396	0.3396	0.3396	0.3396	24000.0
2000-09-05 08:00:00	AMZN	Stock	2.0781	2.0875	2.0719	2.0719	34000.0
2000-09-05 09:00:00	AMZN	Stock	2.0719	2.075	2.0125	2.0562	14836000.0
2000-09-05 10:00:00	AMZN	Stock	2.0562	2.0656	2.0156	2.0438	19716000.0
2000-09-05 11:00:00	AMZN	Stock	2.0469	2.0625	2.0375	2.0438	8172000.0
2000-09-05 12:00:00	AMZN	Stock	2.0406	2.075	2.0375	2.0594	5362000.0
2000-09-05 13:00:00	AMZN	Stock	2.0656	2.1656	2.0531	2.1656	18462000.0
2000-09-05 14:00:00	AMZN	Stock	2.1656	2.2812	2.1594	2.275	73722000.0
2000-09-05 15:00:00	AMZN	Stock	2.275	2.3156	2.2406	2.2844	56780000.0
2000-09-05 16:00:00	AMZN	Stock	2.2844	2.2875	2.25	2.2625	2270000.0
2000-09-05 17:00:00	AMZN	Stock	2.2625	2.2688	2.2562	2.2562	66000.0
2000-09-05 18:00:00	AMZN	Stock	2.2594	2.2625	2.2562	2.2625	88000.0
2000-09-05 09:00:00	CL	Stock	25.7812	26.1562	25.7812	25.875	238200.0
2000-09-05 10:00:00	CL	Stock	25.875	25.875	25.5938	25.6562	418600.0
2000-09-05 11:00:00	CL	Stock	25.625	25.6562	25.4375	25.5625	485800.0
2000-09-05 12:00:00	CL	Stock	25.5625	25.875	25.5312	25.75	223400.0
2000-09-05 13:00:00	CL	Stock	25.7812	26.0	25.75	25.9688	226800.0
2000-09-05 14:00:00	CL	Stock	26.0	26.2188	25.9688	26.1562	240600.0
2000-09-05 15:00:00	CL	Stock	26.1562	26.1562	25.875	26.0938	388000.0

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

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