PREVIEW / stock_1hour / 2000-11-09

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-11-09.parquet
  size:    307 KB
  rows:    15,659
  symbols: 1,238

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-11-09 08:00:00	AAPL	Stock	0.3577	0.3577	0.3516	0.3527	1041600.0
2000-11-09 09:00:00	AAPL	Stock	0.3527	0.356	0.3404	0.3527	56162400.0
2000-11-09 10:00:00	AAPL	Stock	0.3527	0.3661	0.3493	0.356	58564800.0
2000-11-09 11:00:00	AAPL	Stock	0.3566	0.3605	0.3527	0.3594	33717600.0
2000-11-09 12:00:00	AAPL	Stock	0.3616	0.3627	0.3549	0.356	29887200.0
2000-11-09 13:00:00	AAPL	Stock	0.3571	0.3583	0.3404	0.3471	102580800.0
2000-11-09 14:00:00	AAPL	Stock	0.3482	0.3538	0.3449	0.3516	62456800.0
2000-11-09 15:00:00	AAPL	Stock	0.3493	0.3627	0.3482	0.3605	79990400.0
2000-11-09 16:00:00	AAPL	Stock	0.3616	0.3638	0.3527	0.3583	4782400.0
2000-11-09 17:00:00	AAPL	Stock	0.3594	0.3616	0.3571	0.3571	179200.0
2000-11-09 18:00:00	AAPL	Stock	0.3583	0.3583	0.3527	0.3527	117600.0
2000-11-09 08:00:00	MSFT	Stock	34.75	34.75	33.6875	33.8438	330600.0
2000-11-09 09:00:00	MSFT	Stock	33.8438	35.0	33.625	34.9062	11840400.0
2000-11-09 10:00:00	MSFT	Stock	34.9062	35.4375	34.6875	34.9375	12939600.0
2000-11-09 11:00:00	MSFT	Stock	34.9375	35.25	34.7188	35.25	5811800.0
2000-11-09 12:00:00	MSFT	Stock	35.2188	35.3125	34.9375	35.1875	7294800.0
2000-11-09 13:00:00	MSFT	Stock	35.2188	35.3438	34.4375	34.7188	13895800.0
2000-11-09 14:00:00	MSFT	Stock	34.7188	35.5625	34.625	35.3125	13358800.0
2000-11-09 15:00:00	MSFT	Stock	35.3125	35.6562	35.0	35.4375	14607400.0
2000-11-09 16:00:00	MSFT	Stock	35.4531	35.5625	35.0156	35.5	1692600.0
2000-11-09 17:00:00	MSFT	Stock	35.5	35.5625	35.1875	35.2812	236800.0
2000-11-09 18:00:00	MSFT	Stock	35.2812	35.3125	35.0	35.0312	25600.0
2000-11-09 08:00:00	NVDA	Stock	0.2892	0.2892	0.2892	0.2892	1272000.0
2000-11-09 09:00:00	NVDA	Stock	0.2865	0.2865	0.2682	0.2729	63096000.0
2000-11-09 10:00:00	NVDA	Stock	0.2728	0.2831	0.2703	0.2734	50664000.0
2000-11-09 11:00:00	NVDA	Stock	0.2734	0.275	0.2651	0.2656	48312000.0
2000-11-09 12:00:00	NVDA	Stock	0.2656	0.2672	0.2578	0.2591	50496000.0
2000-11-09 13:00:00	NVDA	Stock	0.2604	0.2656	0.2469	0.252	99336000.0
2000-11-09 14:00:00	NVDA	Stock	0.2521	0.2661	0.2513	0.2625	86736000.0
2000-11-09 15:00:00	NVDA	Stock	0.2638	0.2688	0.2578	0.2591	103704000.0
2000-11-09 16:00:00	NVDA	Stock	0.2591	0.2771	0.2578	0.2746	19104000.0
2000-11-09 17:00:00	NVDA	Stock	0.2729	0.2792	0.271	0.2786	456000.0
2000-11-09 18:00:00	NVDA	Stock	0.275	0.275	0.2719	0.275	168000.0
2000-11-09 08:00:00	AMZN	Stock	1.6875	1.6938	1.6375	1.6625	416000.0
2000-11-09 09:00:00	AMZN	Stock	1.6375	1.6438	1.5438	1.6406	26778000.0
2000-11-09 10:00:00	AMZN	Stock	1.6438	1.65	1.6	1.6	12534000.0
2000-11-09 11:00:00	AMZN	Stock	1.6	1.6125	1.5688	1.6031	9000000.0
2000-11-09 12:00:00	AMZN	Stock	1.6031	1.6031	1.5281	1.5406	12012000.0
2000-11-09 13:00:00	AMZN	Stock	1.5406	1.5594	1.4938	1.5594	22720000.0
2000-11-09 14:00:00	AMZN	Stock	1.5594	1.6219	1.5312	1.5906	21548000.0
2000-11-09 15:00:00	AMZN	Stock	1.5875	1.6031	1.55	1.5594	22220000.0
2000-11-09 16:00:00	AMZN	Stock	1.5625	1.5875	1.5563	1.5875	2388000.0
2000-11-09 17:00:00	AMZN	Stock	1.5812	1.5812	1.5688	1.5688	38000.0
2000-11-09 18:00:00	AMZN	Stock	1.5688	1.5688	1.5688	1.5688	2000.0
2000-11-09 09:00:00	CL	Stock	29.4	29.935	29.4	29.93	374200.0
2000-11-09 10:00:00	CL	Stock	29.95	30.3	29.93	30.195	844000.0
2000-11-09 11:00:00	CL	Stock	30.205	30.235	29.95	30.165	420400.0
2000-11-09 12:00:00	CL	Stock	30.16	30.255	29.48	29.77	560200.0
2000-11-09 13:00:00	CL	Stock	29.74	29.74	29.115	29.16	574000.0
2000-11-09 14:00:00	CL	Stock	29.165	29.62	29.025	29.595	616000.0

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

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