PREVIEW / etf_30min / 2014-08-11

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-08-11.parquet
  size:    340 KB
  rows:    11,558

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-08-11 04:00:00	SPY	ETF	193.51	193.65	193.42	193.42	8685.0
2014-08-11 04:30:00	SPY	ETF	193.51	193.63	193.49	193.63	1909.0
2014-08-11 05:00:00	SPY	ETF	193.61	193.62	193.59	193.6	11795.0
2014-08-11 05:30:00	SPY	ETF	193.6	193.63	193.59	193.6	8700.0
2014-08-11 06:00:00	SPY	ETF	193.55	193.66	193.55	193.66	17431.0
2014-08-11 06:30:00	SPY	ETF	193.68	193.77	193.68	193.71	43750.0
2014-08-11 07:00:00	SPY	ETF	193.7	193.9	193.7	193.9	125252.0
2014-08-11 07:30:00	SPY	ETF	193.88	193.88	193.77	193.84	122391.0
2014-08-11 08:00:00	SPY	ETF	193.84	194.06	193.1	194.03	668396.0
2014-08-11 08:30:00	SPY	ETF	194.04	194.11	193.81	193.86	504159.0
2014-08-11 09:00:00	SPY	ETF	193.85	193.99	193.82	193.97	640250.0
2014-08-11 09:30:00	SPY	ETF	193.965	194.22	193.7701	194.1549	10768861.0
2014-08-11 10:00:00	SPY	ETF	194.16	194.35	194.07	194.159	8989215.0
2014-08-11 10:30:00	SPY	ETF	194.16	194.4	194.08	194.195	5445551.0
2014-08-11 11:00:00	SPY	ETF	194.18	194.66	194.13	194.53	6368560.0
2014-08-11 11:30:00	SPY	ETF	194.53	194.58	194.39	194.43	3880620.0
2014-08-11 12:00:00	SPY	ETF	194.44	194.46	194.22	194.35	3961350.0
2014-08-11 12:30:00	SPY	ETF	194.3499	194.45	194.27	194.28	2421889.0
2014-08-11 13:00:00	SPY	ETF	194.281	194.39	194.13	194.14	1990411.0
2014-08-11 13:30:00	SPY	ETF	194.14	194.25	193.82	193.92	4471082.0
2014-08-11 14:00:00	SPY	ETF	193.91	194.01	193.72	193.9399	4710860.0
2014-08-11 14:30:00	SPY	ETF	193.935	194.02	193.83	193.905	2718752.0
2014-08-11 15:00:00	SPY	ETF	193.905	194.12	193.87	193.88	3630433.0
2014-08-11 15:30:00	SPY	ETF	193.875	193.97	193.71	193.79	8363881.0
2014-08-11 16:00:00	SPY	ETF	193.8	193.88	193.75	193.78	2837226.0
2014-08-11 16:30:00	SPY	ETF	193.78	193.9	193.78	193.89	550491.0
2014-08-11 17:00:00	SPY	ETF	193.89	193.95	193.86	193.92	117847.0
2014-08-11 17:30:00	SPY	ETF	193.9	193.9	193.86	193.89	28795.0
2014-08-11 18:00:00	SPY	ETF	193.92	193.97	193.91	193.93	70200.0
2014-08-11 18:30:00	SPY	ETF	193.91	193.97	193.91	193.97	1974.0
2014-08-11 19:00:00	SPY	ETF	193.97	193.97	193.93	193.96	2121.0
2014-08-11 19:30:00	SPY	ETF	193.95	193.97	193.93	193.97	17525.0
2014-08-11 04:00:00	QQQ	ETF	95.06	95.11	94.99	94.99	400.0
2014-08-11 04:30:00	QQQ	ETF	95.05	95.07	95.05	95.07	2200.0
2014-08-11 05:30:00	QQQ	ETF	95.16	95.16	95.16	95.16	1000.0
2014-08-11 06:00:00	QQQ	ETF	95.12	95.17	95.12	95.17	3800.0
2014-08-11 06:30:00	QQQ	ETF	95.17	95.22	95.17	95.2	35480.0
2014-08-11 07:00:00	QQQ	ETF	95.19	95.33	95.19	95.26	37400.0
2014-08-11 07:30:00	QQQ	ETF	95.27	95.28	95.21	95.24	54666.0
2014-08-11 08:00:00	QQQ	ETF	95.28	95.28	95.17	95.27	114750.0
2014-08-11 08:30:00	QQQ	ETF	95.26	95.29	95.18	95.21	91907.0
2014-08-11 09:00:00	QQQ	ETF	95.2	95.26	95.19	95.25	162175.0
2014-08-11 09:30:00	QQQ	ETF	95.25	95.55	95.2	95.52	4088284.0
2014-08-11 10:00:00	QQQ	ETF	95.53	95.64	95.44	95.56	2126223.0
2014-08-11 10:30:00	QQQ	ETF	95.57	95.68	95.53	95.58	1817705.0
2014-08-11 11:00:00	QQQ	ETF	95.57	95.76	95.52	95.7	2185239.0
2014-08-11 11:30:00	QQQ	ETF	95.71	95.75	95.625	95.65	999572.0
2014-08-11 12:00:00	QQQ	ETF	95.65	95.68	95.5599	95.63	1101740.0
2014-08-11 12:30:00	QQQ	ETF	95.63	95.6778	95.55	95.5601	558223.0
2014-08-11 13:00:00	QQQ	ETF	95.56	95.66	95.54	95.555	814484.0

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

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