PREVIEW / stock_1hour / 2000-06-15

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-06-15.parquet
  size:    292 KB
  rows:    15,402
  symbols: 1,177

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-06-15 08:00:00	AAPL	Stock	0.8214	0.8214	0.8192	0.8192	246400.0
2000-06-15 09:00:00	AAPL	Stock	0.8186	0.8192	0.7946	0.7974	42392000.0
2000-06-15 10:00:00	AAPL	Stock	0.7974	0.8089	0.7958	0.8025	46200000.0
2000-06-15 11:00:00	AAPL	Stock	0.8019	0.8203	0.8019	0.8164	59852800.0
2000-06-15 12:00:00	AAPL	Stock	0.8153	0.8259	0.8153	0.8225	19532800.0
2000-06-15 13:00:00	AAPL	Stock	0.8231	0.8326	0.8209	0.8309	20809600.0
2000-06-15 14:00:00	AAPL	Stock	0.832	0.8337	0.8225	0.8292	15310400.0
2000-06-15 15:00:00	AAPL	Stock	0.8298	0.8309	0.8142	0.8242	37542400.0
2000-06-15 16:00:00	AAPL	Stock	0.8242	0.8259	0.8214	0.8248	5308800.0
2000-06-15 17:00:00	AAPL	Stock	0.8248	0.8248	0.8248	0.8248	11200.0
2000-06-15 08:00:00	MSFT	Stock	35.25	35.4375	35.0938	35.2188	53000.0
2000-06-15 09:00:00	MSFT	Stock	35.25	35.875	35.2188	35.4375	10774400.0
2000-06-15 10:00:00	MSFT	Stock	35.4062	35.8125	35.4062	35.75	9131000.0
2000-06-15 11:00:00	MSFT	Stock	35.7812	36.0	35.6875	35.875	6424600.0
2000-06-15 12:00:00	MSFT	Stock	35.8438	36.0	35.8125	35.9375	5769800.0
2000-06-15 13:00:00	MSFT	Stock	35.9688	36.0938	35.9062	36.0312	9573800.0
2000-06-15 14:00:00	MSFT	Stock	36.0312	36.25	35.9375	36.1875	7234600.0
2000-06-15 15:00:00	MSFT	Stock	36.2188	36.3438	35.9688	36.1875	12775400.0
2000-06-15 16:00:00	MSFT	Stock	36.1562	36.9688	36.0938	36.375	3366800.0
2000-06-15 17:00:00	MSFT	Stock	36.3438	36.75	35.4062	36.25	43400.0
2000-06-15 18:00:00	MSFT	Stock	36.1875	36.25	36.1875	36.2188	4000.0
2000-06-15 09:00:00	NVDA	Stock	0.2625	0.2648	0.2622	0.2631	31824000.0
2000-06-15 10:00:00	NVDA	Stock	0.2626	0.2651	0.2492	0.2505	75024000.0
2000-06-15 11:00:00	NVDA	Stock	0.2507	0.2547	0.2495	0.2542	38880000.0
2000-06-15 12:00:00	NVDA	Stock	0.2542	0.2615	0.2534	0.2586	16128000.0
2000-06-15 13:00:00	NVDA	Stock	0.2594	0.2667	0.257	0.2639	35712000.0
2000-06-15 14:00:00	NVDA	Stock	0.2646	0.2684	0.2646	0.2669	45120000.0
2000-06-15 15:00:00	NVDA	Stock	0.2668	0.2711	0.2604	0.2711	65088000.0
2000-06-15 16:00:00	NVDA	Stock	0.2711	0.2711	0.2687	0.2703	19728000.0
2000-06-15 17:00:00	NVDA	Stock	0.2708	0.2708	0.2707	0.2707	816000.0
2000-06-15 18:00:00	NVDA	Stock	0.2708	0.2708	0.2708	0.2708	144000.0
2000-06-15 08:00:00	AMZN	Stock	2.3875	2.3875	2.325	2.325	98000.0
2000-06-15 09:00:00	AMZN	Stock	2.325	2.35	2.2656	2.2812	12282000.0
2000-06-15 10:00:00	AMZN	Stock	2.2812	2.3062	2.275	2.2781	12804000.0
2000-06-15 11:00:00	AMZN	Stock	2.2781	2.3125	2.2719	2.3031	9620000.0
2000-06-15 12:00:00	AMZN	Stock	2.3	2.3375	2.2938	2.3281	9080000.0
2000-06-15 13:00:00	AMZN	Stock	2.3281	2.3875	2.325	2.3656	9546000.0
2000-06-15 14:00:00	AMZN	Stock	2.3672	2.3969	2.3313	2.3594	5016000.0
2000-06-15 15:00:00	AMZN	Stock	2.3594	2.3656	2.3	2.3188	9906000.0
2000-06-15 16:00:00	AMZN	Stock	2.3125	2.3438	2.3125	2.3156	1442000.0
2000-06-15 17:00:00	AMZN	Stock	2.3156	2.3438	2.3156	2.3406	160000.0
2000-06-15 18:00:00	AMZN	Stock	2.3125	2.3125	2.3062	2.3062	14000.0
2000-06-15 09:00:00	CL	Stock	28.6562	29.125	28.6562	29.0625	334800.0
2000-06-15 10:00:00	CL	Stock	29.125	29.125	28.9375	28.9688	625400.0
2000-06-15 11:00:00	CL	Stock	28.9688	29.3438	28.9688	29.1562	406800.0
2000-06-15 12:00:00	CL	Stock	29.125	29.2812	29.0625	29.2812	302400.0
2000-06-15 13:00:00	CL	Stock	29.2812	29.3438	29.1875	29.3125	211800.0
2000-06-15 14:00:00	CL	Stock	29.3125	29.4062	29.1875	29.25	455200.0
2000-06-15 15:00:00	CL	Stock	29.2188	29.3125	29.125	29.25	464000.0
2000-06-15 16:00:00	CL	Stock	29.2188	29.25	29.2188	29.25	179000.0

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

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