PREVIEW / etf_30min / 2017-07-20

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-07-20.parquet
  size:    425 KB
  rows:    14,652

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-07-20 04:00:00	SPY	ETF	247.1	247.28	247.1	247.15	11147.0
2017-07-20 04:30:00	SPY	ETF	247.18	247.26	247.16	247.26	18007.0
2017-07-20 05:00:00	SPY	ETF	247.11	247.11	247.05	247.11	1401.0
2017-07-20 05:30:00	SPY	ETF	247.16	247.19	247.12	247.12	3026.0
2017-07-20 06:00:00	SPY	ETF	247.12	247.18	247.12	247.18	3001.0
2017-07-20 06:30:00	SPY	ETF	247.19	247.19	247.1	247.1	3500.0
2017-07-20 07:00:00	SPY	ETF	247.08	247.13	247.08	247.13	10441.0
2017-07-20 07:30:00	SPY	ETF	247.14	247.23	247.1	247.23	36152.0
2017-07-20 08:00:00	SPY	ETF	247.1	247.46	247.1	247.44	159903.0
2017-07-20 08:30:00	SPY	ETF	247.44	247.5	247.1	247.19	279690.0
2017-07-20 09:00:00	SPY	ETF	247.2	247.37	247.2	247.27	223476.0
2017-07-20 09:30:00	SPY	ETF	247.28	247.42	247.09	247.28	4027575.0
2017-07-20 10:00:00	SPY	ETF	247.27	247.34	246.91	247.0435	2696780.0
2017-07-20 10:30:00	SPY	ETF	247.04	247.17	246.47	247.075	6922548.0
2017-07-20 11:00:00	SPY	ETF	247.08	247.26	246.82	246.845	2929747.0
2017-07-20 11:30:00	SPY	ETF	246.84	247.0	246.67	246.97	1961446.0
2017-07-20 12:00:00	SPY	ETF	246.96	247.25	246.91	247.22	1528089.0
2017-07-20 12:30:00	SPY	ETF	247.23	247.29	247.2	247.245	843046.0
2017-07-20 13:00:00	SPY	ETF	247.245	247.29	247.06	247.2436	1330064.0
2017-07-20 13:30:00	SPY	ETF	247.24	247.36	247.21	247.29	1415358.0
2017-07-20 14:00:00	SPY	ETF	247.295	247.295	247.14	247.185	1330860.0
2017-07-20 14:30:00	SPY	ETF	247.18	247.25	246.97	247.22	2118851.0
2017-07-20 15:00:00	SPY	ETF	247.22	247.33	247.17	247.32	2062282.0
2017-07-20 15:30:00	SPY	ETF	247.31	247.36	246.97	247.07	7981952.0
2017-07-20 16:00:00	SPY	ETF	247.07	247.1	246.95	246.97	7195851.0
2017-07-20 16:30:00	SPY	ETF	246.97	247.2	246.96	247.15	172987.0
2017-07-20 17:00:00	SPY	ETF	247.1	247.18	247.02	247.18	92558.0
2017-07-20 17:30:00	SPY	ETF	247.18	247.18	247.1	247.12	335598.0
2017-07-20 18:00:00	SPY	ETF	247.12	247.16	247.08	247.08	75756.0
2017-07-20 18:30:00	SPY	ETF	247.12	247.12	247.05	247.08	17199.0
2017-07-20 19:00:00	SPY	ETF	247.1	247.12	247.09	247.1	7448.0
2017-07-20 19:30:00	SPY	ETF	247.07	247.07	247.02	247.04	20563.0
2017-07-20 04:30:00	QQQ	ETF	144.06	144.06	144.06	144.06	1699.0
2017-07-20 05:00:00	QQQ	ETF	143.95	144.04	143.95	144.04	5100.0
2017-07-20 05:30:00	QQQ	ETF	144.05	144.05	144.04	144.04	900.0
2017-07-20 06:00:00	QQQ	ETF	144.03	144.08	144.03	144.08	2697.0
2017-07-20 06:30:00	QQQ	ETF	144.03	144.03	144.01	144.03	594.0
2017-07-20 07:00:00	QQQ	ETF	144.09	144.09	144.08	144.08	1684.0
2017-07-20 07:30:00	QQQ	ETF	144.1	144.25	144.08	144.21	49795.0
2017-07-20 08:00:00	QQQ	ETF	144.08	144.44	144.08	144.38	88944.0
2017-07-20 08:30:00	QQQ	ETF	144.38	144.42	144.2	144.31	173569.0
2017-07-20 09:00:00	QQQ	ETF	144.29	144.5	144.29	144.32	144048.0
2017-07-20 09:30:00	QQQ	ETF	144.31	144.44	144.03	144.25	3619194.0
2017-07-20 10:00:00	QQQ	ETF	144.25	144.25	143.77	143.99	2286334.0
2017-07-20 10:30:00	QQQ	ETF	144.0	144.11	143.52	143.99	4036951.0
2017-07-20 11:00:00	QQQ	ETF	143.99	144.23	143.95	144.03	1955582.0
2017-07-20 11:30:00	QQQ	ETF	144.03	144.2	143.92	144.14	1237917.0
2017-07-20 12:00:00	QQQ	ETF	144.13	144.33	144.125	144.2837	1148827.0
2017-07-20 12:30:00	QQQ	ETF	144.2822	144.32	144.18	144.18	665926.0
2017-07-20 13:00:00	QQQ	ETF	144.19	144.22	143.98	144.17	864490.0

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

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