PREVIEW / etf_30min / 2017-04-06

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-04-06.parquet
  size:    422 KB
  rows:    14,490

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-04-06 04:00:00	SPY	ETF	234.23	234.45	234.15	234.25	7172.0
2017-04-06 04:30:00	SPY	ETF	234.32	234.44	234.32	234.44	3200.0
2017-04-06 05:00:00	SPY	ETF	234.52	234.52	234.45	234.45	1425.0
2017-04-06 05:30:00	SPY	ETF	234.5	234.5	234.5	234.5	500.0
2017-04-06 06:00:00	SPY	ETF	234.54	234.63	234.53	234.6	5533.0
2017-04-06 06:30:00	SPY	ETF	234.62	234.91	234.62	234.88	41258.0
2017-04-06 07:00:00	SPY	ETF	234.81	234.9	234.77	234.81	179936.0
2017-04-06 07:30:00	SPY	ETF	234.82	234.9	234.69	234.72	154976.0
2017-04-06 08:00:00	SPY	ETF	234.84	234.88	234.54	234.76	214640.0
2017-04-06 08:30:00	SPY	ETF	234.77	234.97	234.71	234.94	359682.0
2017-04-06 09:00:00	SPY	ETF	234.94	235.19	234.9	234.96	714062.0
2017-04-06 09:30:00	SPY	ETF	234.94	235.34	234.425	235.3	9167347.0
2017-04-06 10:00:00	SPY	ETF	235.31	235.43	234.91	235.334	5618668.0
2017-04-06 10:30:00	SPY	ETF	235.33	235.53	234.94	235.24	4246674.0
2017-04-06 11:00:00	SPY	ETF	235.25	235.7	235.2403	235.67	3532151.0
2017-04-06 11:30:00	SPY	ETF	235.67	235.7	235.48	235.59	1998773.0
2017-04-06 12:00:00	SPY	ETF	235.59	235.68	235.461	235.56	1535919.0
2017-04-06 12:30:00	SPY	ETF	235.555	235.63	235.2	235.38	2604545.0
2017-04-06 13:00:00	SPY	ETF	235.38	235.95	235.33	235.86	3141336.0
2017-04-06 13:30:00	SPY	ETF	235.85	236.04	235.65	235.655	3529249.0
2017-04-06 14:00:00	SPY	ETF	235.65	235.74	235.38	235.425	3789243.0
2017-04-06 14:30:00	SPY	ETF	235.42	235.58	234.88	234.98	5492215.0
2017-04-06 15:00:00	SPY	ETF	234.985	235.37	234.95	235.24	4680814.0
2017-04-06 15:30:00	SPY	ETF	235.25	235.44	235.01	235.39	9402928.0
2017-04-06 16:00:00	SPY	ETF	235.39	235.44	235.17	235.33	6868186.0
2017-04-06 16:30:00	SPY	ETF	235.34	235.42	235.26	235.41	442169.0
2017-04-06 17:00:00	SPY	ETF	235.39	235.47	235.38	235.46	56216.0
2017-04-06 17:30:00	SPY	ETF	235.47	235.5	235.46	235.46	38731.0
2017-04-06 18:00:00	SPY	ETF	235.46	235.54	235.41	235.46	70464.0
2017-04-06 18:30:00	SPY	ETF	235.47	235.51	235.45	235.46	15394.0
2017-04-06 19:00:00	SPY	ETF	235.48	235.51	235.4	235.42	29867.0
2017-04-06 19:30:00	SPY	ETF	235.42	235.48	235.4	235.44	27772.0
2017-04-06 04:00:00	QQQ	ETF	131.74	131.79	131.67	131.79	1898.0
2017-04-06 04:30:00	QQQ	ETF	131.75	131.75	131.72	131.72	634.0
2017-04-06 05:00:00	QQQ	ETF	131.83	131.83	131.83	131.83	497.0
2017-04-06 05:30:00	QQQ	ETF	131.79	131.85	131.79	131.84	25598.0
2017-04-06 06:00:00	QQQ	ETF	131.87	131.88	131.87	131.88	360.0
2017-04-06 06:30:00	QQQ	ETF	131.88	132.09	131.88	132.09	10696.0
2017-04-06 07:00:00	QQQ	ETF	132.04	132.08	132.02	132.05	73250.0
2017-04-06 07:30:00	QQQ	ETF	132.05	132.07	132.0	132.01	6800.0
2017-04-06 08:00:00	QQQ	ETF	131.99	132.04	131.93	132.03	36556.0
2017-04-06 08:30:00	QQQ	ETF	132.05	132.1	132.02	132.09	114539.0
2017-04-06 09:00:00	QQQ	ETF	132.08	132.2	132.08	132.12	60355.0
2017-04-06 09:30:00	QQQ	ETF	132.12	132.3	131.74	132.2573	3117460.0
2017-04-06 10:00:00	QQQ	ETF	132.28	132.34	131.87	132.165	1826302.0
2017-04-06 10:30:00	QQQ	ETF	132.15	132.24	131.84	132.12	1151813.0
2017-04-06 11:00:00	QQQ	ETF	132.13	132.39	132.12	132.33	675124.0
2017-04-06 11:30:00	QQQ	ETF	132.3345	132.35	132.075	132.2147	806406.0
2017-04-06 12:00:00	QQQ	ETF	132.215	132.27	132.06	132.1765	683042.0
2017-04-06 12:30:00	QQQ	ETF	132.1799	132.22	131.92	132.0	1024811.0

> showing 50 of 14,490 rows — these rows as CSV

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