PREVIEW / etf_30min / 2015-08-04

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-08-04.parquet
  size:    370 KB
  rows:    12,492

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-04 04:00:00	SPY	ETF	209.69	209.92	209.42	209.92	5725.0
2015-08-04 04:30:00	SPY	ETF	209.81	209.81	209.53	209.53	800.0
2015-08-04 05:00:00	SPY	ETF	209.65	209.79	209.6	209.79	1210.0
2015-08-04 05:30:00	SPY	ETF	209.82	209.82	209.7	209.7	1100.0
2015-08-04 06:00:00	SPY	ETF	209.6	209.6	209.39	209.53	10193.0
2015-08-04 06:30:00	SPY	ETF	209.44	209.47	209.22	209.38	25771.0
2015-08-04 07:00:00	SPY	ETF	209.38	209.38	209.06	209.2	123860.0
2015-08-04 07:30:00	SPY	ETF	209.21	209.4	209.2	209.37	234934.0
2015-08-04 08:00:00	SPY	ETF	209.4	209.53	209.15	209.42	433299.0
2015-08-04 08:30:00	SPY	ETF	209.42	209.83	209.36	209.81	199664.0
2015-08-04 09:00:00	SPY	ETF	209.8	209.84	209.61	209.71	292508.0
2015-08-04 09:30:00	SPY	ETF	209.7	210.03	209.46	209.83	8861009.0
2015-08-04 10:00:00	SPY	ETF	209.84	210.2483	209.69	210.12	7549729.0
2015-08-04 10:30:00	SPY	ETF	210.13	210.21	209.36	209.46	6878846.0
2015-08-04 11:00:00	SPY	ETF	209.48	209.905	209.44	209.69	3199819.0
2015-08-04 11:30:00	SPY	ETF	209.69	210.0739	209.51	209.655	3024620.0
2015-08-04 12:00:00	SPY	ETF	209.65	209.935	209.58	209.59	3100740.0
2015-08-04 12:30:00	SPY	ETF	209.59	209.66	209.31	209.41	2598060.0
2015-08-04 13:00:00	SPY	ETF	209.41	209.66	209.28	209.66	2680642.0
2015-08-04 13:30:00	SPY	ETF	209.66	209.88	209.05	209.13	6496084.0
2015-08-04 14:00:00	SPY	ETF	209.13	210.091	208.8	209.1	6423309.0
2015-08-04 14:30:00	SPY	ETF	209.09	209.65	209.0	209.51	6131572.0
2015-08-04 15:00:00	SPY	ETF	209.51	209.63	209.25	209.4099	5039405.0
2015-08-04 15:30:00	SPY	ETF	209.4	210.0	209.05	209.35	13009570.0
2015-08-04 16:00:00	SPY	ETF	209.34	209.4	208.92	208.95	3589473.0
2015-08-04 16:30:00	SPY	ETF	208.95	209.38	208.95	209.03	352753.0
2015-08-04 17:00:00	SPY	ETF	209.033	209.033	208.92	208.92	38626.0
2015-08-04 17:30:00	SPY	ETF	208.913	208.94	208.87	208.9	89265.0
2015-08-04 18:00:00	SPY	ETF	208.9	209.03	208.9	209.02	101198.0
2015-08-04 18:30:00	SPY	ETF	209.03	209.08	208.99	209.08	19350.0
2015-08-04 19:00:00	SPY	ETF	209.08	209.09	209.02	209.04	32982.0
2015-08-04 19:30:00	SPY	ETF	209.04	209.05	208.98	208.99	31913.0
2015-08-04 04:00:00	QQQ	ETF	111.6	111.82	111.6	111.82	1200.0
2015-08-04 04:30:00	QQQ	ETF	111.74	111.74	111.52	111.52	1200.0
2015-08-04 05:00:00	QQQ	ETF	111.6	111.66	111.54	111.66	900.0
2015-08-04 05:30:00	QQQ	ETF	111.68	111.68	111.54	111.54	1000.0
2015-08-04 06:00:00	QQQ	ETF	111.52	111.52	111.52	111.52	100.0
2015-08-04 06:30:00	QQQ	ETF	111.4	111.4	111.38	111.39	7200.0
2015-08-04 07:00:00	QQQ	ETF	111.35	111.39	111.26	111.29	65910.0
2015-08-04 07:30:00	QQQ	ETF	111.29	111.4	111.29	111.4	34148.0
2015-08-04 08:00:00	QQQ	ETF	111.34	111.45	111.31	111.42	45440.0
2015-08-04 08:30:00	QQQ	ETF	111.35	111.58	111.33	111.55	59883.0
2015-08-04 09:00:00	QQQ	ETF	111.57	111.6	111.51	111.56	67003.0
2015-08-04 09:30:00	QQQ	ETF	111.55	111.69	111.16	111.44	3328362.0
2015-08-04 10:00:00	QQQ	ETF	111.44	111.745	111.37	111.64	2242221.0
2015-08-04 10:30:00	QQQ	ETF	111.66	111.691	110.93	111.0	2237375.0
2015-08-04 11:00:00	QQQ	ETF	111.0	111.31	110.975	111.3	982216.0
2015-08-04 11:30:00	QQQ	ETF	111.3	111.355	111.14	111.28	712102.0
2015-08-04 12:00:00	QQQ	ETF	111.28	111.53	111.265	111.2772	642488.0
2015-08-04 12:30:00	QQQ	ETF	111.28	111.41	111.12	111.1951	449312.0

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

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