PREVIEW / stock_1hour / 2000-08-29

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-08-29.parquet
  size:    299 KB
  rows:    15,631
  symbols: 1,224

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-08-29 08:00:00	AAPL	Stock	1.0374	1.0424	1.0357	1.0357	1422400.0
2000-08-29 09:00:00	AAPL	Stock	1.0357	1.0558	1.0301	1.0525	32368000.0
2000-08-29 10:00:00	AAPL	Stock	1.0519	1.0592	1.0424	1.048	66903200.0
2000-08-29 11:00:00	AAPL	Stock	1.048	1.0491	1.0446	1.0446	38096800.0
2000-08-29 12:00:00	AAPL	Stock	1.0446	1.048	1.0446	1.0458	10175200.0
2000-08-29 13:00:00	AAPL	Stock	1.0458	1.0558	1.0458	1.0502	30402400.0
2000-08-29 14:00:00	AAPL	Stock	1.0491	1.0519	1.0469	1.0502	27126400.0
2000-08-29 15:00:00	AAPL	Stock	1.0491	1.0614	1.0491	1.0569	39810400.0
2000-08-29 16:00:00	AAPL	Stock	1.0558	1.067	1.0502	1.0569	19588800.0
2000-08-29 17:00:00	AAPL	Stock	1.0569	1.0569	1.0569	1.0569	173600.0
2000-08-29 08:00:00	MSFT	Stock	35.6562	35.75	35.5	35.625	102000.0
2000-08-29 09:00:00	MSFT	Stock	35.625	35.875	35.4375	35.8125	5493800.0
2000-08-29 10:00:00	MSFT	Stock	35.8438	36.0	35.7812	35.9688	12355400.0
2000-08-29 11:00:00	MSFT	Stock	35.9688	36.125	35.9062	36.0938	7466600.0
2000-08-29 12:00:00	MSFT	Stock	36.0625	36.375	36.0625	36.2812	9275000.0
2000-08-29 13:00:00	MSFT	Stock	36.2812	36.3125	35.9688	35.9688	6306000.0
2000-08-29 14:00:00	MSFT	Stock	35.9688	36.0312	35.875	35.9688	6680600.0
2000-08-29 15:00:00	MSFT	Stock	35.9688	36.0312	35.4375	35.4375	8948400.0
2000-08-29 16:00:00	MSFT	Stock	35.4375	35.8125	35.4375	35.4688	1732800.0
2000-08-29 17:00:00	MSFT	Stock	35.4688	35.625	35.4688	35.625	100600.0
2000-08-29 18:00:00	MSFT	Stock	35.5938	35.625	35.5625	35.625	4200.0
2000-08-29 08:00:00	NVDA	Stock	0.326	0.326	0.326	0.326	48000.0
2000-08-29 09:00:00	NVDA	Stock	0.326	0.3268	0.3219	0.3221	17976000.0
2000-08-29 10:00:00	NVDA	Stock	0.3247	0.3255	0.3208	0.3245	32592000.0
2000-08-29 11:00:00	NVDA	Stock	0.3232	0.3245	0.3224	0.3232	8448000.0
2000-08-29 12:00:00	NVDA	Stock	0.3227	0.3247	0.3221	0.3234	16056000.0
2000-08-29 13:00:00	NVDA	Stock	0.3234	0.3247	0.3232	0.3242	7968000.0
2000-08-29 14:00:00	NVDA	Stock	0.3237	0.3247	0.3227	0.3232	30624000.0
2000-08-29 15:00:00	NVDA	Stock	0.3232	0.3271	0.3229	0.3245	33648000.0
2000-08-29 16:00:00	NVDA	Stock	0.3245	0.3245	0.3242	0.3245	816000.0
2000-08-29 08:00:00	AMZN	Stock	1.9938	2.0125	1.9578	2.0	318000.0
2000-08-29 09:00:00	AMZN	Stock	1.9938	2.0	1.9438	1.9938	10724000.0
2000-08-29 10:00:00	AMZN	Stock	1.9938	2.0438	1.9531	1.9562	19390000.0
2000-08-29 11:00:00	AMZN	Stock	1.9625	1.9812	1.9531	1.975	7322000.0
2000-08-29 12:00:00	AMZN	Stock	1.9719	1.9938	1.9594	1.9844	6258000.0
2000-08-29 13:00:00	AMZN	Stock	1.9844	2.0281	1.9844	2.0031	23856000.0
2000-08-29 14:00:00	AMZN	Stock	2.0	2.0219	1.9906	1.9938	9104000.0
2000-08-29 15:00:00	AMZN	Stock	2.0	2.0062	1.9812	1.9812	10806000.0
2000-08-29 16:00:00	AMZN	Stock	1.9844	2.0062	1.9625	2.0031	1044000.0
2000-08-29 17:00:00	AMZN	Stock	2.0062	2.0156	2.0031	2.0125	154000.0
2000-08-29 18:00:00	AMZN	Stock	2.0156	2.025	2.0125	2.025	64000.0
2000-08-29 09:00:00	CL	Stock	26.25	26.25	26.0625	26.0938	110800.0
2000-08-29 10:00:00	CL	Stock	26.0938	26.3125	26.0625	26.125	246600.0
2000-08-29 11:00:00	CL	Stock	26.2188	26.2188	26.0	26.0	356200.0
2000-08-29 12:00:00	CL	Stock	25.9688	26.0	25.625	25.6875	445000.0
2000-08-29 13:00:00	CL	Stock	25.6875	25.9062	25.6875	25.7188	169600.0
2000-08-29 14:00:00	CL	Stock	25.75	25.875	25.6875	25.8438	225000.0
2000-08-29 15:00:00	CL	Stock	25.8125	26.0	25.7812	25.9062	513000.0
2000-08-29 16:00:00	CL	Stock	25.9062	25.9062	25.9062	25.9062	80600.0

> showing 49 of 15,631 rows — these rows as CSV

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