PREVIEW / stock_1hour / 2000-04-19

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-04-19.parquet
  size:    280 KB
  rows:    14,398
  symbols: 1,167

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-19 09:00:00	AAPL	Stock	1.1267	1.1507	1.1138	1.1406	44777600.0
2000-04-19 10:00:00	AAPL	Stock	1.1415	1.1563	1.125	1.1518	64646400.0
2000-04-19 11:00:00	AAPL	Stock	1.1501	1.1629	1.135	1.1557	59102400.0
2000-04-19 12:00:00	AAPL	Stock	1.1546	1.1585	1.1373	1.1384	27137600.0
2000-04-19 13:00:00	AAPL	Stock	1.139	1.1473	1.1323	1.1384	28795200.0
2000-04-19 14:00:00	AAPL	Stock	1.1384	1.1473	1.0804	1.0954	80158400.0
2000-04-19 15:00:00	AAPL	Stock	1.096	1.1016	1.0692	1.0809	156520000.0
2000-04-19 16:00:00	AAPL	Stock	1.0815	1.0837	1.0809	1.0815	2788800.0
2000-04-19 09:00:00	MSFT	Stock	40.7188	40.75	39.75	39.8438	9257400.0
2000-04-19 10:00:00	MSFT	Stock	39.7812	40.125	39.4375	40.125	7270400.0
2000-04-19 11:00:00	MSFT	Stock	40.0938	40.25	39.875	40.1875	5331400.0
2000-04-19 12:00:00	MSFT	Stock	40.1562	40.25	39.7812	39.8125	4410600.0
2000-04-19 13:00:00	MSFT	Stock	39.8125	39.9375	39.4375	39.4375	6412000.0
2000-04-19 14:00:00	MSFT	Stock	39.4375	39.8125	39.1562	39.4375	6532000.0
2000-04-19 15:00:00	MSFT	Stock	39.4375	39.5625	39.0625	39.3438	8982600.0
2000-04-19 16:00:00	MSFT	Stock	39.3438	39.3438	39.3125	39.3438	297200.0
2000-04-19 09:00:00	NVDA	Stock	0.1829	0.1854	0.1667	0.1802	40368000.0
2000-04-19 10:00:00	NVDA	Stock	0.1792	0.1812	0.171	0.1797	26016000.0
2000-04-19 11:00:00	NVDA	Stock	0.1797	0.1844	0.1771	0.1812	41808000.0
2000-04-19 12:00:00	NVDA	Stock	0.1831	0.1854	0.1788	0.1788	12960000.0
2000-04-19 13:00:00	NVDA	Stock	0.1792	0.1807	0.174	0.1755	17520000.0
2000-04-19 14:00:00	NVDA	Stock	0.1755	0.1823	0.1711	0.175	81504000.0
2000-04-19 15:00:00	NVDA	Stock	0.175	0.1768	0.1687	0.1708	40656000.0
2000-04-19 16:00:00	NVDA	Stock	0.1695	0.1695	0.1689	0.1689	3840000.0
2000-04-19 09:00:00	AMZN	Stock	2.7656	2.7656	2.6562	2.6594	26762000.0
2000-04-19 10:00:00	AMZN	Stock	2.6594	2.725	2.5844	2.6875	19304000.0
2000-04-19 11:00:00	AMZN	Stock	2.6906	2.7125	2.6469	2.6688	8718000.0
2000-04-19 12:00:00	AMZN	Stock	2.6656	2.6938	2.6531	2.6656	6416000.0
2000-04-19 13:00:00	AMZN	Stock	2.6656	2.675	2.6031	2.6062	9888000.0
2000-04-19 14:00:00	AMZN	Stock	2.6094	2.6688	2.6031	2.6406	11022000.0
2000-04-19 15:00:00	AMZN	Stock	2.6312	2.725	2.6156	2.6719	18086000.0
2000-04-19 16:00:00	AMZN	Stock	2.6688	2.6719	2.6688	2.6719	430000.0
2000-04-19 09:00:00	CL	Stock	28.0	28.0	26.4062	26.7812	854400.0
2000-04-19 10:00:00	CL	Stock	26.7188	27.2188	26.4375	26.8438	1720200.0
2000-04-19 11:00:00	CL	Stock	26.8125	27.0	26.5	27.0	911800.0
2000-04-19 12:00:00	CL	Stock	27.0	27.1562	26.875	26.875	602600.0
2000-04-19 13:00:00	CL	Stock	26.875	27.0625	26.8438	26.9688	1001200.0
2000-04-19 14:00:00	CL	Stock	26.9688	27.375	26.9062	27.375	1219000.0
2000-04-19 15:00:00	CL	Stock	27.375	27.6875	27.375	27.6875	1433800.0
2000-04-19 16:00:00	CL	Stock	27.75	27.8438	27.75	27.8438	103800.0

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

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