PREVIEW / etf_30min / 2014-02-24

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-02-24.parquet
  size:    345 KB
  rows:    11,658

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-24 04:00:00	SPY	ETF	184.0	184.4	184.0	184.4	4363.0
2014-02-24 04:30:00	SPY	ETF	184.28	184.31	184.15	184.19	4413.0
2014-02-24 05:00:00	SPY	ETF	184.15	184.15	183.95	184.02	27653.0
2014-02-24 05:30:00	SPY	ETF	184.0	184.05	183.98	183.98	23400.0
2014-02-24 06:00:00	SPY	ETF	183.98	184.09	183.98	184.06	23188.0
2014-02-24 06:30:00	SPY	ETF	184.06	184.32	184.06	184.32	56510.0
2014-02-24 07:00:00	SPY	ETF	184.29	184.47	184.29	184.35	322120.0
2014-02-24 07:30:00	SPY	ETF	184.36	184.44	184.33	184.37	271450.0
2014-02-24 08:00:00	SPY	ETF	184.38	184.59	184.33	184.49	341118.0
2014-02-24 08:30:00	SPY	ETF	184.48	184.49	184.32	184.36	225857.0
2014-02-24 09:00:00	SPY	ETF	184.36	184.41	184.19	184.28	397636.0
2014-02-24 09:30:00	SPY	ETF	184.28	185.45	184.2	185.36	15583246.0
2014-02-24 10:00:00	SPY	ETF	185.37	185.45	185.155	185.31	8390459.0
2014-02-24 10:30:00	SPY	ETF	185.31	185.6928	185.27	185.55	7158529.0
2014-02-24 11:00:00	SPY	ETF	185.56	185.75	185.46	185.75	5320627.0
2014-02-24 11:30:00	SPY	ETF	185.75	186.11	185.72	186.04	7658774.0
2014-02-24 12:00:00	SPY	ETF	186.04	186.15	186.03	186.06	5268474.0
2014-02-24 12:30:00	SPY	ETF	186.06	186.07	185.91	185.935	3632526.0
2014-02-24 13:00:00	SPY	ETF	185.93	185.96	185.85	185.91	3568477.0
2014-02-24 13:30:00	SPY	ETF	185.91	186.0	185.73	185.75	4027194.0
2014-02-24 14:00:00	SPY	ETF	185.75	185.97	185.74	185.83	3214770.0
2014-02-24 14:30:00	SPY	ETF	185.835	185.91	185.71	185.71	3243588.0
2014-02-24 15:00:00	SPY	ETF	185.72	185.72	185.25	185.255	9421331.0
2014-02-24 15:30:00	SPY	ETF	185.255	185.51	184.98	184.99	18507727.0
2014-02-24 16:00:00	SPY	ETF	184.95	186.12	183.885	185.03	9505546.0
2014-02-24 16:30:00	SPY	ETF	185.05	185.08	184.95	184.96	4406119.0
2014-02-24 17:00:00	SPY	ETF	184.99	184.99	184.92	184.93	96885.0
2014-02-24 17:30:00	SPY	ETF	184.92	184.97	184.88	184.92	77840.0
2014-02-24 18:00:00	SPY	ETF	184.92	184.94	184.83	184.91	58749.0
2014-02-24 18:30:00	SPY	ETF	184.91	184.99	184.91	184.99	11603.0
2014-02-24 19:00:00	SPY	ETF	185.0	185.08	184.99	184.99	75300.0
2014-02-24 19:30:00	SPY	ETF	185.04	185.09	185.03	185.07	31033.0
2014-02-24 04:00:00	QQQ	ETF	90.03	90.15	90.0	90.15	7710.0
2014-02-24 04:30:00	QQQ	ETF	90.13	90.13	90.08	90.08	1000.0
2014-02-24 05:00:00	QQQ	ETF	90.03	90.03	89.94	89.94	5000.0
2014-02-24 05:30:00	QQQ	ETF	89.99	89.99	89.99	89.99	2000.0
2014-02-24 06:00:00	QQQ	ETF	89.96	89.96	89.96	89.96	451.0
2014-02-24 06:30:00	QQQ	ETF	90.05	90.07	90.05	90.07	1300.0
2014-02-24 07:00:00	QQQ	ETF	90.16	90.16	90.12	90.13	7310.0
2014-02-24 07:30:00	QQQ	ETF	90.14	90.14	90.11	90.13	16000.0
2014-02-24 08:00:00	QQQ	ETF	90.11	90.25	90.1	90.21	111162.0
2014-02-24 08:30:00	QQQ	ETF	90.21	90.22	90.12	90.14	51631.0
2014-02-24 09:00:00	QQQ	ETF	90.13	90.18	90.07	90.11	93796.0
2014-02-24 09:30:00	QQQ	ETF	90.1	90.58	90.04	90.545	4136125.0
2014-02-24 10:00:00	QQQ	ETF	90.55	90.6	90.46	90.5696	2004254.0
2014-02-24 10:30:00	QQQ	ETF	90.57	90.71	90.52	90.6619	2986506.0
2014-02-24 11:00:00	QQQ	ETF	90.67	90.74	90.595	90.72	914356.0
2014-02-24 11:30:00	QQQ	ETF	90.73	90.79	90.69	90.7401	1258620.0
2014-02-24 12:00:00	QQQ	ETF	90.74	90.8	90.731	90.76	769443.0
2014-02-24 12:30:00	QQQ	ETF	90.76	90.77	90.65	90.66	477098.0

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

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