PREVIEW / stock_1hour / 2000-07-27

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-07-27.parquet
  size:    292 KB
  rows:    15,240
  symbols: 1,184

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-07-27 08:00:00	AAPL	Stock	0.894	0.894	0.8839	0.8839	252000.0
2000-07-27 09:00:00	AAPL	Stock	0.8862	0.9196	0.8862	0.9129	18816000.0
2000-07-27 10:00:00	AAPL	Stock	0.9152	0.9219	0.904	0.9163	49901600.0
2000-07-27 11:00:00	AAPL	Stock	0.9174	0.9196	0.9107	0.9152	29030400.0
2000-07-27 12:00:00	AAPL	Stock	0.9141	0.9219	0.9118	0.9174	37486400.0
2000-07-27 13:00:00	AAPL	Stock	0.9141	0.9174	0.9118	0.9141	24942400.0
2000-07-27 14:00:00	AAPL	Stock	0.9141	0.9152	0.9018	0.9063	49196000.0
2000-07-27 15:00:00	AAPL	Stock	0.9074	0.9509	0.904	0.9275	68947200.0
2000-07-27 16:00:00	AAPL	Stock	0.9286	0.9364	0.9202	0.9286	8192800.0
2000-07-27 17:00:00	AAPL	Stock	0.9286	0.9364	0.9219	0.9219	207200.0
2000-07-27 08:00:00	MSFT	Stock	33.8438	33.9688	33.6562	33.875	74800.0
2000-07-27 09:00:00	MSFT	Stock	33.9375	34.125	33.75	33.9688	9488400.0
2000-07-27 10:00:00	MSFT	Stock	33.9688	34.25	33.75	34.1562	8058400.0
2000-07-27 11:00:00	MSFT	Stock	34.125	34.4375	34.0625	34.2812	9140600.0
2000-07-27 12:00:00	MSFT	Stock	34.3125	34.4375	34.125	34.3125	11653800.0
2000-07-27 13:00:00	MSFT	Stock	34.3125	34.5938	34.1562	34.2812	6422000.0
2000-07-27 14:00:00	MSFT	Stock	34.2812	34.875	34.2812	34.8438	8404000.0
2000-07-27 15:00:00	MSFT	Stock	34.8438	35.0625	34.6562	34.7188	16568000.0
2000-07-27 16:00:00	MSFT	Stock	34.6875	34.8906	34.375	34.7812	2042400.0
2000-07-27 17:00:00	MSFT	Stock	34.6875	34.75	34.2812	34.6875	141800.0
2000-07-27 18:00:00	MSFT	Stock	34.6875	34.6875	34.625	34.6875	800.0
2000-07-27 08:00:00	NVDA	Stock	0.2333	0.2344	0.2333	0.2344	96000.0
2000-07-27 09:00:00	NVDA	Stock	0.2365	0.2365	0.2224	0.2234	71592000.0
2000-07-27 10:00:00	NVDA	Stock	0.224	0.225	0.2167	0.2219	73152000.0
2000-07-27 11:00:00	NVDA	Stock	0.2221	0.2292	0.2211	0.226	49128000.0
2000-07-27 12:00:00	NVDA	Stock	0.2255	0.2255	0.2214	0.2229	13824000.0
2000-07-27 13:00:00	NVDA	Stock	0.2229	0.2255	0.2211	0.2219	20544000.0
2000-07-27 14:00:00	NVDA	Stock	0.2219	0.224	0.2185	0.2195	32040000.0
2000-07-27 15:00:00	NVDA	Stock	0.2195	0.2292	0.2172	0.2219	54792000.0
2000-07-27 16:00:00	NVDA	Stock	0.2208	0.2221	0.2188	0.2198	2640000.0
2000-07-27 08:00:00	AMZN	Stock	1.6	1.6125	1.475	1.5531	6596000.0
2000-07-27 09:00:00	AMZN	Stock	1.5578	1.6	1.4813	1.5688	107640000.0
2000-07-27 10:00:00	AMZN	Stock	1.5688	1.575	1.5031	1.525	104064000.0
2000-07-27 11:00:00	AMZN	Stock	1.5219	1.55	1.5094	1.5188	51968000.0
2000-07-27 12:00:00	AMZN	Stock	1.5188	1.5625	1.5156	1.5406	60696000.0
2000-07-27 13:00:00	AMZN	Stock	1.5406	1.5563	1.5344	1.5531	36780000.0
2000-07-27 14:00:00	AMZN	Stock	1.55	1.5594	1.5375	1.5469	22598000.0
2000-07-27 15:00:00	AMZN	Stock	1.5469	1.5781	1.5469	1.5688	52678000.0
2000-07-27 16:00:00	AMZN	Stock	1.5719	1.5906	1.55	1.5688	4812000.0
2000-07-27 17:00:00	AMZN	Stock	1.5719	1.5766	1.5594	1.5766	164000.0
2000-07-27 18:00:00	AMZN	Stock	1.5688	1.5719	1.5594	1.5625	36000.0
2000-07-27 09:00:00	CL	Stock	27.9062	28.1875	27.9062	27.9375	178800.0
2000-07-27 10:00:00	CL	Stock	27.9062	28.125	27.5625	27.6562	286200.0
2000-07-27 11:00:00	CL	Stock	27.625	27.7188	27.375	27.5	447000.0
2000-07-27 12:00:00	CL	Stock	27.5	27.8438	27.5	27.75	245600.0
2000-07-27 13:00:00	CL	Stock	27.75	27.7812	27.6875	27.6875	91400.0
2000-07-27 14:00:00	CL	Stock	27.6875	28.0	27.6875	27.9375	142800.0
2000-07-27 15:00:00	CL	Stock	27.9375	28.3125	27.9062	28.2188	1111600.0
2000-07-27 16:00:00	CL	Stock	28.1875	28.1875	28.1875	28.1875	44800.0
2000-07-27 17:00:00	CL	Stock	28.1875	28.1875	28.1875	28.1875	10000.0

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

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