PREVIEW / stock_1hour / 2000-08-07

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-08-07.parquet
  size:    300 KB
  rows:    15,563
  symbols: 1,210

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-07 08:00:00	AAPL	Stock	0.8454	0.8504	0.8454	0.8493	369600.0
2000-08-07 09:00:00	AAPL	Stock	0.8527	0.8594	0.8438	0.8438	26370400.0
2000-08-07 10:00:00	AAPL	Stock	0.8438	0.8616	0.8426	0.8527	39194400.0
2000-08-07 11:00:00	AAPL	Stock	0.8532	0.8761	0.8516	0.8683	26695200.0
2000-08-07 12:00:00	AAPL	Stock	0.8705	0.8705	0.8571	0.8661	12320000.0
2000-08-07 13:00:00	AAPL	Stock	0.8661	0.8672	0.8616	0.8661	9872800.0
2000-08-07 14:00:00	AAPL	Stock	0.8661	0.8672	0.8549	0.8594	26140800.0
2000-08-07 15:00:00	AAPL	Stock	0.8594	0.8638	0.8538	0.856	37867200.0
2000-08-07 16:00:00	AAPL	Stock	0.856	0.8594	0.8527	0.856	7644000.0
2000-08-07 08:00:00	MSFT	Stock	34.5	34.7188	34.4062	34.7188	193414.0
2000-08-07 09:00:00	MSFT	Stock	34.625	35.75	34.625	34.9688	10384200.0
2000-08-07 10:00:00	MSFT	Stock	35.0312	35.25	34.875	35.1562	6766400.0
2000-08-07 11:00:00	MSFT	Stock	35.1719	35.5625	35.125	35.4375	7044600.0
2000-08-07 12:00:00	MSFT	Stock	35.4375	35.4688	35.0625	35.3125	9129600.0
2000-08-07 13:00:00	MSFT	Stock	35.375	35.5	35.25	35.25	4458400.0
2000-08-07 14:00:00	MSFT	Stock	35.25	35.3438	35.0312	35.125	6272000.0
2000-08-07 15:00:00	MSFT	Stock	35.125	35.3438	34.9688	35.0156	6614600.0
2000-08-07 16:00:00	MSFT	Stock	35.0312	35.2188	34.9844	35.0	1070800.0
2000-08-07 17:00:00	MSFT	Stock	35.0	35.0625	34.875	35.0625	6400.0
2000-08-07 18:00:00	MSFT	Stock	35.0312	35.0625	35.0312	35.0625	4800.0
2000-08-07 09:00:00	NVDA	Stock	0.2688	0.2693	0.2664	0.2669	26664000.0
2000-08-07 10:00:00	NVDA	Stock	0.2669	0.2779	0.2669	0.2729	58512000.0
2000-08-07 11:00:00	NVDA	Stock	0.2755	0.2797	0.2734	0.2789	29424000.0
2000-08-07 12:00:00	NVDA	Stock	0.2781	0.2828	0.2776	0.2797	20328000.0
2000-08-07 13:00:00	NVDA	Stock	0.2816	0.282	0.2781	0.282	19368000.0
2000-08-07 14:00:00	NVDA	Stock	0.2813	0.2875	0.2807	0.2831	43032000.0
2000-08-07 15:00:00	NVDA	Stock	0.2831	0.2888	0.2815	0.2865	42288000.0
2000-08-07 16:00:00	NVDA	Stock	0.2865	0.2875	0.2844	0.2865	4440000.0
2000-08-07 17:00:00	NVDA	Stock	0.2875	0.2875	0.2854	0.2854	72000.0
2000-08-07 08:00:00	AMZN	Stock	1.5875	1.6156	1.5016	1.575	106000.0
2000-08-07 09:00:00	AMZN	Stock	1.575	1.675	1.5719	1.65	18842000.0
2000-08-07 10:00:00	AMZN	Stock	1.6469	1.675	1.6312	1.65	19122000.0
2000-08-07 11:00:00	AMZN	Stock	1.6531	1.6625	1.6375	1.6531	7534000.0
2000-08-07 12:00:00	AMZN	Stock	1.6562	1.6875	1.65	1.675	14870000.0
2000-08-07 13:00:00	AMZN	Stock	1.6719	1.6938	1.6656	1.6781	5206000.0
2000-08-07 14:00:00	AMZN	Stock	1.6781	1.6844	1.6594	1.6656	5094000.0
2000-08-07 15:00:00	AMZN	Stock	1.6688	1.7125	1.6656	1.6938	15306000.0
2000-08-07 16:00:00	AMZN	Stock	1.6906	1.7125	1.6688	1.6875	1388000.0
2000-08-07 17:00:00	AMZN	Stock	1.675	1.675	1.6719	1.6719	24000.0
2000-08-07 09:00:00	CL	Stock	27.625	27.9688	27.5938	27.625	463600.0
2000-08-07 10:00:00	CL	Stock	27.625	27.625	27.375	27.5938	603000.0
2000-08-07 11:00:00	CL	Stock	27.5938	27.5938	27.25	27.25	302000.0
2000-08-07 12:00:00	CL	Stock	27.25	27.25	26.5312	26.6875	574200.0
2000-08-07 13:00:00	CL	Stock	26.7188	26.9062	26.375	26.5625	718200.0
2000-08-07 14:00:00	CL	Stock	26.5625	26.6875	26.3125	26.6875	585800.0
2000-08-07 15:00:00	CL	Stock	26.6875	26.8438	26.5	26.75	864200.0
2000-08-07 16:00:00	CL	Stock	26.75	26.7812	26.75	26.7812	126000.0
2000-08-07 17:00:00	CL	Stock	26.7812	26.7812	26.7812	26.7812	8000.0

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

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