PREVIEW / stock_30min / 2011-04-19

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-04-19.parquet
  size:    1.4 MB
  rows:    74,167
  symbols: 3,519

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
2011-04-19 04:00:00	AAPL	Stock	11.8639	11.9107	11.8639	11.9107	56000.0
2011-04-19 04:30:00	AAPL	Stock	11.9086	11.9239	11.9086	11.9239	19600.0
2011-04-19 05:00:00	AAPL	Stock	11.9489	11.9579	11.9286	11.9286	28000.0
2011-04-19 05:30:00	AAPL	Stock	11.9286	11.9286	11.9286	11.9286	2800.0
2011-04-19 06:00:00	AAPL	Stock	11.9286	11.9393	11.9279	11.9279	30184.0
2011-04-19 06:30:00	AAPL	Stock	11.9318	11.9425	11.9286	11.9286	14000.0
2011-04-19 07:00:00	AAPL	Stock	11.9193	11.9275	11.9	11.9161	180880.0
2011-04-19 07:30:00	AAPL	Stock	11.9107	11.9221	11.9057	11.9189	394940.0
2011-04-19 08:00:00	AAPL	Stock	11.9175	11.9393	11.8946	11.9171	1826188.0
2011-04-19 08:30:00	AAPL	Stock	11.9179	11.9393	11.9071	11.9071	1366372.0
2011-04-19 09:00:00	AAPL	Stock	11.9107	11.9129	11.8957	11.8968	762636.0
2011-04-19 09:30:00	AAPL	Stock	11.8996	11.9529	11.8661	11.9179	76766732.0
2011-04-19 10:00:00	AAPL	Stock	11.9193	11.9354	11.8932	11.9093	31656184.0
2011-04-19 10:30:00	AAPL	Stock	11.9096	11.9121	11.8804	11.9036	25315528.0
2011-04-19 11:00:00	AAPL	Stock	11.9036	11.9354	11.8864	11.9004	23224852.0
2011-04-19 11:30:00	AAPL	Stock	11.9	11.9171	11.8839	11.9136	13013980.0
2011-04-19 12:00:00	AAPL	Stock	11.9133	11.9171	11.892	11.9143	10988600.0
2011-04-19 12:30:00	AAPL	Stock	11.9123	11.9161	11.9007	11.9057	8964760.0
2011-04-19 13:00:00	AAPL	Stock	11.9075	11.9343	11.9025	11.9307	10686620.0
2011-04-19 13:30:00	AAPL	Stock	11.9307	11.9668	11.9307	11.9525	23705640.0
2011-04-19 14:00:00	AAPL	Stock	11.9539	11.9593	11.92	11.9314	36266860.0
2011-04-19 14:30:00	AAPL	Stock	11.9307	11.9671	11.9229	11.9579	30401168.0
2011-04-19 15:00:00	AAPL	Stock	11.9583	12.0432	11.9571	12.0207	51282028.0
2011-04-19 15:30:00	AAPL	Stock	12.0204	12.0707	12.0161	12.0671	60188548.0
2011-04-19 16:00:00	AAPL	Stock	12.0664	12.1364	11.9521	12.1061	7517160.0
2011-04-19 16:30:00	AAPL	Stock	12.1021	12.1186	12.0204	12.1132	1176084.0
2011-04-19 17:00:00	AAPL	Stock	12.1079	12.1182	11.8593	12.1071	347648.0
2011-04-19 17:30:00	AAPL	Stock	12.1075	12.1232	12.1071	12.1232	392392.0
2011-04-19 18:00:00	AAPL	Stock	12.1229	12.1286	12.1157	12.1179	237524.0
2011-04-19 18:30:00	AAPL	Stock	12.1196	12.125	12.1196	12.1232	38220.0
2011-04-19 19:00:00	AAPL	Stock	12.1214	12.1232	12.1161	12.1232	178220.0
2011-04-19 19:30:00	AAPL	Stock	12.1232	12.1339	12.1214	12.1339	206556.0
2011-04-19 04:00:00	MSFT	Stock	25.08	25.08	25.08	25.08	200.0
2011-04-19 06:00:00	MSFT	Stock	25.17	25.18	25.17	25.18	200.0
2011-04-19 07:30:00	MSFT	Stock	25.19	25.19	25.19	25.19	700.0
2011-04-19 08:00:00	MSFT	Stock	25.17	25.17	25.13	25.14	17150.0
2011-04-19 08:30:00	MSFT	Stock	25.15	25.16	25.12	25.12	1100.0
2011-04-19 09:00:00	MSFT	Stock	25.12	25.16	24.98	24.98	88989.0
2011-04-19 09:30:00	MSFT	Stock	25.01	25.15	24.97	24.99	4413282.0
2011-04-19 10:00:00	MSFT	Stock	25.0	25.026	24.93	24.98	3660820.0
2011-04-19 10:30:00	MSFT	Stock	24.97	24.99	24.87	24.98	3563879.0
2011-04-19 11:00:00	MSFT	Stock	24.985	25.01	24.95	24.981	2635956.0
2011-04-19 11:30:00	MSFT	Stock	24.99	25.0	24.96	25.0	1445182.0
2011-04-19 12:00:00	MSFT	Stock	24.992	25.0	24.96	24.97	1503829.0
2011-04-19 12:30:00	MSFT	Stock	24.975	25.01	24.96	24.99	2408130.0
2011-04-19 13:00:00	MSFT	Stock	24.993	25.06	24.99	25.045	1382293.0
2011-04-19 13:30:00	MSFT	Stock	25.045	25.15	25.01	25.1	2953528.0
2011-04-19 14:00:00	MSFT	Stock	25.105	25.12	25.062	25.085	1453969.0
2011-04-19 14:30:00	MSFT	Stock	25.08	25.13	25.04	25.07	2405514.0
2011-04-19 15:00:00	MSFT	Stock	25.08	25.12	25.06	25.1	2593723.0

> showing 50 of 74,167 rows — these rows as CSV

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