PREVIEW / etf_30min / 2018-01-04

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-01-04.parquet
  size:    486 KB
  rows:    16,822

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
2018-01-04 04:00:00	SPY	ETF	270.5	270.72	270.5	270.66	42312.0
2018-01-04 04:30:00	SPY	ETF	270.66	270.87	270.66	270.84	7235.0
2018-01-04 05:00:00	SPY	ETF	270.81	270.81	270.77	270.77	5200.0
2018-01-04 05:30:00	SPY	ETF	270.73	270.75	270.64	270.69	14300.0
2018-01-04 06:00:00	SPY	ETF	270.61	270.78	270.61	270.78	3000.0
2018-01-04 06:30:00	SPY	ETF	270.68	270.81	270.68	270.78	13750.0
2018-01-04 07:00:00	SPY	ETF	270.78	271.05	270.78	271.05	382498.0
2018-01-04 07:30:00	SPY	ETF	271.05	271.05	270.84	270.86	54873.0
2018-01-04 08:00:00	SPY	ETF	270.84	271.18	270.79	271.15	532120.0
2018-01-04 08:30:00	SPY	ETF	271.15	271.19	271.05	271.12	185516.0
2018-01-04 09:00:00	SPY	ETF	271.13	271.25	271.12	271.2	529571.0
2018-01-04 09:30:00	SPY	ETF	271.2	271.86	271.1	271.8162	9118325.0
2018-01-04 10:00:00	SPY	ETF	271.82	271.96	271.659	271.96	4979825.0
2018-01-04 10:30:00	SPY	ETF	271.96	272.16	271.79	271.89	4365230.0
2018-01-04 11:00:00	SPY	ETF	271.89	271.92	271.53	271.56	4749272.0
2018-01-04 11:30:00	SPY	ETF	271.56	271.7	271.43	271.63	4987279.0
2018-01-04 12:00:00	SPY	ETF	271.6215	271.89	271.585	271.72	4286796.0
2018-01-04 12:30:00	SPY	ETF	271.72	271.93	271.66	271.86	3315054.0
2018-01-04 13:00:00	SPY	ETF	271.86	271.9098	271.73	271.84	6708692.0
2018-01-04 13:30:00	SPY	ETF	271.839	271.95	271.76	271.94	2523398.0
2018-01-04 14:00:00	SPY	ETF	271.945	272.06	271.8	271.815	3282646.0
2018-01-04 14:30:00	SPY	ETF	271.81	271.98	271.79	271.905	3528313.0
2018-01-04 15:00:00	SPY	ETF	271.9	271.97	271.67	271.89	4042620.0
2018-01-04 15:30:00	SPY	ETF	271.8989	271.9	271.59	271.63	8024933.0
2018-01-04 16:00:00	SPY	ETF	271.64	271.7926	271.49	271.62	9008598.0
2018-01-04 16:30:00	SPY	ETF	271.64	271.8	271.61	271.71	1188634.0
2018-01-04 17:00:00	SPY	ETF	271.71	271.75	271.61	271.75	113499.0
2018-01-04 17:30:00	SPY	ETF	271.75	271.77	271.72	271.75	65415.0
2018-01-04 18:00:00	SPY	ETF	271.75	271.8	271.73	271.8	104983.0
2018-01-04 18:30:00	SPY	ETF	271.8	271.86	271.78	271.79	29349.0
2018-01-04 19:00:00	SPY	ETF	271.78	271.84	271.74	271.77	13798.0
2018-01-04 19:30:00	SPY	ETF	271.81	271.84	271.8	271.81	12705.0
2018-01-04 04:00:00	QQQ	ETF	160.32	160.37	160.32	160.37	1200.0
2018-01-04 04:30:00	QQQ	ETF	160.35	160.44	160.35	160.44	6100.0
2018-01-04 05:00:00	QQQ	ETF	160.44	160.45	160.38	160.41	16300.0
2018-01-04 05:30:00	QQQ	ETF	160.38	160.4	160.29	160.29	10100.0
2018-01-04 06:00:00	QQQ	ETF	160.29	160.32	160.26	160.32	23900.0
2018-01-04 06:30:00	QQQ	ETF	160.35	160.36	160.33	160.33	1400.0
2018-01-04 07:00:00	QQQ	ETF	160.4	160.52	160.38	160.52	50231.0
2018-01-04 07:30:00	QQQ	ETF	160.54	160.54	160.43	160.45	38368.0
2018-01-04 08:00:00	QQQ	ETF	160.03	160.79	160.03	160.77	127436.0
2018-01-04 08:30:00	QQQ	ETF	160.76	160.81	160.68	160.69	165211.0
2018-01-04 09:00:00	QQQ	ETF	160.72	160.78	160.6	160.6	166751.0
2018-01-04 09:30:00	QQQ	ETF	160.59	160.79	160.0825	160.38	4327020.0
2018-01-04 10:00:00	QQQ	ETF	160.38	160.52	160.23	160.5	1713861.0
2018-01-04 10:30:00	QQQ	ETF	160.5	160.7387	160.42	160.53	1059974.0
2018-01-04 11:00:00	QQQ	ETF	160.54	160.56	160.22	160.255	1476587.0
2018-01-04 11:30:00	QQQ	ETF	160.26	160.47	160.26	160.33	713858.0
2018-01-04 12:00:00	QQQ	ETF	160.33	160.57	160.26	160.31	1252476.0
2018-01-04 12:30:00	QQQ	ETF	160.305	160.47	160.25	160.2962	945685.0

> showing 50 of 16,822 rows — these rows as CSV

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