PREVIEW / etf_30min / 2014-10-16

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-10-16.parquet
  size:    391 KB
  rows:    13,063

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
2014-10-16 04:00:00	SPY	ETF	185.61	185.77	185.1	185.45	12866.0
2014-10-16 04:30:00	SPY	ETF	185.44	185.87	185.01	185.15	46816.0
2014-10-16 05:00:00	SPY	ETF	185.18	185.18	184.13	184.2	52036.0
2014-10-16 05:30:00	SPY	ETF	184.16	184.39	182.49	183.28	166967.0
2014-10-16 06:00:00	SPY	ETF	183.18	183.94	182.55	183.74	398841.0
2014-10-16 06:30:00	SPY	ETF	183.76	183.92	182.26	182.87	549818.0
2014-10-16 07:00:00	SPY	ETF	182.92	183.2	182.17	183.14	945809.0
2014-10-16 07:30:00	SPY	ETF	183.15	183.49	182.9	183.43	805283.0
2014-10-16 08:00:00	SPY	ETF	183.43	183.91	182.39	183.42	1947813.0
2014-10-16 08:30:00	SPY	ETF	183.44	183.74	182.4	182.91	5141211.0
2014-10-16 09:00:00	SPY	ETF	182.92	183.86	182.85	183.05	3463002.0
2014-10-16 09:30:00	SPY	ETF	183.06	185.23	182.89	185.1	31131425.0
2014-10-16 10:00:00	SPY	ETF	185.09	185.83	183.37	184.68	33925277.0
2014-10-16 10:30:00	SPY	ETF	184.67	186.25	184.47	185.52	18627497.0
2014-10-16 11:00:00	SPY	ETF	185.52	186.47	184.58	186.41	16739481.0
2014-10-16 11:30:00	SPY	ETF	186.41	186.78	184.579	185.48	16981291.0
2014-10-16 12:00:00	SPY	ETF	185.481	186.11	185.07	185.64	10516815.0
2014-10-16 12:30:00	SPY	ETF	185.64	186.48	185.125	186.33	9687780.0
2014-10-16 13:00:00	SPY	ETF	186.33	187.36	186.33	187.04	15662337.0
2014-10-16 13:30:00	SPY	ETF	187.03	187.58	184.58	186.58	14734723.0
2014-10-16 14:00:00	SPY	ETF	186.57	187.1	186.16	186.655	14610230.0
2014-10-16 14:30:00	SPY	ETF	186.66	186.91	185.79	186.02	12923063.0
2014-10-16 15:00:00	SPY	ETF	186.03	186.75	185.55	186.55	15762947.0
2014-10-16 15:30:00	SPY	ETF	186.54	186.89	185.99	186.24	25545278.0
2014-10-16 16:00:00	SPY	ETF	186.24	186.3196	185.44	185.6	10001746.0
2014-10-16 16:30:00	SPY	ETF	185.59	187.0	185.49	185.72	7883208.0
2014-10-16 17:00:00	SPY	ETF	185.67	185.91	185.64	185.9	215978.0
2014-10-16 17:30:00	SPY	ETF	185.87	185.91	185.84	185.91	59830.0
2014-10-16 18:00:00	SPY	ETF	185.9	186.24	185.85	186.16	100701.0
2014-10-16 18:30:00	SPY	ETF	186.16	186.3	186.16	186.3	30602.0
2014-10-16 19:00:00	SPY	ETF	186.3	186.3	186.0	186.17	9730.0
2014-10-16 19:30:00	SPY	ETF	186.2	186.25	186.15	186.23	93967.0
2014-10-16 04:00:00	QQQ	ETF	91.57	91.57	91.52	91.52	367.0
2014-10-16 04:30:00	QQQ	ETF	91.77	91.77	91.77	91.77	146.0
2014-10-16 05:00:00	QQQ	ETF	91.46	91.46	91.14	91.14	1690.0
2014-10-16 05:30:00	QQQ	ETF	91.12	91.24	90.42	90.77	28378.0
2014-10-16 06:00:00	QQQ	ETF	90.8	90.98	90.32	90.98	68898.0
2014-10-16 06:30:00	QQQ	ETF	90.93	90.96	90.19	90.41	97450.0
2014-10-16 07:00:00	QQQ	ETF	90.47	90.57	90.1	90.56	139587.0
2014-10-16 07:30:00	QQQ	ETF	90.59	90.73	90.45	90.71	157330.0
2014-10-16 08:00:00	QQQ	ETF	90.72	91.04	90.22	90.69	219195.0
2014-10-16 08:30:00	QQQ	ETF	90.81	90.88	90.27	90.58	553478.0
2014-10-16 09:00:00	QQQ	ETF	90.6	90.9	90.43	90.43	1253780.0
2014-10-16 09:30:00	QQQ	ETF	90.43	91.45	90.39	91.41	13673571.0
2014-10-16 10:00:00	QQQ	ETF	91.43	91.65	90.47	91.19	13337358.0
2014-10-16 10:30:00	QQQ	ETF	91.19	91.8679	91.04	91.55	7701739.0
2014-10-16 11:00:00	QQQ	ETF	91.55	91.97	91.31	91.94	5844984.0
2014-10-16 11:30:00	QQQ	ETF	91.94	92.14	91.3	91.47	6485256.0
2014-10-16 12:00:00	QQQ	ETF	91.47	91.71	91.23	91.45	4085261.0
2014-10-16 12:30:00	QQQ	ETF	91.44	91.94	91.25	91.87	2864258.0

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

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