PREVIEW / stock_30min / 2006-03-24

all stock 30-min files

  file:    by_date/stock_30min/2006/2006-03-24.parquet
  size:    905 KB
  rows:    48,747
  symbols: 2,196

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-03-24 04:30:00	AAPL	Stock	2.15	2.15	2.15	2.15	2800.0
2006-03-24 06:30:00	AAPL	Stock	2.1536	2.1536	2.1536	2.1536	8400.0
2006-03-24 07:00:00	AAPL	Stock	2.1464	2.1464	2.1464	2.1464	2800.0
2006-03-24 07:30:00	AAPL	Stock	2.1518	2.1571	2.1518	2.1571	169680.0
2006-03-24 08:00:00	AAPL	Stock	2.1589	2.1643	2.1543	2.1571	1796368.0
2006-03-24 08:30:00	AAPL	Stock	2.1554	2.1571	2.1514	2.1536	1006096.0
2006-03-24 09:00:00	AAPL	Stock	2.1518	2.1536	2.1439	2.1532	5007856.0
2006-03-24 09:30:00	AAPL	Stock	2.1518	2.1607	2.1343	2.1536	144200644.0
2006-03-24 10:00:00	AAPL	Stock	2.1536	2.1764	2.15	2.1732	137530316.0
2006-03-24 10:30:00	AAPL	Stock	2.1732	2.175	2.1479	2.1554	90719104.0
2006-03-24 11:00:00	AAPL	Stock	2.1561	2.16	2.1411	2.1461	71630720.0
2006-03-24 11:30:00	AAPL	Stock	2.1461	2.1479	2.1407	2.1421	46723068.0
2006-03-24 12:00:00	AAPL	Stock	2.1422	2.1504	2.1339	2.1396	64216628.0
2006-03-24 12:30:00	AAPL	Stock	2.14	2.1432	2.1357	2.1393	35756000.0
2006-03-24 13:00:00	AAPL	Stock	2.1393	2.1404	2.1146	2.1179	100304008.0
2006-03-24 13:30:00	AAPL	Stock	2.1182	2.125	2.1089	2.1118	72289140.0
2006-03-24 14:00:00	AAPL	Stock	2.1118	2.1239	2.1082	2.1179	64349516.0
2006-03-24 14:30:00	AAPL	Stock	2.1175	2.1346	2.1136	2.1282	77001876.0
2006-03-24 15:00:00	AAPL	Stock	2.1279	2.1382	2.125	2.1318	54082784.0
2006-03-24 15:30:00	AAPL	Stock	2.1318	2.1454	2.1307	2.1407	88607624.0
2006-03-24 16:00:00	AAPL	Stock	2.1411	2.1414	2.1371	2.1389	3180128.0
2006-03-24 16:30:00	AAPL	Stock	2.1389	2.1407	2.1382	2.1389	440160.0
2006-03-24 17:00:00	AAPL	Stock	2.1414	2.1414	2.1379	2.1379	296492.0
2006-03-24 17:30:00	AAPL	Stock	2.1379	2.1393	2.1375	2.1375	206220.0
2006-03-24 18:00:00	AAPL	Stock	2.1414	2.1414	2.1375	2.14	143248.0
2006-03-24 07:00:00	MSFT	Stock	26.71	26.71	26.71	26.71	100.0
2006-03-24 08:00:00	MSFT	Stock	26.87	26.9	26.78	26.83	4221.0
2006-03-24 08:30:00	MSFT	Stock	26.8	26.8	26.7	26.7	44206.0
2006-03-24 09:00:00	MSFT	Stock	26.7	26.75	26.69	26.73	279758.0
2006-03-24 09:30:00	MSFT	Stock	26.71	26.73	26.62	26.67	11888834.0
2006-03-24 10:00:00	MSFT	Stock	26.661	26.81	26.66	26.8	7762669.0
2006-03-24 10:30:00	MSFT	Stock	26.8	26.94	26.79	26.93	8306653.0
2006-03-24 11:00:00	MSFT	Stock	26.94	26.94	26.87	26.919	4857229.0
2006-03-24 11:30:00	MSFT	Stock	26.91	26.96	26.89	26.95	2597297.0
2006-03-24 12:00:00	MSFT	Stock	26.96	26.96	26.9	26.94	1920875.0
2006-03-24 12:30:00	MSFT	Stock	26.93	26.99	26.89	26.98	2971514.0
2006-03-24 13:00:00	MSFT	Stock	26.97	27.03	26.92	26.98	6116752.0
2006-03-24 13:30:00	MSFT	Stock	26.97	27.04	26.96	27.03	3522994.0
2006-03-24 14:00:00	MSFT	Stock	27.02	27.07	26.99	27.05	3186727.0
2006-03-24 14:30:00	MSFT	Stock	27.06	27.08	26.95	27.05	2518076.0
2006-03-24 15:00:00	MSFT	Stock	27.05	27.1	27.04	27.07	3199479.0
2006-03-24 15:30:00	MSFT	Stock	27.07	27.21	26.99	27.02	8827743.0
2006-03-24 16:00:00	MSFT	Stock	27.02	27.03	26.96	26.97	173134.0
2006-03-24 16:30:00	MSFT	Stock	27.01	27.01	26.97	27.01	42604.0
2006-03-24 17:00:00	MSFT	Stock	27.01	27.01	26.99	27.01	4510.0
2006-03-24 17:30:00	MSFT	Stock	27.01	27.01	27.01	27.01	694.0
2006-03-24 18:00:00	MSFT	Stock	27.009	27.009	27.0	27.0	5411.0
2006-03-24 08:00:00	NVDA	Stock	0.4195	0.4195	0.4189	0.4189	72000.0
2006-03-24 08:30:00	NVDA	Stock	0.4192	0.4237	0.4192	0.42	300000.0
2006-03-24 09:00:00	NVDA	Stock	0.4203	0.4203	0.4186	0.42	1115520.0

> showing 50 of 48,747 rows — these rows as CSV

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