PREVIEW / stock_1hour / 2000-04-13

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-04-13.parquet
  size:    282 KB
  rows:    14,571
  symbols: 1,165

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-04-13 09:00:00	AAPL	Stock	0.9955	1.0458	0.9688	1.0446	79172800.0
2000-04-13 10:00:00	AAPL	Stock	1.0446	1.0625	1.0145	1.034	116446400.0
2000-04-13 11:00:00	AAPL	Stock	1.0313	1.0692	1.0307	1.0614	56145600.0
2000-04-13 12:00:00	AAPL	Stock	1.0614	1.0681	1.0419	1.0536	71220800.0
2000-04-13 13:00:00	AAPL	Stock	1.0525	1.0714	1.0491	1.0619	22736000.0
2000-04-13 14:00:00	AAPL	Stock	1.0619	1.0647	1.0112	1.0279	46748800.0
2000-04-13 15:00:00	AAPL	Stock	1.0262	1.0555	1.0145	1.0156	87796800.0
2000-04-13 16:00:00	AAPL	Stock	1.0156	1.0195	1.0145	1.0162	806400.0
2000-04-13 09:00:00	MSFT	Stock	40.4375	40.4375	39.5	40.125	14132600.0
2000-04-13 10:00:00	MSFT	Stock	40.0938	40.5	39.75	40.125	15714400.0
2000-04-13 11:00:00	MSFT	Stock	40.125	40.8125	40.0	40.8125	12835800.0
2000-04-13 12:00:00	MSFT	Stock	40.8125	41.125	40.6875	40.75	11572000.0
2000-04-13 13:00:00	MSFT	Stock	40.75	40.8125	40.375	40.5	7052200.0
2000-04-13 14:00:00	MSFT	Stock	40.4844	40.6875	40.0	40.1562	9361800.0
2000-04-13 15:00:00	MSFT	Stock	40.25	40.75	39.5625	39.6562	13889200.0
2000-04-13 16:00:00	MSFT	Stock	39.625	39.75	39.625	39.625	138200.0
2000-04-13 09:00:00	NVDA	Stock	0.1655	0.1714	0.1562	0.1583	41808000.0
2000-04-13 10:00:00	NVDA	Stock	0.1604	0.1677	0.1581	0.1581	62016000.0
2000-04-13 11:00:00	NVDA	Stock	0.1582	0.1633	0.156	0.1625	31680000.0
2000-04-13 12:00:00	NVDA	Stock	0.162	0.1706	0.1615	0.1693	50832000.0
2000-04-13 13:00:00	NVDA	Stock	0.1689	0.1706	0.1678	0.1682	24240000.0
2000-04-13 14:00:00	NVDA	Stock	0.1677	0.1687	0.1544	0.1544	30768000.0
2000-04-13 15:00:00	NVDA	Stock	0.1562	0.1654	0.1562	0.1573	31344000.0
2000-04-13 16:00:00	NVDA	Stock	0.1572	0.1572	0.1572	0.1572	192000.0
2000-04-13 09:00:00	AMZN	Stock	2.8938	2.9062	2.7438	2.8063	20470000.0
2000-04-13 10:00:00	AMZN	Stock	2.8	2.9375	2.7625	2.7875	28244000.0
2000-04-13 11:00:00	AMZN	Stock	2.7938	2.8156	2.7625	2.7906	19722000.0
2000-04-13 12:00:00	AMZN	Stock	2.7875	2.9125	2.7812	2.8531	23054000.0
2000-04-13 13:00:00	AMZN	Stock	2.8531	2.8688	2.8	2.8438	15394000.0
2000-04-13 14:00:00	AMZN	Stock	2.8375	2.8438	2.575	2.65	30528000.0
2000-04-13 15:00:00	AMZN	Stock	2.6625	2.6719	2.3969	2.4	60548000.0
2000-04-13 16:00:00	AMZN	Stock	2.4031	2.4219	2.4	2.4031	604000.0
2000-04-13 09:00:00	CL	Stock	30.5	30.75	30.0	30.5	505600.0
2000-04-13 10:00:00	CL	Stock	30.5	30.5938	29.9062	29.9375	890800.0
2000-04-13 11:00:00	CL	Stock	29.9375	29.9375	29.5	29.6875	1058800.0
2000-04-13 12:00:00	CL	Stock	29.6875	30.0	29.375	29.375	693000.0
2000-04-13 13:00:00	CL	Stock	29.4062	29.4062	28.9062	29.1875	671400.0
2000-04-13 14:00:00	CL	Stock	29.1875	29.4375	29.0625	29.4375	647200.0
2000-04-13 15:00:00	CL	Stock	29.4375	29.5312	29.125	29.5	1095800.0
2000-04-13 16:00:00	CL	Stock	29.5	29.5	29.4688	29.5	262600.0

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

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