PREVIEW / etf_30min / 2016-05-25

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-05-25.parquet
  size:    390 KB
  rows:    13,418

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
2016-05-25 04:00:00	SPY	ETF	208.5	208.85	208.5	208.8	18578.0
2016-05-25 04:30:00	SPY	ETF	208.72	208.91	208.68	208.9	5441.0
2016-05-25 05:00:00	SPY	ETF	208.87	208.96	208.86	208.9	6735.0
2016-05-25 05:30:00	SPY	ETF	208.88	209.04	208.88	208.99	42172.0
2016-05-25 06:00:00	SPY	ETF	208.97	208.97	208.8	208.85	7375.0
2016-05-25 06:30:00	SPY	ETF	208.9	208.92	208.76	208.79	9438.0
2016-05-25 07:00:00	SPY	ETF	208.81	208.86	208.67	208.85	178141.0
2016-05-25 07:30:00	SPY	ETF	208.81	208.93	208.79	208.82	119619.0
2016-05-25 08:00:00	SPY	ETF	208.82	210.2346	208.12	208.89	579132.0
2016-05-25 08:30:00	SPY	ETF	208.89	208.96	208.82	208.83	174566.0
2016-05-25 09:00:00	SPY	ETF	208.83	208.83	208.55	208.67	586503.0
2016-05-25 09:30:00	SPY	ETF	208.67	209.28	208.62	209.21	12680044.0
2016-05-25 10:00:00	SPY	ETF	209.21	209.71	209.2	209.53	7162414.0
2016-05-25 10:30:00	SPY	ETF	209.53	209.63	209.27	209.405	5800232.0
2016-05-25 11:00:00	SPY	ETF	209.41	209.59	209.18	209.2162	5055931.0
2016-05-25 11:30:00	SPY	ETF	209.22	209.38	209.14	209.3	3242019.0
2016-05-25 12:00:00	SPY	ETF	209.31	209.36	209.13	209.1792	3420529.0
2016-05-25 12:30:00	SPY	ETF	209.17	209.35	209.13	209.32	2474940.0
2016-05-25 13:00:00	SPY	ETF	209.32	209.66	209.32	209.6	3915596.0
2016-05-25 13:30:00	SPY	ETF	209.6	209.65	209.5	209.615	1998775.0
2016-05-25 14:00:00	SPY	ETF	209.62	209.64	209.41	209.52	3447912.0
2016-05-25 14:30:00	SPY	ETF	209.52	209.71	209.19	209.22	4812726.0
2016-05-25 15:00:00	SPY	ETF	209.211	209.77	209.16	209.765	5084661.0
2016-05-25 15:30:00	SPY	ETF	209.76	209.765	209.22	209.22	11710905.0
2016-05-25 16:00:00	SPY	ETF	209.22	209.38	209.19	209.26	4427403.0
2016-05-25 16:30:00	SPY	ETF	209.26	209.38	209.26	209.38	205238.0
2016-05-25 17:00:00	SPY	ETF	209.37	209.41	209.35	209.39	124052.0
2016-05-25 17:30:00	SPY	ETF	209.39	209.41	209.37	209.38	45025.0
2016-05-25 18:00:00	SPY	ETF	209.38	209.39	209.21	209.21	151257.0
2016-05-25 18:30:00	SPY	ETF	209.21	209.3	209.21	209.29	24499.0
2016-05-25 19:00:00	SPY	ETF	209.28	209.28	209.23	209.24	24629.0
2016-05-25 19:30:00	SPY	ETF	209.24	209.24	209.13	209.17	112455.0
2016-05-25 04:00:00	QQQ	ETF	108.93	109.02	108.93	108.97	1623.0
2016-05-25 05:00:00	QQQ	ETF	109.06	109.09	109.06	109.09	200.0
2016-05-25 05:30:00	QQQ	ETF	109.08	109.14	109.08	109.14	999.0
2016-05-25 06:00:00	QQQ	ETF	109.12	109.12	109.05	109.05	1800.0
2016-05-25 06:30:00	QQQ	ETF	109.05	109.05	108.98	108.98	1500.0
2016-05-25 07:00:00	QQQ	ETF	109.0	109.01	108.93	109.01	5889.0
2016-05-25 07:30:00	QQQ	ETF	109.0	109.06	109.0	109.02	38034.0
2016-05-25 08:00:00	QQQ	ETF	108.96	109.05	108.92	109.04	62645.0
2016-05-25 08:30:00	QQQ	ETF	109.05	109.08	108.99	108.99	30613.0
2016-05-25 09:00:00	QQQ	ETF	108.98	108.98	108.8	108.86	132903.0
2016-05-25 09:30:00	QQQ	ETF	108.86	109.19	108.684	109.13	2614856.0
2016-05-25 10:00:00	QQQ	ETF	109.13	109.34	109.08	109.19	2496381.0
2016-05-25 10:30:00	QQQ	ETF	109.19	109.29	109.1	109.22	2144836.0
2016-05-25 11:00:00	QQQ	ETF	109.22	109.33	109.02	109.07	1761248.0
2016-05-25 11:30:00	QQQ	ETF	109.065	109.19	109.02	109.19	1071861.0
2016-05-25 12:00:00	QQQ	ETF	109.19	109.25	109.13	109.18	1391580.0
2016-05-25 12:30:00	QQQ	ETF	109.181	109.27	109.1664	109.26	508888.0
2016-05-25 13:00:00	QQQ	ETF	109.27	109.54	109.26	109.51	1464245.0

> showing 50 of 13,418 rows — these rows as CSV

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