PREVIEW / stock_1hour / 2000-09-08

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-09-08.parquet
  size:    301 KB
  rows:    15,301
  symbols: 1,215

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-08 09:00:00	AAPL	Stock	1.1094	1.1384	1.0804	1.0859	28873600.0
2000-09-08 10:00:00	AAPL	Stock	1.0859	1.0882	1.058	1.0592	42033600.0
2000-09-08 11:00:00	AAPL	Stock	1.0569	1.0759	1.0536	1.0636	24388000.0
2000-09-08 12:00:00	AAPL	Stock	1.0625	1.0781	1.0614	1.0692	13316800.0
2000-09-08 13:00:00	AAPL	Stock	1.0681	1.0714	1.0502	1.0513	22965600.0
2000-09-08 14:00:00	AAPL	Stock	1.0525	1.058	1.0446	1.0502	23318400.0
2000-09-08 15:00:00	AAPL	Stock	1.0491	1.0625	1.0491	1.0502	29299200.0
2000-09-08 16:00:00	AAPL	Stock	1.0502	1.0664	1.0491	1.0513	8192800.0
2000-09-08 17:00:00	AAPL	Stock	1.0491	1.0525	1.0491	1.0525	16800.0
2000-09-08 18:00:00	AAPL	Stock	1.0491	1.0536	1.0491	1.0536	16800.0
2000-09-08 08:00:00	MSFT	Stock	35.0625	35.0625	34.9375	35.0	221000.0
2000-09-08 09:00:00	MSFT	Stock	34.9688	35.4375	34.9375	35.1875	6849000.0
2000-09-08 10:00:00	MSFT	Stock	35.1875	35.4375	34.625	34.75	17146400.0
2000-09-08 11:00:00	MSFT	Stock	34.75	34.9375	34.6562	34.875	7982600.0
2000-09-08 12:00:00	MSFT	Stock	34.875	35.0312	34.8438	34.9062	5918000.0
2000-09-08 13:00:00	MSFT	Stock	34.9062	34.9375	34.8438	34.8438	3243200.0
2000-09-08 14:00:00	MSFT	Stock	34.8438	34.875	34.6875	34.7812	4361200.0
2000-09-08 15:00:00	MSFT	Stock	34.75	34.875	34.5938	34.6562	7948400.0
2000-09-08 16:00:00	MSFT	Stock	34.625	34.9844	34.5938	34.6562	1814600.0
2000-09-08 17:00:00	MSFT	Stock	34.6562	34.6562	34.6562	34.6562	400.0
2000-09-08 18:00:00	MSFT	Stock	34.5	34.625	34.5	34.625	2600.0
2000-09-08 08:00:00	NVDA	Stock	0.3258	0.3258	0.3258	0.3258	120000.0
2000-09-08 09:00:00	NVDA	Stock	0.3253	0.3292	0.3188	0.3214	23544000.0
2000-09-08 10:00:00	NVDA	Stock	0.3208	0.3232	0.3141	0.3141	35544000.0
2000-09-08 11:00:00	NVDA	Stock	0.3141	0.3206	0.3125	0.3148	45336000.0
2000-09-08 12:00:00	NVDA	Stock	0.3146	0.3188	0.3146	0.318	19632000.0
2000-09-08 13:00:00	NVDA	Stock	0.3177	0.3182	0.3135	0.3177	14856000.0
2000-09-08 14:00:00	NVDA	Stock	0.3167	0.3182	0.3109	0.3133	34800000.0
2000-09-08 15:00:00	NVDA	Stock	0.3113	0.3143	0.3052	0.306	38904000.0
2000-09-08 16:00:00	NVDA	Stock	0.306	0.3115	0.306	0.3115	1632000.0
2000-09-08 08:00:00	AMZN	Stock	2.1812	2.1938	2.175	2.175	70060.0
2000-09-08 09:00:00	AMZN	Stock	2.1875	2.2375	2.1594	2.1625	16976000.0
2000-09-08 10:00:00	AMZN	Stock	2.1656	2.25	2.1438	2.1562	28946000.0
2000-09-08 11:00:00	AMZN	Stock	2.1531	2.2156	2.125	2.1906	22550000.0
2000-09-08 12:00:00	AMZN	Stock	2.1875	2.225	2.1812	2.2031	6298000.0
2000-09-08 13:00:00	AMZN	Stock	2.2	2.2063	2.1719	2.2	6440000.0
2000-09-08 14:00:00	AMZN	Stock	2.1969	2.2094	2.1812	2.1812	5708000.0
2000-09-08 15:00:00	AMZN	Stock	2.1828	2.2031	2.1438	2.15	11398000.0
2000-09-08 16:00:00	AMZN	Stock	2.15	2.1531	2.1188	2.1312	1286000.0
2000-09-08 17:00:00	AMZN	Stock	2.1359	2.1375	2.125	2.1375	116000.0
2000-09-08 18:00:00	AMZN	Stock	2.1375	2.1375	2.1375	2.1375	26000.0
2000-09-08 09:00:00	CL	Stock	26.5312	26.75	26.4375	26.7188	509600.0
2000-09-08 10:00:00	CL	Stock	26.7188	27.1562	26.7188	27.0	785600.0
2000-09-08 11:00:00	CL	Stock	27.0	27.2188	26.9375	27.0625	633400.0
2000-09-08 12:00:00	CL	Stock	27.0625	27.0625	26.8438	26.9375	343800.0
2000-09-08 13:00:00	CL	Stock	26.9688	27.0312	26.9062	26.9375	344400.0
2000-09-08 14:00:00	CL	Stock	26.9688	27.0	26.9062	26.9375	335800.0
2000-09-08 15:00:00	CL	Stock	26.9375	27.0	26.875	26.9688	471800.0
2000-09-08 16:00:00	CL	Stock	27.0312	27.0312	27.0312	27.0312	76800.0

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

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