PREVIEW / etf_30min / 2015-08-18

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-08-18.parquet
  size:    366 KB
  rows:    12,477

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
2015-08-18 04:00:00	SPY	ETF	210.21	210.21	210.02	210.13	88960.0
2015-08-18 04:30:00	SPY	ETF	210.01	210.32	210.01	210.27	3020.0
2015-08-18 05:00:00	SPY	ETF	210.27	210.39	210.14	210.19	3992.0
2015-08-18 05:30:00	SPY	ETF	210.1	210.25	210.04	210.04	16362.0
2015-08-18 06:00:00	SPY	ETF	210.05	210.21	210.05	210.19	129005.0
2015-08-18 06:30:00	SPY	ETF	210.17	210.3	210.16	210.3	30508.0
2015-08-18 07:00:00	SPY	ETF	210.31	210.34	209.94	210.06	135034.0
2015-08-18 07:30:00	SPY	ETF	210.07	210.14	210.02	210.08	193103.0
2015-08-18 08:00:00	SPY	ETF	210.07	210.32	209.91	209.94	388731.0
2015-08-18 08:30:00	SPY	ETF	209.94	210.59	209.94	210.32	438907.0
2015-08-18 09:00:00	SPY	ETF	210.33	210.38	210.17	210.26	533397.0
2015-08-18 09:30:00	SPY	ETF	210.26	210.43	209.945	210.19	8510770.0
2015-08-18 10:00:00	SPY	ETF	210.205	210.58	210.03	210.34	5426076.0
2015-08-18 10:30:00	SPY	ETF	210.34	210.68	210.2	210.62	4060080.0
2015-08-18 11:00:00	SPY	ETF	210.62	210.64	210.16	210.185	4105376.0
2015-08-18 11:30:00	SPY	ETF	210.185	210.24	209.96	210.14	3803923.0
2015-08-18 12:00:00	SPY	ETF	210.15	210.31	210.05	210.23	2916537.0
2015-08-18 12:30:00	SPY	ETF	210.23	210.24	209.95	209.98	3058080.0
2015-08-18 13:00:00	SPY	ETF	209.975	210.03	209.81	210.01	3625635.0
2015-08-18 13:30:00	SPY	ETF	210.01	210.03	209.699	209.894	4911477.0
2015-08-18 14:00:00	SPY	ETF	209.89	210.15	209.76	210.12	2788966.0
2015-08-18 14:30:00	SPY	ETF	210.12	210.15	209.72	209.751	3884408.0
2015-08-18 15:00:00	SPY	ETF	209.76	209.975	209.75	209.935	4835448.0
2015-08-18 15:30:00	SPY	ETF	209.935	210.09	209.78	209.97	9895112.0
2015-08-18 16:00:00	SPY	ETF	209.96	210.3744	209.8819	210.0	4477800.0
2015-08-18 16:30:00	SPY	ETF	210.0	210.01	209.95	209.96	78329.0
2015-08-18 17:00:00	SPY	ETF	209.96	210.01	209.96	209.98	16803.0
2015-08-18 17:30:00	SPY	ETF	209.98	210.01	209.95	210.01	5513.0
2015-08-18 18:00:00	SPY	ETF	209.98	210.05	209.98	210.03	7155.0
2015-08-18 18:30:00	SPY	ETF	210.033	210.05	210.0	210.0	4420.0
2015-08-18 19:00:00	SPY	ETF	210.0	210.05	210.0	210.04	1662.0
2015-08-18 19:30:00	SPY	ETF	210.03	210.03	209.96	209.98	13156.0
2015-08-18 04:00:00	QQQ	ETF	111.2	111.2	111.06	111.14	13000.0
2015-08-18 04:30:00	QQQ	ETF	111.14	111.24	111.14	111.24	20100.0
2015-08-18 05:00:00	QQQ	ETF	111.29	111.29	111.29	111.29	5000.0
2015-08-18 06:00:00	QQQ	ETF	111.19	111.19	111.14	111.18	8350.0
2015-08-18 07:00:00	QQQ	ETF	111.23	111.23	111.05	111.15	7700.0
2015-08-18 07:30:00	QQQ	ETF	111.13	111.13	111.07	111.1	5249.0
2015-08-18 08:00:00	QQQ	ETF	111.1	111.14	111.03	111.067	49471.0
2015-08-18 08:30:00	QQQ	ETF	111.04	111.29	111.04	111.28	49277.0
2015-08-18 09:00:00	QQQ	ETF	111.27	111.3	111.18	111.29	75269.0
2015-08-18 09:30:00	QQQ	ETF	111.275	111.28	110.91	111.07	2992143.0
2015-08-18 10:00:00	QQQ	ETF	111.08	111.37	110.95	111.165	1298124.0
2015-08-18 10:30:00	QQQ	ETF	111.16	111.369	111.04	111.345	910320.0
2015-08-18 11:00:00	QQQ	ETF	111.34	111.36	111.13	111.15	651116.0
2015-08-18 11:30:00	QQQ	ETF	111.14	111.179	110.98	111.15	766447.0
2015-08-18 12:00:00	QQQ	ETF	111.15	111.25	111.05	111.16	355935.0
2015-08-18 12:30:00	QQQ	ETF	111.16	111.16	110.97	110.99	419296.0
2015-08-18 13:00:00	QQQ	ETF	110.98	111.05	110.86	111.02	567195.0
2015-08-18 13:30:00	QQQ	ETF	111.01	111.02	110.71	110.86	760211.0

> showing 50 of 12,477 rows — these rows as CSV

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