PREVIEW / etf_30min / 2014-02-19

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-02-19.parquet
  size:    346 KB
  rows:    11,534

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-19 04:00:00	SPY	ETF	184.0	184.08	184.0	184.03	2604.0
2014-02-19 04:30:00	SPY	ETF	184.05	184.08	184.03	184.07	14738.0
2014-02-19 05:00:00	SPY	ETF	184.04	184.07	183.9	183.92	107704.0
2014-02-19 05:30:00	SPY	ETF	183.92	183.95	183.82	183.82	30555.0
2014-02-19 06:00:00	SPY	ETF	183.89	183.89	183.76	183.76	25629.0
2014-02-19 06:30:00	SPY	ETF	183.75	183.75	183.54	183.6	36209.0
2014-02-19 07:00:00	SPY	ETF	183.58	183.68	183.54	183.67	125335.0
2014-02-19 07:30:00	SPY	ETF	183.67	183.68	183.54	183.66	95867.0
2014-02-19 08:00:00	SPY	ETF	183.66	183.76	183.56	183.7	342424.0
2014-02-19 08:30:00	SPY	ETF	183.65	183.91	183.58	183.78	698110.0
2014-02-19 09:00:00	SPY	ETF	183.78	183.81	183.64	183.75	844054.0
2014-02-19 09:30:00	SPY	ETF	183.76	184.46	183.64	184.45	9747468.0
2014-02-19 10:00:00	SPY	ETF	184.4501	184.94	184.24	184.88	10420404.0
2014-02-19 10:30:00	SPY	ETF	184.88	184.95	184.625	184.67	9167520.0
2014-02-19 11:00:00	SPY	ETF	184.68	184.75	184.53	184.6	4784228.0
2014-02-19 11:30:00	SPY	ETF	184.605	184.73	184.11	184.11	5061529.0
2014-02-19 12:00:00	SPY	ETF	184.11	184.19	183.57	183.73	11532858.0
2014-02-19 12:30:00	SPY	ETF	183.72	183.91	183.72	183.88	4940700.0
2014-02-19 13:00:00	SPY	ETF	183.88	184.27	183.85	184.185	3915003.0
2014-02-19 13:30:00	SPY	ETF	184.189	184.26	183.98	184.0	3038310.0
2014-02-19 14:00:00	SPY	ETF	184.0	184.4101	183.735	184.1	10896982.0
2014-02-19 14:30:00	SPY	ETF	184.1	184.13	183.66	183.86	6248015.0
2014-02-19 15:00:00	SPY	ETF	183.855	184.21	183.22	183.22	9068769.0
2014-02-19 15:30:00	SPY	ETF	183.225	183.32	182.87	183.02	19360376.0
2014-02-19 16:00:00	SPY	ETF	183.02	184.2786	182.99	183.14	10628811.0
2014-02-19 16:30:00	SPY	ETF	183.14	183.3	183.12	183.15	2800906.0
2014-02-19 17:00:00	SPY	ETF	183.15	183.19	183.11	183.18	30646.0
2014-02-19 17:30:00	SPY	ETF	183.14	183.2	183.1	183.16	45471.0
2014-02-19 18:00:00	SPY	ETF	183.16	183.38	183.13	183.36	457520.0
2014-02-19 18:30:00	SPY	ETF	183.36	183.36	183.22	183.24	21807.0
2014-02-19 19:00:00	SPY	ETF	183.24	183.34	183.24	183.3	15555.0
2014-02-19 19:30:00	SPY	ETF	183.26	183.35	183.26	183.3	21873.0
2014-02-19 04:00:00	QQQ	ETF	90.19	90.19	90.19	90.19	200.0
2014-02-19 04:30:00	QQQ	ETF	90.23	90.23	90.21	90.21	9300.0
2014-02-19 05:00:00	QQQ	ETF	90.23	90.23	90.13	90.13	1050.0
2014-02-19 05:30:00	QQQ	ETF	90.11	90.11	90.11	90.11	5000.0
2014-02-19 06:00:00	QQQ	ETF	90.1	90.1	90.1	90.1	200.0
2014-02-19 06:30:00	QQQ	ETF	90.01	90.01	89.98	90.0	3800.0
2014-02-19 07:00:00	QQQ	ETF	89.98	90.0	89.92	89.98	43576.0
2014-02-19 07:30:00	QQQ	ETF	89.98	90.02	89.96	90.01	13600.0
2014-02-19 08:00:00	QQQ	ETF	90.01	90.04	89.97	90.02	30512.0
2014-02-19 08:30:00	QQQ	ETF	90.01	90.11	90.0	90.1	130344.0
2014-02-19 09:00:00	QQQ	ETF	90.08	90.1	90.03	90.05	36454.0
2014-02-19 09:30:00	QQQ	ETF	90.07	90.26	89.93	90.11	3925914.0
2014-02-19 10:00:00	QQQ	ETF	90.11	90.2299	89.88	90.2	3661318.0
2014-02-19 10:30:00	QQQ	ETF	90.2	90.285	90.11	90.145	1968942.0
2014-02-19 11:00:00	QQQ	ETF	90.145	90.22	90.14	90.15	2889105.0
2014-02-19 11:30:00	QQQ	ETF	90.15	90.21	89.91	89.91	1835489.0
2014-02-19 12:00:00	QQQ	ETF	89.91	89.94	89.66	89.73	2805567.0
2014-02-19 12:30:00	QQQ	ETF	89.72	89.88	89.72	89.861	1120675.0

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

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