PREVIEW / etf_30min / 2017-04-11

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-04-11.parquet
  size:    428 KB
  rows:    14,471

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
2017-04-11 04:00:00	SPY	ETF	235.19	235.25	234.99	234.99	3200.0
2017-04-11 04:30:00	SPY	ETF	235.0	235.05	234.86	234.9	4108.0
2017-04-11 05:00:00	SPY	ETF	235.03	235.03	234.89	234.9	1300.0
2017-04-11 05:30:00	SPY	ETF	235.02	235.12	235.0	235.12	2300.0
2017-04-11 06:00:00	SPY	ETF	235.15	235.34	235.13	235.24	56416.0
2017-04-11 06:30:00	SPY	ETF	235.21	235.21	235.15	235.15	900.0
2017-04-11 07:00:00	SPY	ETF	235.24	235.25	235.08	235.09	76144.0
2017-04-11 07:30:00	SPY	ETF	235.15	235.15	234.96	234.98	50431.0
2017-04-11 08:00:00	SPY	ETF	235.0	235.22	234.9	234.95	145063.0
2017-04-11 08:30:00	SPY	ETF	234.97	235.16	234.95	235.07	119591.0
2017-04-11 09:00:00	SPY	ETF	235.07	235.07	234.81	234.87	326822.0
2017-04-11 09:30:00	SPY	ETF	234.9	235.18	234.09	234.5	10832274.0
2017-04-11 10:00:00	SPY	ETF	234.495	234.731	234.02	234.23	7011737.0
2017-04-11 10:30:00	SPY	ETF	234.2348	234.24	233.34	233.66	9841879.0
2017-04-11 11:00:00	SPY	ETF	233.66	234.01	233.48	233.63	7071304.0
2017-04-11 11:30:00	SPY	ETF	233.64	234.05	233.58	233.93	5812405.0
2017-04-11 12:00:00	SPY	ETF	233.93	234.54	233.75	234.5	4736804.0
2017-04-11 12:30:00	SPY	ETF	234.51	234.65	234.36	234.56	4682227.0
2017-04-11 13:00:00	SPY	ETF	234.56	234.94	234.56	234.7	3720345.0
2017-04-11 13:30:00	SPY	ETF	234.7	234.87	234.43	234.62	4346054.0
2017-04-11 14:00:00	SPY	ETF	234.62	234.78	234.3	234.6438	2940922.0
2017-04-11 14:30:00	SPY	ETF	234.645	235.015	234.56	234.8099	4119093.0
2017-04-11 15:00:00	SPY	ETF	234.8	234.845	234.24	234.5401	4336153.0
2017-04-11 15:30:00	SPY	ETF	234.54	235.06	234.5	235.04	8907916.0
2017-04-11 16:00:00	SPY	ETF	235.03	235.2	234.93	235.15	6759408.0
2017-04-11 16:30:00	SPY	ETF	235.15	235.34	235.06	235.17	916498.0
2017-04-11 17:00:00	SPY	ETF	235.18	235.22	235.14	235.17	145316.0
2017-04-11 17:30:00	SPY	ETF	235.18	235.2	235.18	235.19	39708.0
2017-04-11 18:00:00	SPY	ETF	235.18	235.22	235.03	235.06	91192.0
2017-04-11 18:30:00	SPY	ETF	235.07	235.12	235.05	235.08	44840.0
2017-04-11 19:00:00	SPY	ETF	235.09	235.11	235.05	235.11	19458.0
2017-04-11 19:30:00	SPY	ETF	235.12	235.12	235.0	235.03	51554.0
2017-04-11 04:30:00	QQQ	ETF	131.91	131.91	131.91	131.91	400.0
2017-04-11 05:30:00	QQQ	ETF	131.93	132.03	131.93	132.03	14455.0
2017-04-11 06:00:00	QQQ	ETF	132.01	132.05	132.01	132.05	346.0
2017-04-11 06:30:00	QQQ	ETF	132.02	132.04	132.02	132.04	10479.0
2017-04-11 07:00:00	QQQ	ETF	132.02	132.02	132.0	132.0	2300.0
2017-04-11 07:30:00	QQQ	ETF	131.99	131.99	131.99	131.99	500.0
2017-04-11 08:00:00	QQQ	ETF	131.83	131.98	131.83	131.89	96331.0
2017-04-11 08:30:00	QQQ	ETF	131.89	132.02	131.89	131.99	5393.0
2017-04-11 09:00:00	QQQ	ETF	131.96	131.96	131.85	131.87	179884.0
2017-04-11 09:30:00	QQQ	ETF	131.86	132.095	131.08	131.31	3980166.0
2017-04-11 10:00:00	QQQ	ETF	131.31	131.45	130.82	131.0	3721342.0
2017-04-11 10:30:00	QQQ	ETF	130.99	131.0	130.5	130.76	3930798.0
2017-04-11 11:00:00	QQQ	ETF	130.76	130.93	130.57	130.7	1599891.0
2017-04-11 11:30:00	QQQ	ETF	130.705	131.02	130.68	130.905	1252807.0
2017-04-11 12:00:00	QQQ	ETF	130.91	131.371	130.8208	131.31	1052567.0
2017-04-11 12:30:00	QQQ	ETF	131.31	131.46	131.24	131.375	1351818.0
2017-04-11 13:00:00	QQQ	ETF	131.38	131.62	131.3664	131.445	1039959.0
2017-04-11 13:30:00	QQQ	ETF	131.45	131.53	131.245	131.3264	795642.0

> showing 50 of 14,471 rows — these rows as CSV

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