PREVIEW / stock_30min / 2012-10-08

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-10-08.parquet
  size:    1.3 MB
  rows:    71,661
  symbols: 3,439

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
2012-10-08 04:00:00	AAPL	Stock	23.2168	23.2168	23.1071	23.1071	79688.0
2012-10-08 04:30:00	AAPL	Stock	23.0893	23.125	23.0893	23.125	77840.0
2012-10-08 05:00:00	AAPL	Stock	23.125	23.125	23.0911	23.0982	67900.0
2012-10-08 05:30:00	AAPL	Stock	23.1207	23.1207	23.1011	23.1011	12040.0
2012-10-08 06:00:00	AAPL	Stock	23.105	23.1107	23.0886	23.0886	42000.0
2012-10-08 06:30:00	AAPL	Stock	23.1071	23.1296	23.0982	23.125	28000.0
2012-10-08 07:00:00	AAPL	Stock	23.1254	23.135	23.075	23.1071	453628.0
2012-10-08 07:30:00	AAPL	Stock	23.1157	23.1607	23.1111	23.125	208096.0
2012-10-08 08:00:00	AAPL	Stock	23.1364	23.2114	23.0843	23.1821	1492764.0
2012-10-08 08:30:00	AAPL	Stock	23.1807	23.1807	23.0907	23.1107	1539608.0
2012-10-08 09:00:00	AAPL	Stock	23.1093	23.1382	23.0514	23.0911	3488828.0
2012-10-08 09:30:00	AAPL	Stock	23.095	23.1271	22.9107	23.0286	105997164.0
2012-10-08 10:00:00	AAPL	Stock	23.0296	23.0846	22.7546	22.7621	74655112.0
2012-10-08 10:30:00	AAPL	Stock	22.765	22.96	22.7379	22.935	80621548.0
2012-10-08 11:00:00	AAPL	Stock	22.9254	22.9464	22.7989	22.8766	32903556.0
2012-10-08 11:30:00	AAPL	Stock	22.8722	22.9261	22.7975	22.8911	28574924.0
2012-10-08 12:00:00	AAPL	Stock	22.8911	22.9354	22.825	22.8464	26472880.0
2012-10-08 12:30:00	AAPL	Stock	22.8464	22.8621	22.7429	22.8139	34066592.0
2012-10-08 13:00:00	AAPL	Stock	22.8071	22.8393	22.7182	22.801	29383144.0
2012-10-08 13:30:00	AAPL	Stock	22.7986	22.8857	22.7539	22.767	25638004.0
2012-10-08 14:00:00	AAPL	Stock	22.7672	22.8671	22.7445	22.8143	25285456.0
2012-10-08 14:30:00	AAPL	Stock	22.8142	22.85	22.7896	22.8318	16997372.0
2012-10-08 15:00:00	AAPL	Stock	22.8339	23.0446	22.8283	22.9704	69432636.0
2012-10-08 15:30:00	AAPL	Stock	22.9691	22.9925	22.7904	22.7918	59441452.0
2012-10-08 16:00:00	AAPL	Stock	22.7918	22.9109	22.7714	22.7729	5216960.0
2012-10-08 16:30:00	AAPL	Stock	22.77	22.9652	22.7411	22.7411	512428.0
2012-10-08 17:00:00	AAPL	Stock	22.7461	22.7918	22.6875	22.7068	621348.0
2012-10-08 17:30:00	AAPL	Stock	22.7	22.7089	22.6982	22.7036	257460.0
2012-10-08 18:00:00	AAPL	Stock	22.7061	22.7339	22.7061	22.7211	418180.0
2012-10-08 18:30:00	AAPL	Stock	22.7196	22.7261	22.7161	22.7189	115892.0
2012-10-08 19:00:00	AAPL	Stock	22.7214	22.7261	22.7161	22.7211	167524.0
2012-10-08 19:30:00	AAPL	Stock	22.7268	22.7393	22.7232	22.7393	118048.0
2012-10-08 08:00:00	MSFT	Stock	29.78	29.82	29.78	29.8	8200.0
2012-10-08 08:30:00	MSFT	Stock	29.8	29.82	29.77	29.77	18500.0
2012-10-08 09:00:00	MSFT	Stock	29.78	29.78	29.62	29.66	45016.0
2012-10-08 09:30:00	MSFT	Stock	29.66	29.81	29.55	29.795	3728464.0
2012-10-08 10:00:00	MSFT	Stock	29.795	29.85	29.731	29.805	2362611.0
2012-10-08 10:30:00	MSFT	Stock	29.81	29.92	29.79	29.875	2307782.0
2012-10-08 11:00:00	MSFT	Stock	29.87	29.9	29.74	29.775	1956364.0
2012-10-08 11:30:00	MSFT	Stock	29.775	29.8	29.71	29.8	1801057.0
2012-10-08 12:00:00	MSFT	Stock	29.79	29.8	29.72	29.78	1595194.0
2012-10-08 12:30:00	MSFT	Stock	29.78	29.8	29.74	29.76	1705295.0
2012-10-08 13:00:00	MSFT	Stock	29.76	29.78	29.74	29.77	1307474.0
2012-10-08 13:30:00	MSFT	Stock	29.76	29.79	29.75	29.78	948511.0
2012-10-08 14:00:00	MSFT	Stock	29.77	29.78	29.73	29.745	1820289.0
2012-10-08 14:30:00	MSFT	Stock	29.745	29.8	29.74	29.75	1380651.0
2012-10-08 15:00:00	MSFT	Stock	29.75	29.84	29.75	29.795	1793667.0
2012-10-08 15:30:00	MSFT	Stock	29.79	29.81	29.76	29.79	5224528.0
2012-10-08 16:00:00	MSFT	Stock	29.78	29.782	29.75	29.78	1109805.0
2012-10-08 16:30:00	MSFT	Stock	29.73	29.8	29.73	29.8	1399.0

> showing 50 of 71,661 rows — these rows as CSV

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