PREVIEW / etf_30min / 2015-06-15

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-06-15.parquet
  size:    375 KB
  rows:    12,688

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
2015-06-15 04:00:00	SPY	ETF	209.6	209.6	208.94	209.26	3695.0
2015-06-15 04:30:00	SPY	ETF	209.29	209.34	209.24	209.25	10290.0
2015-06-15 05:00:00	SPY	ETF	209.31	209.35	209.17	209.22	6160.0
2015-06-15 05:30:00	SPY	ETF	209.28	209.35	209.09	209.09	15565.0
2015-06-15 06:00:00	SPY	ETF	209.12	209.38	209.03	209.38	15243.0
2015-06-15 06:30:00	SPY	ETF	209.34	209.43	209.22	209.33	24830.0
2015-06-15 07:00:00	SPY	ETF	209.28	209.31	208.95	209.1	228350.0
2015-06-15 07:30:00	SPY	ETF	209.04	209.05	208.87	208.99	240226.0
2015-06-15 08:00:00	SPY	ETF	209.0	209.21	208.77	209.03	452190.0
2015-06-15 08:30:00	SPY	ETF	209.0	209.03	208.68	208.7	549960.0
2015-06-15 09:00:00	SPY	ETF	208.71	208.8	208.5	208.63	959617.0
2015-06-15 09:30:00	SPY	ETF	208.64	208.66	207.79	208.13	20688063.0
2015-06-15 10:00:00	SPY	ETF	208.125	208.5	208.03	208.35	11902842.0
2015-06-15 10:30:00	SPY	ETF	208.36	208.59	208.191	208.57	8212233.0
2015-06-15 11:00:00	SPY	ETF	208.57	209.34	208.57	208.67	11457090.0
2015-06-15 11:30:00	SPY	ETF	208.675	209.25	208.675	208.99	5290960.0
2015-06-15 12:00:00	SPY	ETF	208.99	209.23	208.94	209.0	5723034.0
2015-06-15 12:30:00	SPY	ETF	208.99	209.31	208.9	209.234	3063463.0
2015-06-15 13:00:00	SPY	ETF	209.24	209.3	209.03	209.07	3268188.0
2015-06-15 13:30:00	SPY	ETF	209.075	209.45	208.78	208.985	9748241.0
2015-06-15 14:00:00	SPY	ETF	208.99	209.32	208.94	209.15	5177483.0
2015-06-15 14:30:00	SPY	ETF	209.16	209.24	208.82	208.91	4241467.0
2015-06-15 15:00:00	SPY	ETF	208.9	208.94	208.75	208.91	6100698.0
2015-06-15 15:30:00	SPY	ETF	208.905	209.26	208.9	209.09	13624481.0
2015-06-15 16:00:00	SPY	ETF	209.08	209.11	208.26	208.98	4620885.0
2015-06-15 16:30:00	SPY	ETF	209.0	209.07	208.95	209.01	2081791.0
2015-06-15 17:00:00	SPY	ETF	209.02	209.11	208.95	208.95	311857.0
2015-06-15 17:30:00	SPY	ETF	208.97	209.01	208.97	209.01	34588.0
2015-06-15 18:00:00	SPY	ETF	209.0	209.0	208.8	208.85	63967.0
2015-06-15 18:30:00	SPY	ETF	208.84	208.87	208.84	208.85	11080.0
2015-06-15 19:00:00	SPY	ETF	208.86	208.887	208.85	208.85	18399.0
2015-06-15 19:30:00	SPY	ETF	208.85	208.88	208.83	208.88	21028.0
2015-06-15 04:00:00	QQQ	ETF	108.28	108.28	108.28	108.28	100.0
2015-06-15 04:30:00	QQQ	ETF	108.32	108.32	108.32	108.32	500.0
2015-06-15 05:30:00	QQQ	ETF	108.32	108.32	108.3	108.3	6150.0
2015-06-15 06:00:00	QQQ	ETF	108.32	108.35	108.24	108.35	10050.0
2015-06-15 07:00:00	QQQ	ETF	108.29	108.33	108.23	108.29	9675.0
2015-06-15 07:30:00	QQQ	ETF	108.24	108.25	108.16	108.18	69876.0
2015-06-15 08:00:00	QQQ	ETF	108.24	108.33	108.13	108.22	41647.0
2015-06-15 08:30:00	QQQ	ETF	108.2	108.2	108.06	108.07	65617.0
2015-06-15 09:00:00	QQQ	ETF	108.08	108.13	107.94	107.94	89744.0
2015-06-15 09:30:00	QQQ	ETF	107.94	107.95	107.31	107.482	4880567.0
2015-06-15 10:00:00	QQQ	ETF	107.48	107.75	107.44	107.62	2427947.0
2015-06-15 10:30:00	QQQ	ETF	107.63	107.78	107.54	107.73	1877437.0
2015-06-15 11:00:00	QQQ	ETF	107.73	108.15	107.73	107.83	2531566.0
2015-06-15 11:30:00	QQQ	ETF	107.83	108.17	107.83	108.02	983208.0
2015-06-15 12:00:00	QQQ	ETF	108.01	108.1899	107.995	108.03	682856.0
2015-06-15 12:30:00	QQQ	ETF	108.02	108.21	107.9743	108.17	708523.0
2015-06-15 13:00:00	QQQ	ETF	108.1757	108.25	108.1099	108.14	555556.0
2015-06-15 13:30:00	QQQ	ETF	108.14	108.38	108.01	108.16	1584083.0

> showing 50 of 12,688 rows — these rows as CSV

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