PREVIEW / stock_1hour / 2000-07-12

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-07-12.parquet
  size:    304 KB
  rows:    15,505
  symbols: 1,197

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-12 08:00:00	AAPL	Stock	1.0268	1.0357	1.0167	1.0335	571200.0
2000-07-12 09:00:00	AAPL	Stock	1.0324	1.0391	1.0112	1.0296	28761600.0
2000-07-12 10:00:00	AAPL	Stock	1.029	1.0435	1.0134	1.0156	32754400.0
2000-07-12 11:00:00	AAPL	Stock	1.0156	1.0313	1.0145	1.0167	30055200.0
2000-07-12 12:00:00	AAPL	Stock	1.019	1.0268	1.0067	1.0246	35509600.0
2000-07-12 13:00:00	AAPL	Stock	1.0246	1.0346	1.0223	1.0313	13602400.0
2000-07-12 14:00:00	AAPL	Stock	1.0324	1.0469	1.0257	1.0424	30648800.0
2000-07-12 15:00:00	AAPL	Stock	1.0413	1.0525	1.0357	1.0502	38119200.0
2000-07-12 16:00:00	AAPL	Stock	1.0502	1.0513	1.0357	1.0357	7520800.0
2000-07-12 17:00:00	AAPL	Stock	1.0357	1.0357	1.0357	1.0357	5600.0
2000-07-12 08:00:00	MSFT	Stock	39.8125	40.0625	39.125	39.4688	157000.0
2000-07-12 09:00:00	MSFT	Stock	39.4375	39.5625	38.5938	38.625	8811200.0
2000-07-12 10:00:00	MSFT	Stock	38.625	39.125	38.5938	39.0625	11546200.0
2000-07-12 11:00:00	MSFT	Stock	39.0781	39.8125	39.0625	39.7188	8453200.0
2000-07-12 12:00:00	MSFT	Stock	39.7188	39.9688	39.6562	39.9062	5090000.0
2000-07-12 13:00:00	MSFT	Stock	39.9375	40.125	39.7812	40.0625	4559200.0
2000-07-12 14:00:00	MSFT	Stock	40.0938	40.5	39.875	40.25	9222800.0
2000-07-12 15:00:00	MSFT	Stock	40.25	40.3125	40.0625	40.1875	8362000.0
2000-07-12 16:00:00	MSFT	Stock	40.1562	40.2656	39.6094	40.1562	1641000.0
2000-07-12 17:00:00	MSFT	Stock	40.1562	40.1719	38.7812	39.9688	23200.0
2000-07-12 18:00:00	MSFT	Stock	39.9688	40.0625	39.8125	39.8125	10200.0
2000-07-12 08:00:00	NVDA	Stock	0.2751	0.2839	0.2751	0.2839	1440000.0
2000-07-12 09:00:00	NVDA	Stock	0.2844	0.2896	0.2779	0.2813	70152000.0
2000-07-12 10:00:00	NVDA	Stock	0.281	0.287	0.2794	0.2844	66216000.0
2000-07-12 11:00:00	NVDA	Stock	0.2836	0.2977	0.2836	0.2893	81936000.0
2000-07-12 12:00:00	NVDA	Stock	0.2893	0.2917	0.2833	0.2901	36168000.0
2000-07-12 13:00:00	NVDA	Stock	0.2901	0.2951	0.2875	0.288	43560000.0
2000-07-12 14:00:00	NVDA	Stock	0.2875	0.2914	0.2867	0.287	30480000.0
2000-07-12 15:00:00	NVDA	Stock	0.287	0.288	0.2813	0.2833	51072000.0
2000-07-12 16:00:00	NVDA	Stock	0.2833	0.2854	0.2833	0.2854	3384000.0
2000-07-12 18:00:00	NVDA	Stock	0.2836	0.2836	0.2836	0.2836	48000.0
2000-07-12 08:00:00	AMZN	Stock	1.775	1.7875	1.7312	1.7562	756000.0
2000-07-12 09:00:00	AMZN	Stock	1.75	1.775	1.7125	1.7312	33300000.0
2000-07-12 10:00:00	AMZN	Stock	1.7375	1.7844	1.7312	1.7812	37302000.0
2000-07-12 11:00:00	AMZN	Stock	1.7812	1.8062	1.7688	1.7781	26992000.0
2000-07-12 12:00:00	AMZN	Stock	1.7781	1.8	1.7594	1.775	16860000.0
2000-07-12 13:00:00	AMZN	Stock	1.775	1.7875	1.75	1.7844	22642000.0
2000-07-12 14:00:00	AMZN	Stock	1.7844	1.7906	1.775	1.7844	40378000.0
2000-07-12 15:00:00	AMZN	Stock	1.7844	1.7938	1.7438	1.75	36206000.0
2000-07-12 16:00:00	AMZN	Stock	1.75	1.7625	1.725	1.7531	7386000.0
2000-07-12 17:00:00	AMZN	Stock	1.7562	1.7594	1.7375	1.75	72000.0
2000-07-12 18:00:00	AMZN	Stock	1.7438	1.75	1.7438	1.75	10000.0
2000-07-12 09:00:00	CL	Stock	27.3125	27.3125	26.4688	26.5	1014800.0
2000-07-12 10:00:00	CL	Stock	26.5	26.8125	26.5	26.5312	943600.0
2000-07-12 11:00:00	CL	Stock	26.5625	26.7812	26.375	26.4688	1149800.0
2000-07-12 12:00:00	CL	Stock	26.4375	26.5312	26.4062	26.5312	475400.0
2000-07-12 13:00:00	CL	Stock	26.5312	26.5625	26.375	26.4688	504400.0
2000-07-12 14:00:00	CL	Stock	26.4375	26.75	26.3438	26.5312	1242600.0
2000-07-12 15:00:00	CL	Stock	26.5312	26.5938	26.4375	26.5625	1435000.0
2000-07-12 16:00:00	CL	Stock	26.5312	26.5312	26.5	26.5	237200.0

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

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