PREVIEW / etf_30min / 2014-12-02

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-12-02.parquet
  size:    363 KB
  rows:    12,272

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
2014-12-02 04:00:00	SPY	ETF	206.29	206.37	206.24	206.32	57500.0
2014-12-02 04:30:00	SPY	ETF	206.22	206.24	206.06	206.07	3180.0
2014-12-02 05:00:00	SPY	ETF	206.09	206.16	206.01	206.01	11050.0
2014-12-02 05:30:00	SPY	ETF	205.93	205.93	205.69	205.78	25455.0
2014-12-02 06:00:00	SPY	ETF	205.83	205.94	205.79	205.83	10125.0
2014-12-02 06:30:00	SPY	ETF	205.85	206.04	205.83	206.01	14197.0
2014-12-02 07:00:00	SPY	ETF	205.99	206.16	205.92	206.06	140909.0
2014-12-02 07:30:00	SPY	ETF	206.06	206.26	206.06	206.13	157396.0
2014-12-02 08:00:00	SPY	ETF	206.12	206.16	205.95	206.06	228727.0
2014-12-02 08:30:00	SPY	ETF	206.01	206.06	205.86	206.02	356040.0
2014-12-02 09:00:00	SPY	ETF	206.01	206.04	205.8	205.81	333253.0
2014-12-02 09:30:00	SPY	ETF	205.81	206.39	205.79	206.31	10361156.0
2014-12-02 10:00:00	SPY	ETF	206.31	206.69	206.28	206.555	6964128.0
2014-12-02 10:30:00	SPY	ETF	206.55	206.77	206.37	206.76	5900069.0
2014-12-02 11:00:00	SPY	ETF	206.755	206.86	206.64	206.75	4702690.0
2014-12-02 11:30:00	SPY	ETF	206.74	206.87	206.61	206.83	4381415.0
2014-12-02 12:00:00	SPY	ETF	206.82	206.84	206.68	206.76	3086915.0
2014-12-02 12:30:00	SPY	ETF	206.75	206.77	206.53	206.71	2901369.0
2014-12-02 13:00:00	SPY	ETF	206.71	207.07	206.68	207.01	4417312.0
2014-12-02 13:30:00	SPY	ETF	207.01	207.05	206.87	206.93	4315834.0
2014-12-02 14:00:00	SPY	ETF	206.93	207.03	206.87	206.98	2755009.0
2014-12-02 14:30:00	SPY	ETF	206.99	207.34	206.91	207.27	4402967.0
2014-12-02 15:00:00	SPY	ETF	207.27	207.3	207.03	207.075	4223627.0
2014-12-02 15:30:00	SPY	ETF	207.07	207.16	206.93	207.09	9191608.0
2014-12-02 16:00:00	SPY	ETF	207.07	207.17	206.99	207.17	2305312.0
2014-12-02 16:30:00	SPY	ETF	207.15	207.22	207.09	207.18	2289504.0
2014-12-02 17:00:00	SPY	ETF	207.18	207.22	207.16	207.17	37126.0
2014-12-02 17:30:00	SPY	ETF	207.17	207.18	207.16	207.16	25195.0
2014-12-02 18:00:00	SPY	ETF	207.16	207.18	207.14	207.16	16650.0
2014-12-02 18:30:00	SPY	ETF	207.18	207.22	207.18	207.22	9490.0
2014-12-02 19:00:00	SPY	ETF	207.21	207.24	207.19	207.22	6520.0
2014-12-02 19:30:00	SPY	ETF	207.2	207.32	207.2	207.3	18171.0
2014-12-02 04:00:00	QQQ	ETF	105.18	105.18	105.17	105.17	24500.0
2014-12-02 05:00:00	QQQ	ETF	105.06	105.06	105.06	105.06	100.0
2014-12-02 05:30:00	QQQ	ETF	104.93	104.93	104.87	104.91	15313.0
2014-12-02 06:00:00	QQQ	ETF	104.99	105.0	104.92	104.95	18400.0
2014-12-02 06:30:00	QQQ	ETF	104.96	104.99	104.96	104.99	1800.0
2014-12-02 07:00:00	QQQ	ETF	105.02	105.1	104.99	105.07	9163.0
2014-12-02 07:30:00	QQQ	ETF	105.05	105.13	105.03	105.03	61621.0
2014-12-02 08:00:00	QQQ	ETF	105.02	105.02	104.9	104.96	160968.0
2014-12-02 08:30:00	QQQ	ETF	104.96	104.98	104.88	104.96	52729.0
2014-12-02 09:00:00	QQQ	ETF	104.99	105.03	104.91	104.92	253983.0
2014-12-02 09:30:00	QQQ	ETF	104.93	105.1	104.7	104.98	5424931.0
2014-12-02 10:00:00	QQQ	ETF	104.98	105.2	104.88	105.13	2461645.0
2014-12-02 10:30:00	QQQ	ETF	105.13	105.2	104.91	104.99	1624721.0
2014-12-02 11:00:00	QQQ	ETF	104.99	105.09	104.87	105.06	1443786.0
2014-12-02 11:30:00	QQQ	ETF	105.06	105.24	105.02	105.2	1592938.0
2014-12-02 12:00:00	QQQ	ETF	105.2	105.2099	104.98	105.031	877120.0
2014-12-02 12:30:00	QQQ	ETF	105.0372	105.06	104.88	105.03	952888.0
2014-12-02 13:00:00	QQQ	ETF	105.03	105.15	104.98	105.11	819012.0

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

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