PREVIEW / etf_30min / 2015-04-02

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-04-02.parquet
  size:    368 KB
  rows:    12,440

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-04-02 04:00:00	SPY	ETF	205.59	205.59	205.09	205.09	3129.0
2015-04-02 04:30:00	SPY	ETF	205.09	205.19	204.95	205.1	2735.0
2015-04-02 05:00:00	SPY	ETF	205.07	205.17	205.0	205.1	13350.0
2015-04-02 05:30:00	SPY	ETF	205.22	205.22	205.14	205.15	8330.0
2015-04-02 06:00:00	SPY	ETF	205.15	205.15	205.02	205.05	7680.0
2015-04-02 06:30:00	SPY	ETF	205.09	205.2	205.01	205.2	8850.0
2015-04-02 07:00:00	SPY	ETF	205.19	205.29	205.14	205.25	47700.0
2015-04-02 07:30:00	SPY	ETF	205.23	205.47	205.23	205.47	31768.0
2015-04-02 08:00:00	SPY	ETF	205.25	205.67	205.19	205.46	180704.0
2015-04-02 08:30:00	SPY	ETF	205.46	205.58	205.21	205.55	396075.0
2015-04-02 09:00:00	SPY	ETF	205.57	205.68	205.32	205.61	410899.0
2015-04-02 09:30:00	SPY	ETF	205.62	206.85	205.4	206.76	14138226.0
2015-04-02 10:00:00	SPY	ETF	206.77	206.98	206.44	206.49	7596738.0
2015-04-02 10:30:00	SPY	ETF	206.495	206.56	206.23	206.39	4530589.0
2015-04-02 11:00:00	SPY	ETF	206.39	206.63	206.28	206.43	4116310.0
2015-04-02 11:30:00	SPY	ETF	206.425	206.61	206.17	206.2527	3342814.0
2015-04-02 12:00:00	SPY	ETF	206.25	206.25	205.83	206.125	4559860.0
2015-04-02 12:30:00	SPY	ETF	206.13	206.42	206.12	206.286	3896196.0
2015-04-02 13:00:00	SPY	ETF	206.29	206.55	206.2	206.43	3581756.0
2015-04-02 13:30:00	SPY	ETF	206.425	206.51	206.22	206.42	2619918.0
2015-04-02 14:00:00	SPY	ETF	206.42	206.73	206.3	206.54	3576043.0
2015-04-02 14:30:00	SPY	ETF	206.54	206.58	206.15	206.33	3752828.0
2015-04-02 15:00:00	SPY	ETF	206.33	206.45	206.22	206.39	3630400.0
2015-04-02 15:30:00	SPY	ETF	206.39	206.77	206.34	206.38	14033866.0
2015-04-02 16:00:00	SPY	ETF	206.37	206.49	206.26	206.48	5753888.0
2015-04-02 16:30:00	SPY	ETF	206.48	206.58	206.46	206.54	2652677.0
2015-04-02 17:00:00	SPY	ETF	206.54	206.54	206.44	206.45	293669.0
2015-04-02 17:30:00	SPY	ETF	206.46	206.48	206.44	206.46	42883.0
2015-04-02 18:00:00	SPY	ETF	206.46	206.48	206.45	206.48	12597.0
2015-04-02 18:30:00	SPY	ETF	206.48	206.48	206.42	206.42	14466.0
2015-04-02 19:00:00	SPY	ETF	206.44	206.44	206.38	206.4	12582.0
2015-04-02 19:30:00	SPY	ETF	206.38	206.42	206.37	206.39	11256.0
2015-04-02 04:00:00	QQQ	ETF	105.0	105.0	105.0	105.0	100.0
2015-04-02 04:30:00	QQQ	ETF	104.68	104.68	104.68	104.68	382.0
2015-04-02 07:00:00	QQQ	ETF	104.9	104.94	104.9	104.94	3885.0
2015-04-02 07:30:00	QQQ	ETF	105.0	105.09	105.0	105.09	2600.0
2015-04-02 08:00:00	QQQ	ETF	105.12	105.18	104.96	105.08	22408.0
2015-04-02 08:30:00	QQQ	ETF	105.09	105.17	104.97	105.13	124503.0
2015-04-02 09:00:00	QQQ	ETF	105.16	105.19	105.09	105.16	102430.0
2015-04-02 09:30:00	QQQ	ETF	105.15	105.4099	104.78	105.3099	4324217.0
2015-04-02 10:00:00	QQQ	ETF	105.31	105.46	105.09	105.11	1636874.0
2015-04-02 10:30:00	QQQ	ETF	105.11	105.18	104.9843	105.08	1172557.0
2015-04-02 11:00:00	QQQ	ETF	105.09	105.24	105.03	105.14	867116.0
2015-04-02 11:30:00	QQQ	ETF	105.15	105.25	105.06	105.08	656972.0
2015-04-02 12:00:00	QQQ	ETF	105.07	105.07	104.85	105.0	867257.0
2015-04-02 12:30:00	QQQ	ETF	105.01	105.1699	104.99	105.09	769889.0
2015-04-02 13:00:00	QQQ	ETF	105.0979	105.25	105.02	105.19	503132.0
2015-04-02 13:30:00	QQQ	ETF	105.2	105.2122	105.105	105.19	778324.0
2015-04-02 14:00:00	QQQ	ETF	105.18	105.33	105.1	105.2	586658.0
2015-04-02 14:30:00	QQQ	ETF	105.2	105.24	105.01	105.07	585947.0

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

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