PREVIEW / etf_30min / 2017-01-25

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-01-25.parquet
  size:    451 KB
  rows:    15,271

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-25 04:00:00	SPY	ETF	228.14	228.29	228.14	228.27	28210.0
2017-01-25 04:30:00	SPY	ETF	228.21	228.22	228.16	228.2	10525.0
2017-01-25 05:00:00	SPY	ETF	228.03	228.05	228.0	228.0	6900.0
2017-01-25 05:30:00	SPY	ETF	228.19	228.19	228.13	228.14	17102.0
2017-01-25 06:00:00	SPY	ETF	228.17	228.17	228.13	228.13	5600.0
2017-01-25 06:30:00	SPY	ETF	228.16	228.16	228.07	228.07	92502.0
2017-01-25 07:00:00	SPY	ETF	228.07	228.21	228.06	228.2	113283.0
2017-01-25 07:30:00	SPY	ETF	228.21	228.42	228.18	228.37	232355.0
2017-01-25 08:00:00	SPY	ETF	228.37	228.41	228.06	228.33	235975.0
2017-01-25 08:30:00	SPY	ETF	228.32	228.54	227.6	228.45	404582.0
2017-01-25 09:00:00	SPY	ETF	228.44	228.7	228.42	228.68	506570.0
2017-01-25 09:30:00	SPY	ETF	228.7	228.91	228.51	228.91	8018150.0
2017-01-25 10:00:00	SPY	ETF	228.91	229.06	228.82	228.8236	4790505.0
2017-01-25 10:30:00	SPY	ETF	228.82	229.17	228.8	229.1057	3750149.0
2017-01-25 11:00:00	SPY	ETF	229.109	229.33	229.06	229.14	4180136.0
2017-01-25 11:30:00	SPY	ETF	229.14	229.15	228.82	228.99	3789246.0
2017-01-25 12:00:00	SPY	ETF	228.99	229.105	228.93	229.05	3130293.0
2017-01-25 12:30:00	SPY	ETF	229.05	229.15	228.9535	229.13	2446510.0
2017-01-25 13:00:00	SPY	ETF	229.13	229.26	229.1147	229.2399	3057519.0
2017-01-25 13:30:00	SPY	ETF	229.24	229.3725	229.11	229.355	4125543.0
2017-01-25 14:00:00	SPY	ETF	229.36	229.49	229.31	229.43	4303010.0
2017-01-25 14:30:00	SPY	ETF	229.42	229.45	229.17	229.2	3037399.0
2017-01-25 15:00:00	SPY	ETF	229.19	229.34	229.09	229.3311	4199727.0
2017-01-25 15:30:00	SPY	ETF	229.34	229.57	229.28	229.49	14305114.0
2017-01-25 16:00:00	SPY	ETF	229.5	229.57	229.1883	229.44	15566661.0
2017-01-25 16:30:00	SPY	ETF	229.45	229.57	229.37	229.44	1094913.0
2017-01-25 17:00:00	SPY	ETF	229.43	229.5	229.4	229.47	163826.0
2017-01-25 17:30:00	SPY	ETF	229.46	229.57	229.45	229.45	143970.0
2017-01-25 18:00:00	SPY	ETF	229.47	229.47	229.39	229.4	86413.0
2017-01-25 18:30:00	SPY	ETF	229.42	229.44	229.39	229.4	14926.0
2017-01-25 19:00:00	SPY	ETF	229.4	229.4	229.29	229.34	89295.0
2017-01-25 19:30:00	SPY	ETF	229.36	229.45	229.33	229.42	61088.0
2017-01-25 04:00:00	QQQ	ETF	124.57	124.65	124.57	124.65	400.0
2017-01-25 04:30:00	QQQ	ETF	124.66	124.66	124.65	124.65	200.0
2017-01-25 05:30:00	QQQ	ETF	124.68	124.7	124.68	124.7	9900.0
2017-01-25 06:00:00	QQQ	ETF	124.66	124.72	124.66	124.72	5978.0
2017-01-25 06:30:00	QQQ	ETF	124.66	124.66	124.65	124.65	200.0
2017-01-25 07:00:00	QQQ	ETF	124.67	124.72	124.65	124.72	24808.0
2017-01-25 07:30:00	QQQ	ETF	124.7	124.83	124.7	124.8	35359.0
2017-01-25 08:00:00	QQQ	ETF	124.81	124.84	124.66	124.77	57641.0
2017-01-25 08:30:00	QQQ	ETF	124.78	124.87	124.18	124.83	19408.0
2017-01-25 09:00:00	QQQ	ETF	124.83	124.95	124.83	124.94	60573.0
2017-01-25 09:30:00	QQQ	ETF	124.94	125.03	124.85	125.02	2400769.0
2017-01-25 10:00:00	QQQ	ETF	125.02	125.1	124.9415	124.96	995690.0
2017-01-25 10:30:00	QQQ	ETF	124.97	125.18	124.96	125.16	646947.0
2017-01-25 11:00:00	QQQ	ETF	125.16	125.27	125.14	125.1765	718369.0
2017-01-25 11:30:00	QQQ	ETF	125.18	125.1943	124.98	125.0767	609519.0
2017-01-25 12:00:00	QQQ	ETF	125.08	125.16	125.06	125.13	475832.0
2017-01-25 12:30:00	QQQ	ETF	125.13	125.19	125.05	125.18	456177.0
2017-01-25 13:00:00	QQQ	ETF	125.19	125.3	125.181	125.29	490581.0

> showing 50 of 15,271 rows — these rows as CSV

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