PREVIEW / etf_30min / 2017-12-07

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-12-07.parquet
  size:    450 KB
  rows:    15,499

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
2017-12-07 04:00:00	SPY	ETF	263.53	263.63	263.53	263.63	2300.0
2017-12-07 04:30:00	SPY	ETF	263.63	263.8	263.63	263.73	3470.0
2017-12-07 05:30:00	SPY	ETF	263.76	263.78	263.54	263.54	3300.0
2017-12-07 06:00:00	SPY	ETF	263.5	263.57	263.45	263.45	13400.0
2017-12-07 06:30:00	SPY	ETF	263.4	263.46	263.35	263.46	11900.0
2017-12-07 07:00:00	SPY	ETF	263.42	263.47	263.2	263.39	146187.0
2017-12-07 07:30:00	SPY	ETF	263.39	263.39	263.16	263.16	60002.0
2017-12-07 08:00:00	SPY	ETF	263.38	263.46	263.13	263.33	206183.0
2017-12-07 08:30:00	SPY	ETF	263.3	263.3	263.07	263.08	99853.0
2017-12-07 09:00:00	SPY	ETF	263.08	263.19	262.97	263.1	351860.0
2017-12-07 09:30:00	SPY	ETF	263.09	263.56	262.94	263.54	7550504.0
2017-12-07 10:00:00	SPY	ETF	263.55	263.69	263.27	263.6	4376021.0
2017-12-07 10:30:00	SPY	ETF	263.6	263.95	263.6	263.93	2974010.0
2017-12-07 11:00:00	SPY	ETF	263.93	264.02	263.59	263.95	3029689.0
2017-12-07 11:30:00	SPY	ETF	263.94	264.31	263.94	264.265	5653682.0
2017-12-07 12:00:00	SPY	ETF	264.27	264.291	264.08	264.15	1802288.0
2017-12-07 12:30:00	SPY	ETF	264.145	264.31	264.11	264.305	2749652.0
2017-12-07 13:00:00	SPY	ETF	264.305	264.43	264.01	264.25	2984378.0
2017-12-07 13:30:00	SPY	ETF	264.25	264.36	264.01	264.1671	3574133.0
2017-12-07 14:00:00	SPY	ETF	264.17	264.24	263.88	263.935	4673785.0
2017-12-07 14:30:00	SPY	ETF	263.9253	263.9399	263.56	263.9	4576746.0
2017-12-07 15:00:00	SPY	ETF	263.9	264.11	263.74	264.02	5129323.0
2017-12-07 15:30:00	SPY	ETF	264.01	264.11	263.75	264.04	10669337.0
2017-12-07 16:00:00	SPY	ETF	264.04	264.28	263.2394	263.2394	8745864.0
2017-12-07 16:30:00	SPY	ETF	264.24	264.29	263.2394	264.24	840647.0
2017-12-07 17:00:00	SPY	ETF	264.23	264.32	264.0087	264.29	70411.0
2017-12-07 17:30:00	SPY	ETF	264.1995	264.31	263.9363	264.28	154250.0
2017-12-07 18:00:00	SPY	ETF	264.28	264.37	264.24	264.32	139470.0
2017-12-07 18:30:00	SPY	ETF	264.34	264.42	264.07	264.42	25619.0
2017-12-07 19:00:00	SPY	ETF	264.41	264.42	264.08	264.24	51111.0
2017-12-07 19:30:00	SPY	ETF	264.28	264.33	264.16	264.3	15540.0
2017-12-07 04:00:00	QQQ	ETF	154.0	154.0	153.96	153.96	1503.0
2017-12-07 04:30:00	QQQ	ETF	154.03	154.11	154.03	154.11	3900.0
2017-12-07 05:00:00	QQQ	ETF	154.03	154.09	154.03	154.09	2600.0
2017-12-07 05:30:00	QQQ	ETF	154.15	154.15	154.01	154.01	31856.0
2017-12-07 06:00:00	QQQ	ETF	153.97	153.97	153.87	153.87	17100.0
2017-12-07 06:30:00	QQQ	ETF	153.82	153.87	153.77	153.85	12400.0
2017-12-07 07:00:00	QQQ	ETF	153.87	153.89	153.7	153.82	132500.0
2017-12-07 07:30:00	QQQ	ETF	153.85	153.85	153.61	153.62	75588.0
2017-12-07 08:00:00	QQQ	ETF	153.82	153.93	153.61	153.92	151259.0
2017-12-07 08:30:00	QQQ	ETF	153.89	153.89	153.65	153.69	95140.0
2017-12-07 09:00:00	QQQ	ETF	153.7	153.72	153.47	153.49	153520.0
2017-12-07 09:30:00	QQQ	ETF	153.49	153.99	153.33	153.77	3816449.0
2017-12-07 10:00:00	QQQ	ETF	153.76	153.97	153.37	153.94	2071932.0
2017-12-07 10:30:00	QQQ	ETF	153.94	154.38	153.94	154.31	3327555.0
2017-12-07 11:00:00	QQQ	ETF	154.31	154.385	153.96	154.2	1427195.0
2017-12-07 11:30:00	QQQ	ETF	154.21	154.46	154.18	154.41	1015010.0
2017-12-07 12:00:00	QQQ	ETF	154.41	154.41	154.15	154.2084	734713.0
2017-12-07 12:30:00	QQQ	ETF	154.2099	154.42	154.185	154.34	441774.0
2017-12-07 13:00:00	QQQ	ETF	154.35	154.43	154.105	154.26	1018451.0

> showing 50 of 15,499 rows — these rows as CSV

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