PREVIEW / stock_1hour / 2000-07-28

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-07-28.parquet
  size:    297 KB
  rows:    15,232
  symbols: 1,192

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-28 08:00:00	AAPL	Stock	0.928	0.9286	0.9275	0.9286	397600.0
2000-07-28 09:00:00	AAPL	Stock	0.9308	0.9375	0.9129	0.9241	14224000.0
2000-07-28 10:00:00	AAPL	Stock	0.9236	0.9241	0.8371	0.8371	50887200.0
2000-07-28 11:00:00	AAPL	Stock	0.8371	0.8783	0.8371	0.8739	49700000.0
2000-07-28 12:00:00	AAPL	Stock	0.875	0.8862	0.8728	0.8772	19796000.0
2000-07-28 13:00:00	AAPL	Stock	0.8772	0.8951	0.8739	0.8929	18345600.0
2000-07-28 14:00:00	AAPL	Stock	0.8929	0.8951	0.8739	0.8783	23312800.0
2000-07-28 15:00:00	AAPL	Stock	0.8783	0.885	0.8549	0.8627	43170400.0
2000-07-28 16:00:00	AAPL	Stock	0.8616	0.8761	0.8571	0.8661	10449600.0
2000-07-28 17:00:00	AAPL	Stock	0.8661	0.8705	0.8627	0.8705	72800.0
2000-07-28 08:00:00	MSFT	Stock	34.8125	35.5	34.6875	35.25	989600.0
2000-07-28 09:00:00	MSFT	Stock	35.2812	35.75	34.75	35.5312	16393400.0
2000-07-28 10:00:00	MSFT	Stock	35.5625	35.9062	34.9062	34.9375	17845200.0
2000-07-28 11:00:00	MSFT	Stock	34.9688	35.5	34.8438	35.1875	10482200.0
2000-07-28 12:00:00	MSFT	Stock	35.1562	35.3125	34.8438	35.125	5516000.0
2000-07-28 13:00:00	MSFT	Stock	35.1562	35.3438	35.0625	35.125	3370800.0
2000-07-28 14:00:00	MSFT	Stock	35.1406	35.1875	34.8125	35.0938	7222600.0
2000-07-28 15:00:00	MSFT	Stock	35.0938	35.2812	34.8125	34.8438	10228000.0
2000-07-28 16:00:00	MSFT	Stock	34.8125	35.1094	34.7656	34.9062	1819600.0
2000-07-28 17:00:00	MSFT	Stock	34.8281	35.125	34.8281	34.9375	14800.0
2000-07-28 18:00:00	MSFT	Stock	35.0625	35.125	35.0	35.125	12000.0
2000-07-28 08:00:00	NVDA	Stock	0.2204	0.2204	0.2204	0.2204	1200000.0
2000-07-28 09:00:00	NVDA	Stock	0.2198	0.2414	0.2177	0.2292	63216000.0
2000-07-28 10:00:00	NVDA	Stock	0.2292	0.2307	0.2083	0.2146	101448000.0
2000-07-28 11:00:00	NVDA	Stock	0.2147	0.226	0.2115	0.2229	84888000.0
2000-07-28 12:00:00	NVDA	Stock	0.2211	0.2289	0.2167	0.2234	43008000.0
2000-07-28 13:00:00	NVDA	Stock	0.224	0.2292	0.2219	0.2281	45432000.0
2000-07-28 14:00:00	NVDA	Stock	0.2273	0.2281	0.2125	0.2164	61344000.0
2000-07-28 15:00:00	NVDA	Stock	0.2161	0.2281	0.2156	0.2245	73032000.0
2000-07-28 16:00:00	NVDA	Stock	0.225	0.2289	0.2215	0.2286	3696000.0
2000-07-28 17:00:00	NVDA	Stock	0.2255	0.2255	0.2255	0.2255	24000.0
2000-07-28 08:00:00	AMZN	Stock	1.5719	1.6	1.55	1.5906	484000.0
2000-07-28 09:00:00	AMZN	Stock	1.5906	1.625	1.5625	1.5812	36310000.0
2000-07-28 10:00:00	AMZN	Stock	1.5812	1.5844	1.4688	1.4719	43422000.0
2000-07-28 11:00:00	AMZN	Stock	1.4688	1.5156	1.45	1.5	55182000.0
2000-07-28 12:00:00	AMZN	Stock	1.5031	1.5062	1.4688	1.5	21116000.0
2000-07-28 13:00:00	AMZN	Stock	1.5031	1.525	1.4969	1.5188	16344000.0
2000-07-28 14:00:00	AMZN	Stock	1.5188	1.5281	1.5031	1.5156	26110000.0
2000-07-28 15:00:00	AMZN	Stock	1.5188	1.5281	1.5	1.5	42658000.0
2000-07-28 16:00:00	AMZN	Stock	1.5031	1.5125	1.4969	1.5	2958000.0
2000-07-28 17:00:00	AMZN	Stock	1.5	1.5016	1.4938	1.5016	118000.0
2000-07-28 18:00:00	AMZN	Stock	1.5	1.525	1.5	1.525	52000.0
2000-07-28 09:00:00	CL	Stock	28.625	28.75	28.3438	28.5312	343400.0
2000-07-28 10:00:00	CL	Stock	28.5625	28.75	28.25	28.25	591000.0
2000-07-28 11:00:00	CL	Stock	28.1875	28.25	28.0625	28.1875	193400.0
2000-07-28 12:00:00	CL	Stock	28.1562	28.2188	28.0938	28.1875	150600.0
2000-07-28 13:00:00	CL	Stock	28.125	28.1875	28.0312	28.0625	275600.0
2000-07-28 14:00:00	CL	Stock	28.0938	28.0938	27.6562	27.7812	432200.0
2000-07-28 15:00:00	CL	Stock	27.8125	28.0	27.6875	27.9688	544400.0
2000-07-28 16:00:00	CL	Stock	27.9688	28.0	27.9688	28.0	80600.0

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

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