PREVIEW / etf_30min / 2017-11-06

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-11-06.parquet
  size:    450 KB
  rows:    15,588

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-11-06 04:00:00	SPY	ETF	258.1	258.12	258.0	258.08	7200.0
2017-11-06 04:30:00	SPY	ETF	258.11	258.11	258.06	258.06	6000.0
2017-11-06 05:00:00	SPY	ETF	258.13	258.13	258.04	258.06	9100.0
2017-11-06 05:30:00	SPY	ETF	258.06	258.07	258.06	258.07	1200.0
2017-11-06 06:00:00	SPY	ETF	258.02	258.1	258.01	258.1	1504.0
2017-11-06 06:30:00	SPY	ETF	258.14	258.2	258.11	258.16	5601.0
2017-11-06 07:00:00	SPY	ETF	258.2	258.28	258.17	258.2	83615.0
2017-11-06 07:30:00	SPY	ETF	258.23	258.25	258.2	258.22	13862.0
2017-11-06 08:00:00	SPY	ETF	258.45	258.45	257.651	258.16	62286.0
2017-11-06 08:30:00	SPY	ETF	258.17	258.28	258.15	258.28	58723.0
2017-11-06 09:00:00	SPY	ETF	258.28	258.35	258.27	258.3	192601.0
2017-11-06 09:30:00	SPY	ETF	258.3	258.59	258.22	258.58	4549944.0
2017-11-06 10:00:00	SPY	ETF	258.585	258.7789	258.4401	258.66	2532850.0
2017-11-06 10:30:00	SPY	ETF	258.66	258.78	258.57	258.62	1978214.0
2017-11-06 11:00:00	SPY	ETF	258.61	258.8	258.52	258.7665	1464865.0
2017-11-06 11:30:00	SPY	ETF	258.77	258.8	258.52	258.56	2804417.0
2017-11-06 12:00:00	SPY	ETF	258.57	258.67	258.53	258.615	1283873.0
2017-11-06 12:30:00	SPY	ETF	258.62	258.825	258.62	258.78	2616466.0
2017-11-06 13:00:00	SPY	ETF	258.79	258.87	258.73	258.745	3000018.0
2017-11-06 13:30:00	SPY	ETF	258.745	258.89	258.74	258.84	925605.0
2017-11-06 14:00:00	SPY	ETF	258.83	258.87	258.78	258.845	929038.0
2017-11-06 14:30:00	SPY	ETF	258.845	258.94	258.75	258.94	1984102.0
2017-11-06 15:00:00	SPY	ETF	258.93	258.99	258.89	258.96	2202790.0
2017-11-06 15:30:00	SPY	ETF	258.96	259.0	258.78	258.82	11885452.0
2017-11-06 16:00:00	SPY	ETF	258.83	258.87	258.68	258.82	8549020.0
2017-11-06 16:30:00	SPY	ETF	258.83	258.85	258.78	258.83	1055391.0
2017-11-06 17:00:00	SPY	ETF	258.82	258.83	258.75	258.75	73831.0
2017-11-06 17:30:00	SPY	ETF	258.78	258.8	258.77	258.77	28132.0
2017-11-06 18:00:00	SPY	ETF	258.79	258.83	258.75	258.77	52515.0
2017-11-06 18:30:00	SPY	ETF	258.81	258.81	258.75	258.8	7743.0
2017-11-06 19:00:00	SPY	ETF	258.77	258.81	258.75	258.78	16616.0
2017-11-06 19:30:00	SPY	ETF	258.8	258.85	258.8	258.85	23403.0
2017-11-06 04:00:00	QQQ	ETF	153.11	153.17	153.11	153.17	2199.0
2017-11-06 04:30:00	QQQ	ETF	153.14	153.2	153.14	153.2	10700.0
2017-11-06 05:00:00	QQQ	ETF	153.17	153.18	153.15	153.18	1200.0
2017-11-06 05:30:00	QQQ	ETF	153.16	153.16	153.15	153.15	1200.0
2017-11-06 06:00:00	QQQ	ETF	153.07	153.13	153.07	153.13	10406.0
2017-11-06 06:30:00	QQQ	ETF	153.16	153.22	153.16	153.22	1821.0
2017-11-06 07:00:00	QQQ	ETF	153.24	153.3	153.21	153.23	14868.0
2017-11-06 07:30:00	QQQ	ETF	153.27	153.29	153.25	153.25	4000.0
2017-11-06 08:00:00	QQQ	ETF	153.255	153.26	153.16	153.25	45166.0
2017-11-06 08:30:00	QQQ	ETF	153.23	153.27	153.2	153.27	11722.0
2017-11-06 09:00:00	QQQ	ETF	153.29	153.3	153.12	153.13	98977.0
2017-11-06 09:30:00	QQQ	ETF	153.13	153.64	153.1	153.61	3096371.0
2017-11-06 10:00:00	QQQ	ETF	153.61	153.78	153.45	153.67	1147314.0
2017-11-06 10:30:00	QQQ	ETF	153.67	153.8	153.5801	153.64	847255.0
2017-11-06 11:00:00	QQQ	ETF	153.63	153.66	153.42	153.56	940906.0
2017-11-06 11:30:00	QQQ	ETF	153.56	153.58	153.28	153.3927	856458.0
2017-11-06 12:00:00	QQQ	ETF	153.4	153.62	153.38	153.55	530412.0
2017-11-06 12:30:00	QQQ	ETF	153.5551	153.64	153.5	153.59	521731.0

> showing 50 of 15,588 rows — these rows as CSV

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