PREVIEW / etf_30min / 2017-09-13

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-09-13.parquet
  size:    423 KB
  rows:    14,763

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-09-13 04:00:00	SPY	ETF	249.8	249.8	249.7	249.79	2055.0
2017-09-13 04:30:00	SPY	ETF	249.73	249.73	249.73	249.73	300.0
2017-09-13 05:00:00	SPY	ETF	249.78	249.8	249.73	249.77	7500.0
2017-09-13 05:30:00	SPY	ETF	249.78	249.78	249.7	249.71	8600.0
2017-09-13 06:00:00	SPY	ETF	249.72	249.72	249.71	249.71	500.0
2017-09-13 06:30:00	SPY	ETF	249.76	249.76	249.67	249.67	6300.0
2017-09-13 07:00:00	SPY	ETF	249.67	249.75	249.65	249.75	40067.0
2017-09-13 07:30:00	SPY	ETF	249.75	249.84	249.73	249.82	36191.0
2017-09-13 08:00:00	SPY	ETF	249.69	249.83	249.69	249.74	112111.0
2017-09-13 08:30:00	SPY	ETF	249.74	249.8	249.63	249.77	305946.0
2017-09-13 09:00:00	SPY	ETF	249.78	249.81	249.63	249.71	327223.0
2017-09-13 09:30:00	SPY	ETF	249.72	249.965	249.59	249.96	4345675.0
2017-09-13 10:00:00	SPY	ETF	249.955	250.06	249.875	250.01	3512254.0
2017-09-13 10:30:00	SPY	ETF	250.0	250.06	249.84	249.95	3601447.0
2017-09-13 11:00:00	SPY	ETF	249.96	250.1	249.94	249.975	3908274.0
2017-09-13 11:30:00	SPY	ETF	249.98	249.99	249.73	249.855	3222918.0
2017-09-13 12:00:00	SPY	ETF	249.86	250.01	249.84	249.95	3644192.0
2017-09-13 12:30:00	SPY	ETF	249.945	250.12	249.93	250.03	1581595.0
2017-09-13 13:00:00	SPY	ETF	250.035	250.07	249.86	249.995	2792539.0
2017-09-13 13:30:00	SPY	ETF	249.9999	250.02	249.93	249.955	1348579.0
2017-09-13 14:00:00	SPY	ETF	249.9535	250.055	249.91	249.97	1204916.0
2017-09-13 14:30:00	SPY	ETF	249.96	250.11	249.93	250.03	1642590.0
2017-09-13 15:00:00	SPY	ETF	250.04	250.1	249.94	250.01	2562732.0
2017-09-13 15:30:00	SPY	ETF	250.005	250.21	249.96	250.18	8005193.0
2017-09-13 16:00:00	SPY	ETF	250.17	250.231	250.01	250.13	15253133.0
2017-09-13 16:30:00	SPY	ETF	250.12	250.2353	250.12	250.14	629764.0
2017-09-13 17:00:00	SPY	ETF	250.13	250.13	250.08	250.1	76113.0
2017-09-13 17:30:00	SPY	ETF	250.1	250.12	250.07	250.07	55412.0
2017-09-13 18:00:00	SPY	ETF	250.08	250.1	249.83	249.95	124092.0
2017-09-13 18:30:00	SPY	ETF	249.96	249.96	249.87	249.92	32765.0
2017-09-13 19:00:00	SPY	ETF	249.94	249.94	249.91	249.92	6870.0
2017-09-13 19:30:00	SPY	ETF	249.91	250.227	249.9	249.93	347027.0
2017-09-13 04:00:00	QQQ	ETF	146.06	146.06	145.96	146.05	2049.0
2017-09-13 04:30:00	QQQ	ETF	145.99	146.0	145.95	145.95	11200.0
2017-09-13 05:30:00	QQQ	ETF	145.96	145.96	145.92	145.95	7100.0
2017-09-13 06:00:00	QQQ	ETF	145.99	145.99	145.99	145.99	200.0
2017-09-13 06:30:00	QQQ	ETF	145.97	145.98	145.88	145.89	4600.0
2017-09-13 07:00:00	QQQ	ETF	145.89	145.97	145.89	145.97	15550.0
2017-09-13 07:30:00	QQQ	ETF	145.95	146.0	145.95	146.0	7731.0
2017-09-13 08:00:00	QQQ	ETF	145.97	145.98	145.93	145.95	40701.0
2017-09-13 08:30:00	QQQ	ETF	145.91	145.99	145.86	145.98	22602.0
2017-09-13 09:00:00	QQQ	ETF	145.99	145.99	145.91	145.94	66403.0
2017-09-13 09:30:00	QQQ	ETF	145.95	146.19	145.73	146.18	4035197.0
2017-09-13 10:00:00	QQQ	ETF	146.18	146.26	146.05	146.065	1816920.0
2017-09-13 10:30:00	QQQ	ETF	146.07	146.15	145.98	146.08	1479706.0
2017-09-13 11:00:00	QQQ	ETF	146.09	146.22	146.06	146.11	813955.0
2017-09-13 11:30:00	QQQ	ETF	146.12	146.125	145.8	145.88	1172152.0
2017-09-13 12:00:00	QQQ	ETF	145.89	146.15	145.87	146.09	609402.0
2017-09-13 12:30:00	QQQ	ETF	146.09	146.3	146.09	146.15	672491.0
2017-09-13 13:00:00	QQQ	ETF	146.15	146.27	146.04	146.225	1426491.0

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

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