PREVIEW / stock_1hour / 2005-10-31

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-10-31.parquet
  size:    582 KB
  rows:    27,382
  symbols: 2,116

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
2005-10-31 07:00:00	AAPL	Stock	1.9571	1.9571	1.9571	1.9571	2800.0
2005-10-31 08:00:00	AAPL	Stock	1.9518	1.9796	1.9518	1.9786	3374084.0
2005-10-31 09:00:00	AAPL	Stock	1.9786	1.9839	1.9554	1.975	96552484.0
2005-10-31 10:00:00	AAPL	Stock	1.975	2.0125	1.9718	2.0039	151392640.0
2005-10-31 11:00:00	AAPL	Stock	2.0043	2.0339	1.9899	2.0286	104049652.0
2005-10-31 12:00:00	AAPL	Stock	2.0289	2.0532	2.025	2.0489	144134788.0
2005-10-31 13:00:00	AAPL	Stock	2.0493	2.0611	2.0379	2.0436	129796548.0
2005-10-31 14:00:00	AAPL	Stock	2.0443	2.0568	2.0386	2.0561	94437168.0
2005-10-31 15:00:00	AAPL	Stock	2.0561	2.0707	2.0521	2.0564	181993868.0
2005-10-31 16:00:00	AAPL	Stock	2.0568	2.0639	2.0271	2.0375	17737860.0
2005-10-31 17:00:00	AAPL	Stock	2.0375	2.0568	2.0311	2.0318	1957116.0
2005-10-31 18:00:00	AAPL	Stock	2.0339	2.0357	2.0311	2.0321	248472.0
2005-10-31 08:00:00	MSFT	Stock	25.62	25.64	25.59	25.6	85659.0
2005-10-31 09:00:00	MSFT	Stock	25.61	25.78	25.559	25.74	12222602.0
2005-10-31 10:00:00	MSFT	Stock	25.737	25.79	25.67	25.7	10587946.0
2005-10-31 11:00:00	MSFT	Stock	25.7	25.74	25.64	25.66	7415109.0
2005-10-31 12:00:00	MSFT	Stock	25.66	25.73	25.6	25.71	5650134.0
2005-10-31 13:00:00	MSFT	Stock	25.71	25.72	25.5	25.58	9209164.0
2005-10-31 14:00:00	MSFT	Stock	25.58	25.71	25.57	25.66	9071879.0
2005-10-31 15:00:00	MSFT	Stock	25.66	25.8	25.64	25.69	14463925.0
2005-10-31 16:00:00	MSFT	Stock	25.67	25.73	25.5	25.56	1915606.0
2005-10-31 17:00:00	MSFT	Stock	25.56	25.7	25.52	25.6	324576.0
2005-10-31 18:00:00	MSFT	Stock	25.59	25.59	25.56	25.57	6450.0
2005-10-31 09:00:00	NVDA	Stock	0.2712	0.2742	0.2708	0.2733	38974560.0
2005-10-31 10:00:00	NVDA	Stock	0.2735	0.2766	0.2733	0.2753	80475000.0
2005-10-31 11:00:00	NVDA	Stock	0.2752	0.2767	0.275	0.2757	38465040.0
2005-10-31 12:00:00	NVDA	Stock	0.2757	0.2772	0.275	0.2772	36396360.0
2005-10-31 13:00:00	NVDA	Stock	0.2772	0.2783	0.2757	0.2772	48961680.0
2005-10-31 14:00:00	NVDA	Stock	0.2772	0.2802	0.2772	0.2796	50183160.0
2005-10-31 15:00:00	NVDA	Stock	0.2796	0.2815	0.2787	0.2796	109365720.0
2005-10-31 16:00:00	NVDA	Stock	0.2793	0.2796	0.2782	0.2783	2948760.0
2005-10-31 17:00:00	NVDA	Stock	0.2775	0.2796	0.2775	0.2783	990240.0
2005-10-31 18:00:00	NVDA	Stock	0.2786	0.2786	0.2779	0.2779	60000.0
2005-10-31 09:00:00	AMZN	Stock	1.963	2.011	1.956	1.998	30079220.0
2005-10-31 10:00:00	AMZN	Stock	1.9975	2.0195	1.993	2.0135	23127920.0
2005-10-31 11:00:00	AMZN	Stock	2.013	2.0145	2.0035	2.006	12669500.0
2005-10-31 12:00:00	AMZN	Stock	2.006	2.008	1.998	2.0035	9595640.0
2005-10-31 13:00:00	AMZN	Stock	2.0035	2.01	2.0025	2.0035	10639680.0
2005-10-31 14:00:00	AMZN	Stock	2.0035	2.0051	1.996	1.999	15592880.0
2005-10-31 15:00:00	AMZN	Stock	1.999	2.0045	1.9925	1.994	25182620.0
2005-10-31 16:00:00	AMZN	Stock	1.993	2.0015	1.983	1.9875	5778020.0
2005-10-31 17:00:00	AMZN	Stock	1.99	1.99	1.99	1.99	106000.0
2005-10-31 18:00:00	AMZN	Stock	1.9905	1.9905	1.99	1.99	17000.0
2005-10-31 09:00:00	CL	Stock	26.6	26.7	26.575	26.665	619200.0
2005-10-31 10:00:00	CL	Stock	26.665	26.69	26.485	26.59	932400.0
2005-10-31 11:00:00	CL	Stock	26.575	26.66	26.465	26.5	991000.0
2005-10-31 12:00:00	CL	Stock	26.495	26.51	26.34	26.445	828400.0
2005-10-31 13:00:00	CL	Stock	26.445	26.53	26.4	26.445	966600.0
2005-10-31 14:00:00	CL	Stock	26.445	26.515	26.375	26.495	557400.0
2005-10-31 15:00:00	CL	Stock	26.495	26.61	26.425	26.475	1256800.0

> showing 50 of 27,382 rows — these rows as CSV

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