PREVIEW / stock_1hour / 2000-06-26

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-06-26.parquet
  size:    297 KB
  rows:    15,277
  symbols: 1,189

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-26 08:00:00	AAPL	Stock	0.9224	0.9224	0.9224	0.9224	380800.0
2000-06-26 09:00:00	AAPL	Stock	0.9263	0.971	0.9263	0.9688	46076800.0
2000-06-26 10:00:00	AAPL	Stock	0.9693	0.9777	0.9487	0.9632	39592000.0
2000-06-26 11:00:00	AAPL	Stock	0.9637	0.9665	0.9576	0.9576	24136000.0
2000-06-26 12:00:00	AAPL	Stock	0.9576	0.9587	0.9353	0.9425	21722400.0
2000-06-26 13:00:00	AAPL	Stock	0.9431	0.9509	0.933	0.9386	10494400.0
2000-06-26 14:00:00	AAPL	Stock	0.9397	0.9643	0.9375	0.9621	16312800.0
2000-06-26 15:00:00	AAPL	Stock	0.9621	0.971	0.9464	0.971	19068000.0
2000-06-26 16:00:00	AAPL	Stock	0.9688	0.981	0.9364	0.9665	5269600.0
2000-06-26 17:00:00	AAPL	Stock	0.9732	0.9732	0.9732	0.9732	16800.0
2000-06-26 08:00:00	MSFT	Stock	38.75	38.8594	38.625	38.625	71200.0
2000-06-26 09:00:00	MSFT	Stock	38.625	39.4375	38.625	39.3438	7239000.0
2000-06-26 10:00:00	MSFT	Stock	39.375	40.0625	39.1562	39.8438	10184400.0
2000-06-26 11:00:00	MSFT	Stock	39.8438	40.0	39.5	39.5312	5564200.0
2000-06-26 12:00:00	MSFT	Stock	39.5312	39.7188	39.4062	39.625	4861200.0
2000-06-26 13:00:00	MSFT	Stock	39.625	39.7188	39.4375	39.625	3640800.0
2000-06-26 14:00:00	MSFT	Stock	39.625	39.9688	39.5312	39.8125	4906800.0
2000-06-26 15:00:00	MSFT	Stock	39.8125	40.0625	39.6875	39.75	8651800.0
2000-06-26 16:00:00	MSFT	Stock	39.7812	40.0	38.7656	39.75	2294200.0
2000-06-26 17:00:00	MSFT	Stock	39.6875	39.8438	39.6875	39.7812	5800.0
2000-06-26 18:00:00	MSFT	Stock	39.8438	39.9375	39.8438	39.8438	3200.0
2000-06-26 08:00:00	NVDA	Stock	0.3125	0.3126	0.3125	0.3125	288000.0
2000-06-26 09:00:00	NVDA	Stock	0.3115	0.3249	0.3096	0.3229	107568000.0
2000-06-26 10:00:00	NVDA	Stock	0.3204	0.3332	0.3167	0.328	96384000.0
2000-06-26 11:00:00	NVDA	Stock	0.3286	0.3322	0.323	0.325	46944000.0
2000-06-26 12:00:00	NVDA	Stock	0.3247	0.3263	0.3187	0.3234	65328000.0
2000-06-26 13:00:00	NVDA	Stock	0.3237	0.3286	0.3221	0.326	52560000.0
2000-06-26 14:00:00	NVDA	Stock	0.3255	0.3375	0.3237	0.3372	76704000.0
2000-06-26 15:00:00	NVDA	Stock	0.3365	0.3477	0.3286	0.3457	140832000.0
2000-06-26 16:00:00	NVDA	Stock	0.3457	0.3458	0.3441	0.3457	10272000.0
2000-06-26 17:00:00	NVDA	Stock	0.3448	0.3469	0.3448	0.346	528000.0
2000-06-26 18:00:00	NVDA	Stock	0.346	0.346	0.346	0.346	144000.0
2000-06-26 08:00:00	AMZN	Stock	1.7688	1.775	1.6953	1.7438	3578000.0
2000-06-26 09:00:00	AMZN	Stock	1.7406	1.775	1.6406	1.6406	110594000.0
2000-06-26 10:00:00	AMZN	Stock	1.6406	1.7016	1.6406	1.675	72990000.0
2000-06-26 11:00:00	AMZN	Stock	1.6781	1.7125	1.675	1.6969	65432000.0
2000-06-26 12:00:00	AMZN	Stock	1.6969	1.7188	1.6906	1.7031	33752000.0
2000-06-26 13:00:00	AMZN	Stock	1.7031	1.7062	1.6875	1.6906	28906000.0
2000-06-26 14:00:00	AMZN	Stock	1.6906	1.6938	1.675	1.6781	40214000.0
2000-06-26 15:00:00	AMZN	Stock	1.6781	1.7125	1.675	1.7	48262000.0
2000-06-26 16:00:00	AMZN	Stock	1.6984	1.7656	1.6906	1.6969	3482000.0
2000-06-26 17:00:00	AMZN	Stock	1.7	1.7	1.6938	1.7	78000.0
2000-06-26 18:00:00	AMZN	Stock	1.6969	1.7	1.6938	1.7	1010000.0
2000-06-26 09:00:00	CL	Stock	27.8125	28.0625	27.7812	28.0312	239800.0
2000-06-26 10:00:00	CL	Stock	28.0312	28.375	28.0312	28.25	399800.0
2000-06-26 11:00:00	CL	Stock	28.25	28.3125	28.0938	28.25	288200.0
2000-06-26 12:00:00	CL	Stock	28.2812	28.4375	28.125	28.1875	383200.0
2000-06-26 13:00:00	CL	Stock	28.1875	28.25	28.125	28.1875	210600.0
2000-06-26 14:00:00	CL	Stock	28.1562	28.2188	28.0625	28.0938	408400.0
2000-06-26 15:00:00	CL	Stock	28.0625	28.3125	28.0625	28.2188	484600.0

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

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