PREVIEW / stock_1hour / 2000-08-11

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-08-11.parquet
  size:    294 KB
  rows:    15,247
  symbols: 1,201

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-08-11 08:00:00	AAPL	Stock	0.851	0.8527	0.8482	0.8527	397600.0
2000-08-11 09:00:00	AAPL	Stock	0.8438	0.8449	0.8237	0.827	36400000.0
2000-08-11 10:00:00	AAPL	Stock	0.8281	0.8281	0.8136	0.8186	66852800.0
2000-08-11 11:00:00	AAPL	Stock	0.8192	0.8337	0.8158	0.827	33303200.0
2000-08-11 12:00:00	AAPL	Stock	0.8281	0.8415	0.827	0.8371	26482400.0
2000-08-11 13:00:00	AAPL	Stock	0.8371	0.8449	0.8326	0.8426	18132800.0
2000-08-11 14:00:00	AAPL	Stock	0.8426	0.8482	0.8371	0.8471	25513600.0
2000-08-11 15:00:00	AAPL	Stock	0.8471	0.8571	0.8421	0.8504	26846400.0
2000-08-11 16:00:00	AAPL	Stock	0.8516	0.8516	0.8371	0.8516	3824800.0
2000-08-11 18:00:00	AAPL	Stock	0.8393	0.8527	0.8393	0.8527	33600.0
2000-08-11 08:00:00	MSFT	Stock	36.2969	36.375	36.0	36.0938	80200.0
2000-08-11 09:00:00	MSFT	Stock	36.0938	36.3125	35.9375	35.9688	6465800.0
2000-08-11 10:00:00	MSFT	Stock	35.9688	36.0312	35.8125	36.0	6862800.0
2000-08-11 11:00:00	MSFT	Stock	35.9375	36.25	35.9375	36.1875	6191200.0
2000-08-11 12:00:00	MSFT	Stock	36.1562	36.25	36.1562	36.1875	4169000.0
2000-08-11 13:00:00	MSFT	Stock	36.1875	36.3438	36.1875	36.2188	2547000.0
2000-08-11 14:00:00	MSFT	Stock	36.25	36.2812	36.0625	36.125	2696200.0
2000-08-11 15:00:00	MSFT	Stock	36.1562	36.3438	36.0625	36.1875	4104800.0
2000-08-11 16:00:00	MSFT	Stock	36.2188	36.3125	36.0625	36.25	2145800.0
2000-08-11 17:00:00	MSFT	Stock	36.0625	36.125	36.0625	36.0625	600.0
2000-08-11 09:00:00	NVDA	Stock	0.2781	0.2781	0.2557	0.2599	28608000.0
2000-08-11 10:00:00	NVDA	Stock	0.2609	0.2638	0.2591	0.2604	22584000.0
2000-08-11 11:00:00	NVDA	Stock	0.2615	0.2714	0.2612	0.2646	19320000.0
2000-08-11 12:00:00	NVDA	Stock	0.2659	0.2688	0.2656	0.2672	9144000.0
2000-08-11 13:00:00	NVDA	Stock	0.2677	0.2677	0.2641	0.2641	8424000.0
2000-08-11 14:00:00	NVDA	Stock	0.2641	0.2656	0.2641	0.2641	5088000.0
2000-08-11 15:00:00	NVDA	Stock	0.2641	0.2695	0.2583	0.2677	30240000.0
2000-08-11 16:00:00	NVDA	Stock	0.2682	0.2688	0.2677	0.2685	5976000.0
2000-08-11 17:00:00	NVDA	Stock	0.2677	0.2677	0.2677	0.2677	24000.0
2000-08-11 08:00:00	AMZN	Stock	1.5156	1.6	1.5	1.5062	80000.0
2000-08-11 09:00:00	AMZN	Stock	1.525	1.5625	1.5	1.55	16720000.0
2000-08-11 10:00:00	AMZN	Stock	1.55	1.5625	1.5375	1.5469	11374000.0
2000-08-11 11:00:00	AMZN	Stock	1.5469	1.5812	1.5438	1.5812	18550000.0
2000-08-11 12:00:00	AMZN	Stock	1.5812	1.6094	1.575	1.6031	30986000.0
2000-08-11 13:00:00	AMZN	Stock	1.6031	1.6547	1.5969	1.6281	22702000.0
2000-08-11 14:00:00	AMZN	Stock	1.6281	1.6812	1.625	1.6469	29126000.0
2000-08-11 15:00:00	AMZN	Stock	1.6469	1.7	1.6375	1.6812	37776000.0
2000-08-11 16:00:00	AMZN	Stock	1.6812	1.6844	1.6125	1.675	14494000.0
2000-08-11 17:00:00	AMZN	Stock	1.675	1.6812	1.675	1.6812	116000.0
2000-08-11 18:00:00	AMZN	Stock	1.675	1.6844	1.675	1.6844	104000.0
2000-08-11 09:00:00	CL	Stock	27.1875	27.2188	26.9375	27.0938	393600.0
2000-08-11 10:00:00	CL	Stock	27.0625	27.0938	26.625	26.6875	338000.0
2000-08-11 11:00:00	CL	Stock	26.6562	26.7188	26.2812	26.5625	356000.0
2000-08-11 12:00:00	CL	Stock	26.5938	26.625	26.375	26.5	286600.0
2000-08-11 13:00:00	CL	Stock	26.5625	26.7812	26.5	26.7188	163400.0
2000-08-11 14:00:00	CL	Stock	26.75	26.875	26.6562	26.7812	155200.0
2000-08-11 15:00:00	CL	Stock	26.8438	26.9688	26.7188	26.7812	533000.0
2000-08-11 16:00:00	CL	Stock	26.7812	26.7812	26.6875	26.6875	36800.0

> showing 48 of 15,247 rows — these rows as CSV

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