PREVIEW / etf_30min / 2016-03-04

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-03-04.parquet
  size:    408 KB
  rows:    13,823

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-03-04 04:00:00	SPY	ETF	199.56	199.56	199.31	199.38	23675.0
2016-03-04 04:30:00	SPY	ETF	199.64	199.65	199.53	199.6	8608.0
2016-03-04 05:00:00	SPY	ETF	199.6	199.71	199.6	199.64	3814.0
2016-03-04 05:30:00	SPY	ETF	199.66	199.83	199.64	199.83	7013.0
2016-03-04 06:00:00	SPY	ETF	199.83	200.05	199.83	199.83	56981.0
2016-03-04 06:30:00	SPY	ETF	199.87	200.01	199.87	200.01	7659.0
2016-03-04 07:00:00	SPY	ETF	199.92	200.05	199.84	199.92	63364.0
2016-03-04 07:30:00	SPY	ETF	199.95	200.18	199.95	200.07	141706.0
2016-03-04 08:00:00	SPY	ETF	200.06	200.13	199.91	199.99	637635.0
2016-03-04 08:30:00	SPY	ETF	200.09	200.85	199.66	199.72	3870021.0
2016-03-04 09:00:00	SPY	ETF	199.7	200.385	199.44	200.0	2979999.0
2016-03-04 09:30:00	SPY	ETF	200.01	200.15	199.03	199.29	13058536.0
2016-03-04 10:00:00	SPY	ETF	199.29	199.81	199.06	199.66	8033283.0
2016-03-04 10:30:00	SPY	ETF	199.67	200.38	199.625	200.23	9172402.0
2016-03-04 11:00:00	SPY	ETF	200.23	200.98	200.22	200.55	10339842.0
2016-03-04 11:30:00	SPY	ETF	200.55	200.77	200.35	200.74	5879699.0
2016-03-04 12:00:00	SPY	ETF	200.74	200.85	200.45	200.56	4773136.0
2016-03-04 12:30:00	SPY	ETF	200.56	200.93	200.47	200.78	4844947.0
2016-03-04 13:00:00	SPY	ETF	200.78	200.945	200.54	200.93	4867872.0
2016-03-04 13:30:00	SPY	ETF	200.9295	201.35	200.79	201.2405	6507360.0
2016-03-04 14:00:00	SPY	ETF	201.23	201.25	200.49	200.56	6348736.0
2016-03-04 14:30:00	SPY	ETF	200.57	200.68	199.77	200.0411	9386377.0
2016-03-04 15:00:00	SPY	ETF	200.041	200.49	199.71	200.42	8450355.0
2016-03-04 15:30:00	SPY	ETF	200.42	200.65	200.21	200.38	16634010.0
2016-03-04 16:00:00	SPY	ETF	200.38	200.47	199.708	200.07	10171398.0
2016-03-04 16:30:00	SPY	ETF	200.07	200.36	199.93	200.06	719431.0
2016-03-04 17:00:00	SPY	ETF	200.1	200.43	199.95	199.97	272793.0
2016-03-04 17:30:00	SPY	ETF	199.98	200.36	199.92	199.99	62457.0
2016-03-04 18:00:00	SPY	ETF	199.98	200.01	199.94	199.98	255300.0
2016-03-04 18:30:00	SPY	ETF	199.96	199.99	199.94	199.98	5013.0
2016-03-04 19:00:00	SPY	ETF	199.99	200.01	199.96	199.98	3717.0
2016-03-04 19:30:00	SPY	ETF	199.97	200.05	199.95	200.05	20547.0
2016-03-04 04:00:00	QQQ	ETF	105.45	105.45	105.41	105.41	347.0
2016-03-04 05:30:00	QQQ	ETF	105.53	105.59	105.53	105.59	600.0
2016-03-04 06:00:00	QQQ	ETF	105.66	105.75	105.66	105.75	1599.0
2016-03-04 06:30:00	QQQ	ETF	105.77	105.79	105.77	105.79	1200.0
2016-03-04 07:00:00	QQQ	ETF	105.83	105.87	105.76	105.85	7830.0
2016-03-04 07:30:00	QQQ	ETF	105.9	105.95	105.88	105.94	6831.0
2016-03-04 08:00:00	QQQ	ETF	105.91	105.93	105.79	105.85	45650.0
2016-03-04 08:30:00	QQQ	ETF	106.19	106.3	105.6	105.6	700728.0
2016-03-04 09:00:00	QQQ	ETF	105.58	105.77	105.42	105.74	161323.0
2016-03-04 09:30:00	QQQ	ETF	105.75	105.82	104.97	105.15	4703450.0
2016-03-04 10:00:00	QQQ	ETF	105.16	105.38	104.99	105.265	2282533.0
2016-03-04 10:30:00	QQQ	ETF	105.27	105.71	105.25	105.61	1546947.0
2016-03-04 11:00:00	QQQ	ETF	105.61	106.075	105.61	105.84	1870734.0
2016-03-04 11:30:00	QQQ	ETF	105.84	105.93	105.62	105.87	1219049.0
2016-03-04 12:00:00	QQQ	ETF	105.8707	105.9465	105.72	105.8	1005372.0
2016-03-04 12:30:00	QQQ	ETF	105.8	106.05	105.79	106.0	963584.0
2016-03-04 13:00:00	QQQ	ETF	106.005	106.04	105.85	106.02	758691.0
2016-03-04 13:30:00	QQQ	ETF	106.022	106.35	105.96	106.275	1679871.0

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

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