PREVIEW / etf_30min / 2014-11-26

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-11-26.parquet
  size:    343 KB
  rows:    11,723

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-11-26 04:00:00	SPY	ETF	207.51	207.55	207.44	207.55	900.0
2014-11-26 05:00:00	SPY	ETF	207.57	207.58	207.51	207.51	1200.0
2014-11-26 05:30:00	SPY	ETF	207.52	207.52	207.44	207.44	8700.0
2014-11-26 06:00:00	SPY	ETF	207.47	207.52	207.47	207.52	6000.0
2014-11-26 06:30:00	SPY	ETF	207.52	207.54	207.47	207.52	35150.0
2014-11-26 07:00:00	SPY	ETF	207.51	207.53	207.41	207.41	190015.0
2014-11-26 07:30:00	SPY	ETF	207.42	207.42	207.19	207.19	77269.0
2014-11-26 08:00:00	SPY	ETF	207.18	207.65	207.0632	207.34	196320.0
2014-11-26 08:30:00	SPY	ETF	207.31	207.33	207.05	207.18	474240.0
2014-11-26 09:00:00	SPY	ETF	207.18	207.27	207.11	207.27	356240.0
2014-11-26 09:30:00	SPY	ETF	207.29	207.4	207.03	207.24	8152075.0
2014-11-26 10:00:00	SPY	ETF	207.24	207.37	207.06	207.31	4690053.0
2014-11-26 10:30:00	SPY	ETF	207.31	207.38	207.22	207.28	2775813.0
2014-11-26 11:00:00	SPY	ETF	207.29	207.36	207.17	207.25	3406934.0
2014-11-26 11:30:00	SPY	ETF	207.24	207.33	207.2	207.28	2120029.0
2014-11-26 12:00:00	SPY	ETF	207.28	207.43	207.23	207.36	2601793.0
2014-11-26 12:30:00	SPY	ETF	207.36	207.4	207.32	207.36	1373934.0
2014-11-26 13:00:00	SPY	ETF	207.35	207.47	207.35	207.42	1454400.0
2014-11-26 13:30:00	SPY	ETF	207.42	207.52	207.41	207.46	2140371.0
2014-11-26 14:00:00	SPY	ETF	207.46	207.49	207.35	207.44	2293532.0
2014-11-26 14:30:00	SPY	ETF	207.44	207.48	207.38	207.43	3336657.0
2014-11-26 15:00:00	SPY	ETF	207.43	207.55	207.39	207.495	3633672.0
2014-11-26 15:30:00	SPY	ETF	207.4942	207.76	207.48	207.66	8620814.0
2014-11-26 16:00:00	SPY	ETF	207.64	207.81	207.47	207.79	10769334.0
2014-11-26 16:30:00	SPY	ETF	207.78	208.06	207.64	207.96	1370526.0
2014-11-26 17:00:00	SPY	ETF	207.97	207.97	207.91	207.93	48489.0
2014-11-26 17:30:00	SPY	ETF	207.93	207.94	207.88	207.9	61467.0
2014-11-26 18:00:00	SPY	ETF	207.92	207.92	207.83	207.85	34170.0
2014-11-26 18:30:00	SPY	ETF	207.84	207.88	207.83	207.83	41616.0
2014-11-26 19:00:00	SPY	ETF	207.83	207.86	207.8	207.81	45800.0
2014-11-26 19:30:00	SPY	ETF	207.81	207.83	207.78	207.83	62170.0
2014-11-26 04:00:00	QQQ	ETF	105.0	105.09	105.0	105.09	2000.0
2014-11-26 04:30:00	QQQ	ETF	105.02	105.11	105.02	105.1	2507.0
2014-11-26 06:30:00	QQQ	ETF	105.07	105.07	105.07	105.07	1000.0
2014-11-26 07:00:00	QQQ	ETF	105.09	105.09	105.05	105.06	7722.0
2014-11-26 07:30:00	QQQ	ETF	105.01	105.01	104.93	104.93	26500.0
2014-11-26 08:00:00	QQQ	ETF	105.07	105.07	104.919	104.98	28831.0
2014-11-26 08:30:00	QQQ	ETF	104.92	104.99	104.86	104.93	57212.0
2014-11-26 09:00:00	QQQ	ETF	104.93	104.94	104.89	104.94	153827.0
2014-11-26 09:30:00	QQQ	ETF	104.94	105.11	104.834	105.02	2617155.0
2014-11-26 10:00:00	QQQ	ETF	105.01	105.1651	104.92	105.135	1536812.0
2014-11-26 10:30:00	QQQ	ETF	105.131	105.235	105.09	105.17	1456314.0
2014-11-26 11:00:00	QQQ	ETF	105.17	105.28	105.17	105.2474	1260743.0
2014-11-26 11:30:00	QQQ	ETF	105.24	105.2998	105.2	105.22	646182.0
2014-11-26 12:00:00	QQQ	ETF	105.22	105.26	105.1766	105.22	618210.0
2014-11-26 12:30:00	QQQ	ETF	105.23	105.32	105.224	105.255	664693.0
2014-11-26 13:00:00	QQQ	ETF	105.26	105.36	105.26	105.32	443553.0
2014-11-26 13:30:00	QQQ	ETF	105.329	105.395	105.315	105.38	532856.0
2014-11-26 14:00:00	QQQ	ETF	105.389	105.39	105.32	105.3768	469252.0
2014-11-26 14:30:00	QQQ	ETF	105.38	105.41	105.332	105.34	621628.0

> showing 50 of 11,723 rows — these rows as CSV

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