PREVIEW / stock_1hour / 2005-11-18

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-11-18.parquet
  size:    602 KB
  rows:    28,451
  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-11-18 07:00:00	AAPL	Stock	2.3139	2.3139	2.3139	2.3139	8400.0
2005-11-18 08:00:00	AAPL	Stock	2.3211	2.3279	2.3136	2.3236	2374316.0
2005-11-18 09:00:00	AAPL	Stock	2.3236	2.3368	2.315	2.3211	114364460.0
2005-11-18 10:00:00	AAPL	Stock	2.3221	2.3293	2.3018	2.3064	102487644.0
2005-11-18 11:00:00	AAPL	Stock	2.3064	2.3157	2.2989	2.3125	57792112.0
2005-11-18 12:00:00	AAPL	Stock	2.3125	2.3225	2.3068	2.3179	50156316.0
2005-11-18 13:00:00	AAPL	Stock	2.3179	2.3264	2.3143	2.3232	38821160.0
2005-11-18 14:00:00	AAPL	Stock	2.3229	2.3246	2.3082	2.3114	46846660.0
2005-11-18 15:00:00	AAPL	Stock	2.3118	2.3157	2.3	2.3107	85089676.0
2005-11-18 16:00:00	AAPL	Stock	2.3057	2.3143	2.3057	2.3071	7676928.0
2005-11-18 17:00:00	AAPL	Stock	2.3064	2.3082	2.3036	2.3082	457688.0
2005-11-18 18:00:00	AAPL	Stock	2.3071	2.3107	2.3061	2.3107	162400.0
2005-11-18 07:00:00	MSFT	Stock	28.04	28.09	28.03	28.04	4650.0
2005-11-18 08:00:00	MSFT	Stock	27.97	28.1	27.97	28.09	352093.0
2005-11-18 09:00:00	MSFT	Stock	28.09	28.25	27.97	28.02	22462405.0
2005-11-18 10:00:00	MSFT	Stock	28.02	28.07	27.94	27.95	12074901.0
2005-11-18 11:00:00	MSFT	Stock	27.96	28.01	27.9	27.98	9138405.0
2005-11-18 12:00:00	MSFT	Stock	27.98	28.01	27.93	27.97	5386015.0
2005-11-18 13:00:00	MSFT	Stock	27.97	28.01	27.95	27.998	4951850.0
2005-11-18 14:00:00	MSFT	Stock	28.0	28.05	27.97	27.97	5696146.0
2005-11-18 15:00:00	MSFT	Stock	27.98	28.14	27.97	28.05	12474630.0
2005-11-18 16:00:00	MSFT	Stock	28.06	28.07	28.0	28.02	173657.0
2005-11-18 17:00:00	MSFT	Stock	28.02	28.07	27.98	28.05	581839.0
2005-11-18 18:00:00	MSFT	Stock	28.05	28.07	28.01	28.01	7384.0
2005-11-18 08:00:00	NVDA	Stock	0.3038	0.3046	0.3038	0.3046	338400.0
2005-11-18 09:00:00	NVDA	Stock	0.3038	0.3057	0.3008	0.3052	93486360.0
2005-11-18 10:00:00	NVDA	Stock	0.3052	0.3057	0.2957	0.2962	134971560.0
2005-11-18 11:00:00	NVDA	Stock	0.2962	0.2995	0.2961	0.2982	39991680.0
2005-11-18 12:00:00	NVDA	Stock	0.2979	0.2985	0.2975	0.2983	29020080.0
2005-11-18 13:00:00	NVDA	Stock	0.2983	0.3012	0.2983	0.3004	39536040.0
2005-11-18 14:00:00	NVDA	Stock	0.3003	0.3017	0.2999	0.3015	38255520.0
2005-11-18 15:00:00	NVDA	Stock	0.3016	0.3017	0.3004	0.3016	68454600.0
2005-11-18 16:00:00	NVDA	Stock	0.3014	0.3015	0.3006	0.3014	1170000.0
2005-11-18 17:00:00	NVDA	Stock	0.3008	0.3014	0.2952	0.3014	96000.0
2005-11-18 18:00:00	NVDA	Stock	0.3014	0.3014	0.3014	0.3014	180000.0
2005-11-18 07:00:00	AMZN	Stock	2.35	2.35	2.345	2.345	8000.0
2005-11-18 08:00:00	AMZN	Stock	2.344	2.3475	2.3175	2.3325	682520.0
2005-11-18 09:00:00	AMZN	Stock	2.3345	2.3745	2.33	2.3715	52200800.0
2005-11-18 10:00:00	AMZN	Stock	2.3716	2.387	2.3535	2.3555	67614780.0
2005-11-18 11:00:00	AMZN	Stock	2.355	2.3705	2.3467	2.3565	32992600.0
2005-11-18 12:00:00	AMZN	Stock	2.3565	2.368	2.355	2.363	20169240.0
2005-11-18 13:00:00	AMZN	Stock	2.363	2.3685	2.354	2.368	18930460.0
2005-11-18 14:00:00	AMZN	Stock	2.368	2.379	2.365	2.3735	39932020.0
2005-11-18 15:00:00	AMZN	Stock	2.3735	2.4	2.3505	2.3945	300689940.0
2005-11-18 16:00:00	AMZN	Stock	2.394	2.3965	2.3725	2.375	141097000.0
2005-11-18 17:00:00	AMZN	Stock	2.375	2.395	2.338	2.375	6928560.0
2005-11-18 18:00:00	AMZN	Stock	2.376	2.3775	2.373	2.3735	298500.0
2005-11-18 09:00:00	CL	Stock	27.295	27.295	26.91	26.945	884000.0
2005-11-18 10:00:00	CL	Stock	26.94	26.955	26.8	26.82	707000.0
2005-11-18 11:00:00	CL	Stock	26.81	26.83	26.735	26.815	531400.0

> showing 50 of 28,451 rows — these rows as CSV

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