PREVIEW / stock_1hour / 2000-07-19

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-07-19.parquet
  size:    296 KB
  rows:    15,224
  symbols: 1,188

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-07-19 08:00:00	AAPL	Stock	0.9732	1.0229	0.9509	1.0045	10130400.0
2000-07-19 09:00:00	AAPL	Stock	1.0	1.0145	0.9621	0.9777	56067200.0
2000-07-19 10:00:00	AAPL	Stock	0.9777	0.9844	0.9598	0.9632	69249600.0
2000-07-19 11:00:00	AAPL	Stock	0.9632	0.9799	0.9509	0.9542	77022400.0
2000-07-19 12:00:00	AAPL	Stock	0.9554	0.9626	0.9397	0.9442	40863200.0
2000-07-19 13:00:00	AAPL	Stock	0.9431	0.9554	0.9386	0.9397	34081600.0
2000-07-19 14:00:00	AAPL	Stock	0.9397	0.9509	0.9353	0.9364	47975200.0
2000-07-19 15:00:00	AAPL	Stock	0.9353	0.9487	0.9241	0.9397	93100000.0
2000-07-19 16:00:00	AAPL	Stock	0.9408	0.9554	0.9252	0.9464	13832000.0
2000-07-19 17:00:00	AAPL	Stock	0.9531	0.9554	0.9464	0.9531	403200.0
2000-07-19 18:00:00	AAPL	Stock	0.9542	0.9542	0.9464	0.9464	56000.0
2000-07-19 08:00:00	MSFT	Stock	37.75	39.5	37.5	38.25	1053400.0
2000-07-19 09:00:00	MSFT	Stock	38.1875	38.375	37.3438	37.5156	24200600.0
2000-07-19 10:00:00	MSFT	Stock	37.5	37.5625	37.0938	37.2188	27260600.0
2000-07-19 11:00:00	MSFT	Stock	37.1875	37.25	36.4688	36.4688	22764800.0
2000-07-19 12:00:00	MSFT	Stock	36.5	36.875	36.4688	36.8438	16688000.0
2000-07-19 13:00:00	MSFT	Stock	36.8438	37.0625	36.625	36.6562	9297000.0
2000-07-19 14:00:00	MSFT	Stock	36.6875	36.7812	36.5938	36.625	12480200.0
2000-07-19 15:00:00	MSFT	Stock	36.625	36.8125	36.4062	36.5312	20257400.0
2000-07-19 16:00:00	MSFT	Stock	36.5625	38.1562	36.5	36.5938	2989400.0
2000-07-19 17:00:00	MSFT	Stock	36.7188	37.0938	36.6875	36.75	85400.0
2000-07-19 18:00:00	MSFT	Stock	36.75	36.8281	36.7188	36.7812	21400.0
2000-07-19 09:00:00	NVDA	Stock	0.2917	0.2917	0.2813	0.2828	37728000.0
2000-07-19 10:00:00	NVDA	Stock	0.2826	0.2896	0.2813	0.2875	30288000.0
2000-07-19 11:00:00	NVDA	Stock	0.2875	0.2875	0.2732	0.2784	40776000.0
2000-07-19 12:00:00	NVDA	Stock	0.2781	0.2833	0.2781	0.2789	22392000.0
2000-07-19 13:00:00	NVDA	Stock	0.2789	0.2833	0.2786	0.2805	8592000.0
2000-07-19 14:00:00	NVDA	Stock	0.2807	0.2833	0.2784	0.2786	9936000.0
2000-07-19 15:00:00	NVDA	Stock	0.2786	0.2831	0.2779	0.2792	31344000.0
2000-07-19 16:00:00	NVDA	Stock	0.2789	0.2797	0.2789	0.2797	624000.0
2000-07-19 17:00:00	NVDA	Stock	0.276	0.276	0.276	0.276	24000.0
2000-07-19 08:00:00	AMZN	Stock	2.05	2.0875	2.05	2.0688	88000.0
2000-07-19 09:00:00	AMZN	Stock	2.0688	2.0797	2.0125	2.0188	11828000.0
2000-07-19 10:00:00	AMZN	Stock	2.0219	2.075	2.0	2.0562	19436000.0
2000-07-19 11:00:00	AMZN	Stock	2.0562	2.0688	2.0062	2.0125	18082000.0
2000-07-19 12:00:00	AMZN	Stock	2.0156	2.0375	2.0156	2.0219	11384000.0
2000-07-19 13:00:00	AMZN	Stock	2.0219	2.0344	2.0188	2.0281	6380000.0
2000-07-19 14:00:00	AMZN	Stock	2.0281	2.0438	2.0031	2.0156	9348000.0
2000-07-19 15:00:00	AMZN	Stock	2.0156	2.0469	2.0062	2.0375	14980000.0
2000-07-19 16:00:00	AMZN	Stock	2.0375	2.0625	2.0281	2.0438	2084000.0
2000-07-19 17:00:00	AMZN	Stock	2.0344	2.05	2.0156	2.0469	242000.0
2000-07-19 18:00:00	AMZN	Stock	2.05	2.05	2.0375	2.0375	14000.0
2000-07-19 09:00:00	CL	Stock	27.5	27.5938	27.4688	27.4688	235400.0
2000-07-19 10:00:00	CL	Stock	27.4688	27.4688	26.625	26.8125	726200.0
2000-07-19 11:00:00	CL	Stock	26.8125	26.8125	26.5312	26.75	688000.0
2000-07-19 12:00:00	CL	Stock	26.7812	26.875	26.75	26.8125	235000.0
2000-07-19 13:00:00	CL	Stock	26.8125	26.9688	26.5938	26.8438	395800.0
2000-07-19 14:00:00	CL	Stock	26.8438	27.0625	26.8438	26.9688	544000.0
2000-07-19 15:00:00	CL	Stock	26.9688	27.3438	26.9688	27.2812	1133000.0
2000-07-19 16:00:00	CL	Stock	27.2812	27.2812	26.9688	26.9688	47800.0

> showing 50 of 15,224 rows — these rows as CSV

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