PREVIEW / etf_30min / 2021-07-13

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-07-13.parquet
  size:    607 KB
  rows:    23,216

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
2021-07-13 04:00:00	SPY	ETF	436.66	436.84	436.52	436.77	10152.0
2021-07-13 04:30:00	SPY	ETF	436.8	437.15	436.8	437.12	3225.0
2021-07-13 05:00:00	SPY	ETF	437.0	437.22	436.99	437.05	944.0
2021-07-13 05:30:00	SPY	ETF	437.02	437.25	437.02	437.15	3425.0
2021-07-13 06:00:00	SPY	ETF	437.22	437.29	437.14	437.17	4291.0
2021-07-13 06:30:00	SPY	ETF	437.1	437.2	437.08	437.11	4884.0
2021-07-13 07:00:00	SPY	ETF	437.13	437.2	437.0	437.06	19556.0
2021-07-13 07:30:00	SPY	ETF	437.1	437.25	437.06	437.17	25237.0
2021-07-13 08:00:00	SPY	ETF	437.1	437.2496	436.47	437.05	43626.0
2021-07-13 08:30:00	SPY	ETF	437.0	437.02	435.16	435.2	695818.0
2021-07-13 09:00:00	SPY	ETF	435.22	436.31	435.2	436.29	488130.0
2021-07-13 09:30:00	SPY	ETF	436.26	437.12	436.19	436.8	5258482.0
2021-07-13 10:00:00	SPY	ETF	436.82	437.19	436.55	437.13	2700732.0
2021-07-13 10:30:00	SPY	ETF	437.13	437.485	436.84	436.9119	2342818.0
2021-07-13 11:00:00	SPY	ETF	436.91	437.8	436.91	437.69	1782354.0
2021-07-13 11:30:00	SPY	ETF	437.695	437.74	437.49	437.725	1726447.0
2021-07-13 12:00:00	SPY	ETF	437.73	437.84	437.4	437.45	1120011.0
2021-07-13 12:30:00	SPY	ETF	437.4589	437.61	437.41	437.52	863201.0
2021-07-13 13:00:00	SPY	ETF	437.515	437.5389	436.2	436.48	2907933.0
2021-07-13 13:30:00	SPY	ETF	436.49	436.59	435.74	436.47	3465347.0
2021-07-13 14:00:00	SPY	ETF	436.46	436.535	435.57	436.439	3727269.0
2021-07-13 14:30:00	SPY	ETF	436.435	436.435	435.63	436.2799	2445490.0
2021-07-13 15:00:00	SPY	ETF	436.28	436.29	435.49	435.6719	3401378.0
2021-07-13 15:30:00	SPY	ETF	435.67	436.25	435.31	435.61	7877969.0
2021-07-13 16:00:00	SPY	ETF	435.61	435.74	435.35	435.44	1847660.0
2021-07-13 16:30:00	SPY	ETF	435.38	435.47	435.3	435.41	140052.0
2021-07-13 17:00:00	SPY	ETF	435.48	435.58	435.25	435.31	470792.0
2021-07-13 17:30:00	SPY	ETF	435.3799	435.42	435.37	435.42	15397.0
2021-07-13 18:00:00	SPY	ETF	435.42	435.54	435.37	435.53	46563.0
2021-07-13 18:30:00	SPY	ETF	435.59	435.73	435.55	435.55	37507.0
2021-07-13 19:00:00	SPY	ETF	435.63	435.63	435.52	435.56	10555.0
2021-07-13 19:30:00	SPY	ETF	435.55	435.55	434.94	435.01	57166.0
2021-07-13 04:00:00	QQQ	ETF	362.38	362.62	362.29	362.6	15418.0
2021-07-13 04:30:00	QQQ	ETF	362.7	363.2	362.6	363.09	19672.0
2021-07-13 05:00:00	QQQ	ETF	363.13	363.5	363.13	363.4	29023.0
2021-07-13 05:30:00	QQQ	ETF	363.46	363.73	363.44	363.72	17390.0
2021-07-13 06:00:00	QQQ	ETF	363.8	363.8	363.58	363.59	13926.0
2021-07-13 06:30:00	QQQ	ETF	363.58	363.73	363.58	363.66	9305.0
2021-07-13 07:00:00	QQQ	ETF	363.7	363.75	363.58	363.69	26787.0
2021-07-13 07:30:00	QQQ	ETF	363.71	363.78	363.45	363.5	26434.0
2021-07-13 08:00:00	QQQ	ETF	363.62	363.7896	362.5	363.38	54978.0
2021-07-13 08:30:00	QQQ	ETF	363.3	363.3	360.77	360.82	1134847.0
2021-07-13 09:00:00	QQQ	ETF	360.91	362.18	360.62	362.04	293117.0
2021-07-13 09:30:00	QQQ	ETF	362.04	363.64	361.77	363.51	3557800.0
2021-07-13 10:00:00	QQQ	ETF	363.51	364.5	363.51	364.47	2761469.0
2021-07-13 10:30:00	QQQ	ETF	364.48	364.9392	364.21	364.4	1934356.0
2021-07-13 11:00:00	QQQ	ETF	364.4298	365.38	364.38	365.35	1529366.0
2021-07-13 11:30:00	QQQ	ETF	365.34	365.465	365.05	365.325	1324725.0
2021-07-13 12:00:00	QQQ	ETF	365.32	365.35	364.91	365.041	963758.0
2021-07-13 12:30:00	QQQ	ETF	365.05	365.295	364.96	365.06	523101.0

> showing 50 of 23,216 rows — these rows as CSV

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