PREVIEW / stock_1hour / 2006-05-17

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-05-17.parquet
  size:    624 KB
  rows:    29,479
  symbols: 2,275

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
2006-05-17 07:00:00	AAPL	Stock	2.3232	2.3232	2.3232	2.3232	2800.0
2006-05-17 08:00:00	AAPL	Stock	2.3268	2.3279	2.3107	2.3179	2302104.0
2006-05-17 09:00:00	AAPL	Stock	2.3157	2.3371	2.2982	2.3171	128682512.0
2006-05-17 10:00:00	AAPL	Stock	2.3171	2.3221	2.3043	2.3118	107424212.0
2006-05-17 11:00:00	AAPL	Stock	2.3118	2.3196	2.2882	2.3041	103049380.0
2006-05-17 12:00:00	AAPL	Stock	2.3043	2.325	2.3036	2.325	97351688.0
2006-05-17 13:00:00	AAPL	Stock	2.325	2.3293	2.3071	2.315	70012180.0
2006-05-17 14:00:00	AAPL	Stock	2.3146	2.3211	2.3036	2.3096	69617492.0
2006-05-17 15:00:00	AAPL	Stock	2.3096	2.3464	2.3093	2.3293	151982824.0
2006-05-17 16:00:00	AAPL	Stock	2.3314	2.3346	2.3286	2.3336	1750588.0
2006-05-17 17:00:00	AAPL	Stock	2.3336	2.3375	2.3307	2.3343	14039592.0
2006-05-17 18:00:00	AAPL	Stock	2.3357	2.3368	2.3339	2.3357	156660.0
2006-05-17 04:00:00	MSFT	Stock	23.1	23.1	23.1	23.1	220.0
2006-05-17 05:00:00	MSFT	Stock	23.03	23.03	23.03	23.03	150.0
2006-05-17 07:00:00	MSFT	Stock	23.05	23.05	23.03	23.03	400.0
2006-05-17 08:00:00	MSFT	Stock	23.04	23.06	22.93	22.93	420256.0
2006-05-17 09:00:00	MSFT	Stock	22.95	23.01	22.88	22.91	10401211.0
2006-05-17 10:00:00	MSFT	Stock	22.91	22.97	22.88	22.97	11244662.0
2006-05-17 11:00:00	MSFT	Stock	22.962	23.04	22.82	23.02	16308273.0
2006-05-17 12:00:00	MSFT	Stock	23.01	23.08	22.85	22.89	12323231.0
2006-05-17 13:00:00	MSFT	Stock	22.89	22.97	22.849	22.91	10430302.0
2006-05-17 14:00:00	MSFT	Stock	22.91	22.93	22.81	22.86	11780021.0
2006-05-17 15:00:00	MSFT	Stock	22.85	22.89	22.73	22.73	18974171.0
2006-05-17 16:00:00	MSFT	Stock	22.74	22.85	22.64	22.73	1888388.0
2006-05-17 17:00:00	MSFT	Stock	22.75	22.8	22.73	22.73	459698.0
2006-05-17 18:00:00	MSFT	Stock	22.74	22.74	22.73	22.74	4626.0
2006-05-17 08:00:00	NVDA	Stock	0.434	0.434	0.4308	0.4308	156000.0
2006-05-17 09:00:00	NVDA	Stock	0.4298	0.4345	0.425	0.431	75494700.0
2006-05-17 10:00:00	NVDA	Stock	0.431	0.4317	0.4208	0.4237	106009800.0
2006-05-17 11:00:00	NVDA	Stock	0.4237	0.4245	0.413	0.4165	131632080.0
2006-05-17 12:00:00	NVDA	Stock	0.4167	0.4215	0.4152	0.4208	113057940.0
2006-05-17 13:00:00	NVDA	Stock	0.421	0.4228	0.4148	0.4173	73724520.0
2006-05-17 14:00:00	NVDA	Stock	0.4173	0.4182	0.4083	0.411	101232900.0
2006-05-17 15:00:00	NVDA	Stock	0.411	0.417	0.4107	0.4157	175405740.0
2006-05-17 16:00:00	NVDA	Stock	0.416	0.4175	0.4157	0.4167	1726320.0
2006-05-17 17:00:00	NVDA	Stock	0.4167	0.4172	0.416	0.416	14514000.0
2006-05-17 18:00:00	NVDA	Stock	0.4155	0.4172	0.4155	0.4172	143880.0
2006-05-17 09:00:00	AMZN	Stock	1.623	1.635	1.613	1.6185	8306240.0
2006-05-17 10:00:00	AMZN	Stock	1.618	1.6185	1.5935	1.603	16052000.0
2006-05-17 11:00:00	AMZN	Stock	1.6026	1.615	1.582	1.606	17030560.0
2006-05-17 12:00:00	AMZN	Stock	1.606	1.616	1.589	1.59	10032280.0
2006-05-17 13:00:00	AMZN	Stock	1.5895	1.5945	1.585	1.5895	15628100.0
2006-05-17 14:00:00	AMZN	Stock	1.59	1.5945	1.579	1.58	20649980.0
2006-05-17 15:00:00	AMZN	Stock	1.58	1.593	1.5765	1.581	35833440.0
2006-05-17 16:00:00	AMZN	Stock	1.58	1.5815	1.5755	1.5805	5621580.0
2006-05-17 18:00:00	AMZN	Stock	1.5805	1.5805	1.5805	1.5805	2538000.0
2006-05-17 09:00:00	CL	Stock	30.3	30.85	30.275	30.85	1486200.0
2006-05-17 10:00:00	CL	Stock	30.85	31.055	30.75	30.91	2476600.0
2006-05-17 11:00:00	CL	Stock	30.92	30.985	30.805	30.985	3298200.0
2006-05-17 12:00:00	CL	Stock	30.975	30.99	30.85	30.875	1746400.0

> showing 50 of 29,479 rows — these rows as CSV

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