PREVIEW / stock_1hour / 2006-01-12

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-01-12.parquet
  size:    582 KB
  rows:    27,436
  symbols: 2,160

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-01-12 04:00:00	AAPL	Stock	3.0143	3.0286	3.0143	3.0286	8400.0
2006-01-12 05:00:00	AAPL	Stock	3.0268	3.0357	3.0268	3.0357	168000.0
2006-01-12 06:00:00	AAPL	Stock	3.0375	3.0625	3.0375	3.0446	218400.0
2006-01-12 07:00:00	AAPL	Stock	3.0379	3.0446	3.0232	3.0321	1256052.0
2006-01-12 08:00:00	AAPL	Stock	3.0339	3.0607	3.0275	3.0304	23283904.0
2006-01-12 09:00:00	AAPL	Stock	3.0307	3.0496	3.0125	3.0496	196439740.0
2006-01-12 10:00:00	AAPL	Stock	3.0493	3.0804	3.0425	3.0729	233678424.0
2006-01-12 11:00:00	AAPL	Stock	3.0725	3.08	3.0586	3.0732	130540928.0
2006-01-12 12:00:00	AAPL	Stock	3.0732	3.0857	3.0511	3.06	120056944.0
2006-01-12 13:00:00	AAPL	Stock	3.0604	3.0604	3.0179	3.0239	155190644.0
2006-01-12 14:00:00	AAPL	Stock	3.0243	3.0429	2.9864	3.0089	237033300.0
2006-01-12 15:00:00	AAPL	Stock	3.0094	3.0268	2.9986	3.0132	166221076.0
2006-01-12 16:00:00	AAPL	Stock	3.0129	3.0143	3.0071	3.0089	4642316.0
2006-01-12 17:00:00	AAPL	Stock	3.0089	3.0129	3.0007	3.0118	1070888.0
2006-01-12 18:00:00	AAPL	Stock	3.0136	3.0161	3.0096	3.0129	414736.0
2006-01-12 04:00:00	MSFT	Stock	27.22	27.22	27.22	27.22	100.0
2006-01-12 07:00:00	MSFT	Stock	27.05	27.24	27.05	27.24	6200.0
2006-01-12 08:00:00	MSFT	Stock	27.14	27.25	27.14	27.2	26304.0
2006-01-12 09:00:00	MSFT	Stock	27.2	27.28	27.09	27.15	5650561.0
2006-01-12 10:00:00	MSFT	Stock	27.15	27.2	27.08	27.14	5744069.0
2006-01-12 11:00:00	MSFT	Stock	27.16	27.16	27.01	27.06	5820569.0
2006-01-12 12:00:00	MSFT	Stock	27.06	27.15	27.0	27.018	5421951.0
2006-01-12 13:00:00	MSFT	Stock	27.01	27.07	26.97	27.002	5195167.0
2006-01-12 14:00:00	MSFT	Stock	27.0	27.05	26.97	27.02	6126067.0
2006-01-12 15:00:00	MSFT	Stock	27.01	27.14	26.98	27.14	9285624.0
2006-01-12 16:00:00	MSFT	Stock	27.14	27.16	27.1	27.1	358724.0
2006-01-12 17:00:00	MSFT	Stock	27.09	27.14	27.09	27.1	6496.0
2006-01-12 09:00:00	NVDA	Stock	0.3621	0.3677	0.3589	0.367	57672240.0
2006-01-12 10:00:00	NVDA	Stock	0.3672	0.3681	0.3617	0.3652	93950400.0
2006-01-12 11:00:00	NVDA	Stock	0.3651	0.3662	0.3634	0.3648	61004880.0
2006-01-12 12:00:00	NVDA	Stock	0.3648	0.3659	0.3642	0.3652	26504760.0
2006-01-12 13:00:00	NVDA	Stock	0.3652	0.3654	0.3601	0.361	58267560.0
2006-01-12 14:00:00	NVDA	Stock	0.361	0.3616	0.3562	0.3583	76523160.0
2006-01-12 15:00:00	NVDA	Stock	0.3585	0.3587	0.3548	0.3573	90099360.0
2006-01-12 16:00:00	NVDA	Stock	0.3571	0.3574	0.3563	0.3563	1924920.0
2006-01-12 17:00:00	NVDA	Stock	0.3564	0.3564	0.3564	0.3564	36000.0
2006-01-12 08:00:00	AMZN	Stock	2.215	2.215	2.2125	2.2135	38000.0
2006-01-12 09:00:00	AMZN	Stock	2.2325	2.246	2.2285	2.237	8630040.0
2006-01-12 10:00:00	AMZN	Stock	2.237	2.2545	2.225	2.238	18106320.0
2006-01-12 11:00:00	AMZN	Stock	2.2375	2.24	2.22	2.235	9924700.0
2006-01-12 12:00:00	AMZN	Stock	2.2355	2.236	2.217	2.234	9196860.0
2006-01-12 13:00:00	AMZN	Stock	2.234	2.234	2.2245	2.2285	8027820.0
2006-01-12 14:00:00	AMZN	Stock	2.2285	2.2285	2.2045	2.215	20620340.0
2006-01-12 15:00:00	AMZN	Stock	2.215	2.226	2.211	2.2145	28636040.0
2006-01-12 16:00:00	AMZN	Stock	2.2145	2.218	2.2115	2.217	1737860.0
2006-01-12 17:00:00	AMZN	Stock	2.22	2.22	2.22	2.22	4000.0
2006-01-12 09:00:00	CL	Stock	27.325	27.325	27.185	27.265	840800.0
2006-01-12 10:00:00	CL	Stock	27.265	27.295	27.185	27.185	507200.0
2006-01-12 11:00:00	CL	Stock	27.185	27.22	27.125	27.1335	582000.0
2006-01-12 12:00:00	CL	Stock	27.135	27.135	27.05	27.11	464600.0

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

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