PREVIEW / etf_30min / 2016-06-22

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-06-22.parquet
  size:    386 KB
  rows:    13,130

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-06-22 04:00:00	SPY	ETF	208.26	208.44	208.23	208.34	8575.0
2016-06-22 04:30:00	SPY	ETF	208.35	208.4	208.35	208.4	1105.0
2016-06-22 05:00:00	SPY	ETF	208.4	208.43	208.36	208.43	605.0
2016-06-22 05:30:00	SPY	ETF	208.5	208.68	208.49	208.68	1220.0
2016-06-22 06:00:00	SPY	ETF	208.65	208.65	208.54	208.57	3313.0
2016-06-22 06:30:00	SPY	ETF	208.57	208.68	208.56	208.68	6567.0
2016-06-22 07:00:00	SPY	ETF	208.69	208.83	208.56	208.56	68685.0
2016-06-22 07:30:00	SPY	ETF	208.55	208.58	208.44	208.57	31252.0
2016-06-22 08:00:00	SPY	ETF	208.57	208.69	208.5	208.56	108152.0
2016-06-22 08:30:00	SPY	ETF	208.57	208.66	208.57	208.6	127859.0
2016-06-22 09:00:00	SPY	ETF	208.6	208.73	208.57	208.66	189177.0
2016-06-22 09:30:00	SPY	ETF	208.65	208.9	208.57	208.69	5958786.0
2016-06-22 10:00:00	SPY	ETF	208.69	209.06	208.57	209.04	4968102.0
2016-06-22 10:30:00	SPY	ETF	209.035	209.5	208.82	209.3	7292350.0
2016-06-22 11:00:00	SPY	ETF	209.31	209.48	209.17	209.45	4515189.0
2016-06-22 11:30:00	SPY	ETF	209.445	209.45	208.82	209.075	8001000.0
2016-06-22 12:00:00	SPY	ETF	209.075	209.14	208.43	208.58	8001066.0
2016-06-22 12:30:00	SPY	ETF	208.58	208.66	208.36	208.62	5241725.0
2016-06-22 13:00:00	SPY	ETF	208.63	208.64	208.04	208.32	7077474.0
2016-06-22 13:30:00	SPY	ETF	208.32	208.72	208.28	208.63	4934404.0
2016-06-22 14:00:00	SPY	ETF	208.63	208.78	208.44	208.64	5804173.0
2016-06-22 14:30:00	SPY	ETF	208.63	208.71	208.29	208.48	4611629.0
2016-06-22 15:00:00	SPY	ETF	208.48	208.715	208.1	208.15	7192341.0
2016-06-22 15:30:00	SPY	ETF	208.14	208.36	207.93	208.05	13957025.0
2016-06-22 16:00:00	SPY	ETF	208.05	209.0806	207.98	208.06	3805551.0
2016-06-22 16:30:00	SPY	ETF	208.07	208.18	208.03	208.09	411293.0
2016-06-22 17:00:00	SPY	ETF	208.09	208.55	208.09	208.54	562097.0
2016-06-22 17:30:00	SPY	ETF	208.53	208.68	208.51	208.68	781880.0
2016-06-22 18:00:00	SPY	ETF	208.68	209.36	208.67	209.01	240106.0
2016-06-22 18:30:00	SPY	ETF	209.02	209.11	208.97	209.01	62769.0
2016-06-22 19:00:00	SPY	ETF	209.01	209.08	209.01	209.03	18867.0
2016-06-22 19:30:00	SPY	ETF	209.02	209.03	208.87	209.01	50414.0
2016-06-22 04:00:00	QQQ	ETF	107.25	107.33	107.25	107.33	7399.0
2016-06-22 04:30:00	QQQ	ETF	107.34	107.34	107.34	107.34	500.0
2016-06-22 05:00:00	QQQ	ETF	107.35	107.45	107.35	107.45	3100.0
2016-06-22 05:30:00	QQQ	ETF	107.45	107.52	107.45	107.52	1505.0
2016-06-22 06:00:00	QQQ	ETF	107.56	107.56	107.54	107.54	900.0
2016-06-22 06:30:00	QQQ	ETF	107.51	107.58	107.49	107.58	918.0
2016-06-22 07:00:00	QQQ	ETF	107.57	107.66	107.56	107.62	25949.0
2016-06-22 07:30:00	QQQ	ETF	107.53	107.57	107.53	107.57	2301.0
2016-06-22 08:00:00	QQQ	ETF	107.58	107.58	107.54	107.54	6200.0
2016-06-22 08:30:00	QQQ	ETF	107.56	107.59	107.54	107.58	7895.0
2016-06-22 09:00:00	QQQ	ETF	107.62	107.62	107.54	107.57	46978.0
2016-06-22 09:30:00	QQQ	ETF	107.58	107.63	107.37	107.38	1440983.0
2016-06-22 10:00:00	QQQ	ETF	107.38	107.59	107.33	107.52	975727.0
2016-06-22 10:30:00	QQQ	ETF	107.515	108.04	107.46	107.95	1622125.0
2016-06-22 11:00:00	QQQ	ETF	107.95	108.19	107.92	108.16	1161592.0
2016-06-22 11:30:00	QQQ	ETF	108.16	108.16	107.84	107.94	1462113.0
2016-06-22 12:00:00	QQQ	ETF	107.93	107.97	107.47	107.56	927827.0
2016-06-22 12:30:00	QQQ	ETF	107.56	107.6198	107.4	107.59	745825.0

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

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