PREVIEW / stock_1hour / 2000-08-03

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-08-03.parquet
  size:    300 KB
  rows:    15,280
  symbols: 1,193

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-03 08:00:00	AAPL	Stock	0.8432	0.8432	0.808	0.8125	1024800.0
2000-08-03 09:00:00	AAPL	Stock	0.8058	0.8214	0.7902	0.8002	51676800.0
2000-08-03 10:00:00	AAPL	Stock	0.8013	0.8103	0.7991	0.8002	44956800.0
2000-08-03 11:00:00	AAPL	Stock	0.8013	0.8092	0.7991	0.8058	24589600.0
2000-08-03 12:00:00	AAPL	Stock	0.8058	0.8237	0.8047	0.8237	51105600.0
2000-08-03 13:00:00	AAPL	Stock	0.8237	0.8259	0.8103	0.8158	26756800.0
2000-08-03 14:00:00	AAPL	Stock	0.8158	0.8259	0.8103	0.817	37357600.0
2000-08-03 15:00:00	AAPL	Stock	0.817	0.8583	0.8158	0.856	69568800.0
2000-08-03 16:00:00	AAPL	Stock	0.8571	0.8661	0.817	0.8571	19958400.0
2000-08-03 17:00:00	AAPL	Stock	0.8594	0.8594	0.856	0.8571	67200.0
2000-08-03 08:00:00	MSFT	Stock	34.375	34.5	33.75	34.125	266000.0
2000-08-03 09:00:00	MSFT	Stock	34.0625	34.7031	34.0312	34.2344	6169400.0
2000-08-03 10:00:00	MSFT	Stock	34.2188	34.7188	34.125	34.4688	7904000.0
2000-08-03 11:00:00	MSFT	Stock	34.4688	34.5625	34.375	34.4375	3853400.0
2000-08-03 12:00:00	MSFT	Stock	34.4688	34.7188	34.375	34.6875	4301600.0
2000-08-03 13:00:00	MSFT	Stock	34.6875	34.9375	34.5312	34.5938	5266200.0
2000-08-03 14:00:00	MSFT	Stock	34.5938	35.0	34.5625	34.8125	6602600.0
2000-08-03 15:00:00	MSFT	Stock	34.8438	35.1875	34.6875	35.125	9682200.0
2000-08-03 16:00:00	MSFT	Stock	35.1562	35.1562	34.625	34.9062	8601200.0
2000-08-03 17:00:00	MSFT	Stock	35.125	35.1562	34.9375	34.9375	10200.0
2000-08-03 18:00:00	MSFT	Stock	35.0	35.0	34.9688	34.9688	1200.0
2000-08-03 09:00:00	NVDA	Stock	0.2375	0.2479	0.225	0.2458	55488000.0
2000-08-03 10:00:00	NVDA	Stock	0.2461	0.2531	0.2417	0.2492	45648000.0
2000-08-03 11:00:00	NVDA	Stock	0.249	0.2492	0.2461	0.2492	15000000.0
2000-08-03 12:00:00	NVDA	Stock	0.249	0.2594	0.2484	0.2589	39600000.0
2000-08-03 13:00:00	NVDA	Stock	0.2594	0.2625	0.2573	0.2594	59856000.0
2000-08-03 14:00:00	NVDA	Stock	0.2594	0.2667	0.2594	0.2602	28416000.0
2000-08-03 15:00:00	NVDA	Stock	0.2602	0.2667	0.2557	0.2609	87264000.0
2000-08-03 16:00:00	NVDA	Stock	0.2609	0.262	0.2552	0.2609	11616000.0
2000-08-03 18:00:00	NVDA	Stock	0.2604	0.2604	0.2604	0.2604	24000.0
2000-08-03 08:00:00	AMZN	Stock	1.525	1.5391	1.475	1.4813	254000.0
2000-08-03 09:00:00	AMZN	Stock	1.475	1.5219	1.4594	1.5125	19346000.0
2000-08-03 10:00:00	AMZN	Stock	1.5094	1.5594	1.4875	1.525	23050000.0
2000-08-03 11:00:00	AMZN	Stock	1.525	1.5375	1.5203	1.5344	8380000.0
2000-08-03 12:00:00	AMZN	Stock	1.5312	1.575	1.5312	1.5688	11588000.0
2000-08-03 13:00:00	AMZN	Stock	1.575	1.5781	1.5563	1.5594	9752000.0
2000-08-03 14:00:00	AMZN	Stock	1.5625	1.5656	1.5375	1.5469	6364000.0
2000-08-03 15:00:00	AMZN	Stock	1.5469	1.5875	1.5438	1.5781	16382000.0
2000-08-03 16:00:00	AMZN	Stock	1.5781	1.5875	1.5438	1.5625	1726000.0
2000-08-03 17:00:00	AMZN	Stock	1.575	1.575	1.575	1.575	46000.0
2000-08-03 18:00:00	AMZN	Stock	1.5703	1.6	1.5688	1.5688	8000.0
2000-08-03 09:00:00	CL	Stock	28.25	28.75	28.25	28.5938	181000.0
2000-08-03 10:00:00	CL	Stock	28.5938	28.625	28.3438	28.5625	643000.0
2000-08-03 11:00:00	CL	Stock	28.5	28.5625	28.2188	28.2812	304200.0
2000-08-03 12:00:00	CL	Stock	28.2812	28.375	28.0938	28.1562	165200.0
2000-08-03 13:00:00	CL	Stock	28.1875	28.375	28.125	28.2812	321200.0
2000-08-03 14:00:00	CL	Stock	28.3125	28.375	28.2188	28.3438	173800.0
2000-08-03 15:00:00	CL	Stock	28.375	28.375	28.0625	28.1562	440200.0
2000-08-03 16:00:00	CL	Stock	28.1562	28.1875	28.1562	28.1875	82400.0
2000-08-03 17:00:00	CL	Stock	28.1875	28.1875	28.1875	28.1875	48000.0

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

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