PREVIEW / etf_30min / 2013-01-28

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-01-28.parquet
  size:    308 KB
  rows:    10,780

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
2013-01-28 04:00:00	SPY	ETF	150.03	150.03	150.03	150.03	357.0
2013-01-28 04:30:00	SPY	ETF	149.99	150.0	149.99	150.0	5500.0
2013-01-28 05:00:00	SPY	ETF	150.03	150.03	150.03	150.03	500.0
2013-01-28 05:30:00	SPY	ETF	150.04	150.08	150.03	150.05	5850.0
2013-01-28 06:00:00	SPY	ETF	149.97	149.97	149.97	149.97	136.0
2013-01-28 06:30:00	SPY	ETF	149.99	150.02	149.99	149.99	22294.0
2013-01-28 07:00:00	SPY	ETF	150.04	150.15	149.99	150.09	79057.0
2013-01-28 07:30:00	SPY	ETF	150.09	150.2	150.05	150.17	71875.0
2013-01-28 08:00:00	SPY	ETF	150.19	150.2	150.0	150.04	169376.0
2013-01-28 08:30:00	SPY	ETF	150.02	150.36	149.965	150.31	928740.0
2013-01-28 09:00:00	SPY	ETF	150.33	150.34	150.22	150.29	629536.0
2013-01-28 09:30:00	SPY	ETF	150.29	150.33	149.92	149.93	10660788.0
2013-01-28 10:00:00	SPY	ETF	149.92	150.1896	149.51	149.82	11897341.0
2013-01-28 10:30:00	SPY	ETF	149.82	149.98	149.73	149.91	5672095.0
2013-01-28 11:00:00	SPY	ETF	149.905	150.03	149.82	150.01	5440083.0
2013-01-28 11:30:00	SPY	ETF	150.01	150.19	150.005	150.13	5621299.0
2013-01-28 12:00:00	SPY	ETF	150.138	150.18	149.97	150.019	5675111.0
2013-01-28 12:30:00	SPY	ETF	150.01	150.06	149.94	149.99	2730295.0
2013-01-28 13:00:00	SPY	ETF	149.99	150.0	149.78	149.845	4938297.0
2013-01-28 13:30:00	SPY	ETF	149.84	150.05	149.83	150.01	2407571.0
2013-01-28 14:00:00	SPY	ETF	150.0	150.14	149.99	150.12	2669071.0
2013-01-28 14:30:00	SPY	ETF	150.12	150.1896	150.03	150.13	4239404.0
2013-01-28 15:00:00	SPY	ETF	150.13	150.21	149.89	149.97	15391374.0
2013-01-28 15:30:00	SPY	ETF	149.97	150.1	149.89	150.04	12881221.0
2013-01-28 16:00:00	SPY	ETF	150.03	150.19	149.9019	150.04	19328732.0
2013-01-28 16:30:00	SPY	ETF	150.04	150.05	149.93	149.95	693501.0
2013-01-28 17:00:00	SPY	ETF	149.95	150.02	149.86	149.89	395953.0
2013-01-28 17:30:00	SPY	ETF	149.87	149.9	149.85	149.9	81200.0
2013-01-28 18:00:00	SPY	ETF	149.91	149.94	149.9	149.91	76804.0
2013-01-28 18:30:00	SPY	ETF	149.9	149.9	149.85	149.88	10125.0
2013-01-28 19:00:00	SPY	ETF	149.9	149.92	149.85	149.86	10821.0
2013-01-28 19:30:00	SPY	ETF	149.89	149.9	149.85	149.86	12983.0
2013-01-28 04:30:00	QQQ	ETF	66.97	66.97	66.9	66.9	4200.0
2013-01-28 06:00:00	QQQ	ETF	66.94	66.95	66.94	66.95	5968.0
2013-01-28 07:00:00	QQQ	ETF	66.95	66.99	66.95	66.99	6200.0
2013-01-28 07:30:00	QQQ	ETF	66.96	67.03	66.96	67.03	7773.0
2013-01-28 08:00:00	QQQ	ETF	67.04	67.05	66.93	66.95	64805.0
2013-01-28 08:30:00	QQQ	ETF	66.96	67.05	66.95	67.04	148789.0
2013-01-28 09:00:00	QQQ	ETF	67.04	67.04	66.98	67.01	56469.0
2013-01-28 09:30:00	QQQ	ETF	67.02	67.22	66.97	67.179	3713841.0
2013-01-28 10:00:00	QQQ	ETF	67.17	67.26	66.93	67.17	5050493.0
2013-01-28 10:30:00	QQQ	ETF	67.17	67.25	67.1	67.21	1413131.0
2013-01-28 11:00:00	QQQ	ETF	67.22	67.28	67.15	67.22	1075871.0
2013-01-28 11:30:00	QQQ	ETF	67.2199	67.38	67.21	67.35	1138227.0
2013-01-28 12:00:00	QQQ	ETF	67.35	67.37	67.2499	67.2601	959991.0
2013-01-28 12:30:00	QQQ	ETF	67.27	67.34	67.21	67.21	550357.0
2013-01-28 13:00:00	QQQ	ETF	67.21	67.22	67.02	67.06	1524757.0
2013-01-28 13:30:00	QQQ	ETF	67.06	67.185	67.04	67.17	787335.0
2013-01-28 14:00:00	QQQ	ETF	67.17	67.277	67.15	67.27	1057453.0
2013-01-28 14:30:00	QQQ	ETF	67.27	67.31	67.21	67.26	624668.0

> showing 50 of 10,780 rows — these rows as CSV

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