PREVIEW / etf_30min / 2013-11-25

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-11-25.parquet
  size:    328 KB
  rows:    11,163

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
2013-11-25 04:00:00	SPY	ETF	180.97	181.17	180.97	181.17	443199.0
2013-11-25 04:30:00	SPY	ETF	181.2	181.26	181.17	181.24	9695.0
2013-11-25 05:00:00	SPY	ETF	181.11	181.12	181.11	181.12	489.0
2013-11-25 05:30:00	SPY	ETF	181.16	181.21	181.15	181.21	67069.0
2013-11-25 06:00:00	SPY	ETF	181.17	181.22	181.17	181.22	93200.0
2013-11-25 06:30:00	SPY	ETF	181.23	181.28	181.19	181.28	60600.0
2013-11-25 07:00:00	SPY	ETF	181.24	181.26	181.18	181.19	38484.0
2013-11-25 07:30:00	SPY	ETF	181.2	181.24	181.15	181.24	95893.0
2013-11-25 08:00:00	SPY	ETF	181.21	181.29	181.2	181.25	170767.0
2013-11-25 08:30:00	SPY	ETF	181.28	181.28	181.18	181.22	442576.0
2013-11-25 09:00:00	SPY	ETF	181.18	181.25	181.1	181.13	475207.0
2013-11-25 09:30:00	SPY	ETF	181.13	181.17	180.84	180.86	9749571.0
2013-11-25 10:00:00	SPY	ETF	180.85	180.93	180.711	180.815	5719387.0
2013-11-25 10:30:00	SPY	ETF	180.81	181.03	180.73	180.86	4439894.0
2013-11-25 11:00:00	SPY	ETF	180.86	180.97	180.83	180.935	2203635.0
2013-11-25 11:30:00	SPY	ETF	180.94	181.01	180.86	180.93	2940922.0
2013-11-25 12:00:00	SPY	ETF	180.9201	181.0	180.87	180.98	2121302.0
2013-11-25 12:30:00	SPY	ETF	180.98	180.99	180.8078	180.89	5570907.0
2013-11-25 13:00:00	SPY	ETF	180.89	180.91	180.81	180.88	2801901.0
2013-11-25 13:30:00	SPY	ETF	180.88	181.04	180.87	181.005	2131895.0
2013-11-25 14:00:00	SPY	ETF	181.005	181.09	180.98	181.0299	2063216.0
2013-11-25 14:30:00	SPY	ETF	181.025	181.05	180.9	180.92	2712021.0
2013-11-25 15:00:00	SPY	ETF	180.91	180.92	180.49	180.61	8756558.0
2013-11-25 15:30:00	SPY	ETF	180.61	181.05	180.37	180.655	16201140.0
2013-11-25 16:00:00	SPY	ETF	180.65	181.7	180.43	180.8078	3038127.0
2013-11-25 16:30:00	SPY	ETF	180.71	180.8168	180.66	180.72	3168538.0
2013-11-25 17:00:00	SPY	ETF	180.73	180.8078	180.65	180.7	578309.0
2013-11-25 17:30:00	SPY	ETF	180.7	180.71	180.67	180.67	24153.0
2013-11-25 18:00:00	SPY	ETF	180.65	180.69	180.63	180.69	33252.0
2013-11-25 18:30:00	SPY	ETF	180.69	180.73	180.69	180.73	82040.0
2013-11-25 19:00:00	SPY	ETF	180.73	180.75	180.69	180.71	52433.0
2013-11-25 19:30:00	SPY	ETF	180.73	180.85	180.72	180.83	75609.0
2013-11-25 04:00:00	QQQ	ETF	84.07	84.28	84.07	84.28	1239.0
2013-11-25 04:30:00	QQQ	ETF	84.27	84.28	84.26	84.26	17700.0
2013-11-25 05:00:00	QQQ	ETF	84.23	84.23	84.23	84.23	1500.0
2013-11-25 05:30:00	QQQ	ETF	84.26	84.26	84.26	84.26	1500.0
2013-11-25 06:30:00	QQQ	ETF	84.28	84.29	84.28	84.29	2000.0
2013-11-25 07:00:00	QQQ	ETF	84.26	84.3	84.26	84.3	3900.0
2013-11-25 07:30:00	QQQ	ETF	84.28	84.3	84.28	84.3	18090.0
2013-11-25 08:00:00	QQQ	ETF	84.28	84.31	84.27	84.29	37445.0
2013-11-25 08:30:00	QQQ	ETF	84.3	84.31	84.27	84.31	8085.0
2013-11-25 09:00:00	QQQ	ETF	84.31	84.34	84.26	84.29	55930.0
2013-11-25 09:30:00	QQQ	ETF	84.29	84.38	84.1199	84.13	3406810.0
2013-11-25 10:00:00	QQQ	ETF	84.12	84.15	83.98	84.05	1925182.0
2013-11-25 10:30:00	QQQ	ETF	84.04	84.18	84.0	84.08	1458030.0
2013-11-25 11:00:00	QQQ	ETF	84.08	84.22	84.07	84.191	1110527.0
2013-11-25 11:30:00	QQQ	ETF	84.2	84.26	84.17	84.2001	1904867.0
2013-11-25 12:00:00	QQQ	ETF	84.21	84.28	84.16	84.27	748409.0
2013-11-25 12:30:00	QQQ	ETF	84.27	84.28	84.17	84.17	709954.0
2013-11-25 13:00:00	QQQ	ETF	84.175	84.225	84.16	84.2	540906.0

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

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