PREVIEW / etf_30min / 2014-12-03

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-12-03.parquet
  size:    350 KB
  rows:    12,040

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-12-03 04:00:00	SPY	ETF	207.06	207.06	206.87	206.99	4052.0
2014-12-03 04:30:00	SPY	ETF	206.98	207.15	206.98	207.13	3677.0
2014-12-03 05:00:00	SPY	ETF	207.12	207.12	207.0	207.04	4430.0
2014-12-03 05:30:00	SPY	ETF	207.04	207.04	206.85	206.9	13160.0
2014-12-03 06:00:00	SPY	ETF	207.05	207.05	206.97	207.05	14200.0
2014-12-03 06:30:00	SPY	ETF	207.1	207.17	207.1	207.12	9465.0
2014-12-03 07:00:00	SPY	ETF	207.1	207.15	207.09	207.15	4770.0
2014-12-03 07:30:00	SPY	ETF	207.13	207.2	207.11	207.16	80175.0
2014-12-03 08:00:00	SPY	ETF	207.16	207.19	207.01	207.03	227946.0
2014-12-03 08:30:00	SPY	ETF	207.02	207.14	207.01	207.08	225678.0
2014-12-03 09:00:00	SPY	ETF	207.09	207.32	207.06	207.28	603377.0
2014-12-03 09:30:00	SPY	ETF	207.3	207.63	207.1	207.51	7959487.0
2014-12-03 10:00:00	SPY	ETF	207.52	207.68	207.3	207.6	6258425.0
2014-12-03 10:30:00	SPY	ETF	207.6	207.77	207.53	207.65	3875348.0
2014-12-03 11:00:00	SPY	ETF	207.64	207.76	207.42	207.56	4348648.0
2014-12-03 11:30:00	SPY	ETF	207.57	207.63	207.41	207.49	4484052.0
2014-12-03 12:00:00	SPY	ETF	207.495	207.57	207.43	207.46	2026667.0
2014-12-03 12:30:00	SPY	ETF	207.455	207.61	207.335	207.6	3187289.0
2014-12-03 13:00:00	SPY	ETF	207.6	207.66	207.55	207.64	3097862.0
2014-12-03 13:30:00	SPY	ETF	207.64	207.66	207.54	207.635	2447386.0
2014-12-03 14:00:00	SPY	ETF	207.64	207.78	207.59	207.735	3739481.0
2014-12-03 14:30:00	SPY	ETF	207.73	207.76	207.62	207.69	2644875.0
2014-12-03 15:00:00	SPY	ETF	207.69	208.02	207.67	208.0199	4439366.0
2014-12-03 15:30:00	SPY	ETF	208.02	208.15	207.87	207.91	10370064.0
2014-12-03 16:00:00	SPY	ETF	207.91	207.94	207.77	207.8	7597040.0
2014-12-03 16:30:00	SPY	ETF	207.79	207.91	207.72	207.83	349384.0
2014-12-03 17:00:00	SPY	ETF	207.82	207.87	207.82	207.87	364133.0
2014-12-03 17:30:00	SPY	ETF	207.87	207.87	207.84	207.84	11335.0
2014-12-03 18:00:00	SPY	ETF	207.85	207.889	207.81	207.85	30105.0
2014-12-03 18:30:00	SPY	ETF	207.88	207.89	207.85	207.86	5586.0
2014-12-03 19:00:00	SPY	ETF	207.86	207.86	207.82	207.82	20800.0
2014-12-03 19:30:00	SPY	ETF	207.82	207.84	207.8	207.84	19658.0
2014-12-03 05:00:00	QQQ	ETF	105.23	105.23	105.22	105.22	645.0
2014-12-03 05:30:00	QQQ	ETF	105.15	105.15	105.15	105.15	500.0
2014-12-03 06:00:00	QQQ	ETF	105.19	105.2	105.19	105.19	3550.0
2014-12-03 06:30:00	QQQ	ETF	105.27	105.27	105.2	105.2	3076.0
2014-12-03 07:00:00	QQQ	ETF	105.24	105.24	105.18	105.18	1103.0
2014-12-03 07:30:00	QQQ	ETF	105.27	105.27	105.27	105.27	300.0
2014-12-03 08:00:00	QQQ	ETF	105.28	105.29	105.23	105.23	18574.0
2014-12-03 08:30:00	QQQ	ETF	105.22	105.24	105.18	105.18	19190.0
2014-12-03 09:00:00	QQQ	ETF	105.22	105.43	105.22	105.38	235565.0
2014-12-03 09:30:00	QQQ	ETF	105.38	105.52	105.08	105.14	4296918.0
2014-12-03 10:00:00	QQQ	ETF	105.15	105.2	104.7626	104.9239	3392634.0
2014-12-03 10:30:00	QQQ	ETF	104.924	105.145	104.915	105.02	1468467.0
2014-12-03 11:00:00	QQQ	ETF	105.01	105.18	104.98	105.15	1472369.0
2014-12-03 11:30:00	QQQ	ETF	105.16	105.24	105.1	105.19	1109112.0
2014-12-03 12:00:00	QQQ	ETF	105.19	105.2425	105.13	105.16	877932.0
2014-12-03 12:30:00	QQQ	ETF	105.155	105.22	105.09	105.17	936932.0
2014-12-03 13:00:00	QQQ	ETF	105.175	105.32	105.155	105.3	702707.0
2014-12-03 13:30:00	QQQ	ETF	105.3	105.4	105.29	105.39	991154.0

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

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