PREVIEW / etf_30min / 2017-05-18

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-05-18.parquet
  size:    451 KB
  rows:    15,361

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
2017-05-18 04:00:00	SPY	ETF	236.11	236.24	235.9	236.08	97012.0
2017-05-18 04:30:00	SPY	ETF	236.08	236.29	236.08	236.29	20940.0
2017-05-18 05:00:00	SPY	ETF	236.15	236.26	235.42	235.46	61764.0
2017-05-18 05:30:00	SPY	ETF	235.4	235.48	234.75	234.79	133669.0
2017-05-18 06:00:00	SPY	ETF	234.81	235.34	234.81	235.22	82304.0
2017-05-18 06:30:00	SPY	ETF	235.28	235.31	234.99	235.06	29528.0
2017-05-18 07:00:00	SPY	ETF	235.06	235.5	234.94	235.44	212404.0
2017-05-18 07:30:00	SPY	ETF	235.48	235.73	235.43	235.59	204660.0
2017-05-18 08:00:00	SPY	ETF	235.6	236.69	234.86	235.19	1198828.0
2017-05-18 08:30:00	SPY	ETF	235.19	235.46	235.16	235.16	1111205.0
2017-05-18 09:00:00	SPY	ETF	235.16	236.0	235.08	235.7	1632348.0
2017-05-18 09:30:00	SPY	ETF	235.73	236.15	235.43	235.68	12123986.0
2017-05-18 10:00:00	SPY	ETF	235.69	236.88	235.6808	236.75	10510557.0
2017-05-18 10:30:00	SPY	ETF	236.75	237.02	236.43	236.6351	7314591.0
2017-05-18 11:00:00	SPY	ETF	236.64	236.88	236.55	236.685	3943532.0
2017-05-18 11:30:00	SPY	ETF	236.68	236.815	236.15	236.18	4576739.0
2017-05-18 12:00:00	SPY	ETF	236.18	236.47	235.97	236.34	5706546.0
2017-05-18 12:30:00	SPY	ETF	236.34	236.68	236.14	236.39	3288838.0
2017-05-18 13:00:00	SPY	ETF	236.39	236.469	236.081	236.2135	2921020.0
2017-05-18 13:30:00	SPY	ETF	236.21	236.91	236.1	236.73	4012778.0
2017-05-18 14:00:00	SPY	ETF	236.73	237.48	236.73	237.375	8791329.0
2017-05-18 14:30:00	SPY	ETF	237.38	237.75	237.15	237.2	6207583.0
2017-05-18 15:00:00	SPY	ETF	237.2	237.37	236.925	237.05	5598273.0
2017-05-18 15:30:00	SPY	ETF	237.05	237.33	236.64	236.67	17045509.0
2017-05-18 16:00:00	SPY	ETF	236.74	237.09	236.56	236.58	7764458.0
2017-05-18 16:30:00	SPY	ETF	236.59	236.66	236.49	236.62	460485.0
2017-05-18 17:00:00	SPY	ETF	236.68	236.75	236.4249	236.72	168479.0
2017-05-18 17:30:00	SPY	ETF	236.72	236.74	236.69	236.7	66613.0
2017-05-18 18:00:00	SPY	ETF	236.7	236.79	236.69	236.76	70273.0
2017-05-18 18:30:00	SPY	ETF	236.78	236.82	236.77	236.81	17394.0
2017-05-18 19:00:00	SPY	ETF	236.79	236.82	236.79	236.82	35752.0
2017-05-18 19:30:00	SPY	ETF	236.79	236.8	236.7	236.76	12899.0
2017-05-18 04:00:00	QQQ	ETF	136.29	136.29	136.05	136.06	31819.0
2017-05-18 04:30:00	QQQ	ETF	136.12	136.17	136.12	136.13	2486.0
2017-05-18 05:00:00	QQQ	ETF	136.15	136.15	135.65	135.67	22046.0
2017-05-18 05:30:00	QQQ	ETF	135.66	135.7	135.32	135.32	49897.0
2017-05-18 06:00:00	QQQ	ETF	135.48	135.71	135.48	135.58	15696.0
2017-05-18 06:30:00	QQQ	ETF	135.62	135.64	135.6	135.64	3198.0
2017-05-18 07:00:00	QQQ	ETF	135.58	135.77	135.51	135.72	23681.0
2017-05-18 07:30:00	QQQ	ETF	135.74	135.96	135.74	135.89	52544.0
2017-05-18 08:00:00	QQQ	ETF	135.53	136.0	135.53	135.8	252193.0
2017-05-18 08:30:00	QQQ	ETF	135.85	135.99	135.85	135.88	86530.0
2017-05-18 09:00:00	QQQ	ETF	135.87	136.1	135.55	136.05	428655.0
2017-05-18 09:30:00	QQQ	ETF	136.06	136.74	135.87	136.52	5283743.0
2017-05-18 10:00:00	QQQ	ETF	136.53	137.38	136.52	137.19	6333024.0
2017-05-18 10:30:00	QQQ	ETF	137.19	137.44	137.03	137.13	2895014.0
2017-05-18 11:00:00	QQQ	ETF	137.13	137.33	137.04	137.22	1604637.0
2017-05-18 11:30:00	QQQ	ETF	137.22	137.279	136.69	136.7084	1898428.0
2017-05-18 12:00:00	QQQ	ETF	136.71	136.93	136.56	136.88	2348690.0
2017-05-18 12:30:00	QQQ	ETF	136.87	137.11	136.75	136.89	1616957.0

> showing 50 of 15,361 rows — these rows as CSV

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