PREVIEW / stock_1hour / 2000-05-30

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-05-30.parquet
  size:    287 KB
  rows:    14,942
  symbols: 1,164

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-05-30 08:00:00	AAPL	Stock	0.779	0.7857	0.779	0.7801	156800.0
2000-05-30 09:00:00	AAPL	Stock	0.7852	0.7868	0.7623	0.7623	84392000.0
2000-05-30 10:00:00	AAPL	Stock	0.7623	0.7645	0.7299	0.7388	167596800.0
2000-05-30 11:00:00	AAPL	Stock	0.7394	0.7478	0.7372	0.745	81256000.0
2000-05-30 12:00:00	AAPL	Stock	0.745	0.7556	0.7394	0.75	57937600.0
2000-05-30 13:00:00	AAPL	Stock	0.7489	0.7522	0.7461	0.7478	37654400.0
2000-05-30 14:00:00	AAPL	Stock	0.7483	0.7511	0.7366	0.7478	81580800.0
2000-05-30 15:00:00	AAPL	Stock	0.7489	0.7857	0.7455	0.7818	136987200.0
2000-05-30 16:00:00	AAPL	Stock	0.7824	0.7857	0.7539	0.7818	58273600.0
2000-05-30 17:00:00	AAPL	Stock	0.7818	0.7818	0.779	0.7813	2508800.0
2000-05-30 18:00:00	AAPL	Stock	0.779	0.7857	0.779	0.7857	123200.0
2000-05-30 08:00:00	MSFT	Stock	31.25	31.4062	31.0	31.1875	40800.0
2000-05-30 09:00:00	MSFT	Stock	31.125	31.4375	31.0312	31.3438	8821600.0
2000-05-30 10:00:00	MSFT	Stock	31.3438	31.75	31.1562	31.75	10702000.0
2000-05-30 11:00:00	MSFT	Stock	31.75	31.8125	31.375	31.4375	5586000.0
2000-05-30 12:00:00	MSFT	Stock	31.4062	31.6875	31.4062	31.4062	5340400.0
2000-05-30 13:00:00	MSFT	Stock	31.4688	31.625	31.4062	31.5	4433200.0
2000-05-30 14:00:00	MSFT	Stock	31.5	32.0	31.4688	31.6875	12230400.0
2000-05-30 15:00:00	MSFT	Stock	31.6875	32.0625	31.5312	31.6875	17685200.0
2000-05-30 16:00:00	MSFT	Stock	31.7188	31.9375	31.5625	31.625	2520800.0
2000-05-30 17:00:00	MSFT	Stock	31.625	31.75	31.625	31.7188	202000.0
2000-05-30 18:00:00	MSFT	Stock	31.75	31.75	31.75	31.75	3800.0
2000-05-30 09:00:00	NVDA	Stock	0.2253	0.2333	0.2234	0.2293	43200000.0
2000-05-30 10:00:00	NVDA	Stock	0.2292	0.2318	0.226	0.2293	42288000.0
2000-05-30 11:00:00	NVDA	Stock	0.2293	0.2297	0.2272	0.2292	20064000.0
2000-05-30 12:00:00	NVDA	Stock	0.2297	0.2297	0.2276	0.229	14112000.0
2000-05-30 13:00:00	NVDA	Stock	0.2292	0.2292	0.2273	0.2273	14064000.0
2000-05-30 14:00:00	NVDA	Stock	0.2275	0.2346	0.2271	0.2323	53616000.0
2000-05-30 15:00:00	NVDA	Stock	0.2344	0.2346	0.2281	0.2286	109344000.0
2000-05-30 16:00:00	NVDA	Stock	0.2286	0.2302	0.2286	0.2302	1296000.0
2000-05-30 18:00:00	NVDA	Stock	0.2302	0.2302	0.2302	0.2302	288000.0
2000-05-30 08:00:00	AMZN	Stock	2.35	2.35	2.3375	2.35	28000.0
2000-05-30 09:00:00	AMZN	Stock	2.3406	2.4563	2.3375	2.4125	10740000.0
2000-05-30 10:00:00	AMZN	Stock	2.4062	2.4969	2.3844	2.4969	14054000.0
2000-05-30 11:00:00	AMZN	Stock	2.4969	2.4969	2.4563	2.4781	9192000.0
2000-05-30 12:00:00	AMZN	Stock	2.4781	2.5062	2.475	2.4875	9076000.0
2000-05-30 13:00:00	AMZN	Stock	2.4906	2.5031	2.4563	2.4563	7370000.0
2000-05-30 14:00:00	AMZN	Stock	2.4563	2.5078	2.4375	2.5	16946000.0
2000-05-30 15:00:00	AMZN	Stock	2.5	2.5938	2.4969	2.5844	41594000.0
2000-05-30 16:00:00	AMZN	Stock	2.5844	2.5938	2.425	2.5875	1958000.0
2000-05-30 17:00:00	AMZN	Stock	2.5719	2.5719	2.5719	2.5719	6000.0
2000-05-30 18:00:00	AMZN	Stock	2.5594	2.5594	2.5594	2.5594	4000.0
2000-05-30 09:00:00	CL	Stock	28.0625	28.125	27.6562	27.8125	223400.0
2000-05-30 10:00:00	CL	Stock	27.75	27.75	27.125	27.25	372800.0
2000-05-30 11:00:00	CL	Stock	27.25	27.3438	27.0625	27.3438	332400.0
2000-05-30 12:00:00	CL	Stock	27.3438	27.3438	27.0938	27.0938	219000.0
2000-05-30 13:00:00	CL	Stock	27.0938	27.1562	27.0312	27.0312	399000.0
2000-05-30 14:00:00	CL	Stock	27.0938	27.1875	26.9062	27.0	385600.0
2000-05-30 15:00:00	CL	Stock	27.0	27.125	26.9688	27.0312	664400.0
2000-05-30 16:00:00	CL	Stock	27.0625	27.0625	27.0312	27.0625	57400.0

> showing 50 of 14,942 rows — these rows as CSV

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