PREVIEW / etf_30min / 2017-11-24

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-11-24.parquet
  size:    254 KB
  rows:    8,570

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-24 04:00:00	SPY	ETF	259.8	259.97	259.8	259.9	3800.0
2017-11-24 05:00:00	SPY	ETF	259.9	260.0	259.9	259.99	884.0
2017-11-24 05:30:00	SPY	ETF	260.04	260.1	260.04	260.1	8304.0
2017-11-24 06:00:00	SPY	ETF	260.06	260.4	260.06	260.18	7955.0
2017-11-24 06:30:00	SPY	ETF	260.26	260.35	260.26	260.33	42114.0
2017-11-24 07:00:00	SPY	ETF	260.29	260.4	260.29	260.37	103930.0
2017-11-24 07:30:00	SPY	ETF	260.37	260.38	260.25	260.35	50144.0
2017-11-24 08:00:00	SPY	ETF	260.27	260.42	260.25	260.4	331149.0
2017-11-24 08:30:00	SPY	ETF	260.4	260.42	260.27	260.3	382895.0
2017-11-24 09:00:00	SPY	ETF	260.31	260.33	260.26	260.28	372172.0
2017-11-24 09:30:00	SPY	ETF	260.32	260.32	260.17	260.273	4127622.0
2017-11-24 10:00:00	SPY	ETF	260.28	260.33	260.16	260.28	2994862.0
2017-11-24 10:30:00	SPY	ETF	260.29	260.36	260.24	260.3289	2265205.0
2017-11-24 11:00:00	SPY	ETF	260.32	260.48	260.32	260.39	1417235.0
2017-11-24 11:30:00	SPY	ETF	260.3954	260.46	260.33	260.38	1734426.0
2017-11-24 12:00:00	SPY	ETF	260.38	260.48	260.37	260.45	1547202.0
2017-11-24 12:30:00	SPY	ETF	260.445	260.48	260.26	260.34	5764508.0
2017-11-24 13:00:00	SPY	ETF	260.35	260.45	260.18	260.2	2156216.0
2017-11-24 13:30:00	SPY	ETF	260.2	260.2	260.01	260.01	358651.0
2017-11-24 14:00:00	SPY	ETF	260.01	260.03	259.8	260.03	376484.0
2017-11-24 14:30:00	SPY	ETF	260.04	260.14	260.04	260.14	30422.0
2017-11-24 15:00:00	SPY	ETF	260.15	260.15	260.1	260.12	6397.0
2017-11-24 15:30:00	SPY	ETF	260.11	260.16	260.09	260.12	4350.0
2017-11-24 16:00:00	SPY	ETF	260.15	260.2	260.03	260.03	43538.0
2017-11-24 16:30:00	SPY	ETF	260.03	260.03	259.83	259.85	69152.0
2017-11-24 04:00:00	QQQ	ETF	155.74	155.79	155.74	155.75	15636.0
2017-11-24 04:30:00	QQQ	ETF	155.79	155.8	155.78	155.8	6300.0
2017-11-24 05:00:00	QQQ	ETF	155.8	155.8	155.8	155.8	500.0
2017-11-24 06:00:00	QQQ	ETF	155.86	155.87	155.86	155.87	4288.0
2017-11-24 06:30:00	QQQ	ETF	155.89	155.92	155.88	155.88	13067.0
2017-11-24 07:00:00	QQQ	ETF	155.87	155.91	155.84	155.9	28999.0
2017-11-24 07:30:00	QQQ	ETF	155.9	155.91	155.88	155.91	6669.0
2017-11-24 08:00:00	QQQ	ETF	155.86	156.0	155.86	155.96	57947.0
2017-11-24 08:30:00	QQQ	ETF	155.96	155.96	155.9	155.91	61297.0
2017-11-24 09:00:00	QQQ	ETF	155.69	156.0	155.69	155.84	195201.0
2017-11-24 09:30:00	QQQ	ETF	155.86	155.98	155.76	155.96	1149468.0
2017-11-24 10:00:00	QQQ	ETF	155.96	156.01	155.83	155.945	562216.0
2017-11-24 10:30:00	QQQ	ETF	155.95	156.135	155.95	156.1	461280.0
2017-11-24 11:00:00	QQQ	ETF	156.0985	156.28	156.0985	156.209	720422.0
2017-11-24 11:30:00	QQQ	ETF	156.21	156.31	156.17	156.2	619465.0
2017-11-24 12:00:00	QQQ	ETF	156.2	156.2993	156.1909	156.25	697244.0
2017-11-24 12:30:00	QQQ	ETF	156.25	156.28	156.19	156.25	1559971.0
2017-11-24 13:00:00	QQQ	ETF	156.25	156.33	156.15	156.15	413734.0
2017-11-24 13:30:00	QQQ	ETF	156.15	156.16	156.09	156.1	30376.0
2017-11-24 14:00:00	QQQ	ETF	156.11	156.11	156.01	156.09	16887.0
2017-11-24 14:30:00	QQQ	ETF	156.14	156.19	156.14	156.1437	2812.0
2017-11-24 15:00:00	QQQ	ETF	156.15	156.16	156.15	156.16	1827.0
2017-11-24 15:30:00	QQQ	ETF	156.12	156.14	156.1	156.14	5296.0
2017-11-24 16:00:00	QQQ	ETF	156.11	156.11	156.04	156.05	5694.0
2017-11-24 16:30:00	QQQ	ETF	156.06	156.11	155.99	156.05	14541.0

> showing 50 of 8,570 rows — these rows as CSV

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