PREVIEW / etf_30min / 2016-07-07

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-07-07.parquet
  size:    402 KB
  rows:    13,592

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
2016-07-07 04:00:00	SPY	ETF	209.92	210.12	209.86	210.09	11940.0
2016-07-07 04:30:00	SPY	ETF	210.11	210.27	210.06	210.06	10710.0
2016-07-07 05:00:00	SPY	ETF	210.0	210.0	209.66	209.66	7725.0
2016-07-07 05:30:00	SPY	ETF	209.71	209.9	209.68	209.9	16511.0
2016-07-07 06:00:00	SPY	ETF	209.84	209.94	209.78	209.78	13729.0
2016-07-07 06:30:00	SPY	ETF	209.83	209.84	209.56	209.56	9461.0
2016-07-07 07:00:00	SPY	ETF	209.6	209.69	209.56	209.58	140824.0
2016-07-07 07:30:00	SPY	ETF	209.6	209.67	209.43	209.5	212865.0
2016-07-07 08:00:00	SPY	ETF	209.5	209.9	209.45	209.58	484997.0
2016-07-07 08:30:00	SPY	ETF	209.62	209.86	209.61	209.77	225830.0
2016-07-07 09:00:00	SPY	ETF	209.77	209.92	209.67	209.88	404238.0
2016-07-07 09:30:00	SPY	ETF	209.87	210.6495	209.87	210.56	8697236.0
2016-07-07 10:00:00	SPY	ETF	210.56	210.595	210.25	210.485	4793538.0
2016-07-07 10:30:00	SPY	ETF	210.49	210.59	209.91	210.0	4306914.0
2016-07-07 11:00:00	SPY	ETF	209.99	210.03	209.55	209.76	7344018.0
2016-07-07 11:30:00	SPY	ETF	209.77	209.8	209.4	209.69	5259869.0
2016-07-07 12:00:00	SPY	ETF	209.7	209.79	209.42	209.7	3151156.0
2016-07-07 12:30:00	SPY	ETF	209.7	209.72	209.06	209.11	5035939.0
2016-07-07 13:00:00	SPY	ETF	209.11	209.38	208.96	209.23	4549280.0
2016-07-07 13:30:00	SPY	ETF	209.24	209.45	209.01	209.2207	5080661.0
2016-07-07 14:00:00	SPY	ETF	209.22	209.35	208.72	208.9199	5867705.0
2016-07-07 14:30:00	SPY	ETF	208.92	209.0	208.65	208.74	4469864.0
2016-07-07 15:00:00	SPY	ETF	208.73	209.24	208.63	209.19	5818346.0
2016-07-07 15:30:00	SPY	ETF	209.19	209.62	209.1	209.53	11241670.0
2016-07-07 16:00:00	SPY	ETF	209.54	209.65	209.44	209.62	5134908.0
2016-07-07 16:30:00	SPY	ETF	209.62	209.67	209.526	209.66	2289537.0
2016-07-07 17:00:00	SPY	ETF	209.66	209.67	209.58	209.6	98886.0
2016-07-07 17:30:00	SPY	ETF	209.61	209.67	209.59	209.63	20157.0
2016-07-07 18:00:00	SPY	ETF	209.58	209.68	209.52	209.56	76998.0
2016-07-07 18:30:00	SPY	ETF	209.6	209.6	209.58	209.59	6598.0
2016-07-07 19:00:00	SPY	ETF	209.6	209.67	209.59	209.67	24538.0
2016-07-07 19:30:00	SPY	ETF	209.66	209.71	209.59	209.61	50646.0
2016-07-07 04:00:00	QQQ	ETF	108.47	108.5	108.47	108.5	997.0
2016-07-07 06:00:00	QQQ	ETF	108.43	108.43	108.41	108.41	600.0
2016-07-07 06:30:00	QQQ	ETF	108.42	108.42	108.42	108.42	500.0
2016-07-07 07:00:00	QQQ	ETF	108.25	108.3	108.23	108.26	75852.0
2016-07-07 07:30:00	QQQ	ETF	108.25	108.25	108.19	108.23	14375.0
2016-07-07 08:00:00	QQQ	ETF	108.19	108.31	108.19	108.25	109274.0
2016-07-07 08:30:00	QQQ	ETF	108.28	108.4	108.25	108.37	253391.0
2016-07-07 09:00:00	QQQ	ETF	108.37	108.43	108.33	108.39	69927.0
2016-07-07 09:30:00	QQQ	ETF	108.39	108.86	108.39	108.79	2632559.0
2016-07-07 10:00:00	QQQ	ETF	108.79	108.81	108.6238	108.71	922780.0
2016-07-07 10:30:00	QQQ	ETF	108.73	108.809	108.42	108.45	762064.0
2016-07-07 11:00:00	QQQ	ETF	108.44	108.58	108.32	108.455	1401935.0
2016-07-07 11:30:00	QQQ	ETF	108.45	108.5	108.27	108.415	619579.0
2016-07-07 12:00:00	QQQ	ETF	108.41	108.57	108.36	108.535	950109.0
2016-07-07 12:30:00	QQQ	ETF	108.535	108.55	108.17	108.18	1473256.0
2016-07-07 13:00:00	QQQ	ETF	108.18	108.42	108.11	108.37	1046358.0
2016-07-07 13:30:00	QQQ	ETF	108.38	108.47	108.266	108.3801	719828.0
2016-07-07 14:00:00	QQQ	ETF	108.385	108.5	108.16	108.33	925169.0

> showing 50 of 13,592 rows — these rows as CSV

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