PREVIEW / etf_30min / 2015-08-06

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-08-06.parquet
  size:    375 KB
  rows:    12,532

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-06 04:00:00	SPY	ETF	210.08	210.18	210.08	210.18	1700.0
2015-08-06 04:30:00	SPY	ETF	210.13	210.23	210.1	210.23	2300.0
2015-08-06 05:00:00	SPY	ETF	210.1	210.1	210.01	210.06	3704.0
2015-08-06 05:30:00	SPY	ETF	209.91	209.97	209.86	209.96	4910.0
2015-08-06 06:00:00	SPY	ETF	209.96	210.11	209.93	210.06	4707.0
2015-08-06 06:30:00	SPY	ETF	210.05	210.05	209.89	210.04	7722.0
2015-08-06 07:00:00	SPY	ETF	210.08	210.1	209.98	210.05	38863.0
2015-08-06 07:30:00	SPY	ETF	210.06	210.55	210.06	210.43	172023.0
2015-08-06 08:00:00	SPY	ETF	210.39	210.51	210.01	210.21	194881.0
2015-08-06 08:30:00	SPY	ETF	210.3	210.33	210.1	210.15	291134.0
2015-08-06 09:00:00	SPY	ETF	210.19	210.29	210.14	210.29	211031.0
2015-08-06 09:30:00	SPY	ETF	210.29	210.415	209.23	209.35	8946806.0
2015-08-06 10:00:00	SPY	ETF	209.36	209.61	209.03	209.05	6793619.0
2015-08-06 10:30:00	SPY	ETF	209.05	209.49	208.94	209.15	6413122.0
2015-08-06 11:00:00	SPY	ETF	209.14	209.18	208.47	208.5	6931444.0
2015-08-06 11:30:00	SPY	ETF	208.5	208.54	207.965	208.005	10816207.0
2015-08-06 12:00:00	SPY	ETF	208.0	208.21	207.77	208.01	7939164.0
2015-08-06 12:30:00	SPY	ETF	208.0001	208.01	207.65	207.89	5085261.0
2015-08-06 13:00:00	SPY	ETF	207.89	208.43	207.81	208.36	6917925.0
2015-08-06 13:30:00	SPY	ETF	208.37	208.495	208.2	208.205	3871363.0
2015-08-06 14:00:00	SPY	ETF	208.2	208.54	208.09	208.535	4762828.0
2015-08-06 14:30:00	SPY	ETF	208.54	208.62	208.325	208.409	4846494.0
2015-08-06 15:00:00	SPY	ETF	208.41	208.5	208.185	208.21	4555047.0
2015-08-06 15:30:00	SPY	ETF	208.22	208.7	208.12	208.47	15846215.0
2015-08-06 16:00:00	SPY	ETF	208.45	208.65	208.27	208.62	4647233.0
2015-08-06 16:30:00	SPY	ETF	208.63	208.65	208.35	208.62	1503953.0
2015-08-06 17:00:00	SPY	ETF	208.62	208.63	208.56	208.63	44377.0
2015-08-06 17:30:00	SPY	ETF	208.62	208.66	208.355	208.65	5655777.0
2015-08-06 18:00:00	SPY	ETF	208.64	208.67	208.62	208.64	90986.0
2015-08-06 18:30:00	SPY	ETF	208.62	208.65	208.59	208.64	17632.0
2015-08-06 19:00:00	SPY	ETF	208.62	208.65	208.58	208.6	6898.0
2015-08-06 19:30:00	SPY	ETF	208.56	208.62	208.54	208.55	30999.0
2015-08-06 06:00:00	QQQ	ETF	112.25	112.25	112.25	112.25	12500.0
2015-08-06 06:30:00	QQQ	ETF	112.25	112.25	112.25	112.25	4500.0
2015-08-06 07:00:00	QQQ	ETF	112.23	112.24	112.23	112.24	400.0
2015-08-06 07:30:00	QQQ	ETF	112.29	112.5	112.29	112.41	21200.0
2015-08-06 08:00:00	QQQ	ETF	112.4	112.41	112.24	112.38	23944.0
2015-08-06 08:30:00	QQQ	ETF	112.4	112.4	112.22	112.25	21959.0
2015-08-06 09:00:00	QQQ	ETF	112.26	112.35	112.22	112.35	101768.0
2015-08-06 09:30:00	QQQ	ETF	112.35	112.5	111.48	111.58	4099415.0
2015-08-06 10:00:00	QQQ	ETF	111.58	111.789	111.21	111.22	2195545.0
2015-08-06 10:30:00	QQQ	ETF	111.22	111.3265	111.0	111.0001	3681306.0
2015-08-06 11:00:00	QQQ	ETF	111.0	111.06	110.37	110.41	3725837.0
2015-08-06 11:30:00	QQQ	ETF	110.41	110.449	110.09	110.12	3873863.0
2015-08-06 12:00:00	QQQ	ETF	110.11	110.27	110.0	110.19	2101073.0
2015-08-06 12:30:00	QQQ	ETF	110.19	110.23	109.95	110.18	1620792.0
2015-08-06 13:00:00	QQQ	ETF	110.18	110.53	110.09	110.48	2116600.0
2015-08-06 13:30:00	QQQ	ETF	110.485	110.58	110.33	110.335	1504158.0
2015-08-06 14:00:00	QQQ	ETF	110.33	110.56	110.25	110.555	1456735.0
2015-08-06 14:30:00	QQQ	ETF	110.56	110.61	110.36	110.42	1861466.0

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

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