PREVIEW / stock_30min / 2007-07-06

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-07-06.parquet
  size:    1.1 MB
  rows:    62,166
  symbols: 3,032

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
2007-07-06 09:30:00	AAPL	Stock	4.7546	4.7621	4.6571	4.6904	249991140.0
2007-07-06 10:00:00	AAPL	Stock	4.6918	4.7186	4.68	4.7057	103078472.0
2007-07-06 10:30:00	AAPL	Stock	4.7061	4.7125	4.6982	4.7011	51487828.0
2007-07-06 11:00:00	AAPL	Stock	4.7011	4.7314	4.6954	4.7257	60668692.0
2007-07-06 11:30:00	AAPL	Stock	4.7264	4.7439	4.7164	4.7204	67121852.0
2007-07-06 12:00:00	AAPL	Stock	4.72	4.7304	4.7	4.7043	46513236.0
2007-07-06 12:30:00	AAPL	Stock	4.7046	4.7196	4.7	4.7139	26065620.0
2007-07-06 13:00:00	AAPL	Stock	4.7136	4.7232	4.7046	4.7207	23029468.0
2007-07-06 13:30:00	AAPL	Stock	4.7204	4.7275	4.7125	4.7264	29098132.0
2007-07-06 14:00:00	AAPL	Stock	4.7261	4.7304	4.7179	4.7207	34509664.0
2007-07-06 14:30:00	AAPL	Stock	4.7204	4.7254	4.7175	4.7236	23564464.0
2007-07-06 15:00:00	AAPL	Stock	4.7232	4.7286	4.72	4.7218	32229372.0
2007-07-06 15:30:00	AAPL	Stock	4.7218	4.7279	4.7179	4.725	63419048.0
2007-07-06 16:00:00	AAPL	Stock	4.7236	4.725	4.7232	4.725	6512128.0
2007-07-06 09:30:00	MSFT	Stock	29.91	30.04	29.9	29.96	5973118.0
2007-07-06 10:00:00	MSFT	Stock	29.96	29.99	29.94	29.98	6848687.0
2007-07-06 10:30:00	MSFT	Stock	29.97	30.01	29.96	29.97	2785065.0
2007-07-06 11:00:00	MSFT	Stock	29.97	30.0	29.96	29.971	2750022.0
2007-07-06 11:30:00	MSFT	Stock	29.975	29.99	29.91	29.92	2353516.0
2007-07-06 12:00:00	MSFT	Stock	29.925	29.93	29.75	29.79	3305429.0
2007-07-06 12:30:00	MSFT	Stock	29.79	29.82	29.72	29.77	2631543.0
2007-07-06 13:00:00	MSFT	Stock	29.78	29.81	29.7	29.72	1581576.0
2007-07-06 13:30:00	MSFT	Stock	29.72	29.76	29.66	29.76	2325486.0
2007-07-06 14:00:00	MSFT	Stock	29.76	29.84	29.72	29.81	3002011.0
2007-07-06 14:30:00	MSFT	Stock	29.81	29.91	29.8	29.89	3676921.0
2007-07-06 15:00:00	MSFT	Stock	29.9	29.91	29.87	29.905	3804554.0
2007-07-06 15:30:00	MSFT	Stock	29.9	29.96	29.88	29.96	5285539.0
2007-07-06 16:00:00	MSFT	Stock	29.94	29.97	29.94	29.97	1220785.0
2007-07-06 08:30:00	NVDA	Stock	0.7258	0.726	0.7258	0.726	42000.0
2007-07-06 09:00:00	NVDA	Stock	0.725	0.7257	0.725	0.725	276000.0
2007-07-06 09:30:00	NVDA	Stock	0.725	0.7275	0.7237	0.7255	41094660.0
2007-07-06 10:00:00	NVDA	Stock	0.7255	0.7323	0.7253	0.7315	30412680.0
2007-07-06 10:30:00	NVDA	Stock	0.7317	0.732	0.7263	0.7275	30157440.0
2007-07-06 11:00:00	NVDA	Stock	0.7277	0.7283	0.7262	0.7282	20142780.0
2007-07-06 11:30:00	NVDA	Stock	0.7282	0.7295	0.7275	0.7282	19409280.0
2007-07-06 12:00:00	NVDA	Stock	0.728	0.7287	0.7248	0.725	17501760.0
2007-07-06 12:30:00	NVDA	Stock	0.725	0.7282	0.725	0.7262	13475580.0
2007-07-06 13:00:00	NVDA	Stock	0.726	0.7275	0.7255	0.7273	8573820.0
2007-07-06 13:30:00	NVDA	Stock	0.7272	0.728	0.7265	0.7275	10693920.0
2007-07-06 14:00:00	NVDA	Stock	0.7275	0.7292	0.7273	0.7277	13145100.0
2007-07-06 14:30:00	NVDA	Stock	0.7278	0.7292	0.7273	0.7275	13652820.0
2007-07-06 15:00:00	NVDA	Stock	0.7277	0.7282	0.727	0.7277	14567220.0
2007-07-06 15:30:00	NVDA	Stock	0.7277	0.7298	0.727	0.7295	40616520.0
2007-07-06 16:00:00	NVDA	Stock	0.7292	0.7295	0.7277	0.7277	1767120.0
2007-07-06 16:30:00	NVDA	Stock	0.7295	0.7295	0.7278	0.7278	609720.0
2007-07-06 17:30:00	NVDA	Stock	0.728	0.728	0.728	0.728	18000.0
2007-07-06 18:00:00	NVDA	Stock	0.7278	0.7315	0.7275	0.73	222180.0
2007-07-06 18:30:00	NVDA	Stock	0.7313	0.7313	0.7292	0.7292	42000.0
2007-07-06 19:30:00	NVDA	Stock	0.7295	0.7295	0.7295	0.7295	6000.0
2007-07-06 08:00:00	AMZN	Stock	3.438	3.438	3.4375	3.4375	9200.0

> showing 50 of 62,166 rows — these rows as CSV

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