PREVIEW / stock_1hour / 2000-09-27

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-09-27.parquet
  size:    303 KB
  rows:    15,485
  symbols: 1,225

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-27 08:00:00	AAPL	Stock	0.9286	0.9297	0.9018	0.9286	285600.0
2000-09-27 09:00:00	AAPL	Stock	0.9353	0.942	0.9208	0.9275	26997600.0
2000-09-27 10:00:00	AAPL	Stock	0.9286	0.9386	0.9063	0.9074	67020800.0
2000-09-27 11:00:00	AAPL	Stock	0.9074	0.9196	0.8973	0.9129	48938400.0
2000-09-27 12:00:00	AAPL	Stock	0.9118	0.9163	0.8996	0.9007	53015200.0
2000-09-27 13:00:00	AAPL	Stock	0.9007	0.9012	0.8839	0.885	53144000.0
2000-09-27 14:00:00	AAPL	Stock	0.885	0.8884	0.8683	0.8683	63952000.0
2000-09-27 15:00:00	AAPL	Stock	0.8683	0.8839	0.8616	0.8739	63823200.0
2000-09-27 16:00:00	AAPL	Stock	0.8728	0.9063	0.8717	0.8728	7604800.0
2000-09-27 17:00:00	AAPL	Stock	0.8728	0.8728	0.8728	0.8728	50400.0
2000-09-27 08:00:00	MSFT	Stock	31.5	31.9375	31.0625	31.5312	615400.0
2000-09-27 09:00:00	MSFT	Stock	31.5625	31.7812	30.9375	31.0938	15574600.0
2000-09-27 10:00:00	MSFT	Stock	31.0625	31.0938	30.4375	30.4688	18173200.0
2000-09-27 11:00:00	MSFT	Stock	30.4688	30.9062	30.2812	30.8438	13709200.0
2000-09-27 12:00:00	MSFT	Stock	30.8125	30.9375	30.5625	30.8125	9334400.0
2000-09-27 13:00:00	MSFT	Stock	30.8438	30.875	30.5	30.5625	6872200.0
2000-09-27 14:00:00	MSFT	Stock	30.5938	30.625	30.1875	30.3125	13913600.0
2000-09-27 15:00:00	MSFT	Stock	30.3125	30.4375	30.1562	30.2812	21492000.0
2000-09-27 16:00:00	MSFT	Stock	30.2812	30.6094	30.1875	30.25	2323600.0
2000-09-27 17:00:00	MSFT	Stock	30.2812	30.5312	30.125	30.25	54200.0
2000-09-27 18:00:00	MSFT	Stock	30.25	30.4062	30.1875	30.3125	6600.0
2000-09-27 08:00:00	NVDA	Stock	0.3229	0.3229	0.3167	0.3208	8688000.0
2000-09-27 09:00:00	NVDA	Stock	0.3208	0.3318	0.3201	0.3294	48864000.0
2000-09-27 10:00:00	NVDA	Stock	0.3297	0.331	0.3245	0.3284	63000000.0
2000-09-27 11:00:00	NVDA	Stock	0.3284	0.3392	0.3276	0.3375	135672000.0
2000-09-27 12:00:00	NVDA	Stock	0.3378	0.3557	0.3375	0.3474	198960000.0
2000-09-27 13:00:00	NVDA	Stock	0.3474	0.349	0.3422	0.3422	66552000.0
2000-09-27 14:00:00	NVDA	Stock	0.3422	0.3474	0.3354	0.3357	79416000.0
2000-09-27 15:00:00	NVDA	Stock	0.337	0.3469	0.3357	0.3398	56496000.0
2000-09-27 16:00:00	NVDA	Stock	0.3406	0.3496	0.3354	0.3385	5784000.0
2000-09-27 08:00:00	AMZN	Stock	1.975	1.975	1.9375	1.9469	516000.0
2000-09-27 09:00:00	AMZN	Stock	1.95	1.9812	1.8938	1.9656	22280000.0
2000-09-27 10:00:00	AMZN	Stock	1.9656	1.975	1.9062	1.9062	34752000.0
2000-09-27 11:00:00	AMZN	Stock	1.9062	1.9219	1.8875	1.9156	24700000.0
2000-09-27 12:00:00	AMZN	Stock	1.9188	1.9219	1.8969	1.9	8834000.0
2000-09-27 13:00:00	AMZN	Stock	1.9	1.9062	1.825	1.8312	24914000.0
2000-09-27 14:00:00	AMZN	Stock	1.825	1.8344	1.775	1.7938	38240000.0
2000-09-27 15:00:00	AMZN	Stock	1.7938	1.9	1.7906	1.8938	38630000.0
2000-09-27 16:00:00	AMZN	Stock	1.8938	1.8969	1.85	1.8938	2276000.0
2000-09-27 17:00:00	AMZN	Stock	1.9078	1.9078	1.8781	1.8969	810000.0
2000-09-27 18:00:00	AMZN	Stock	1.8938	1.8938	1.8938	1.8938	10000.0
2000-09-27 09:00:00	CL	Stock	22.5	22.5	22.325	22.35	276000.0
2000-09-27 10:00:00	CL	Stock	22.375	22.465	22.33	22.35	300400.0
2000-09-27 11:00:00	CL	Stock	22.35	22.425	22.265	22.33	396200.0
2000-09-27 12:00:00	CL	Stock	22.345	22.35	22.15	22.155	440600.0
2000-09-27 13:00:00	CL	Stock	22.155	22.22	22.125	22.18	190400.0
2000-09-27 14:00:00	CL	Stock	22.18	22.255	22.13	22.165	602200.0
2000-09-27 15:00:00	CL	Stock	22.155	22.325	22.13	22.25	672800.0
2000-09-27 16:00:00	CL	Stock	22.255	22.255	22.25	22.25	99400.0

> showing 49 of 15,485 rows — these rows as CSV

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