PREVIEW / etf_30min / 2013-11-19

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-11-19.parquet
  size:    330 KB
  rows:    11,084

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
2013-11-19 04:00:00	SPY	ETF	179.22	179.32	179.09	179.19	19949.0
2013-11-19 04:30:00	SPY	ETF	179.2	179.22	179.12	179.17	12207.0
2013-11-19 05:00:00	SPY	ETF	179.17	179.18	178.99	179.05	17178.0
2013-11-19 05:30:00	SPY	ETF	179.06	179.21	179.05	179.16	66833.0
2013-11-19 06:00:00	SPY	ETF	179.15	179.26	179.15	179.23	107779.0
2013-11-19 06:30:00	SPY	ETF	179.23	179.26	179.1	179.13	62871.0
2013-11-19 07:00:00	SPY	ETF	179.13	179.16	178.94	179.01	302918.0
2013-11-19 07:30:00	SPY	ETF	179.0	179.12	178.98	179.08	73477.0
2013-11-19 08:00:00	SPY	ETF	179.07	179.18	178.96	179.12	167151.0
2013-11-19 08:30:00	SPY	ETF	179.15	179.33	179.13	179.29	294498.0
2013-11-19 09:00:00	SPY	ETF	179.28	179.48	179.25	179.32	647347.0
2013-11-19 09:30:00	SPY	ETF	179.33	179.49	178.88	179.39	11398912.0
2013-11-19 10:00:00	SPY	ETF	179.39	179.77	179.38	179.54	6514595.0
2013-11-19 10:30:00	SPY	ETF	179.55	179.87	179.51	179.685	8126492.0
2013-11-19 11:00:00	SPY	ETF	179.69	179.71	179.29	179.38	4720016.0
2013-11-19 11:30:00	SPY	ETF	179.37	179.45	179.14	179.3799	4889038.0
2013-11-19 12:00:00	SPY	ETF	179.38	179.7	179.31	179.645	5305121.0
2013-11-19 12:30:00	SPY	ETF	179.64	179.67	179.32	179.33	2286185.0
2013-11-19 13:00:00	SPY	ETF	179.325	179.36	178.86	178.89	5355169.0
2013-11-19 13:30:00	SPY	ETF	178.88	179.09	178.75	178.82	6654759.0
2013-11-19 14:00:00	SPY	ETF	178.82	179.4406	178.72	178.82	6850384.0
2013-11-19 14:30:00	SPY	ETF	178.81	179.33	178.8	179.07	7580234.0
2013-11-19 15:00:00	SPY	ETF	179.07	179.45	179.05	179.24	5464079.0
2013-11-19 15:30:00	SPY	ETF	179.245	179.28	178.92	179.04	10778955.0
2013-11-19 16:00:00	SPY	ETF	179.05	179.4406	178.97	179.06	2707087.0
2013-11-19 16:30:00	SPY	ETF	179.06	179.06	179.0	179.06	1262854.0
2013-11-19 17:00:00	SPY	ETF	179.04	179.06	179.0	179.03	11458.0
2013-11-19 17:30:00	SPY	ETF	179.02	179.03	179.01	179.03	11535.0
2013-11-19 18:00:00	SPY	ETF	179.05	179.45	179.03	179.45	290688.0
2013-11-19 18:30:00	SPY	ETF	179.44	179.52	179.27	179.34	310186.0
2013-11-19 19:00:00	SPY	ETF	179.32	179.33	179.14	179.14	85394.0
2013-11-19 19:30:00	SPY	ETF	179.17	179.19	178.95	178.95	136311.0
2013-11-19 05:00:00	QQQ	ETF	82.9	82.9	82.9	82.9	100.0
2013-11-19 06:00:00	QQQ	ETF	83.02	83.03	83.02	83.03	13100.0
2013-11-19 06:30:00	QQQ	ETF	83.05	83.07	82.98	82.98	10900.0
2013-11-19 07:00:00	QQQ	ETF	82.99	83.0	82.94	82.95	9500.0
2013-11-19 07:30:00	QQQ	ETF	82.92	83.01	82.92	83.01	16600.0
2013-11-19 08:00:00	QQQ	ETF	83.01	83.07	82.94	83.05	16456.0
2013-11-19 08:30:00	QQQ	ETF	83.07	83.15	83.07	83.11	26985.0
2013-11-19 09:00:00	QQQ	ETF	83.1	83.19	83.08	83.1	322330.0
2013-11-19 09:30:00	QQQ	ETF	83.09	83.33	82.91	83.32	5428170.0
2013-11-19 10:00:00	QQQ	ETF	83.32	83.49	83.26	83.26	2278069.0
2013-11-19 10:30:00	QQQ	ETF	83.26	83.42	83.225	83.305	1633817.0
2013-11-19 11:00:00	QQQ	ETF	83.31	83.34	83.15	83.2	1161907.0
2013-11-19 11:30:00	QQQ	ETF	83.19	83.22	83.08	83.209	1122731.0
2013-11-19 12:00:00	QQQ	ETF	83.2001	83.3693	83.14	83.32	1126037.0
2013-11-19 12:30:00	QQQ	ETF	83.33	83.36	83.09	83.09	535461.0
2013-11-19 13:00:00	QQQ	ETF	83.09	83.11	82.83	82.85	1666824.0
2013-11-19 13:30:00	QQQ	ETF	82.84	82.93	82.76	82.8099	1505968.0
2013-11-19 14:00:00	QQQ	ETF	82.8	82.92	82.76	82.775	1841994.0

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

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