PREVIEW / etf_30min / 2016-04-28

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-04-28.parquet
  size:    403 KB
  rows:    13,635

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-04-28 04:00:00	SPY	ETF	208.47	208.47	207.63	207.75	68175.0
2016-04-28 04:30:00	SPY	ETF	207.77	207.78	207.45	207.6	123539.0
2016-04-28 05:00:00	SPY	ETF	207.61	207.83	207.6	207.83	12638.0
2016-04-28 05:30:00	SPY	ETF	207.88	207.95	207.75	207.88	11367.0
2016-04-28 06:00:00	SPY	ETF	207.84	208.04	207.84	207.96	12325.0
2016-04-28 06:30:00	SPY	ETF	207.94	208.0	207.84	207.84	53759.0
2016-04-28 07:00:00	SPY	ETF	207.86	208.21	207.83	207.83	146805.0
2016-04-28 07:30:00	SPY	ETF	207.82	208.05	207.8	207.97	216512.0
2016-04-28 08:00:00	SPY	ETF	207.93	208.29	207.82	208.13	425297.0
2016-04-28 08:30:00	SPY	ETF	208.12	208.27	208.01	208.27	393308.0
2016-04-28 09:00:00	SPY	ETF	208.24	208.56	208.18	208.46	930494.0
2016-04-28 09:30:00	SPY	ETF	208.46	209.08	208.19	209.05	8753888.0
2016-04-28 10:00:00	SPY	ETF	209.04	209.36	208.925	209.095	6295428.0
2016-04-28 10:30:00	SPY	ETF	209.1	209.48	209.0	209.44	5187076.0
2016-04-28 11:00:00	SPY	ETF	209.44	209.7	209.36	209.63	3901428.0
2016-04-28 11:30:00	SPY	ETF	209.62	209.76	209.54	209.56	2554720.0
2016-04-28 12:00:00	SPY	ETF	209.57	209.71	209.35	209.42	2833610.0
2016-04-28 12:30:00	SPY	ETF	209.42	209.69	209.32	209.62	3705183.0
2016-04-28 13:00:00	SPY	ETF	209.625	209.65	209.06	209.26	3800199.0
2016-04-28 13:30:00	SPY	ETF	209.25	209.4	209.18	209.25	2366201.0
2016-04-28 14:00:00	SPY	ETF	209.25	209.35	208.9901	209.16	3298791.0
2016-04-28 14:30:00	SPY	ETF	209.16	209.2	208.5	208.61	4202054.0
2016-04-28 15:00:00	SPY	ETF	208.62	208.63	207.01	207.08	13857013.0
2016-04-28 15:30:00	SPY	ETF	207.07	207.71	206.96	207.48	22668427.0
2016-04-28 16:00:00	SPY	ETF	207.49	209.339	207.2685	207.8	7225619.0
2016-04-28 16:30:00	SPY	ETF	207.8	207.9	207.78	207.85	274950.0
2016-04-28 17:00:00	SPY	ETF	207.83	207.86	207.4475	207.86	511497.0
2016-04-28 17:30:00	SPY	ETF	207.87	207.93	207.81	207.83	59446.0
2016-04-28 18:00:00	SPY	ETF	207.83	207.87	207.65	207.71	329681.0
2016-04-28 18:30:00	SPY	ETF	207.69	207.72	207.61	207.69	43320.0
2016-04-28 19:00:00	SPY	ETF	207.72	207.83	207.72	207.81	15598.0
2016-04-28 19:30:00	SPY	ETF	207.84	207.86	207.79	207.81	28968.0
2016-04-28 04:00:00	QQQ	ETF	107.59	107.59	107.4	107.4	3247.0
2016-04-28 04:30:00	QQQ	ETF	107.3	107.34	107.22	107.27	7598.0
2016-04-28 05:00:00	QQQ	ETF	107.35	107.42	107.35	107.42	4606.0
2016-04-28 05:30:00	QQQ	ETF	107.38	107.38	107.32	107.32	1300.0
2016-04-28 06:00:00	QQQ	ETF	107.44	107.5	107.44	107.5	5000.0
2016-04-28 06:30:00	QQQ	ETF	107.45	107.52	107.43	107.43	3097.0
2016-04-28 07:00:00	QQQ	ETF	107.33	107.56	107.33	107.43	48537.0
2016-04-28 07:30:00	QQQ	ETF	107.43	107.54	107.43	107.5	10599.0
2016-04-28 08:00:00	QQQ	ETF	107.51	107.63	107.47	107.55	42113.0
2016-04-28 08:30:00	QQQ	ETF	107.55	107.66	107.49	107.66	69352.0
2016-04-28 09:00:00	QQQ	ETF	107.67	107.76	107.62	107.69	191261.0
2016-04-28 09:30:00	QQQ	ETF	107.69	108.036	107.56	107.982	3004987.0
2016-04-28 10:00:00	QQQ	ETF	107.98	108.14	107.81	108.0	1411212.0
2016-04-28 10:30:00	QQQ	ETF	108.01	108.27	107.921	108.26	1474067.0
2016-04-28 11:00:00	QQQ	ETF	108.265	108.33	108.171	108.2601	993866.0
2016-04-28 11:30:00	QQQ	ETF	108.27	108.3335	108.17	108.21	877998.0
2016-04-28 12:00:00	QQQ	ETF	108.22	108.28	107.92	107.931	789457.0
2016-04-28 12:30:00	QQQ	ETF	107.93	107.96	107.8089	107.9	754632.0

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

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