PREVIEW / etf_30min / 2020-04-28

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-04-28.parquet
  size:    568 KB
  rows:    20,698

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
2020-04-28 04:00:00	SPY	ETF	288.2	288.2	287.58	287.92	29823.0
2020-04-28 04:30:00	SPY	ETF	287.8	288.26	287.71	287.88	13469.0
2020-04-28 05:00:00	SPY	ETF	287.91	290.16	287.91	289.81	121410.0
2020-04-28 05:30:00	SPY	ETF	289.79	290.66	289.6	290.61	111703.0
2020-04-28 06:00:00	SPY	ETF	290.7	290.95	290.2	290.25	71671.0
2020-04-28 06:30:00	SPY	ETF	290.3	290.8	290.23	290.29	101024.0
2020-04-28 07:00:00	SPY	ETF	290.26	290.75	290.02	290.74	380300.0
2020-04-28 07:30:00	SPY	ETF	290.75	290.84	290.4	290.84	329572.0
2020-04-28 08:00:00	SPY	ETF	290.84	291.08	285.5	290.9	472876.0
2020-04-28 08:30:00	SPY	ETF	290.93	291.42	290.8	291.37	888816.0
2020-04-28 09:00:00	SPY	ETF	291.32	291.45	290.81	291.04	566084.0
2020-04-28 09:30:00	SPY	ETF	291.02	291.4	289.45	289.48	14643579.0
2020-04-28 10:00:00	SPY	ETF	289.46	289.99	288.53	288.83	8913698.0
2020-04-28 10:30:00	SPY	ETF	288.84	288.95	285.62	285.82	12465382.0
2020-04-28 11:00:00	SPY	ETF	285.84	287.44	285.58	287.27	8385874.0
2020-04-28 11:30:00	SPY	ETF	287.29	287.79	286.5101	286.81	6082063.0
2020-04-28 12:00:00	SPY	ETF	286.84	287.4584	285.7	286.41	5052150.0
2020-04-28 12:30:00	SPY	ETF	286.42	291.28	286.19	287.31	3563728.0
2020-04-28 13:00:00	SPY	ETF	287.32	287.64	287.035	287.41	3303892.0
2020-04-28 13:30:00	SPY	ETF	287.415	288.02	287.0	287.45	3689875.0
2020-04-28 14:00:00	SPY	ETF	287.45	288.36	287.45	288.09	4099795.0
2020-04-28 14:30:00	SPY	ETF	288.0901	288.33	287.07	287.347	4623159.0
2020-04-28 15:00:00	SPY	ETF	287.35	288.09	286.8	287.535	5452633.0
2020-04-28 15:30:00	SPY	ETF	287.53	287.69	285.4	285.77	15285561.0
2020-04-28 16:00:00	SPY	ETF	285.78	287.7804	285.64	286.78	4143003.0
2020-04-28 16:30:00	SPY	ETF	286.78	286.92	285.73	286.28	706313.0
2020-04-28 17:00:00	SPY	ETF	286.22	286.78	286.2	286.69	117181.0
2020-04-28 17:30:00	SPY	ETF	286.69	291.0	285.73	287.12	119661.0
2020-04-28 18:00:00	SPY	ETF	287.14	287.4	286.61	287.08	139294.0
2020-04-28 18:30:00	SPY	ETF	287.1	287.1	286.36	286.62	148743.0
2020-04-28 19:00:00	SPY	ETF	286.65	287.38	286.33	287.23	77457.0
2020-04-28 19:30:00	SPY	ETF	287.21	287.75	287.21	287.39	100639.0
2020-04-28 04:00:00	QQQ	ETF	216.41	216.5	216.1	216.33	10380.0
2020-04-28 04:30:00	QQQ	ETF	216.18	216.4	216.18	216.3	10405.0
2020-04-28 05:00:00	QQQ	ETF	216.35	217.77	216.34	217.56	17615.0
2020-04-28 05:30:00	QQQ	ETF	217.52	218.12	217.45	218.12	32293.0
2020-04-28 06:00:00	QQQ	ETF	218.1	218.3	217.72	217.73	27412.0
2020-04-28 06:30:00	QQQ	ETF	217.7	218.19	217.7	217.73	29511.0
2020-04-28 07:00:00	QQQ	ETF	217.75	217.9	217.51	217.85	85523.0
2020-04-28 07:30:00	QQQ	ETF	217.89	217.92	217.58	217.9	64209.0
2020-04-28 08:00:00	QQQ	ETF	217.6301	218.0	215.33	217.52	121255.0
2020-04-28 08:30:00	QQQ	ETF	217.55	217.77	217.39	217.73	185971.0
2020-04-28 09:00:00	QQQ	ETF	217.64	217.74	217.26	217.27	200118.0
2020-04-28 09:30:00	QQQ	ETF	217.27	217.32	215.42	215.47	5018493.0
2020-04-28 10:00:00	QQQ	ETF	215.47	215.7	213.57	214.17	4652852.0
2020-04-28 10:30:00	QQQ	ETF	214.19	214.63	212.06	212.3	4319880.0
2020-04-28 11:00:00	QQQ	ETF	212.32	213.34	212.1769	213.19	2823679.0
2020-04-28 11:30:00	QQQ	ETF	213.19	213.59	212.6	212.76	1638118.0
2020-04-28 12:00:00	QQQ	ETF	212.78	213.15	211.71	212.3	3562374.0
2020-04-28 12:30:00	QQQ	ETF	212.2801	213.2098	212.07	213.0529	1659451.0

> showing 50 of 20,698 rows — these rows as CSV

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