PREVIEW / etf_30min / 2016-04-18

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-04-18.parquet
  size:    398 KB
  rows:    13,484

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-04-18 04:00:00	SPY	ETF	207.21	207.24	207.0	207.06	20439.0
2016-04-18 04:30:00	SPY	ETF	206.93	207.45	206.92	207.38	16080.0
2016-04-18 05:00:00	SPY	ETF	207.47	207.55	207.3	207.3	15875.0
2016-04-18 05:30:00	SPY	ETF	207.26	207.5	207.25	207.47	8785.0
2016-04-18 06:00:00	SPY	ETF	207.46	207.73	207.46	207.54	46673.0
2016-04-18 06:30:00	SPY	ETF	207.58	207.58	207.25	207.3	18587.0
2016-04-18 07:00:00	SPY	ETF	207.29	207.38	207.21	207.28	48206.0
2016-04-18 07:30:00	SPY	ETF	207.37	207.37	207.18	207.23	106790.0
2016-04-18 08:00:00	SPY	ETF	207.24	207.52	206.44	207.18	525262.0
2016-04-18 08:30:00	SPY	ETF	207.18	207.38	207.09	207.16	717026.0
2016-04-18 09:00:00	SPY	ETF	207.17	208.09	207.03	207.12	318177.0
2016-04-18 09:30:00	SPY	ETF	207.14	207.87	207.0	207.81	7983614.0
2016-04-18 10:00:00	SPY	ETF	207.805	208.57	207.79	208.53	8638333.0
2016-04-18 10:30:00	SPY	ETF	208.54	208.84	208.5	208.654	5378378.0
2016-04-18 11:00:00	SPY	ETF	208.65	208.83	208.57	208.7	4003153.0
2016-04-18 11:30:00	SPY	ETF	208.69	208.83	208.61	208.71	5394426.0
2016-04-18 12:00:00	SPY	ETF	208.71	208.96	208.68	208.9	3950653.0
2016-04-18 12:30:00	SPY	ETF	208.8999	209.115	208.88	208.93	3610725.0
2016-04-18 13:00:00	SPY	ETF	208.92	208.94	208.68	208.81	2830007.0
2016-04-18 13:30:00	SPY	ETF	208.815	209.005	208.76	208.96	2852563.0
2016-04-18 14:00:00	SPY	ETF	208.95	209.09	208.75	208.95	4546330.0
2016-04-18 14:30:00	SPY	ETF	208.94	209.27	208.92	209.1	4178596.0
2016-04-18 15:00:00	SPY	ETF	209.1	209.125	208.96	209.04	3982059.0
2016-04-18 15:30:00	SPY	ETF	209.04	209.28	209.0	209.28	10185518.0
2016-04-18 16:00:00	SPY	ETF	209.26	209.26	207.8588	209.11	8205000.0
2016-04-18 16:30:00	SPY	ETF	209.1	209.13	209.01	209.03	686871.0
2016-04-18 17:00:00	SPY	ETF	209.05	209.07	209.03	209.05	43518.0
2016-04-18 17:30:00	SPY	ETF	209.05	209.05	208.96	208.96	45324.0
2016-04-18 18:00:00	SPY	ETF	208.97	209.05	208.93	209.04	149857.0
2016-04-18 18:30:00	SPY	ETF	209.04	209.04	209.01	209.03	30441.0
2016-04-18 19:00:00	SPY	ETF	209.05	209.07	209.03	209.03	22170.0
2016-04-18 19:30:00	SPY	ETF	209.05	209.25	209.05	209.19	74451.0
2016-04-18 04:00:00	QQQ	ETF	110.24	110.24	110.24	110.24	100.0
2016-04-18 04:30:00	QQQ	ETF	110.32	110.47	110.32	110.4	11100.0
2016-04-18 05:30:00	QQQ	ETF	110.52	110.52	110.45	110.51	2600.0
2016-04-18 06:00:00	QQQ	ETF	110.49	110.61	110.49	110.61	1075.0
2016-04-18 06:30:00	QQQ	ETF	110.6	110.6	110.57	110.57	773.0
2016-04-18 07:00:00	QQQ	ETF	110.4	110.44	110.35	110.35	46500.0
2016-04-18 07:30:00	QQQ	ETF	110.43	110.43	110.35	110.35	15151.0
2016-04-18 08:00:00	QQQ	ETF	110.35	110.37	110.28	110.34	17430.0
2016-04-18 08:30:00	QQQ	ETF	110.35	110.46	110.29	110.29	34046.0
2016-04-18 09:00:00	QQQ	ETF	110.31	110.37	110.3	110.34	31659.0
2016-04-18 09:30:00	QQQ	ETF	110.33	110.65	110.25	110.63	1790152.0
2016-04-18 10:00:00	QQQ	ETF	110.625	111.1999	110.625	111.135	2026258.0
2016-04-18 10:30:00	QQQ	ETF	111.14	111.265	111.08	111.17	1402469.0
2016-04-18 11:00:00	QQQ	ETF	111.17	111.19	110.85	110.9	1178653.0
2016-04-18 11:30:00	QQQ	ETF	110.89	110.95	110.74	110.802	1022722.0
2016-04-18 12:00:00	QQQ	ETF	110.81	111.03	110.8	110.96	589270.0
2016-04-18 12:30:00	QQQ	ETF	110.96	111.14	110.96	111.02	969086.0
2016-04-18 13:00:00	QQQ	ETF	111.01	111.02	110.84	110.93	1134796.0

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

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