PREVIEW / etf_30min / 2017-06-15

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-06-15.parquet
  size:    433 KB
  rows:    14,990

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-15 04:00:00	SPY	ETF	243.29	243.32	243.02	243.28	20011.0
2017-06-15 04:30:00	SPY	ETF	243.31	243.31	242.94	242.94	10045.0
2017-06-15 05:00:00	SPY	ETF	242.95	243.2	242.92	243.1	39767.0
2017-06-15 05:30:00	SPY	ETF	243.15	243.15	242.76	242.77	15775.0
2017-06-15 06:00:00	SPY	ETF	242.71	242.74	242.35	242.62	113162.0
2017-06-15 06:30:00	SPY	ETF	242.55	242.75	242.52	242.75	33121.0
2017-06-15 07:00:00	SPY	ETF	242.74	242.84	242.67	242.75	302452.0
2017-06-15 07:30:00	SPY	ETF	242.75	242.78	242.62	242.7	369869.0
2017-06-15 08:00:00	SPY	ETF	244.24	244.24	242.47	242.55	375938.0
2017-06-15 08:30:00	SPY	ETF	242.57	242.85	242.57	242.83	380484.0
2017-06-15 09:00:00	SPY	ETF	242.83	242.93	242.67	242.7	395410.0
2017-06-15 09:30:00	SPY	ETF	242.68	243.13	242.52	243.0	8792667.0
2017-06-15 10:00:00	SPY	ETF	243.0	243.22	242.36	242.62	5426995.0
2017-06-15 10:30:00	SPY	ETF	242.61	242.99	242.5601	242.98	4244353.0
2017-06-15 11:00:00	SPY	ETF	242.9734	243.47	242.92	243.47	4584179.0
2017-06-15 11:30:00	SPY	ETF	243.47	243.54	243.16	243.18	3232267.0
2017-06-15 12:00:00	SPY	ETF	243.18	243.29	243.04	243.11	2011509.0
2017-06-15 12:30:00	SPY	ETF	243.11	243.44	243.06	243.408	2269630.0
2017-06-15 13:00:00	SPY	ETF	243.41	243.62	243.28	243.32	3087898.0
2017-06-15 13:30:00	SPY	ETF	243.33	243.505	243.21	243.3299	2231995.0
2017-06-15 14:00:00	SPY	ETF	243.322	243.77	243.26	243.6001	2709278.0
2017-06-15 14:30:00	SPY	ETF	243.6	243.76	243.52	243.635	4074994.0
2017-06-15 15:00:00	SPY	ETF	243.63	243.91	243.59	243.84	4626780.0
2017-06-15 15:30:00	SPY	ETF	243.8301	243.88	243.42	243.79	8869034.0
2017-06-15 16:00:00	SPY	ETF	243.79	243.99	243.28	243.96	4762232.0
2017-06-15 16:30:00	SPY	ETF	243.94	243.99	242.7327	243.88	597091.0
2017-06-15 17:00:00	SPY	ETF	243.88	243.89	243.76	243.77	1321353.0
2017-06-15 17:30:00	SPY	ETF	243.81	243.84	243.77	243.8	112618.0
2017-06-15 18:00:00	SPY	ETF	243.83	243.84	243.75	243.76	20078.0
2017-06-15 18:30:00	SPY	ETF	243.79	243.82	243.74	243.74	28733.0
2017-06-15 19:00:00	SPY	ETF	243.73	243.79	243.72	243.75	19669.0
2017-06-15 19:30:00	SPY	ETF	243.78	243.95	243.76	243.92	17502.0
2017-06-15 04:00:00	QQQ	ETF	138.46	138.54	138.28	138.39	23505.0
2017-06-15 04:30:00	QQQ	ETF	138.39	138.43	138.1	138.1	4870.0
2017-06-15 05:00:00	QQQ	ETF	138.14	138.36	138.04	138.36	15072.0
2017-06-15 05:30:00	QQQ	ETF	138.34	138.34	138.16	138.16	20309.0
2017-06-15 06:00:00	QQQ	ETF	138.17	138.28	137.97	138.15	17149.0
2017-06-15 06:30:00	QQQ	ETF	138.12	138.28	138.04	138.27	35760.0
2017-06-15 07:00:00	QQQ	ETF	138.29	138.4	138.25	138.35	130799.0
2017-06-15 07:30:00	QQQ	ETF	138.33	138.34	138.25	138.28	184979.0
2017-06-15 08:00:00	QQQ	ETF	138.29	138.35	138.14	138.15	165240.0
2017-06-15 08:30:00	QQQ	ETF	138.13	138.49	138.13	138.49	372472.0
2017-06-15 09:00:00	QQQ	ETF	138.48	138.64	138.325	138.36	425418.0
2017-06-15 09:30:00	QQQ	ETF	138.35	138.54	137.63	138.12	7684163.0
2017-06-15 10:00:00	QQQ	ETF	138.11	138.28	137.49	137.74	5938140.0
2017-06-15 10:30:00	QQQ	ETF	137.73	138.27	137.64	138.232	5397330.0
2017-06-15 11:00:00	QQQ	ETF	138.23	138.54	138.115	138.53	4183123.0
2017-06-15 11:30:00	QQQ	ETF	138.53	138.6	138.22	138.2266	2434266.0
2017-06-15 12:00:00	QQQ	ETF	138.23	138.5	138.1757	138.42	1144870.0
2017-06-15 12:30:00	QQQ	ETF	138.43	138.76	138.345	138.7	1636355.0

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

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