PREVIEW / etf_30min / 2017-01-23

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-01-23.parquet
  size:    434 KB
  rows:    14,598

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-01-23 04:00:00	SPY	ETF	226.28	226.28	226.08	226.27	17646.0
2017-01-23 04:30:00	SPY	ETF	226.28	226.35	226.28	226.31	1730.0
2017-01-23 05:00:00	SPY	ETF	226.33	226.34	226.27	226.3	3101.0
2017-01-23 05:30:00	SPY	ETF	226.3	226.3	226.25	226.26	3005.0
2017-01-23 06:00:00	SPY	ETF	226.24	226.41	226.23	226.38	6404.0
2017-01-23 06:30:00	SPY	ETF	226.37	226.37	226.23	226.23	56705.0
2017-01-23 07:00:00	SPY	ETF	226.25	226.33	226.23	226.3	30854.0
2017-01-23 07:30:00	SPY	ETF	226.3	226.32	226.13	226.2	73320.0
2017-01-23 08:00:00	SPY	ETF	226.2	226.41	226.15	226.2	149516.0
2017-01-23 08:30:00	SPY	ETF	226.2	226.33	226.15	226.33	243520.0
2017-01-23 09:00:00	SPY	ETF	226.33	226.53	226.21	226.35	631599.0
2017-01-23 09:30:00	SPY	ETF	226.35	226.805	226.22	226.38	6478448.0
2017-01-23 10:00:00	SPY	ETF	226.38	226.49	225.91	225.92	5520245.0
2017-01-23 10:30:00	SPY	ETF	225.92	225.94	225.6	225.75	4933332.0
2017-01-23 11:00:00	SPY	ETF	225.75	225.93	225.53	225.74	4179079.0
2017-01-23 11:30:00	SPY	ETF	225.74	225.84	225.27	225.53	4896264.0
2017-01-23 12:00:00	SPY	ETF	225.53	225.67	225.32	225.6465	4793280.0
2017-01-23 12:30:00	SPY	ETF	225.64	225.82	225.62	225.74	2196078.0
2017-01-23 13:00:00	SPY	ETF	225.73	225.915	225.7	225.73	2443060.0
2017-01-23 13:30:00	SPY	ETF	225.73	226.24	225.73	225.88	7469197.0
2017-01-23 14:00:00	SPY	ETF	225.87	226.7311	225.695	225.8	5990011.0
2017-01-23 14:30:00	SPY	ETF	225.8	226.06	225.78	226.02	2249743.0
2017-01-23 15:00:00	SPY	ETF	226.025	226.19	225.85	226.07	3896537.0
2017-01-23 15:30:00	SPY	ETF	226.075	226.33	226.05	226.18	8714861.0
2017-01-23 16:00:00	SPY	ETF	226.18	226.29	226.1211	226.24	8249133.0
2017-01-23 16:30:00	SPY	ETF	226.25	226.25	216.15	226.2	180861.0
2017-01-23 17:00:00	SPY	ETF	226.19	226.22	226.18	226.22	787614.0
2017-01-23 17:30:00	SPY	ETF	226.19	226.21	226.15	226.15	10799.0
2017-01-23 18:00:00	SPY	ETF	226.15	226.25	226.13	226.24	18413.0
2017-01-23 18:30:00	SPY	ETF	226.17	226.24	226.15	226.22	48023.0
2017-01-23 19:00:00	SPY	ETF	226.2	226.28	226.19	226.28	54760.0
2017-01-23 19:30:00	SPY	ETF	226.25	226.26	226.21	226.24	5708.0
2017-01-23 04:00:00	QQQ	ETF	122.96	122.96	122.82	122.82	2873.0
2017-01-23 05:00:00	QQQ	ETF	122.99	122.99	122.97	122.97	1977.0
2017-01-23 05:30:00	QQQ	ETF	122.96	122.96	122.96	122.96	600.0
2017-01-23 06:00:00	QQQ	ETF	123.0	123.01	122.96	123.01	1380.0
2017-01-23 06:30:00	QQQ	ETF	123.0	123.0	123.0	123.0	200.0
2017-01-23 07:00:00	QQQ	ETF	122.99	123.05	122.98	123.05	16476.0
2017-01-23 07:30:00	QQQ	ETF	123.02	123.04	122.94	122.98	64919.0
2017-01-23 08:00:00	QQQ	ETF	122.99	123.08	122.98	123.02	23375.0
2017-01-23 08:30:00	QQQ	ETF	123.01	123.08	122.98	123.08	25451.0
2017-01-23 09:00:00	QQQ	ETF	123.06	123.16	123.06	123.16	55512.0
2017-01-23 09:30:00	QQQ	ETF	123.16	123.53	123.04	123.18	2391851.0
2017-01-23 10:00:00	QQQ	ETF	123.1741	123.27	122.95	122.98	1472979.0
2017-01-23 10:30:00	QQQ	ETF	122.97	122.98	122.76	122.8359	1052749.0
2017-01-23 11:00:00	QQQ	ETF	122.83	122.95	122.78	122.8921	466211.0
2017-01-23 11:30:00	QQQ	ETF	122.91	122.97	122.57	122.8027	2714979.0
2017-01-23 12:00:00	QQQ	ETF	122.8	122.99	122.73	122.97	1073618.0
2017-01-23 12:30:00	QQQ	ETF	122.96	123.09	122.96	123.045	544591.0
2017-01-23 13:00:00	QQQ	ETF	123.05	123.205	123.03	123.085	781853.0

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

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