PREVIEW / stock_30min / 2011-12-20

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-12-20.parquet
  size:    1.5 MB
  rows:    78,270
  symbols: 3,591

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-12-20 07:00:00	AAPL	Stock	13.7589	13.8021	13.75	13.7643	145460.0
2011-12-20 07:30:00	AAPL	Stock	13.7657	13.8068	13.7657	13.7857	259364.0
2011-12-20 08:00:00	AAPL	Stock	13.7718	13.7964	13.7561	13.7782	407820.0
2011-12-20 08:30:00	AAPL	Stock	13.7746	13.7929	13.7739	13.7907	766584.0
2011-12-20 09:00:00	AAPL	Stock	13.7893	13.8554	13.7879	13.8482	2519328.0
2011-12-20 09:30:00	AAPL	Stock	13.8486	13.9125	13.8307	13.8871	53965436.0
2011-12-20 10:00:00	AAPL	Stock	13.8839	13.9639	13.8836	13.9586	26352788.0
2011-12-20 10:30:00	AAPL	Stock	13.9561	14.0157	13.9439	14.0136	25327008.0
2011-12-20 11:00:00	AAPL	Stock	14.0139	14.0846	14.0114	14.0406	36684816.0
2011-12-20 11:30:00	AAPL	Stock	14.0432	14.075	14.0339	14.0593	17405836.0
2011-12-20 12:00:00	AAPL	Stock	14.06	14.0632	14.0414	14.0568	8978956.0
2011-12-20 12:30:00	AAPL	Stock	14.0571	14.0725	14.0475	14.0704	11752384.0
2011-12-20 13:00:00	AAPL	Stock	14.0704	14.1054	14.0704	14.0889	18662532.0
2011-12-20 13:30:00	AAPL	Stock	14.0875	14.0964	14.0779	14.0825	9688924.0
2011-12-20 14:00:00	AAPL	Stock	14.0825	14.0893	14.0579	14.0885	13151068.0
2011-12-20 14:30:00	AAPL	Stock	14.0882	14.1043	14.0811	14.0993	13783336.0
2011-12-20 15:00:00	AAPL	Stock	14.0975	14.1232	14.0957	14.1132	23115652.0
2011-12-20 15:30:00	AAPL	Stock	14.1144	14.1464	14.0821	14.1464	45399116.0
2011-12-20 16:00:00	AAPL	Stock	14.1432	14.1492	13.9981	14.1229	22174124.0
2011-12-20 16:30:00	AAPL	Stock	14.1179	14.1464	14.1071	14.1143	2165296.0
2011-12-20 17:00:00	AAPL	Stock	14.1143	14.1164	14.1029	14.1107	307160.0
2011-12-20 17:30:00	AAPL	Stock	14.1136	14.1164	14.1079	14.1132	203196.0
2011-12-20 18:00:00	AAPL	Stock	14.115	14.1411	14.1146	14.1232	391384.0
2011-12-20 18:30:00	AAPL	Stock	14.1218	14.1282	14.1218	14.1221	43176.0
2011-12-20 19:00:00	AAPL	Stock	14.1279	14.1282	14.1221	14.1243	54208.0
2011-12-20 19:30:00	AAPL	Stock	14.1275	14.1318	14.1196	14.1318	99932.0
2011-12-20 04:00:00	MSFT	Stock	25.62	25.62	25.62	25.62	3410.0
2011-12-20 07:00:00	MSFT	Stock	25.72	25.72	25.71	25.71	900.0
2011-12-20 07:30:00	MSFT	Stock	25.7	25.86	25.7	25.8	16756.0
2011-12-20 08:00:00	MSFT	Stock	25.8	25.84	25.75	25.78	25050.0
2011-12-20 08:30:00	MSFT	Stock	25.75	25.82	25.75	25.82	39790.0
2011-12-20 09:00:00	MSFT	Stock	25.82	25.89	25.8	25.86	99482.0
2011-12-20 09:30:00	MSFT	Stock	25.87	26.0	25.81	25.9	9371936.0
2011-12-20 10:00:00	MSFT	Stock	25.9	26.03	25.88	26.02	5335587.0
2011-12-20 10:30:00	MSFT	Stock	26.01	26.05	25.97	25.99	3085045.0
2011-12-20 11:00:00	MSFT	Stock	25.99	26.02	25.95	25.98	2213146.0
2011-12-20 11:30:00	MSFT	Stock	25.98	26.1	25.925	26.002	3882410.0
2011-12-20 12:00:00	MSFT	Stock	26.0	26.02	25.97	25.995	1721097.0
2011-12-20 12:30:00	MSFT	Stock	25.995	26.04	25.97	25.995	2208911.0
2011-12-20 13:00:00	MSFT	Stock	25.995	26.08	25.99	26.025	3785856.0
2011-12-20 13:30:00	MSFT	Stock	26.02	26.085	26.02	26.043	1924706.0
2011-12-20 14:00:00	MSFT	Stock	26.042	26.06	25.98	26.0	2777334.0
2011-12-20 14:30:00	MSFT	Stock	26.01	26.03	25.99	26.0	2724043.0
2011-12-20 15:00:00	MSFT	Stock	25.995	26.01	25.98	26.0	2625685.0
2011-12-20 15:30:00	MSFT	Stock	25.996	26.05	25.97	26.04	9726515.0
2011-12-20 16:00:00	MSFT	Stock	26.03	26.055	25.8	25.86	7697383.0
2011-12-20 16:30:00	MSFT	Stock	25.83	26.05	25.82	25.9	570713.0
2011-12-20 17:00:00	MSFT	Stock	25.91	25.92	25.88	25.88	3800.0
2011-12-20 17:30:00	MSFT	Stock	25.89	25.89	25.89	25.89	100.0
2011-12-20 18:00:00	MSFT	Stock	25.9	26.02	25.89	25.95	18504.0

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

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