PREVIEW / etf_30min / 2016-04-15

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-04-15.parquet
  size:    381 KB
  rows:    13,051

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
2016-04-15 04:00:00	SPY	ETF	207.84	207.84	207.73	207.76	6040.0
2016-04-15 04:30:00	SPY	ETF	207.7	207.77	207.67	207.75	3390.0
2016-04-15 05:00:00	SPY	ETF	207.77	207.89	207.77	207.78	4010.0
2016-04-15 05:30:00	SPY	ETF	207.74	207.85	207.74	207.85	1160.0
2016-04-15 06:00:00	SPY	ETF	207.85	207.85	207.7	207.73	8034.0
2016-04-15 06:30:00	SPY	ETF	207.68	207.79	207.63	207.72	135677.0
2016-04-15 07:00:00	SPY	ETF	207.71	207.81	207.61	207.61	45321.0
2016-04-15 07:30:00	SPY	ETF	207.63	207.71	207.59	207.66	263661.0
2016-04-15 08:00:00	SPY	ETF	207.62	208.16	207.58	207.73	236932.0
2016-04-15 08:30:00	SPY	ETF	207.73	207.85	207.62	207.8	386093.0
2016-04-15 09:00:00	SPY	ETF	207.8	208.06	207.68	208.02	848526.0
2016-04-15 09:30:00	SPY	ETF	208.01	208.11	207.81	207.92	11777672.0
2016-04-15 10:00:00	SPY	ETF	207.93	208.1721	207.58	207.82	8059736.0
2016-04-15 10:30:00	SPY	ETF	207.82	208.05	207.8	207.865	5183719.0
2016-04-15 11:00:00	SPY	ETF	207.86	208.09	207.8208	208.0	3060395.0
2016-04-15 11:30:00	SPY	ETF	208.005	208.04	207.9	207.93	2715705.0
2016-04-15 12:00:00	SPY	ETF	207.93	208.0	207.87	207.97	2593647.0
2016-04-15 12:30:00	SPY	ETF	207.97	207.98	207.72	207.73	3334813.0
2016-04-15 13:00:00	SPY	ETF	207.73	207.79	207.605	207.6989	2900041.0
2016-04-15 13:30:00	SPY	ETF	207.69	207.695	207.43	207.56	4358881.0
2016-04-15 14:00:00	SPY	ETF	207.56	207.68	207.4	207.68	3292395.0
2016-04-15 14:30:00	SPY	ETF	207.68	207.89	207.62	207.88	3525658.0
2016-04-15 15:00:00	SPY	ETF	207.8785	207.93	207.75	207.87	3663155.0
2016-04-15 15:30:00	SPY	ETF	207.875	207.95	207.66	207.81	10680981.0
2016-04-15 16:00:00	SPY	ETF	207.8	208.0	207.71	207.95	4151701.0
2016-04-15 16:30:00	SPY	ETF	207.95	208.09	207.9	207.95	352330.0
2016-04-15 17:00:00	SPY	ETF	207.95	207.97	207.91	207.92	181585.0
2016-04-15 17:30:00	SPY	ETF	207.93	207.95	207.91	207.93	52786.0
2016-04-15 18:00:00	SPY	ETF	207.93	207.93	207.91	207.91	14437.0
2016-04-15 18:30:00	SPY	ETF	207.93	207.93	207.89	207.9	8339.0
2016-04-15 19:00:00	SPY	ETF	207.89	207.91	207.89	207.91	18625.0
2016-04-15 19:30:00	SPY	ETF	207.91	207.92	207.89	207.89	9861.0
2016-04-15 05:30:00	QQQ	ETF	110.8	110.8	110.8	110.8	200.0
2016-04-15 06:00:00	QQQ	ETF	110.73	110.73	110.71	110.72	800.0
2016-04-15 06:30:00	QQQ	ETF	110.66	110.72	110.66	110.71	1601.0
2016-04-15 07:00:00	QQQ	ETF	110.66	110.73	110.65	110.67	5810.0
2016-04-15 07:30:00	QQQ	ETF	110.7	110.7	110.65	110.66	6746.0
2016-04-15 08:00:00	QQQ	ETF	110.65	110.74	110.64	110.73	15809.0
2016-04-15 08:30:00	QQQ	ETF	110.74	110.75	110.69	110.71	3639.0
2016-04-15 09:00:00	QQQ	ETF	110.73	110.84	110.63	110.83	203307.0
2016-04-15 09:30:00	QQQ	ETF	110.83	110.95	110.61	110.81	2096675.0
2016-04-15 10:00:00	QQQ	ETF	110.81	110.82	110.61	110.75	1612827.0
2016-04-15 10:30:00	QQQ	ETF	110.755	111.0	110.73	110.9	1073605.0
2016-04-15 11:00:00	QQQ	ETF	110.9	111.055	110.876	110.99	1236696.0
2016-04-15 11:30:00	QQQ	ETF	111.0	111.02	110.87	110.88	709767.0
2016-04-15 12:00:00	QQQ	ETF	110.88	110.95	110.84	110.94	569911.0
2016-04-15 12:30:00	QQQ	ETF	110.94	110.94	110.79	110.79	639814.0
2016-04-15 13:00:00	QQQ	ETF	110.785	110.815	110.47	110.53	1611111.0
2016-04-15 13:30:00	QQQ	ETF	110.53	110.55	110.37	110.5275	1205585.0
2016-04-15 14:00:00	QQQ	ETF	110.52	110.58	110.36	110.55	1044700.0

> showing 50 of 13,051 rows — these rows as CSV

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