PREVIEW / etf_30min / 2016-06-03

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-06-03.parquet
  size:    393 KB
  rows:    13,380

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-06-03 04:00:00	SPY	ETF	210.86	210.86	210.75	210.84	6765.0
2016-06-03 04:30:00	SPY	ETF	210.87	210.96	210.84	210.92	10278.0
2016-06-03 05:00:00	SPY	ETF	210.93	210.93	210.88	210.91	6218.0
2016-06-03 05:30:00	SPY	ETF	210.92	210.92	210.85	210.85	4578.0
2016-06-03 06:00:00	SPY	ETF	210.92	210.94	210.9	210.94	6208.0
2016-06-03 06:30:00	SPY	ETF	210.94	210.95	210.9	210.91	1803.0
2016-06-03 07:00:00	SPY	ETF	210.93	211.04	210.93	211.04	21401.0
2016-06-03 07:30:00	SPY	ETF	211.03	211.11	211.01	211.11	18790.0
2016-06-03 08:00:00	SPY	ETF	211.08	211.1	210.711	211.07	182036.0
2016-06-03 08:30:00	SPY	ETF	210.4	211.03	209.66	210.04	4045281.0
2016-06-03 09:00:00	SPY	ETF	210.04	210.28	209.88	210.26	1594248.0
2016-06-03 09:30:00	SPY	ETF	210.25	210.37	209.41	209.63	12032639.0
2016-06-03 10:00:00	SPY	ETF	209.63	209.635	208.86	209.1	15171057.0
2016-06-03 10:30:00	SPY	ETF	209.09	209.73	209.02	209.68	7139166.0
2016-06-03 11:00:00	SPY	ETF	209.69	209.75	209.36	209.5162	5777378.0
2016-06-03 11:30:00	SPY	ETF	209.52	210.22	209.47	210.15	6690050.0
2016-06-03 12:00:00	SPY	ETF	210.155	210.18	209.96	210.06	3377612.0
2016-06-03 12:30:00	SPY	ETF	210.07	210.23	209.73	209.76	3942062.0
2016-06-03 13:00:00	SPY	ETF	209.76	210.02	209.73	209.8002	3092722.0
2016-06-03 13:30:00	SPY	ETF	209.82	210.16	209.72	210.125	3504839.0
2016-06-03 14:00:00	SPY	ETF	210.13	210.28	209.94	210.24	4379330.0
2016-06-03 14:30:00	SPY	ETF	210.24	210.69	210.21	210.4915	6985989.0
2016-06-03 15:00:00	SPY	ETF	210.495	210.55	210.33	210.495	4476081.0
2016-06-03 15:30:00	SPY	ETF	210.49	210.6	210.18	210.3	12685677.0
2016-06-03 16:00:00	SPY	ETF	210.29	210.38	210.22	210.36	3056059.0
2016-06-03 16:30:00	SPY	ETF	210.36	210.4	210.29	210.32	1616703.0
2016-06-03 17:00:00	SPY	ETF	210.29	210.31	210.23	210.23	100960.0
2016-06-03 17:30:00	SPY	ETF	210.23	210.3	210.16	210.23	88735.0
2016-06-03 18:00:00	SPY	ETF	210.25	210.27	210.18	210.26	23798.0
2016-06-03 18:30:00	SPY	ETF	210.23	210.23	210.18	210.22	4150.0
2016-06-03 19:00:00	SPY	ETF	210.23	210.23	210.2	210.23	5321.0
2016-06-03 19:30:00	SPY	ETF	210.23	210.25	210.21	210.22	15974.0
2016-06-03 04:00:00	QQQ	ETF	110.5	110.5	110.5	110.5	500.0
2016-06-03 05:00:00	QQQ	ETF	110.57	110.57	110.57	110.57	500.0
2016-06-03 05:30:00	QQQ	ETF	110.55	110.55	110.55	110.55	100.0
2016-06-03 07:00:00	QQQ	ETF	110.6	110.6	110.58	110.59	1250.0
2016-06-03 07:30:00	QQQ	ETF	110.61	110.63	110.61	110.63	8610.0
2016-06-03 08:00:00	QQQ	ETF	110.61	110.64	110.58	110.64	20155.0
2016-06-03 08:30:00	QQQ	ETF	110.63	110.63	110.04	110.19	477997.0
2016-06-03 09:00:00	QQQ	ETF	110.15	110.36	110.08	110.36	294349.0
2016-06-03 09:30:00	QQQ	ETF	110.37	110.42	109.79	109.8695	3580846.0
2016-06-03 10:00:00	QQQ	ETF	109.86	109.86	109.34	109.52	3006724.0
2016-06-03 10:30:00	QQQ	ETF	109.51	109.95	109.44	109.87	1929525.0
2016-06-03 11:00:00	QQQ	ETF	109.88	109.92	109.69	109.8	875299.0
2016-06-03 11:30:00	QQQ	ETF	109.805	110.12	109.78	110.09	1138044.0
2016-06-03 12:00:00	QQQ	ETF	110.09	110.15	109.97	109.9999	807655.0
2016-06-03 12:30:00	QQQ	ETF	109.99	110.0799	109.84	109.84	748756.0
2016-06-03 13:00:00	QQQ	ETF	109.84	110.02	109.83	109.87	578727.0
2016-06-03 13:30:00	QQQ	ETF	109.88	110.08	109.86	110.02	755114.0
2016-06-03 14:00:00	QQQ	ETF	110.02	110.07	109.87	110.04	651648.0

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

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