PREVIEW / etf_30min / 2014-03-11

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-03-11.parquet
  size:    332 KB
  rows:    11,128

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
2014-03-11 04:00:00	SPY	ETF	188.14	188.21	188.07	188.07	8900.0
2014-03-11 04:30:00	SPY	ETF	188.07	188.15	188.07	188.14	5900.0
2014-03-11 05:00:00	SPY	ETF	188.09	188.09	188.07	188.07	2358.0
2014-03-11 05:30:00	SPY	ETF	188.11	188.11	187.9	188.0	8507.0
2014-03-11 06:00:00	SPY	ETF	188.03	188.07	187.95	188.03	6910.0
2014-03-11 06:30:00	SPY	ETF	188.02	188.14	187.92	188.14	39858.0
2014-03-11 07:00:00	SPY	ETF	188.09	188.18	188.05	188.15	47063.0
2014-03-11 07:30:00	SPY	ETF	188.12	188.13	188.02	188.05	81534.0
2014-03-11 08:00:00	SPY	ETF	188.07	188.18	188.04	188.16	180100.0
2014-03-11 08:30:00	SPY	ETF	188.15	188.44	188.14	188.38	449177.0
2014-03-11 09:00:00	SPY	ETF	188.36	188.56	188.3	188.44	743270.0
2014-03-11 09:30:00	SPY	ETF	188.44	188.48	187.68	187.9301	9768179.0
2014-03-11 10:00:00	SPY	ETF	187.94	188.26	187.66	188.25	7185347.0
2014-03-11 10:30:00	SPY	ETF	188.25	188.71	188.245	188.59	6454800.0
2014-03-11 11:00:00	SPY	ETF	188.6	188.65	188.33	188.35	3618311.0
2014-03-11 11:30:00	SPY	ETF	188.36	188.37	187.842	187.94	6647984.0
2014-03-11 12:00:00	SPY	ETF	187.93	187.98	187.4	187.6	7736934.0
2014-03-11 12:30:00	SPY	ETF	187.61	187.81	187.54	187.67	4175534.0
2014-03-11 13:00:00	SPY	ETF	187.66	187.73	187.32	187.32	4819078.0
2014-03-11 13:30:00	SPY	ETF	187.325	187.78	187.27	187.75	4509888.0
2014-03-11 14:00:00	SPY	ETF	187.74	187.83	187.32	187.41	5084628.0
2014-03-11 14:30:00	SPY	ETF	187.42	187.45	187.11	187.15	6424949.0
2014-03-11 15:00:00	SPY	ETF	187.15	187.2	186.8	187.07	9393470.0
2014-03-11 15:30:00	SPY	ETF	187.06	187.3	186.93	187.2	12605844.0
2014-03-11 16:00:00	SPY	ETF	187.18	187.9204	186.95	187.03	3060440.0
2014-03-11 16:30:00	SPY	ETF	187.05	188.1467	186.92	186.95	3840462.0
2014-03-11 17:00:00	SPY	ETF	186.95	187.03	186.94	186.97	112280.0
2014-03-11 17:30:00	SPY	ETF	186.96	187.02	186.95	187.0	15975.0
2014-03-11 18:00:00	SPY	ETF	187.0	187.1	186.96	187.01	35110.0
2014-03-11 18:30:00	SPY	ETF	187.01	187.08	186.96	187.01	41857.0
2014-03-11 19:00:00	SPY	ETF	186.98	187.02	186.97	187.02	4500.0
2014-03-11 19:30:00	SPY	ETF	187.01	187.01	186.79	186.85	99733.0
2014-03-11 06:00:00	QQQ	ETF	90.55	90.55	90.55	90.55	100.0
2014-03-11 06:30:00	QQQ	ETF	90.55	90.61	90.54	90.61	2000.0
2014-03-11 07:00:00	QQQ	ETF	90.62	90.62	90.62	90.62	185.0
2014-03-11 07:30:00	QQQ	ETF	90.62	90.62	90.59	90.6	8250.0
2014-03-11 08:00:00	QQQ	ETF	90.61	90.66	90.6	90.64	14340.0
2014-03-11 08:30:00	QQQ	ETF	90.66	90.78	90.66	90.77	69947.0
2014-03-11 09:00:00	QQQ	ETF	90.74	90.87	90.71	90.82	72861.0
2014-03-11 09:30:00	QQQ	ETF	90.83	90.86	90.48	90.67	2161797.0
2014-03-11 10:00:00	QQQ	ETF	90.67	90.87	90.51	90.86	1834705.0
2014-03-11 10:30:00	QQQ	ETF	90.859	91.055	90.84	91.0	1747208.0
2014-03-11 11:00:00	QQQ	ETF	91.01	91.03	90.9	90.95	1128585.0
2014-03-11 11:30:00	QQQ	ETF	90.95	90.96	90.671	90.78	1040406.0
2014-03-11 12:00:00	QQQ	ETF	90.78	90.82	90.5	90.6	1640550.0
2014-03-11 12:30:00	QQQ	ETF	90.6	90.6799	90.56	90.58	782283.0
2014-03-11 13:00:00	QQQ	ETF	90.57	90.6	90.4	90.41	1306173.0
2014-03-11 13:30:00	QQQ	ETF	90.41	90.6	90.37	90.58	1129854.0
2014-03-11 14:00:00	QQQ	ETF	90.575	90.62	90.3	90.37	735148.0
2014-03-11 14:30:00	QQQ	ETF	90.37	90.385	90.15	90.16	2408428.0

> showing 50 of 11,128 rows — these rows as CSV

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