PREVIEW / etf_30min / 2017-04-18

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-04-18.parquet
  size:    433 KB
  rows:    14,815

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-04-18 04:30:00	SPY	ETF	234.21	234.21	234.0	234.05	3070.0
2017-04-18 05:00:00	SPY	ETF	234.1	234.11	233.96	233.96	3850.0
2017-04-18 05:30:00	SPY	ETF	233.96	233.96	233.5	233.5	14835.0
2017-04-18 06:00:00	SPY	ETF	233.56	233.74	233.56	233.7	26739.0
2017-04-18 06:30:00	SPY	ETF	233.72	233.9	233.64	233.9	60852.0
2017-04-18 07:00:00	SPY	ETF	233.91	234.23	233.87	233.98	182329.0
2017-04-18 07:30:00	SPY	ETF	234.01	234.12	233.92	234.0	167912.0
2017-04-18 08:00:00	SPY	ETF	234.02	234.09	233.78	233.86	204594.0
2017-04-18 08:30:00	SPY	ETF	233.86	234.0	233.78	233.88	258189.0
2017-04-18 09:00:00	SPY	ETF	233.88	233.9	233.67	233.69	457092.0
2017-04-18 09:30:00	SPY	ETF	233.72	234.46	233.55	234.45	7585614.0
2017-04-18 10:00:00	SPY	ETF	234.46	234.49	233.7265	233.8	8617461.0
2017-04-18 10:30:00	SPY	ETF	233.79	234.05	233.76	233.935	5330476.0
2017-04-18 11:00:00	SPY	ETF	233.94	234.13	233.72	234.05	5078020.0
2017-04-18 11:30:00	SPY	ETF	234.05	234.06	233.28	233.29	4649252.0
2017-04-18 12:00:00	SPY	ETF	233.29	233.49	233.08	233.455	7100274.0
2017-04-18 12:30:00	SPY	ETF	233.45	233.56	233.28	233.44	2740742.0
2017-04-18 13:00:00	SPY	ETF	233.44	233.67	233.27	233.67	2207471.0
2017-04-18 13:30:00	SPY	ETF	233.67	233.85	233.58	233.8	4697668.0
2017-04-18 14:00:00	SPY	ETF	233.8	234.05	233.8	234.01	3482947.0
2017-04-18 14:30:00	SPY	ETF	234.0	234.145	233.74	233.87	3788273.0
2017-04-18 15:00:00	SPY	ETF	233.87	234.0157	233.68	233.915	5144005.0
2017-04-18 15:30:00	SPY	ETF	233.91	234.15	233.83	233.86	11974679.0
2017-04-18 16:00:00	SPY	ETF	233.87	233.89	233.74	233.76	6778781.0
2017-04-18 16:30:00	SPY	ETF	233.78	233.8717	233.76	233.85	1973248.0
2017-04-18 17:00:00	SPY	ETF	233.84	233.85	233.82	233.82	18220.0
2017-04-18 17:30:00	SPY	ETF	233.83	233.84	233.77	233.8	51978.0
2017-04-18 18:00:00	SPY	ETF	233.8	233.83	233.68	233.8	30918.0
2017-04-18 18:30:00	SPY	ETF	233.75	233.85	233.74	233.75	2990.0
2017-04-18 19:00:00	SPY	ETF	233.78	233.85	233.78	233.85	13134.0
2017-04-18 19:30:00	SPY	ETF	233.86	233.94	233.86	233.91	14349.0
2017-04-18 04:00:00	QQQ	ETF	131.34	131.43	131.32	131.32	1894.0
2017-04-18 04:30:00	QQQ	ETF	131.34	131.34	131.23	131.23	1280.0
2017-04-18 05:00:00	QQQ	ETF	131.25	131.25	131.25	131.25	200.0
2017-04-18 05:30:00	QQQ	ETF	131.12	131.12	130.97	131.04	20040.0
2017-04-18 06:00:00	QQQ	ETF	131.04	131.04	131.03	131.03	2300.0
2017-04-18 06:30:00	QQQ	ETF	131.01	131.01	131.0	131.0	250.0
2017-04-18 07:00:00	QQQ	ETF	131.07	131.23	131.04	131.16	11947.0
2017-04-18 07:30:00	QQQ	ETF	131.19	131.21	131.11	131.18	3200.0
2017-04-18 08:00:00	QQQ	ETF	131.19	131.22	131.1	131.1	3849.0
2017-04-18 08:30:00	QQQ	ETF	131.12	131.17	131.05	131.15	43275.0
2017-04-18 09:00:00	QQQ	ETF	131.1	131.1	130.99	131.01	158784.0
2017-04-18 09:30:00	QQQ	ETF	131.01	131.64	130.98	131.63	2719449.0
2017-04-18 10:00:00	QQQ	ETF	131.631	131.66	131.14	131.19	1481204.0
2017-04-18 10:30:00	QQQ	ETF	131.19	131.39	131.16	131.28	690187.0
2017-04-18 11:00:00	QQQ	ETF	131.29	131.45	131.139	131.399	547062.0
2017-04-18 11:30:00	QQQ	ETF	131.4	131.4	131.07	131.07	767856.0
2017-04-18 12:00:00	QQQ	ETF	131.06	131.12	130.97	131.0907	870902.0
2017-04-18 12:30:00	QQQ	ETF	131.08	131.15	131.01	131.075	487876.0
2017-04-18 13:00:00	QQQ	ETF	131.07	131.17	130.95	131.17	607093.0

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

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