PREVIEW / etf_30min / 2014-02-12

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-02-12.parquet
  size:    339 KB
  rows:    11,528

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-02-12 04:00:00	SPY	ETF	182.16	182.23	182.15	182.19	46397.0
2014-02-12 04:30:00	SPY	ETF	182.19	182.33	182.19	182.33	14849.0
2014-02-12 05:00:00	SPY	ETF	182.29	182.36	182.24	182.28	13590.0
2014-02-12 05:30:00	SPY	ETF	182.27	182.28	182.16	182.23	32027.0
2014-02-12 06:00:00	SPY	ETF	182.14	182.15	181.95	181.98	5503.0
2014-02-12 06:30:00	SPY	ETF	181.97	182.03	181.81	181.82	32777.0
2014-02-12 07:00:00	SPY	ETF	181.82	181.98	181.8	181.93	120660.0
2014-02-12 07:30:00	SPY	ETF	181.93	181.95	181.74	181.84	117109.0
2014-02-12 08:00:00	SPY	ETF	182.25	182.25	181.7	181.75	234082.0
2014-02-12 08:30:00	SPY	ETF	181.76	181.98	181.76	181.96	224384.0
2014-02-12 09:00:00	SPY	ETF	181.95	182.29	181.95	182.22	653456.0
2014-02-12 09:30:00	SPY	ETF	182.22	182.81	182.21	182.77	13683975.0
2014-02-12 10:00:00	SPY	ETF	182.78	182.83	182.16	182.2925	10965379.0
2014-02-12 10:30:00	SPY	ETF	182.29	182.33	181.92	182.06	8058137.0
2014-02-12 11:00:00	SPY	ETF	182.06	182.318	181.9	181.93	6186758.0
2014-02-12 11:30:00	SPY	ETF	181.93	182.05	181.705	181.91	5739407.0
2014-02-12 12:00:00	SPY	ETF	181.91	182.17	181.82	182.13	5127631.0
2014-02-12 12:30:00	SPY	ETF	182.14	182.24	181.97	182.15	3224407.0
2014-02-12 13:00:00	SPY	ETF	182.15	182.37	182.05	182.31	4106235.0
2014-02-12 13:30:00	SPY	ETF	182.31	182.396	182.2	182.24	4391361.0
2014-02-12 14:00:00	SPY	ETF	182.25	182.335	182.03	182.105	3358890.0
2014-02-12 14:30:00	SPY	ETF	182.105	182.105	181.76	181.88	5333288.0
2014-02-12 15:00:00	SPY	ETF	181.88	182.02	181.775	181.91	5934190.0
2014-02-12 15:30:00	SPY	ETF	181.91	182.14	181.8	182.08	10591523.0
2014-02-12 16:00:00	SPY	ETF	182.08	182.24	182.0653	182.2	3735546.0
2014-02-12 16:30:00	SPY	ETF	182.2	182.351	182.15	182.17	1426311.0
2014-02-12 17:00:00	SPY	ETF	182.16	182.19	182.065	182.13	179675.0
2014-02-12 17:30:00	SPY	ETF	182.14	182.18	182.11	182.15	39726.0
2014-02-12 18:00:00	SPY	ETF	182.15	182.16	182.0	182.0	42634.0
2014-02-12 18:30:00	SPY	ETF	182.0	182.08	182.0	182.03	11210.0
2014-02-12 19:00:00	SPY	ETF	182.05	182.13	182.05	182.12	127401.0
2014-02-12 19:30:00	SPY	ETF	182.12	182.12	181.94	181.99	98402.0
2014-02-12 04:00:00	QQQ	ETF	88.8	88.8	88.8	88.8	390.0
2014-02-12 04:30:00	QQQ	ETF	88.9	88.93	88.9	88.93	4500.0
2014-02-12 05:00:00	QQQ	ETF	88.93	88.93	88.93	88.93	1200.0
2014-02-12 05:30:00	QQQ	ETF	88.9	88.9	88.88	88.88	13600.0
2014-02-12 06:00:00	QQQ	ETF	88.85	88.89	88.78	88.78	1400.0
2014-02-12 06:30:00	QQQ	ETF	88.76	88.8	88.75	88.75	3800.0
2014-02-12 07:00:00	QQQ	ETF	88.71	88.77	88.69	88.77	32730.0
2014-02-12 07:30:00	QQQ	ETF	88.76	88.76	88.7	88.71	8972.0
2014-02-12 08:00:00	QQQ	ETF	88.71	88.75	88.67	88.69	55508.0
2014-02-12 08:30:00	QQQ	ETF	88.71	88.81	88.71	88.8	97048.0
2014-02-12 09:00:00	QQQ	ETF	88.8	88.99	88.8	88.97	1034932.0
2014-02-12 09:30:00	QQQ	ETF	88.97	89.15	88.93	89.15	6760727.0
2014-02-12 10:00:00	QQQ	ETF	89.15	89.1695	88.85	88.91	3660201.0
2014-02-12 10:30:00	QQQ	ETF	88.91	88.99	88.7877	88.81	2119391.0
2014-02-12 11:00:00	QQQ	ETF	88.81	89.01	88.79	88.82	1546704.0
2014-02-12 11:30:00	QQQ	ETF	88.815	88.89	88.7	88.8	1472596.0
2014-02-12 12:00:00	QQQ	ETF	88.79	88.93	88.74	88.93	1116458.0
2014-02-12 12:30:00	QQQ	ETF	88.93	89.0	88.83	88.951	888068.0

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

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