PREVIEW / stock_1hour / 2005-11-21

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-11-21.parquet
  size:    571 KB
  rows:    27,142
  symbols: 2,126

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-11-21 07:00:00	AAPL	Stock	2.3093	2.3111	2.3093	2.3111	5600.0
2005-11-21 08:00:00	AAPL	Stock	2.3143	2.325	2.3143	2.3189	1246084.0
2005-11-21 09:00:00	AAPL	Stock	2.3186	2.3189	2.29	2.2936	83417992.0
2005-11-21 10:00:00	AAPL	Stock	2.2939	2.2979	2.2771	2.2914	114666440.0
2005-11-21 11:00:00	AAPL	Stock	2.2914	2.2921	2.2757	2.2871	58704464.0
2005-11-21 12:00:00	AAPL	Stock	2.2871	2.3071	2.2845	2.3043	55171172.0
2005-11-21 13:00:00	AAPL	Stock	2.3043	2.3279	2.3	2.3225	62801340.0
2005-11-21 14:00:00	AAPL	Stock	2.3229	2.3236	2.3096	2.3175	40288668.0
2005-11-21 15:00:00	AAPL	Stock	2.3175	2.3282	2.3071	2.3179	86993676.0
2005-11-21 16:00:00	AAPL	Stock	2.32	2.32	2.2826	2.3186	2090032.0
2005-11-21 17:00:00	AAPL	Stock	2.3182	2.3189	2.3179	2.3179	95900.0
2005-11-21 18:00:00	AAPL	Stock	2.3189	2.3193	2.3182	2.3182	11900.0
2005-11-21 06:00:00	MSFT	Stock	28.0	28.0	28.0	28.0	100.0
2005-11-21 07:00:00	MSFT	Stock	28.08	28.1	28.08	28.1	1100.0
2005-11-21 08:00:00	MSFT	Stock	28.1	28.24	28.07	28.1	115451.0
2005-11-21 09:00:00	MSFT	Stock	28.1	28.135	27.85	27.87	8637114.0
2005-11-21 10:00:00	MSFT	Stock	27.87	28.07	27.84	27.95	8008994.0
2005-11-21 11:00:00	MSFT	Stock	27.95	28.07	27.922	28.06	8537013.0
2005-11-21 12:00:00	MSFT	Stock	28.06	28.08	27.5	28.02	4561472.0
2005-11-21 13:00:00	MSFT	Stock	28.01	28.08	27.93	28.05	5331649.0
2005-11-21 14:00:00	MSFT	Stock	28.05	28.18	28.0	28.09	10863707.0
2005-11-21 15:00:00	MSFT	Stock	28.091	28.24	28.0	28.16	14348542.0
2005-11-21 16:00:00	MSFT	Stock	28.17	28.23	28.026	28.2	835623.0
2005-11-21 17:00:00	MSFT	Stock	28.16	28.21	28.1	28.18	337623.0
2005-11-21 18:00:00	MSFT	Stock	28.19	28.2	28.16	28.17	370496.0
2005-11-21 09:00:00	NVDA	Stock	0.3017	0.3029	0.2999	0.3005	41222160.0
2005-11-21 10:00:00	NVDA	Stock	0.3003	0.3063	0.3003	0.3041	98151360.0
2005-11-21 11:00:00	NVDA	Stock	0.3041	0.3061	0.3026	0.3054	68476080.0
2005-11-21 12:00:00	NVDA	Stock	0.3052	0.3056	0.3036	0.3042	21824760.0
2005-11-21 13:00:00	NVDA	Stock	0.3042	0.3062	0.3032	0.3055	52484400.0
2005-11-21 14:00:00	NVDA	Stock	0.3055	0.3062	0.3047	0.3054	49709520.0
2005-11-21 15:00:00	NVDA	Stock	0.3053	0.3074	0.3046	0.3069	107850360.0
2005-11-21 16:00:00	NVDA	Stock	0.3069	0.307	0.3069	0.307	1692000.0
2005-11-21 17:00:00	NVDA	Stock	0.3072	0.3072	0.3072	0.3072	180000.0
2005-11-21 18:00:00	NVDA	Stock	0.3079	0.3079	0.3079	0.3079	60000.0
2005-11-21 07:00:00	AMZN	Stock	2.37	2.3785	2.37	2.3775	214800.0
2005-11-21 08:00:00	AMZN	Stock	2.375	2.3825	2.375	2.3775	1964500.0
2005-11-21 09:00:00	AMZN	Stock	2.378	2.3875	2.364	2.3795	92518240.0
2005-11-21 10:00:00	AMZN	Stock	2.3795	2.4025	2.379	2.4015	79754660.0
2005-11-21 11:00:00	AMZN	Stock	2.4015	2.4015	2.3805	2.3825	48428540.0
2005-11-21 12:00:00	AMZN	Stock	2.382	2.3965	2.3815	2.395	26211200.0
2005-11-21 13:00:00	AMZN	Stock	2.3965	2.3965	2.3875	2.389	18674020.0
2005-11-21 14:00:00	AMZN	Stock	2.3895	2.3995	2.387	2.397	23601820.0
2005-11-21 15:00:00	AMZN	Stock	2.3965	2.4155	2.396	2.398	58111160.0
2005-11-21 16:00:00	AMZN	Stock	2.398	2.4023	2.3858	2.3985	1858320.0
2005-11-21 17:00:00	AMZN	Stock	2.3985	2.3985	2.3975	2.3985	28000.0
2005-11-21 18:00:00	AMZN	Stock	2.3975	2.4	2.388	2.395	631900.0
2005-11-21 09:00:00	CL	Stock	26.975	27.065	26.9	27.035	284000.0
2005-11-21 10:00:00	CL	Stock	27.04	27.19	27.04	27.145	367000.0
2005-11-21 11:00:00	CL	Stock	27.145	27.2	27.065	27.085	422000.0

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

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