PREVIEW / etf_30min / 2017-02-07

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-02-07.parquet
  size:    434 KB
  rows:    14,858

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-02-07 04:00:00	SPY	ETF	228.97	229.0	228.95	228.95	1720.0
2017-02-07 04:30:00	SPY	ETF	228.98	229.26	228.98	229.22	4500.0
2017-02-07 05:00:00	SPY	ETF	229.2	229.28	229.16	229.16	13260.0
2017-02-07 05:30:00	SPY	ETF	229.16	229.18	229.15	229.15	3500.0
2017-02-07 06:00:00	SPY	ETF	229.2	229.46	229.2	229.41	22710.0
2017-02-07 06:30:00	SPY	ETF	229.41	229.55	229.41	229.49	44014.0
2017-02-07 07:00:00	SPY	ETF	229.5	229.51	229.4	229.46	28580.0
2017-02-07 07:30:00	SPY	ETF	229.49	229.56	229.37	229.4	44820.0
2017-02-07 08:00:00	SPY	ETF	229.46	229.55	229.31	229.39	167196.0
2017-02-07 08:30:00	SPY	ETF	229.39	229.4	229.31	229.34	105164.0
2017-02-07 09:00:00	SPY	ETF	229.34	229.43	229.32	229.39	296766.0
2017-02-07 09:30:00	SPY	ETF	229.38	229.6556	229.2	229.47	5088550.0
2017-02-07 10:00:00	SPY	ETF	229.47	229.62	229.39	229.48	3942245.0
2017-02-07 10:30:00	SPY	ETF	229.475	229.57	229.369	229.5	3275925.0
2017-02-07 11:00:00	SPY	ETF	229.495	229.62	229.08	229.15	6154781.0
2017-02-07 11:30:00	SPY	ETF	229.15	229.32	229.12	229.25	3565523.0
2017-02-07 12:00:00	SPY	ETF	229.245	229.4	228.9227	228.97	4658128.0
2017-02-07 12:30:00	SPY	ETF	228.97	229.1	228.72	228.81	5489267.0
2017-02-07 13:00:00	SPY	ETF	228.8	229.0	228.72	228.945	2543480.0
2017-02-07 13:30:00	SPY	ETF	228.94	229.25	228.92	228.9925	1573751.0
2017-02-07 14:00:00	SPY	ETF	229.0	229.08	228.865	228.95	3507220.0
2017-02-07 14:30:00	SPY	ETF	228.95	229.07	228.9	229.0	1344079.0
2017-02-07 15:00:00	SPY	ETF	229.005	229.175	228.93	229.01	3307772.0
2017-02-07 15:30:00	SPY	ETF	229.01	229.015	228.79	228.97	6928466.0
2017-02-07 16:00:00	SPY	ETF	228.97	229.04	228.93	228.95	2149685.0
2017-02-07 16:30:00	SPY	ETF	228.96	228.97	228.77	228.78	376184.0
2017-02-07 17:00:00	SPY	ETF	228.8	228.94	228.7	228.8	2115831.0
2017-02-07 17:30:00	SPY	ETF	228.79	228.79	228.74	228.74	11837.0
2017-02-07 18:00:00	SPY	ETF	228.76	228.77	228.61	228.77	55816.0
2017-02-07 18:30:00	SPY	ETF	228.74	228.81	228.72	228.72	18449.0
2017-02-07 19:00:00	SPY	ETF	228.77	228.82	228.77	228.82	16800.0
2017-02-07 19:30:00	SPY	ETF	228.81	228.83	228.78	228.83	12120.0
2017-02-07 04:00:00	QQQ	ETF	125.83	125.83	125.83	125.83	100.0
2017-02-07 04:30:00	QQQ	ETF	125.79	125.92	125.79	125.92	2476.0
2017-02-07 05:00:00	QQQ	ETF	125.96	125.96	125.92	125.92	340.0
2017-02-07 05:30:00	QQQ	ETF	125.91	125.95	125.91	125.95	10000.0
2017-02-07 06:00:00	QQQ	ETF	125.98	126.05	125.98	126.04	6927.0
2017-02-07 06:30:00	QQQ	ETF	126.02	126.09	126.02	126.09	12200.0
2017-02-07 07:00:00	QQQ	ETF	126.02	126.04	126.0	126.04	2200.0
2017-02-07 07:30:00	QQQ	ETF	126.07	126.07	125.99	126.02	4750.0
2017-02-07 08:00:00	QQQ	ETF	126.0	126.02	125.98	126.0	8615.0
2017-02-07 08:30:00	QQQ	ETF	126.0	126.0	125.98	125.99	5639.0
2017-02-07 09:00:00	QQQ	ETF	126.01	126.09	126.0	126.06	61053.0
2017-02-07 09:30:00	QQQ	ETF	126.06	126.2899	125.97	126.23	1835114.0
2017-02-07 10:00:00	QQQ	ETF	126.23	126.395	126.2064	126.28	1017591.0
2017-02-07 10:30:00	QQQ	ETF	126.279	126.51	126.27	126.472	1103872.0
2017-02-07 11:00:00	QQQ	ETF	126.47	126.55	126.28	126.34	691495.0
2017-02-07 11:30:00	QQQ	ETF	126.34	126.44	126.2925	126.4059	536093.0
2017-02-07 12:00:00	QQQ	ETF	126.4	126.46	126.23	126.26	439608.0
2017-02-07 12:30:00	QQQ	ETF	126.25	126.32	126.07	126.151	719100.0

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

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