PREVIEW / etf_30min / 2017-06-23

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-06-23.parquet
  size:    418 KB
  rows:    14,500

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-06-23 04:00:00	SPY	ETF	243.09	243.15	243.09	243.15	10000.0
2017-06-23 04:30:00	SPY	ETF	243.24	243.25	243.17	243.2	4210.0
2017-06-23 05:00:00	SPY	ETF	243.11	243.15	243.11	243.13	2300.0
2017-06-23 05:30:00	SPY	ETF	243.12	243.19	242.91	242.91	2200.0
2017-06-23 06:00:00	SPY	ETF	242.98	243.0	242.63	242.75	13890.0
2017-06-23 06:30:00	SPY	ETF	242.72	242.84	242.64	242.75	70100.0
2017-06-23 07:00:00	SPY	ETF	242.85	242.85	242.78	242.78	8510.0
2017-06-23 07:30:00	SPY	ETF	242.82	242.88	242.8	242.86	14265.0
2017-06-23 08:00:00	SPY	ETF	242.87	242.98	242.82	242.92	44392.0
2017-06-23 08:30:00	SPY	ETF	242.97	243.06	242.88	243.03	169890.0
2017-06-23 09:00:00	SPY	ETF	243.02	243.09	242.9	242.9	227241.0
2017-06-23 09:30:00	SPY	ETF	242.91	242.93	242.47	242.79	5872582.0
2017-06-23 10:00:00	SPY	ETF	242.8	242.99	242.74	242.945	2688937.0
2017-06-23 10:30:00	SPY	ETF	242.95	243.38	242.94	243.235	3148759.0
2017-06-23 11:00:00	SPY	ETF	243.24	243.345	243.175	243.275	1581003.0
2017-06-23 11:30:00	SPY	ETF	243.28	243.35	243.175	243.3	1308442.0
2017-06-23 12:00:00	SPY	ETF	243.3	243.41	243.25	243.4	1828042.0
2017-06-23 12:30:00	SPY	ETF	243.4	243.485	243.29	243.32	1362737.0
2017-06-23 13:00:00	SPY	ETF	243.31	243.35	243.22	243.33	1333001.0
2017-06-23 13:30:00	SPY	ETF	243.33	243.51	243.33	243.39	1409688.0
2017-06-23 14:00:00	SPY	ETF	243.4	243.42	243.23	243.24	2523277.0
2017-06-23 14:30:00	SPY	ETF	243.24	243.32	243.1	243.11	2789913.0
2017-06-23 15:00:00	SPY	ETF	243.115	243.13	242.71	242.75	8111284.0
2017-06-23 15:30:00	SPY	ETF	242.74	243.32	242.72	243.16	19258297.0
2017-06-23 16:00:00	SPY	ETF	243.17	243.26	242.96	243.1	9170481.0
2017-06-23 16:30:00	SPY	ETF	243.09	243.13	242.82	242.84	850495.0
2017-06-23 17:00:00	SPY	ETF	242.94	243.04	242.92	243.03	110225.0
2017-06-23 17:30:00	SPY	ETF	243.04	243.17	243.02	243.15	64140.0
2017-06-23 18:00:00	SPY	ETF	243.15	243.17	243.09	243.09	20985.0
2017-06-23 18:30:00	SPY	ETF	243.11	243.22	243.1	243.18	37565.0
2017-06-23 19:00:00	SPY	ETF	243.11	243.2	243.11	243.2	21800.0
2017-06-23 19:30:00	SPY	ETF	243.19	243.2	243.15	243.19	16700.0
2017-06-23 04:00:00	QQQ	ETF	141.06	141.06	141.06	141.06	500.0
2017-06-23 04:30:00	QQQ	ETF	140.99	141.04	140.99	141.04	12400.0
2017-06-23 05:00:00	QQQ	ETF	140.99	140.99	140.99	140.99	400.0
2017-06-23 06:00:00	QQQ	ETF	140.68	140.69	140.47	140.5	22100.0
2017-06-23 06:30:00	QQQ	ETF	140.49	140.53	140.47	140.52	16200.0
2017-06-23 07:00:00	QQQ	ETF	140.58	140.6	140.52	140.52	35807.0
2017-06-23 07:30:00	QQQ	ETF	140.52	140.58	140.49	140.52	25801.0
2017-06-23 08:00:00	QQQ	ETF	140.53	140.66	140.53	140.64	79978.0
2017-06-23 08:30:00	QQQ	ETF	140.64	140.69	140.59	140.69	62643.0
2017-06-23 09:00:00	QQQ	ETF	140.67	140.75	140.53	140.53	55320.0
2017-06-23 09:30:00	QQQ	ETF	140.53	140.69	140.15	140.41	3084477.0
2017-06-23 10:00:00	QQQ	ETF	140.4	140.68	140.35	140.62	1628304.0
2017-06-23 10:30:00	QQQ	ETF	140.62	140.93	140.62	140.849	1646714.0
2017-06-23 11:00:00	QQQ	ETF	140.84	140.95	140.8	140.87	935210.0
2017-06-23 11:30:00	QQQ	ETF	140.88	141.0867	140.8	141.05	767403.0
2017-06-23 12:00:00	QQQ	ETF	141.04	141.2394	140.94	141.23	824735.0
2017-06-23 12:30:00	QQQ	ETF	141.23	141.36	141.195	141.2199	894417.0
2017-06-23 13:00:00	QQQ	ETF	141.21	141.32	141.16	141.31	480723.0

> showing 50 of 14,500 rows — these rows as CSV

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