PREVIEW / stock_1hour / 2001-05-17

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-05-17.parquet
  size:    370 KB
  rows:    17,540
  symbols: 1,297

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
2001-05-17 08:00:00	AAPL	Stock	0.4357	0.4357	0.4291	0.433	212800.0
2001-05-17 09:00:00	AAPL	Stock	0.433	0.4345	0.4305	0.4323	43612800.0
2001-05-17 10:00:00	AAPL	Stock	0.4321	0.4334	0.4152	0.4209	66197600.0
2001-05-17 11:00:00	AAPL	Stock	0.4209	0.4225	0.4188	0.4213	34960800.0
2001-05-17 12:00:00	AAPL	Stock	0.4214	0.4254	0.4209	0.4248	33902400.0
2001-05-17 13:00:00	AAPL	Stock	0.4248	0.4286	0.4214	0.4216	36467200.0
2001-05-17 14:00:00	AAPL	Stock	0.4216	0.4241	0.4173	0.4173	41126400.0
2001-05-17 15:00:00	AAPL	Stock	0.4179	0.4211	0.417	0.4202	42537600.0
2001-05-17 16:00:00	AAPL	Stock	0.4205	0.433	0.4152	0.4161	15019200.0
2001-05-17 17:00:00	AAPL	Stock	0.4161	0.4161	0.4161	0.4161	67200.0
2001-05-17 08:00:00	MSFT	Stock	34.755	34.935	34.5	34.55	73000.0
2001-05-17 09:00:00	MSFT	Stock	34.5	34.955	34.05	34.945	10290000.0
2001-05-17 10:00:00	MSFT	Stock	34.95	35.07	34.615	34.79	19212600.0
2001-05-17 11:00:00	MSFT	Stock	34.79	34.845	34.605	34.65	14222400.0
2001-05-17 12:00:00	MSFT	Stock	34.655	34.74	34.61	34.685	8357800.0
2001-05-17 13:00:00	MSFT	Stock	34.69	34.875	34.605	34.615	9533200.0
2001-05-17 14:00:00	MSFT	Stock	34.615	34.655	33.84	33.87	16109400.0
2001-05-17 15:00:00	MSFT	Stock	33.87	34.125	33.775	34.08	16409000.0
2001-05-17 16:00:00	MSFT	Stock	34.08	34.93	33.95	33.95	6665400.0
2001-05-17 17:00:00	MSFT	Stock	33.885	34.0	33.605	33.605	30200.0
2001-05-17 18:00:00	MSFT	Stock	33.755	33.755	33.5	33.5	2200.0
2001-05-17 08:00:00	NVDA	Stock	0.3625	0.3625	0.3551	0.3563	1920000.0
2001-05-17 09:00:00	NVDA	Stock	0.3575	0.3621	0.3519	0.3612	105048000.0
2001-05-17 10:00:00	NVDA	Stock	0.3613	0.3646	0.3519	0.3535	194688000.0
2001-05-17 11:00:00	NVDA	Stock	0.3536	0.364	0.3531	0.3625	118944000.0
2001-05-17 12:00:00	NVDA	Stock	0.3625	0.3681	0.3623	0.3674	85800000.0
2001-05-17 13:00:00	NVDA	Stock	0.3675	0.3729	0.3671	0.3685	123912000.0
2001-05-17 14:00:00	NVDA	Stock	0.3688	0.3704	0.362	0.3635	133128000.0
2001-05-17 15:00:00	NVDA	Stock	0.3635	0.365	0.3575	0.3635	120048000.0
2001-05-17 16:00:00	NVDA	Stock	0.3635	0.3635	0.3608	0.3608	6336000.0
2001-05-17 17:00:00	NVDA	Stock	0.3625	0.3625	0.3583	0.3583	1512000.0
2001-05-17 18:00:00	NVDA	Stock	0.3583	0.3588	0.3573	0.3573	432000.0
2001-05-17 08:00:00	AMZN	Stock	0.7105	0.7105	0.7065	0.7065	14000.0
2001-05-17 09:00:00	AMZN	Stock	0.7035	0.7175	0.7	0.7175	13804000.0
2001-05-17 10:00:00	AMZN	Stock	0.7175	0.727	0.7145	0.7225	25648000.0
2001-05-17 11:00:00	AMZN	Stock	0.7225	0.7425	0.721	0.7375	13468000.0
2001-05-17 12:00:00	AMZN	Stock	0.737	0.75	0.736	0.745	15762000.0
2001-05-17 13:00:00	AMZN	Stock	0.745	0.75	0.7315	0.7425	16006000.0
2001-05-17 14:00:00	AMZN	Stock	0.7425	0.7475	0.7325	0.739	14314000.0
2001-05-17 15:00:00	AMZN	Stock	0.7385	0.743	0.734	0.739	17850000.0
2001-05-17 16:00:00	AMZN	Stock	0.739	0.75	0.7085	0.737	10890000.0
2001-05-17 17:00:00	AMZN	Stock	0.739	0.74	0.739	0.739	26000.0
2001-05-17 09:00:00	CL	Stock	29.425	29.53	29.3	29.325	338400.0
2001-05-17 10:00:00	CL	Stock	29.325	29.4	28.9	29.035	476400.0
2001-05-17 11:00:00	CL	Stock	29.035	29.145	28.865	29.125	412600.0
2001-05-17 12:00:00	CL	Stock	29.13	29.145	28.92	29.035	276800.0
2001-05-17 13:00:00	CL	Stock	29.03	29.1	28.795	28.81	305600.0
2001-05-17 14:00:00	CL	Stock	28.815	29.0	28.805	28.97	347400.0
2001-05-17 15:00:00	CL	Stock	28.97	29.2	28.935	29.05	501600.0
2001-05-17 16:00:00	CL	Stock	29.05	29.05	29.025	29.025	65200.0

> showing 50 of 17,540 rows — these rows as CSV

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