PREVIEW / stock_1hour / 2000-04-27

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-04-27.parquet
  size:    276 KB
  rows:    14,097
  symbols: 1,156

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-27 09:00:00	AAPL	Stock	1.0463	1.0703	1.0407	1.0519	38292800.0
2000-04-27 10:00:00	AAPL	Stock	1.0491	1.0901	1.0458	1.0742	62832000.0
2000-04-27 11:00:00	AAPL	Stock	1.0742	1.1027	1.067	1.1027	40936000.0
2000-04-27 12:00:00	AAPL	Stock	1.1027	1.1183	1.1004	1.1138	37105600.0
2000-04-27 13:00:00	AAPL	Stock	1.1141	1.1141	1.1038	1.1099	21358400.0
2000-04-27 14:00:00	AAPL	Stock	1.1083	1.1295	1.1055	1.1144	40544000.0
2000-04-27 15:00:00	AAPL	Stock	1.115	1.1339	1.1071	1.1317	67558400.0
2000-04-27 16:00:00	AAPL	Stock	1.1311	1.1317	1.1311	1.1317	2385600.0
2000-04-27 09:00:00	MSFT	Stock	33.7188	34.5938	33.6875	34.1719	11319000.0
2000-04-27 10:00:00	MSFT	Stock	34.125	34.625	34.0	34.25	14325800.0
2000-04-27 11:00:00	MSFT	Stock	34.25	34.4375	34.0	34.3125	8349600.0
2000-04-27 12:00:00	MSFT	Stock	34.3125	34.7188	34.25	34.4688	6995000.0
2000-04-27 13:00:00	MSFT	Stock	34.4688	34.6875	34.1875	34.6875	4765400.0
2000-04-27 14:00:00	MSFT	Stock	34.6875	34.8125	34.375	34.7812	9127800.0
2000-04-27 15:00:00	MSFT	Stock	34.75	34.9688	34.375	34.9062	14976000.0
2000-04-27 16:00:00	MSFT	Stock	34.9062	34.9062	34.875	34.9062	234800.0
2000-04-27 09:00:00	NVDA	Stock	0.1635	0.1729	0.1635	0.1674	34656000.0
2000-04-27 10:00:00	NVDA	Stock	0.1687	0.1833	0.1677	0.1833	45120000.0
2000-04-27 11:00:00	NVDA	Stock	0.1833	0.1833	0.1771	0.181	20736000.0
2000-04-27 12:00:00	NVDA	Stock	0.1822	0.1844	0.1797	0.1797	13920000.0
2000-04-27 13:00:00	NVDA	Stock	0.1823	0.187	0.1789	0.1854	33072000.0
2000-04-27 14:00:00	NVDA	Stock	0.1833	0.1875	0.1815	0.1844	27456000.0
2000-04-27 15:00:00	NVDA	Stock	0.1844	0.1914	0.1812	0.1891	68880000.0
2000-04-27 16:00:00	NVDA	Stock	0.1891	0.1896	0.1891	0.1896	5472000.0
2000-04-27 09:00:00	AMZN	Stock	2.4656	2.6125	2.425	2.6125	45862000.0
2000-04-27 10:00:00	AMZN	Stock	2.6062	2.675	2.5688	2.6	50132000.0
2000-04-27 11:00:00	AMZN	Stock	2.6	2.6438	2.5719	2.6344	22440000.0
2000-04-27 12:00:00	AMZN	Stock	2.6406	2.6813	2.6188	2.6375	17396000.0
2000-04-27 13:00:00	AMZN	Stock	2.6438	2.6719	2.625	2.6719	15042000.0
2000-04-27 14:00:00	AMZN	Stock	2.6703	2.7625	2.6375	2.7125	27912000.0
2000-04-27 15:00:00	AMZN	Stock	2.7125	2.725	2.6344	2.6406	25674000.0
2000-04-27 16:00:00	AMZN	Stock	2.6438	2.6438	2.6406	2.6438	416000.0
2000-04-27 09:00:00	CL	Stock	28.4375	28.5	28.1875	28.375	409600.0
2000-04-27 10:00:00	CL	Stock	28.375	28.875	28.3125	28.5625	703000.0
2000-04-27 11:00:00	CL	Stock	28.5625	28.5625	28.2188	28.375	317000.0
2000-04-27 12:00:00	CL	Stock	28.375	28.4688	28.1875	28.2812	461400.0
2000-04-27 13:00:00	CL	Stock	28.25	29.25	28.2188	29.125	1286600.0
2000-04-27 14:00:00	CL	Stock	29.125	29.75	29.0625	29.5	602000.0
2000-04-27 15:00:00	CL	Stock	29.4688	29.9375	29.2812	29.3438	719400.0
2000-04-27 16:00:00	CL	Stock	29.375	29.375	29.3438	29.3438	55000.0

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

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