PREVIEW / etf_30min / 2015-02-17

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-02-17.parquet
  size:    383 KB
  rows:    12,963

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
2015-02-17 04:00:00	SPY	ETF	209.16	209.16	208.91	208.91	659.0
2015-02-17 05:00:00	SPY	ETF	209.25	209.4	208.91	209.4	2300.0
2015-02-17 05:30:00	SPY	ETF	209.37	209.71	209.36	209.5	1375.0
2015-02-17 06:00:00	SPY	ETF	209.71	209.71	209.51	209.51	210.0
2015-02-17 06:30:00	SPY	ETF	209.65	209.7	209.55	209.58	14500.0
2015-02-17 07:00:00	SPY	ETF	209.73	209.73	209.59	209.62	46600.0
2015-02-17 07:30:00	SPY	ETF	209.7	209.75	209.6	209.6	22575.0
2015-02-17 08:00:00	SPY	ETF	209.65	209.76	209.39	209.42	221580.0
2015-02-17 08:30:00	SPY	ETF	209.38	209.55	209.34	209.54	400617.0
2015-02-17 09:00:00	SPY	ETF	209.54	209.58	209.36	209.38	734815.0
2015-02-17 09:30:00	SPY	ETF	209.4	209.62	209.1	209.47	10150468.0
2015-02-17 10:00:00	SPY	ETF	209.47	209.69	209.34	209.56	5057101.0
2015-02-17 10:30:00	SPY	ETF	209.561	209.68	209.3	209.39	5289236.0
2015-02-17 11:00:00	SPY	ETF	209.39	209.65	209.3	209.62	3496676.0
2015-02-17 11:30:00	SPY	ETF	209.61	209.74	209.58	209.7	3087661.0
2015-02-17 12:00:00	SPY	ETF	209.7	209.8	209.61	209.72	2528077.0
2015-02-17 12:30:00	SPY	ETF	209.7161	209.96	209.68	209.91	3731955.0
2015-02-17 13:00:00	SPY	ETF	209.91	210.32	209.86	210.28	4698118.0
2015-02-17 13:30:00	SPY	ETF	210.275	210.32	210.05	210.14	3601026.0
2015-02-17 14:00:00	SPY	ETF	210.14	210.18	210.0	210.06	4599972.0
2015-02-17 14:30:00	SPY	ETF	210.065	210.18	209.92	209.96	3564494.0
2015-02-17 15:00:00	SPY	ETF	209.97	210.18	209.91	210.09	3935487.0
2015-02-17 15:30:00	SPY	ETF	210.095	210.16	209.8	210.16	10546873.0
2015-02-17 16:00:00	SPY	ETF	210.16	210.24	209.52	210.05	7395338.0
2015-02-17 16:30:00	SPY	ETF	210.06	210.22	210.05	210.21	2896405.0
2015-02-17 17:00:00	SPY	ETF	210.22	210.22	210.08	210.11	39439.0
2015-02-17 17:30:00	SPY	ETF	210.11	210.14	210.09	210.14	9875.0
2015-02-17 18:00:00	SPY	ETF	210.13	210.13	210.02	210.049	47951.0
2015-02-17 18:30:00	SPY	ETF	210.04	210.14	210.04	210.14	7250.0
2015-02-17 19:00:00	SPY	ETF	210.1	210.15	210.1	210.1	4896.0
2015-02-17 19:30:00	SPY	ETF	210.09	210.12	210.08	210.11	11710.0
2015-02-17 04:00:00	QQQ	ETF	106.85	106.85	106.63	106.63	400.0
2015-02-17 06:00:00	QQQ	ETF	106.53	106.96	106.53	106.96	2506.0
2015-02-17 06:30:00	QQQ	ETF	106.91	106.91	106.91	106.91	1000.0
2015-02-17 07:00:00	QQQ	ETF	106.91	106.99	106.91	106.99	5390.0
2015-02-17 07:30:00	QQQ	ETF	106.98	107.01	106.97	106.97	18700.0
2015-02-17 08:00:00	QQQ	ETF	106.98	107.0	106.88	106.89	95028.0
2015-02-17 08:30:00	QQQ	ETF	106.88	106.93	106.84	106.92	123808.0
2015-02-17 09:00:00	QQQ	ETF	106.92	106.95	106.88	106.89	123050.0
2015-02-17 09:30:00	QQQ	ETF	106.91	106.95	106.6432	106.82	2996486.0
2015-02-17 10:00:00	QQQ	ETF	106.82	106.97	106.77	106.93	1390528.0
2015-02-17 10:30:00	QQQ	ETF	106.94	107.02	106.701	106.77	1188980.0
2015-02-17 11:00:00	QQQ	ETF	106.77	106.93	106.7	106.9	583094.0
2015-02-17 11:30:00	QQQ	ETF	106.89	106.93	106.8035	106.8999	678567.0
2015-02-17 12:00:00	QQQ	ETF	106.9	106.95	106.7751	106.835	577655.0
2015-02-17 12:30:00	QQQ	ETF	106.83	106.93	106.79	106.84	532635.0
2015-02-17 13:00:00	QQQ	ETF	106.835	107.08	106.83	107.05	1349670.0
2015-02-17 13:30:00	QQQ	ETF	107.054	107.06	106.869	106.92	585783.0
2015-02-17 14:00:00	QQQ	ETF	106.9234	106.94	106.82	106.9	542269.0
2015-02-17 14:30:00	QQQ	ETF	106.901	106.97	106.84	106.88	528313.0

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

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