PREVIEW / etf_30min / 2015-05-12

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-05-12.parquet
  size:    380 KB
  rows:    12,777

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-05-12 04:00:00	SPY	ETF	209.83	209.83	209.46	209.58	19044.0
2015-05-12 04:30:00	SPY	ETF	209.51	209.51	208.87	208.9	24889.0
2015-05-12 05:00:00	SPY	ETF	208.87	209.03	208.75	208.78	75969.0
2015-05-12 05:30:00	SPY	ETF	208.78	209.04	208.52	208.9	118153.0
2015-05-12 06:00:00	SPY	ETF	209.01	209.01	208.74	208.96	94340.0
2015-05-12 06:30:00	SPY	ETF	208.95	209.14	208.77	208.78	175983.0
2015-05-12 07:00:00	SPY	ETF	208.8	209.24	208.8	208.92	417290.0
2015-05-12 07:30:00	SPY	ETF	208.89	209.04	208.59	209.03	836757.0
2015-05-12 08:00:00	SPY	ETF	208.71	210.0	208.61	209.16	1472237.0
2015-05-12 08:30:00	SPY	ETF	209.18	209.45	209.03	209.375	777107.0
2015-05-12 09:00:00	SPY	ETF	209.36	209.68	209.21	209.63	1429688.0
2015-05-12 09:30:00	SPY	ETF	209.61	209.63	208.62	209.05	21019064.0
2015-05-12 10:00:00	SPY	ETF	209.04	209.27	208.74	208.91	10088881.0
2015-05-12 10:30:00	SPY	ETF	208.91	210.19	208.89	209.7799	14214072.0
2015-05-12 11:00:00	SPY	ETF	209.775	210.28	209.75	209.84	7111953.0
2015-05-12 11:30:00	SPY	ETF	209.84	210.22	209.81	210.02	5277425.0
2015-05-12 12:00:00	SPY	ETF	210.015	210.1	209.58	209.85	4248714.0
2015-05-12 12:30:00	SPY	ETF	209.85	210.28	209.78	210.12	3946747.0
2015-05-12 13:00:00	SPY	ETF	210.12	210.49	210.01	210.28	4958434.0
2015-05-12 13:30:00	SPY	ETF	210.285	210.33	209.925	210.1	4606562.0
2015-05-12 14:00:00	SPY	ETF	210.09	210.44	209.93	210.38	3765989.0
2015-05-12 14:30:00	SPY	ETF	210.37	210.63	210.07	210.19	6594406.0
2015-05-12 15:00:00	SPY	ETF	210.19	210.39	210.095	210.22	4679861.0
2015-05-12 15:30:00	SPY	ETF	210.22	210.3999	209.96	209.96	10135624.0
2015-05-12 16:00:00	SPY	ETF	209.97	210.1908	209.1806	210.13	6262289.0
2015-05-12 16:30:00	SPY	ETF	210.12	210.24	209.81	210.15	5685756.0
2015-05-12 17:00:00	SPY	ETF	210.12	210.24	209.98	210.23	35569.0
2015-05-12 17:30:00	SPY	ETF	210.18	210.21	210.17	210.19	18409.0
2015-05-12 18:00:00	SPY	ETF	210.23	210.29	209.98	210.29	34135.0
2015-05-12 18:30:00	SPY	ETF	210.31	210.36	210.29	210.36	17380.0
2015-05-12 19:00:00	SPY	ETF	210.34	210.35	210.3	210.3	3100.0
2015-05-12 19:30:00	SPY	ETF	210.28	210.4	210.27	210.38	12732.0
2015-05-12 04:00:00	QQQ	ETF	107.86	107.86	107.62	107.7	3400.0
2015-05-12 04:30:00	QQQ	ETF	107.55	107.55	107.31	107.34	1085.0
2015-05-12 05:00:00	QQQ	ETF	107.21	107.35	107.21	107.24	7846.0
2015-05-12 05:30:00	QQQ	ETF	107.23	107.35	107.11	107.3	38750.0
2015-05-12 06:00:00	QQQ	ETF	107.33	107.36	107.2	107.3	26380.0
2015-05-12 06:30:00	QQQ	ETF	107.32	107.37	107.29	107.31	7000.0
2015-05-12 07:00:00	QQQ	ETF	107.27	107.48	107.27	107.31	132493.0
2015-05-12 07:30:00	QQQ	ETF	107.27	107.32	107.13	107.32	41450.0
2015-05-12 08:00:00	QQQ	ETF	107.35	107.4	107.27	107.38	52002.0
2015-05-12 08:30:00	QQQ	ETF	107.37	107.48	107.28	107.43	98412.0
2015-05-12 09:00:00	QQQ	ETF	107.43	107.65	107.37	107.64	219981.0
2015-05-12 09:30:00	QQQ	ETF	107.63	107.64	106.8	107.11	5310604.0
2015-05-12 10:00:00	QQQ	ETF	107.11	107.27	106.97	107.13	2725751.0
2015-05-12 10:30:00	QQQ	ETF	107.13	107.85	107.12	107.655	3124181.0
2015-05-12 11:00:00	QQQ	ETF	107.66	108.02	107.66	107.78	1518409.0
2015-05-12 11:30:00	QQQ	ETF	107.78	107.97	107.76	107.84	643356.0
2015-05-12 12:00:00	QQQ	ETF	107.84	107.9	107.6	107.7802	725138.0
2015-05-12 12:30:00	QQQ	ETF	107.79	108.1	107.745	108.0	1169193.0

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

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