PREVIEW / etf_30min / 2016-07-01

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-07-01.parquet
  size:    404 KB
  rows:    13,742

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-07-01 04:00:00	SPY	ETF	208.85	209.08	208.76	209.08	48755.0
2016-07-01 04:30:00	SPY	ETF	209.12	209.12	208.81	208.81	22930.0
2016-07-01 05:00:00	SPY	ETF	208.8	208.91	208.76	208.8	27040.0
2016-07-01 05:30:00	SPY	ETF	208.82	208.83	208.69	208.83	23315.0
2016-07-01 06:00:00	SPY	ETF	208.88	208.93	208.66	208.83	45250.0
2016-07-01 06:30:00	SPY	ETF	208.85	209.27	208.85	209.18	53323.0
2016-07-01 07:00:00	SPY	ETF	209.15	209.36	209.13	209.25	72598.0
2016-07-01 07:30:00	SPY	ETF	209.24	209.56	209.18	209.54	301735.0
2016-07-01 08:00:00	SPY	ETF	209.53	209.54	209.13	209.46	629148.0
2016-07-01 08:30:00	SPY	ETF	209.46	209.55	209.29	209.3	229017.0
2016-07-01 09:00:00	SPY	ETF	209.3	209.53	209.28	209.38	424147.0
2016-07-01 09:30:00	SPY	ETF	209.36	210.15	209.29	210.03	12283036.0
2016-07-01 10:00:00	SPY	ETF	210.04	210.41	210.035	210.345	8743966.0
2016-07-01 10:30:00	SPY	ETF	210.355	210.49	210.24	210.39	7114932.0
2016-07-01 11:00:00	SPY	ETF	210.39	210.46	209.93	210.061	7826779.0
2016-07-01 11:30:00	SPY	ETF	210.065	210.15	209.92	210.12	4602453.0
2016-07-01 12:00:00	SPY	ETF	210.12	210.19	209.71	209.8	6199207.0
2016-07-01 12:30:00	SPY	ETF	209.79	210.0	209.76	209.92	4191874.0
2016-07-01 13:00:00	SPY	ETF	209.92	210.14	209.67	209.7	3937835.0
2016-07-01 13:30:00	SPY	ETF	209.69	209.88	209.59	209.82	4336272.0
2016-07-01 14:00:00	SPY	ETF	209.82	209.95	209.665	209.78	3704980.0
2016-07-01 14:30:00	SPY	ETF	209.78	209.84	209.51	209.74	4186720.0
2016-07-01 15:00:00	SPY	ETF	209.74	210.13	209.73	210.06	8199833.0
2016-07-01 15:30:00	SPY	ETF	210.06	210.18	209.71	209.83	14055247.0
2016-07-01 16:00:00	SPY	ETF	209.83	210.09	209.74	210.03	11642010.0
2016-07-01 16:30:00	SPY	ETF	210.02	210.04	209.91	210.02	940480.0
2016-07-01 17:00:00	SPY	ETF	210.03	210.12	210.0	210.09	242705.0
2016-07-01 17:30:00	SPY	ETF	210.1	210.15	210.1	210.12	27908.0
2016-07-01 18:00:00	SPY	ETF	210.12	210.12	210.02	210.02	33911.0
2016-07-01 18:30:00	SPY	ETF	210.01	210.05	209.99	210.03	20795.0
2016-07-01 19:00:00	SPY	ETF	210.03	210.04	210.01	210.02	8979.0
2016-07-01 19:30:00	SPY	ETF	210.01	210.05	209.99	209.99	16267.0
2016-07-01 04:00:00	QQQ	ETF	107.21	107.31	107.16	107.27	2187.0
2016-07-01 04:30:00	QQQ	ETF	107.25	107.25	107.25	107.25	200.0
2016-07-01 05:00:00	QQQ	ETF	107.22	107.25	107.22	107.25	5400.0
2016-07-01 05:30:00	QQQ	ETF	107.2	107.22	107.17	107.22	38200.0
2016-07-01 06:00:00	QQQ	ETF	107.24	107.27	107.2	107.26	2650.0
2016-07-01 06:30:00	QQQ	ETF	107.31	107.38	107.31	107.38	1200.0
2016-07-01 07:00:00	QQQ	ETF	107.39	107.48	107.37	107.41	9290.0
2016-07-01 07:30:00	QQQ	ETF	107.4	107.6	107.4	107.6	19325.0
2016-07-01 08:00:00	QQQ	ETF	107.56	107.56	107.5	107.53	19487.0
2016-07-01 08:30:00	QQQ	ETF	107.55	107.58	107.46	107.5	12542.0
2016-07-01 09:00:00	QQQ	ETF	107.48	107.54	107.47	107.5	23518.0
2016-07-01 09:30:00	QQQ	ETF	107.49	108.16	107.45	108.11	2858550.0
2016-07-01 10:00:00	QQQ	ETF	108.11	108.39	108.11	108.31	2292502.0
2016-07-01 10:30:00	QQQ	ETF	108.32	108.47	108.27	108.43	1594694.0
2016-07-01 11:00:00	QQQ	ETF	108.43	108.48	108.19	108.27	1520788.0
2016-07-01 11:30:00	QQQ	ETF	108.27	108.31	108.14	108.285	1178657.0
2016-07-01 12:00:00	QQQ	ETF	108.28	108.32	108.06	108.11	808869.0
2016-07-01 12:30:00	QQQ	ETF	108.11	108.26	108.08	108.18	994806.0

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

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