PREVIEW / etf_30min / 2016-10-07

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-10-07.parquet
  size:    397 KB
  rows:    13,464

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-10-07 04:00:00	SPY	ETF	215.53	215.59	215.5	215.59	800.0
2016-10-07 04:30:00	SPY	ETF	215.56	215.61	215.53	215.56	3350.0
2016-10-07 05:00:00	SPY	ETF	215.6	215.73	215.6	215.66	3063.0
2016-10-07 05:30:00	SPY	ETF	215.7	215.7	215.55	215.56	7544.0
2016-10-07 06:00:00	SPY	ETF	215.5	215.5	215.2	215.28	61287.0
2016-10-07 06:30:00	SPY	ETF	215.2	215.38	215.2	215.35	53829.0
2016-10-07 07:00:00	SPY	ETF	215.35	215.6	215.34	215.47	94386.0
2016-10-07 07:30:00	SPY	ETF	215.47	215.52	215.4	215.51	145060.0
2016-10-07 08:00:00	SPY	ETF	215.39	215.98	215.39	215.7	302119.0
2016-10-07 08:30:00	SPY	ETF	215.78	216.49	215.35	216.13	3605176.0
2016-10-07 09:00:00	SPY	ETF	216.14	216.3	215.78	216.05	708486.0
2016-10-07 09:30:00	SPY	ETF	216.1	216.3	215.04	215.22	12383521.0
2016-10-07 10:00:00	SPY	ETF	215.22	215.56	215.18	215.415	4393496.0
2016-10-07 10:30:00	SPY	ETF	215.4193	215.51	215.12	215.16	4785410.0
2016-10-07 11:00:00	SPY	ETF	215.16	215.37	215.05	215.1801	3954428.0
2016-10-07 11:30:00	SPY	ETF	215.186	215.24	214.19	214.42	10234438.0
2016-10-07 12:00:00	SPY	ETF	214.41	214.85	214.31	214.4692	6232300.0
2016-10-07 12:30:00	SPY	ETF	214.47	214.67	214.25	214.595	3702791.0
2016-10-07 13:00:00	SPY	ETF	214.6	215.0	214.34	214.94	3469781.0
2016-10-07 13:30:00	SPY	ETF	214.94	215.36	214.92	215.19	5876732.0
2016-10-07 14:00:00	SPY	ETF	215.19	215.41	215.07	215.27	4943687.0
2016-10-07 14:30:00	SPY	ETF	215.265	215.49	215.255	215.37	4105681.0
2016-10-07 15:00:00	SPY	ETF	215.37	215.44	215.18	215.32	3176791.0
2016-10-07 15:30:00	SPY	ETF	215.33	215.41	215.03	215.05	10708546.0
2016-10-07 16:00:00	SPY	ETF	215.05	215.1317	214.94	215.0	4674852.0
2016-10-07 16:30:00	SPY	ETF	215.0	215.02	214.99	215.0	256162.0
2016-10-07 17:00:00	SPY	ETF	214.99	215.06	214.99	215.06	320831.0
2016-10-07 17:30:00	SPY	ETF	215.04	215.05	214.91	214.95	42553.0
2016-10-07 18:00:00	SPY	ETF	214.92	216.04	214.87	215.0	136454.0
2016-10-07 18:30:00	SPY	ETF	214.99	215.03	214.93	215.03	6548.0
2016-10-07 19:00:00	SPY	ETF	214.96	214.96	214.94	214.94	302.0
2016-10-07 19:30:00	SPY	ETF	214.95	215.0	214.94	214.94	10190.0
2016-10-07 04:00:00	QQQ	ETF	118.48	118.48	118.48	118.48	200.0
2016-10-07 06:00:00	QQQ	ETF	118.46	118.46	118.36	118.42	33598.0
2016-10-07 07:00:00	QQQ	ETF	118.45	118.58	118.45	118.55	18596.0
2016-10-07 07:30:00	QQQ	ETF	118.49	118.54	118.49	118.53	4000.0
2016-10-07 08:00:00	QQQ	ETF	118.53	118.66	118.48	118.54	201086.0
2016-10-07 08:30:00	QQQ	ETF	118.65	119.03	118.41	118.85	233881.0
2016-10-07 09:00:00	QQQ	ETF	118.86	118.93	118.68	118.81	149789.0
2016-10-07 09:30:00	QQQ	ETF	118.86	119.01	118.3	118.47	2820915.0
2016-10-07 10:00:00	QQQ	ETF	118.47	118.73	118.455	118.66	1140008.0
2016-10-07 10:30:00	QQQ	ETF	118.66	118.6699	118.425	118.44	697810.0
2016-10-07 11:00:00	QQQ	ETF	118.44	118.6	118.39	118.49	698450.0
2016-10-07 11:30:00	QQQ	ETF	118.49	118.53	117.89	118.02	2167988.0
2016-10-07 12:00:00	QQQ	ETF	118.015	118.24	118.0	118.08	1339690.0
2016-10-07 12:30:00	QQQ	ETF	118.07	118.14	117.95	118.13	883292.0
2016-10-07 13:00:00	QQQ	ETF	118.12	118.35	118.01	118.32	911287.0
2016-10-07 13:30:00	QQQ	ETF	118.32	118.585	118.31	118.5	1019498.0
2016-10-07 14:00:00	QQQ	ETF	118.5	118.6	118.4243	118.5401	483095.0
2016-10-07 14:30:00	QQQ	ETF	118.54	118.64	118.54	118.58	561388.0

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

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