PREVIEW / etf_30min / 2014-10-13

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-10-13.parquet
  size:    379 KB
  rows:    12,569

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-10-13 04:00:00	SPY	ETF	189.66	189.82	189.5	189.82	25814.0
2014-10-13 04:30:00	SPY	ETF	189.84	190.38	189.84	190.37	27615.0
2014-10-13 05:00:00	SPY	ETF	190.35	190.38	190.21	190.26	29559.0
2014-10-13 05:30:00	SPY	ETF	190.21	190.27	190.0	190.15	42610.0
2014-10-13 06:00:00	SPY	ETF	190.18	190.36	190.16	190.35	22921.0
2014-10-13 06:30:00	SPY	ETF	190.3	190.66	190.3	190.63	238350.0
2014-10-13 07:00:00	SPY	ETF	190.59	190.61	190.29	190.34	273167.0
2014-10-13 07:30:00	SPY	ETF	190.32	190.5	190.31	190.34	492832.0
2014-10-13 08:00:00	SPY	ETF	189.56	190.61	189.46	190.59	1138529.0
2014-10-13 08:30:00	SPY	ETF	190.59	190.86	189.22	190.72	1382763.0
2014-10-13 09:00:00	SPY	ETF	190.72	190.74	190.34	190.46	1906922.0
2014-10-13 09:30:00	SPY	ETF	190.46	191.15	189.55	190.07	30012591.0
2014-10-13 10:00:00	SPY	ETF	190.09	190.45	189.195	189.21	18920037.0
2014-10-13 10:30:00	SPY	ETF	189.2	189.94	188.95	189.67	17688186.0
2014-10-13 11:00:00	SPY	ETF	189.67	190.28	189.38	189.605	13706714.0
2014-10-13 11:30:00	SPY	ETF	189.61	190.33	189.59	189.91	9495399.0
2014-10-13 12:00:00	SPY	ETF	189.91	190.63	189.71	190.6	8424877.0
2014-10-13 12:30:00	SPY	ETF	190.6	191.15	190.57	190.65	13719599.0
2014-10-13 13:00:00	SPY	ETF	190.65	190.88	190.04	190.71	10183087.0
2014-10-13 13:30:00	SPY	ETF	190.719	190.85	189.96	190.23	6427189.0
2014-10-13 14:00:00	SPY	ETF	190.23	190.5	189.915	190.41	9325708.0
2014-10-13 14:30:00	SPY	ETF	190.41	190.41	189.58	189.695	7638275.0
2014-10-13 15:00:00	SPY	ETF	189.69	189.78	188.97	189.13	10694026.0
2014-10-13 15:30:00	SPY	ETF	189.13	189.13	187.3	187.38	44565677.0
2014-10-13 16:00:00	SPY	ETF	187.38	189.922	187.09	187.23	9071746.0
2014-10-13 16:30:00	SPY	ETF	187.25	187.25	187.04	187.12	2321985.0
2014-10-13 17:00:00	SPY	ETF	187.1	187.29	186.97	187.27	336518.0
2014-10-13 17:30:00	SPY	ETF	187.25	187.4099	187.0	187.28	8198899.0
2014-10-13 18:00:00	SPY	ETF	187.26	187.51	187.23	187.35	338739.0
2014-10-13 18:30:00	SPY	ETF	187.37	187.42	187.34	187.41	79788.0
2014-10-13 19:00:00	SPY	ETF	187.4	187.45	187.35	187.41	64509.0
2014-10-13 19:30:00	SPY	ETF	187.4	187.7	187.4	187.7	365699.0
2014-10-13 04:00:00	QQQ	ETF	94.17	94.17	93.85	93.95	14599.0
2014-10-13 04:30:00	QQQ	ETF	93.99	94.12	93.98	93.98	3160.0
2014-10-13 05:00:00	QQQ	ETF	94.2	94.2	94.14	94.19	13000.0
2014-10-13 05:30:00	QQQ	ETF	94.12	94.14	94.08	94.14	7600.0
2014-10-13 06:00:00	QQQ	ETF	94.06	94.21	94.04	94.15	15550.0
2014-10-13 06:30:00	QQQ	ETF	94.25	94.32	94.23	94.32	38050.0
2014-10-13 07:00:00	QQQ	ETF	94.27	94.3	94.15	94.15	37800.0
2014-10-13 07:30:00	QQQ	ETF	94.17	94.26	94.16	94.18	57960.0
2014-10-13 08:00:00	QQQ	ETF	94.19	94.44	94.1	94.28	174212.0
2014-10-13 08:30:00	QQQ	ETF	94.29	94.4	94.29	94.36	130493.0
2014-10-13 09:00:00	QQQ	ETF	94.35	94.36	94.26	94.29	705755.0
2014-10-13 09:30:00	QQQ	ETF	94.29	94.73	93.72	94.05	11433376.0
2014-10-13 10:00:00	QQQ	ETF	94.05	94.22	93.41	93.4399	7087514.0
2014-10-13 10:30:00	QQQ	ETF	93.44	93.8999	93.11	93.78	6680157.0
2014-10-13 11:00:00	QQQ	ETF	93.78	94.17	93.62	93.815	7894926.0
2014-10-13 11:30:00	QQQ	ETF	93.82	94.49	93.81	94.27	5488454.0
2014-10-13 12:00:00	QQQ	ETF	94.26	94.73	94.09	94.71	3061413.0
2014-10-13 12:30:00	QQQ	ETF	94.71	94.99	94.64	94.69	3281254.0

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

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