PREVIEW / etf_30min / 2017-10-23

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-10-23.parquet
  size:    444 KB
  rows:    15,365

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-10-23 04:00:00	SPY	ETF	257.15	257.18	257.05	257.17	1750.0
2017-10-23 04:30:00	SPY	ETF	257.17	257.26	257.17	257.21	1304.0
2017-10-23 05:00:00	SPY	ETF	257.18	257.2	257.18	257.18	1800.0
2017-10-23 05:30:00	SPY	ETF	257.26	257.47	257.26	257.47	1829.0
2017-10-23 06:00:00	SPY	ETF	257.47	257.47	257.47	257.47	400.0
2017-10-23 06:30:00	SPY	ETF	257.4	257.48	257.4	257.48	12400.0
2017-10-23 07:00:00	SPY	ETF	257.46	257.51	257.44	257.44	71591.0
2017-10-23 07:30:00	SPY	ETF	257.45	257.46	257.3	257.34	84844.0
2017-10-23 08:00:00	SPY	ETF	257.43	257.46	257.27	257.38	67055.0
2017-10-23 08:30:00	SPY	ETF	257.37	257.47	257.37	257.47	104004.0
2017-10-23 09:00:00	SPY	ETF	257.47	257.52	257.43	257.47	2804069.0
2017-10-23 09:30:00	SPY	ETF	257.48	257.51	257.12	257.305	4869752.0
2017-10-23 10:00:00	SPY	ETF	257.305	257.305	257.03	257.11	3039703.0
2017-10-23 10:30:00	SPY	ETF	257.11	257.23	257.0	257.02	3008806.0
2017-10-23 11:00:00	SPY	ETF	257.025	257.18	257.02	257.125	1420229.0
2017-10-23 11:30:00	SPY	ETF	257.12	257.13	256.85	256.975	8402397.0
2017-10-23 12:00:00	SPY	ETF	256.97	257.03	256.88	256.9955	1516333.0
2017-10-23 12:30:00	SPY	ETF	256.995	257.05	256.9	257.05	1233385.0
2017-10-23 13:00:00	SPY	ETF	257.045	257.08	256.87	256.925	897675.0
2017-10-23 13:30:00	SPY	ETF	256.925	256.97	256.7	256.805	1865933.0
2017-10-23 14:00:00	SPY	ETF	256.8	256.86	256.55	256.6738	2796047.0
2017-10-23 14:30:00	SPY	ETF	256.68	256.7	256.48	256.655	3352898.0
2017-10-23 15:00:00	SPY	ETF	256.66	256.67	256.23	256.325	3558900.0
2017-10-23 15:30:00	SPY	ETF	256.32	256.4	256.02	256.15	13694376.0
2017-10-23 16:00:00	SPY	ETF	256.14	256.26	256.06	256.1	9417670.0
2017-10-23 16:30:00	SPY	ETF	256.1	256.12	255.96	256.08	359390.0
2017-10-23 17:00:00	SPY	ETF	256.09	257.1539	256.07	256.07	22131.0
2017-10-23 17:30:00	SPY	ETF	256.07	256.08	256.05	256.06	8169.0
2017-10-23 18:00:00	SPY	ETF	256.06	256.19	256.02	256.15	36786.0
2017-10-23 18:30:00	SPY	ETF	256.17	256.2	256.16	256.2	8707.0
2017-10-23 19:00:00	SPY	ETF	256.22	256.28	256.2	256.28	16492.0
2017-10-23 19:30:00	SPY	ETF	256.26	256.27	256.23	256.26	9373.0
2017-10-23 04:30:00	QQQ	ETF	148.82	148.94	148.82	148.83	4100.0
2017-10-23 05:00:00	QQQ	ETF	148.78	148.79	148.78	148.79	3000.0
2017-10-23 05:30:00	QQQ	ETF	149.0	149.02	148.99	149.02	3600.0
2017-10-23 06:00:00	QQQ	ETF	149.02	149.05	149.01	149.01	15627.0
2017-10-23 06:30:00	QQQ	ETF	149.0	149.06	149.0	149.06	1000.0
2017-10-23 07:00:00	QQQ	ETF	149.0	149.02	148.95	148.95	3860.0
2017-10-23 07:30:00	QQQ	ETF	148.96	148.98	148.88	148.88	2450.0
2017-10-23 08:00:00	QQQ	ETF	148.89	148.96	148.87	148.96	22700.0
2017-10-23 08:30:00	QQQ	ETF	149.0	149.05	148.71	149.05	45310.0
2017-10-23 09:00:00	QQQ	ETF	149.05	149.07	148.99	149.0	80688.0
2017-10-23 09:30:00	QQQ	ETF	149.01	149.03	148.6	148.66	2345747.0
2017-10-23 10:00:00	QQQ	ETF	148.66	148.7	148.26	148.3808	2374805.0
2017-10-23 10:30:00	QQQ	ETF	148.39	148.44	148.16	148.28	1049087.0
2017-10-23 11:00:00	QQQ	ETF	148.28	148.43	148.28	148.35	760071.0
2017-10-23 11:30:00	QQQ	ETF	148.355	148.38	148.18	148.3362	757410.0
2017-10-23 12:00:00	QQQ	ETF	148.335	148.5467	148.31	148.535	1224142.0
2017-10-23 12:30:00	QQQ	ETF	148.535	148.595	148.46	148.585	556851.0
2017-10-23 13:00:00	QQQ	ETF	148.58	148.61	148.46	148.48	600608.0

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

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