PREVIEW / etf_30min / 2013-09-13

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-09-13.parquet
  size:    308 KB
  rows:    10,618

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-09-13 04:00:00	SPY	ETF	169.03	169.03	168.8	168.81	65300.0
2013-09-13 04:30:00	SPY	ETF	168.83	168.83	168.77	168.83	2500.0
2013-09-13 05:00:00	SPY	ETF	168.86	168.89	168.86	168.89	900.0
2013-09-13 05:30:00	SPY	ETF	168.92	168.94	168.87	168.87	5296.0
2013-09-13 06:00:00	SPY	ETF	168.89	168.92	168.89	168.92	900.0
2013-09-13 06:30:00	SPY	ETF	168.9	168.92	168.85	168.92	2760.0
2013-09-13 07:00:00	SPY	ETF	168.94	168.98	168.88	168.94	56950.0
2013-09-13 07:30:00	SPY	ETF	168.97	169.13	168.97	169.07	235005.0
2013-09-13 08:00:00	SPY	ETF	169.06	169.41	168.92	169.19	338574.0
2013-09-13 08:30:00	SPY	ETF	169.19	169.22	169.04	169.2	191558.0
2013-09-13 09:00:00	SPY	ETF	169.19	169.2	168.58	169.13	568837.0
2013-09-13 09:30:00	SPY	ETF	169.13	169.46	169.02	169.27	11410214.0
2013-09-13 10:00:00	SPY	ETF	169.26	169.27	168.74	168.8699	7744393.0
2013-09-13 10:30:00	SPY	ETF	168.87	169.21	168.85	169.13	4797233.0
2013-09-13 11:00:00	SPY	ETF	169.13	169.37	169.08	169.28	3700798.0
2013-09-13 11:30:00	SPY	ETF	169.28	169.34	169.23	169.28	3411386.0
2013-09-13 12:00:00	SPY	ETF	169.29	169.4	169.25	169.33	4504876.0
2013-09-13 12:30:00	SPY	ETF	169.32	169.34	169.16	169.19	2961681.0
2013-09-13 13:00:00	SPY	ETF	169.182	169.33	169.182	169.3199	2299405.0
2013-09-13 13:30:00	SPY	ETF	169.32	169.34	169.235	169.34	2326290.0
2013-09-13 14:00:00	SPY	ETF	169.34	169.43	169.29	169.32	3892942.0
2013-09-13 14:30:00	SPY	ETF	169.32	169.32	169.26	169.2705	2716151.0
2013-09-13 15:00:00	SPY	ETF	169.27	169.32	169.19	169.26	3190789.0
2013-09-13 15:30:00	SPY	ETF	169.26	169.38	169.11	169.34	9709285.0
2013-09-13 16:00:00	SPY	ETF	169.35	169.49	168.8798	169.47	5098997.0
2013-09-13 16:30:00	SPY	ETF	169.48	169.59	168.8798	169.52	2607933.0
2013-09-13 17:00:00	SPY	ETF	169.52	169.54	169.47	169.5	293250.0
2013-09-13 17:30:00	SPY	ETF	169.54	169.59	169.2279	169.59	251013.0
2013-09-13 18:00:00	SPY	ETF	169.52	169.57	169.48	169.48	6590.0
2013-09-13 18:30:00	SPY	ETF	169.53	169.53	169.48	169.5	6100.0
2013-09-13 19:00:00	SPY	ETF	169.49	169.52	169.48	169.52	960.0
2013-09-13 19:30:00	SPY	ETF	169.5	169.53	169.47	169.53	13255.0
2013-09-13 04:00:00	QQQ	ETF	78.08	78.08	77.99	77.99	8300.0
2013-09-13 04:30:00	QQQ	ETF	78.01	78.01	77.97	78.01	4000.0
2013-09-13 05:00:00	QQQ	ETF	78.03	78.05	78.03	78.05	1500.0
2013-09-13 05:30:00	QQQ	ETF	78.07	78.07	78.05	78.05	1600.0
2013-09-13 06:00:00	QQQ	ETF	78.03	78.03	78.03	78.03	100.0
2013-09-13 06:30:00	QQQ	ETF	78.03	78.03	78.01	78.01	8700.0
2013-09-13 07:00:00	QQQ	ETF	78.03	78.03	78.03	78.03	1200.0
2013-09-13 07:30:00	QQQ	ETF	78.05	78.12	78.05	78.09	7800.0
2013-09-13 08:00:00	QQQ	ETF	78.06	78.13	78.06	78.12	8880.0
2013-09-13 08:30:00	QQQ	ETF	78.09	78.13	78.05	78.12	41275.0
2013-09-13 09:00:00	QQQ	ETF	78.12	78.13	78.04	78.11	149794.0
2013-09-13 09:30:00	QQQ	ETF	78.11	78.145	77.97	78.03	2327716.0
2013-09-13 10:00:00	QQQ	ETF	78.03	78.049	77.64	77.685	2609305.0
2013-09-13 10:30:00	QQQ	ETF	77.68	77.89	77.67	77.84	1531954.0
2013-09-13 11:00:00	QQQ	ETF	77.84	77.98	77.8	77.92	857719.0
2013-09-13 11:30:00	QQQ	ETF	77.925	77.96	77.92	77.935	510844.0
2013-09-13 12:00:00	QQQ	ETF	77.94	78.07	77.93	78.005	792551.0
2013-09-13 12:30:00	QQQ	ETF	78.01	78.02	77.87	77.9301	1658496.0

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

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