PREVIEW / stock_30min / 2011-03-21

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-03-21.parquet
  size:    1.5 MB
  rows:    78,217
  symbols: 3,531

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-03-21 04:00:00	AAPL	Stock	11.8929	11.9911	11.8929	11.9821	88200.0
2011-03-21 04:30:00	AAPL	Stock	11.99	12.0	11.99	12.0	33600.0
2011-03-21 05:00:00	AAPL	Stock	11.9821	12.0	11.97	12.0	47600.0
2011-03-21 05:30:00	AAPL	Stock	11.9929	11.9929	11.9821	11.9821	8400.0
2011-03-21 06:00:00	AAPL	Stock	12.0	12.0	11.9857	12.0	42000.0
2011-03-21 06:30:00	AAPL	Stock	12.0	12.0	11.9929	11.9929	36400.0
2011-03-21 07:00:00	AAPL	Stock	11.9929	12.0304	11.9732	12.0179	684992.0
2011-03-21 07:30:00	AAPL	Stock	12.0182	12.0321	12.0011	12.0096	272160.0
2011-03-21 08:00:00	AAPL	Stock	12.0036	12.0179	11.9718	11.9804	1689436.0
2011-03-21 08:30:00	AAPL	Stock	11.98	11.9918	11.9643	11.9821	1745324.0
2011-03-21 09:00:00	AAPL	Stock	11.9836	11.9996	11.9696	11.9996	3578540.0
2011-03-21 09:30:00	AAPL	Stock	12.0	12.1029	11.9736	12.0709	94969224.0
2011-03-21 10:00:00	AAPL	Stock	12.0714	12.0864	12.0407	12.0832	42139524.0
2011-03-21 10:30:00	AAPL	Stock	12.0829	12.0893	12.0596	12.0654	28842856.0
2011-03-21 11:00:00	AAPL	Stock	12.0661	12.1336	12.0654	12.1132	41884612.0
2011-03-21 11:30:00	AAPL	Stock	12.1121	12.1193	12.0846	12.0857	20207096.0
2011-03-21 12:00:00	AAPL	Stock	12.0868	12.11	12.0864	12.1054	14866740.0
2011-03-21 12:30:00	AAPL	Stock	12.1057	12.1104	12.0821	12.0954	12966604.0
2011-03-21 13:00:00	AAPL	Stock	12.0952	12.0964	12.0589	12.065	15548484.0
2011-03-21 13:30:00	AAPL	Stock	12.065	12.0984	12.0418	12.0982	18354112.0
2011-03-21 14:00:00	AAPL	Stock	12.0986	12.1179	12.0907	12.0991	16369752.0
2011-03-21 14:30:00	AAPL	Stock	12.0989	12.1211	12.0914	12.0948	18047988.0
2011-03-21 15:00:00	AAPL	Stock	12.0936	12.1143	12.0696	12.0839	18465748.0
2011-03-21 15:30:00	AAPL	Stock	12.085	12.1261	12.0821	12.1143	40148724.0
2011-03-21 16:00:00	AAPL	Stock	12.115	12.1307	12.0807	12.1268	8195572.0
2011-03-21 16:30:00	AAPL	Stock	12.1239	12.1268	12.0644	12.1246	335524.0
2011-03-21 17:00:00	AAPL	Stock	12.1243	12.1332	12.0139	12.1332	407932.0
2011-03-21 17:30:00	AAPL	Stock	12.1332	12.1332	12.1275	12.1289	48972.0
2011-03-21 18:00:00	AAPL	Stock	12.1325	12.1404	12.1179	12.1375	217532.0
2011-03-21 18:30:00	AAPL	Stock	12.1375	12.1382	12.1264	12.1332	163632.0
2011-03-21 19:00:00	AAPL	Stock	12.1304	12.1386	12.1304	12.1361	205408.0
2011-03-21 19:30:00	AAPL	Stock	12.1375	12.1404	12.1321	12.1382	239064.0
2011-03-21 04:00:00	MSFT	Stock	24.97	25.0	24.97	25.0	800.0
2011-03-21 04:30:00	MSFT	Stock	25.04	25.04	25.04	25.04	200.0
2011-03-21 05:00:00	MSFT	Stock	25.04	25.04	25.04	25.04	100.0
2011-03-21 06:00:00	MSFT	Stock	25.05	25.11	25.05	25.11	400.0
2011-03-21 06:30:00	MSFT	Stock	25.03	25.03	25.03	25.03	100.0
2011-03-21 07:00:00	MSFT	Stock	25.03	25.03	25.03	25.03	800.0
2011-03-21 07:30:00	MSFT	Stock	25.05	25.06	25.05	25.05	3834.0
2011-03-21 08:00:00	MSFT	Stock	25.01	25.08	24.96	25.08	39039.0
2011-03-21 08:30:00	MSFT	Stock	25.06	25.07	25.03	25.07	12920.0
2011-03-21 09:00:00	MSFT	Stock	25.07	25.19	25.04	25.18	130471.0
2011-03-21 09:30:00	MSFT	Stock	25.19	25.51	25.15	25.502	6824747.0
2011-03-21 10:00:00	MSFT	Stock	25.5	25.56	25.45	25.55	5262622.0
2011-03-21 10:30:00	MSFT	Stock	25.555	25.58	25.5	25.52	3158407.0
2011-03-21 11:00:00	MSFT	Stock	25.52	25.56	25.48	25.48	2268155.0
2011-03-21 11:30:00	MSFT	Stock	25.48	25.49	25.28	25.28	3846067.0
2011-03-21 12:00:00	MSFT	Stock	25.282	25.39	25.28	25.385	1648506.0
2011-03-21 12:30:00	MSFT	Stock	25.385	25.41	25.28	25.335	1612349.0
2011-03-21 13:00:00	MSFT	Stock	25.331	25.37	25.28	25.29	1886619.0

> showing 50 of 78,217 rows — these rows as CSV

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