PREVIEW / etf_30min / 2016-02-10

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-02-10.parquet
  size:    400 KB
  rows:    13,563

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-02-10 04:00:00	SPY	ETF	186.58	186.95	186.52	186.72	38613.0
2016-02-10 04:30:00	SPY	ETF	186.77	187.2	186.51	187.04	82946.0
2016-02-10 05:00:00	SPY	ETF	187.1	187.62	187.04	187.46	41515.0
2016-02-10 05:30:00	SPY	ETF	187.53	187.53	187.22	187.36	48553.0
2016-02-10 06:00:00	SPY	ETF	187.39	187.54	187.02	187.31	53530.0
2016-02-10 06:30:00	SPY	ETF	187.35	187.38	187.04	187.19	106044.0
2016-02-10 07:00:00	SPY	ETF	187.24	187.49	187.11	187.18	156741.0
2016-02-10 07:30:00	SPY	ETF	187.21	187.73	187.16	187.62	367164.0
2016-02-10 08:00:00	SPY	ETF	186.695	187.73	186.695	187.43	949561.0
2016-02-10 08:30:00	SPY	ETF	187.42	187.54	186.5	186.99	2400534.0
2016-02-10 09:00:00	SPY	ETF	187.0	187.09	186.2	186.41	1718488.0
2016-02-10 09:30:00	SPY	ETF	186.41	187.2	186.0738	187.1	15652912.0
2016-02-10 10:00:00	SPY	ETF	187.1	187.65	186.73	187.38	12452182.0
2016-02-10 10:30:00	SPY	ETF	187.38	188.34	186.52	186.74	17181310.0
2016-02-10 11:00:00	SPY	ETF	186.75	187.16	186.26	186.53	13200877.0
2016-02-10 11:30:00	SPY	ETF	186.53	186.9	185.86	186.68	11536313.0
2016-02-10 12:00:00	SPY	ETF	186.68	187.1	186.27	187.03	6562996.0
2016-02-10 12:30:00	SPY	ETF	187.03	187.7	186.809	187.551	6866372.0
2016-02-10 13:00:00	SPY	ETF	187.55	187.716	186.79	186.88	8729378.0
2016-02-10 13:30:00	SPY	ETF	186.87	187.22	186.62	186.77	5003905.0
2016-02-10 14:00:00	SPY	ETF	186.79	187.22	186.69	186.94	4615842.0
2016-02-10 14:30:00	SPY	ETF	186.94	187.275	186.2	186.38	6141487.0
2016-02-10 15:00:00	SPY	ETF	186.38	187.08	185.6	185.671	9718951.0
2016-02-10 15:30:00	SPY	ETF	185.7057	185.93	185.12	185.29	17879459.0
2016-02-10 16:00:00	SPY	ETF	185.27	185.43	184.94	185.27	4798773.0
2016-02-10 16:30:00	SPY	ETF	185.27	185.31	184.79	184.83	442658.0
2016-02-10 17:00:00	SPY	ETF	184.82	185.0	184.8	184.93	174646.0
2016-02-10 17:30:00	SPY	ETF	184.95	184.98	184.75	184.78	112180.0
2016-02-10 18:00:00	SPY	ETF	184.92	185.27	184.73	184.82	210485.0
2016-02-10 18:30:00	SPY	ETF	184.84	184.84	184.45	184.49	112003.0
2016-02-10 19:00:00	SPY	ETF	184.51	184.81	184.32	184.73	67349.0
2016-02-10 19:30:00	SPY	ETF	184.75	184.79	183.9	183.93	195954.0
2016-02-10 04:00:00	QQQ	ETF	97.08	97.32	97.01	97.3	6236.0
2016-02-10 04:30:00	QQQ	ETF	97.33	97.56	97.33	97.56	6850.0
2016-02-10 05:00:00	QQQ	ETF	97.58	97.89	97.58	97.89	2800.0
2016-02-10 05:30:00	QQQ	ETF	97.67	97.79	97.67	97.72	1700.0
2016-02-10 06:00:00	QQQ	ETF	97.81	97.81	97.57	97.57	3300.0
2016-02-10 06:30:00	QQQ	ETF	97.72	97.72	97.63	97.65	9056.0
2016-02-10 07:00:00	QQQ	ETF	97.63	97.75	97.54	97.54	33299.0
2016-02-10 07:30:00	QQQ	ETF	97.57	97.93	97.56	97.93	204023.0
2016-02-10 08:00:00	QQQ	ETF	97.91	98.01	97.78	97.94	180017.0
2016-02-10 08:30:00	QQQ	ETF	97.91	97.98	97.5	97.66	530914.0
2016-02-10 09:00:00	QQQ	ETF	97.57	97.66	97.16	97.51	353538.0
2016-02-10 09:30:00	QQQ	ETF	97.5	97.98	97.03	97.95	6970797.0
2016-02-10 10:00:00	QQQ	ETF	97.94	98.34	97.71	98.19	4827066.0
2016-02-10 10:30:00	QQQ	ETF	98.2	98.69	97.52	97.61	6017914.0
2016-02-10 11:00:00	QQQ	ETF	97.61	97.99	97.34	97.62	4074459.0
2016-02-10 11:30:00	QQQ	ETF	97.62	97.8	97.1686	97.62	2404662.0
2016-02-10 12:00:00	QQQ	ETF	97.64	97.98	97.42	97.97	1503738.0
2016-02-10 12:30:00	QQQ	ETF	97.97	98.28	97.83	98.23	2118927.0

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

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