PREVIEW / stock_1hour / 2000-03-06

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-03-06.parquet
  size:    289 KB
  rows:    14,658
  symbols: 1,146

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-03-06 09:00:00	AAPL	Stock	1.125	1.1451	1.1177	1.1429	36579200.0
2000-03-06 10:00:00	AAPL	Stock	1.1417	1.1496	1.1161	1.1473	47297600.0
2000-03-06 11:00:00	AAPL	Stock	1.1473	1.1529	1.1339	1.1412	28112000.0
2000-03-06 12:00:00	AAPL	Stock	1.1417	1.1451	1.125	1.1339	24091200.0
2000-03-06 13:00:00	AAPL	Stock	1.1323	1.1384	1.1267	1.1373	10539200.0
2000-03-06 14:00:00	AAPL	Stock	1.1367	1.139	1.1267	1.1306	11334400.0
2000-03-06 15:00:00	AAPL	Stock	1.1306	1.1417	1.1172	1.1205	27540800.0
2000-03-06 16:00:00	AAPL	Stock	1.1217	1.1222	1.1205	1.1222	1904000.0
2000-03-06 09:00:00	MSFT	Stock	48.0	48.6875	47.625	48.0	10587000.0
2000-03-06 10:00:00	MSFT	Stock	47.9375	48.1875	47.5938	48.0312	10484200.0
2000-03-06 11:00:00	MSFT	Stock	48.0312	48.0938	47.5	47.8438	9424200.0
2000-03-06 12:00:00	MSFT	Stock	47.8438	48.0	47.375	47.5	5848800.0
2000-03-06 13:00:00	MSFT	Stock	47.4688	47.5312	46.875	47.0	6423000.0
2000-03-06 14:00:00	MSFT	Stock	47.0	47.0625	46.0938	46.1562	9845000.0
2000-03-06 15:00:00	MSFT	Stock	46.1875	46.2188	45.0469	45.375	33615000.0
2000-03-06 16:00:00	MSFT	Stock	45.2812	45.4375	45.1875	45.3125	55200.0
2000-03-06 09:00:00	NVDA	Stock	0.1234	0.124	0.1225	0.1229	11520000.0
2000-03-06 10:00:00	NVDA	Stock	0.1232	0.1242	0.1214	0.1227	49200000.0
2000-03-06 11:00:00	NVDA	Stock	0.1223	0.1229	0.1208	0.1224	17328000.0
2000-03-06 12:00:00	NVDA	Stock	0.1224	0.1229	0.1208	0.1227	48192000.0
2000-03-06 13:00:00	NVDA	Stock	0.1227	0.1262	0.1219	0.1262	84864000.0
2000-03-06 14:00:00	NVDA	Stock	0.1262	0.1328	0.1255	0.1294	106464000.0
2000-03-06 15:00:00	NVDA	Stock	0.1292	0.1299	0.1214	0.1219	81936000.0
2000-03-06 09:00:00	AMZN	Stock	3.1438	3.3125	3.1406	3.2812	22512000.0
2000-03-06 10:00:00	AMZN	Stock	3.2812	3.3625	3.2656	3.2875	40036000.0
2000-03-06 11:00:00	AMZN	Stock	3.2875	3.3	3.2281	3.2312	22002000.0
2000-03-06 12:00:00	AMZN	Stock	3.2312	3.25	3.2031	3.225	13578000.0
2000-03-06 13:00:00	AMZN	Stock	3.2312	3.2875	3.2219	3.2781	15648000.0
2000-03-06 14:00:00	AMZN	Stock	3.2781	3.3	3.2281	3.2594	12040000.0
2000-03-06 15:00:00	AMZN	Stock	3.2594	3.2781	3.15	3.2031	15776000.0
2000-03-06 16:00:00	AMZN	Stock	3.1906	3.2063	3.1875	3.1969	550000.0
2000-03-06 09:00:00	CL	Stock	27.5	27.5	27.0	27.125	330400.0
2000-03-06 10:00:00	CL	Stock	27.125	27.1562	26.625	26.8125	422000.0
2000-03-06 11:00:00	CL	Stock	26.8125	26.875	26.625	26.625	276000.0
2000-03-06 12:00:00	CL	Stock	26.625	26.6875	26.3125	26.5312	333200.0
2000-03-06 13:00:00	CL	Stock	26.5	26.5625	26.375	26.4062	178200.0
2000-03-06 14:00:00	CL	Stock	26.4062	26.5625	26.375	26.4688	274000.0
2000-03-06 15:00:00	CL	Stock	26.4688	26.5625	26.3125	26.3438	357400.0
2000-03-06 16:00:00	CL	Stock	26.4062	26.4062	26.4062	26.4062	56600.0

> showing 39 of 14,658 rows — these rows as CSV

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