PREVIEW / etf_30min / 2021-07-16

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-07-16.parquet
  size:    598 KB
  rows:    22,676

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-16 04:00:00	SPY	ETF	434.8	434.9	434.47	434.47	9708.0
2021-07-16 04:30:00	SPY	ETF	434.73	435.06	434.73	435.05	1050.0
2021-07-16 05:00:00	SPY	ETF	435.13	435.37	435.13	435.19	9000.0
2021-07-16 05:30:00	SPY	ETF	435.13	435.29	435.0	435.25	3948.0
2021-07-16 06:00:00	SPY	ETF	435.33	435.35	434.72	434.9	5787.0
2021-07-16 06:30:00	SPY	ETF	434.88	435.25	434.88	435.23	59650.0
2021-07-16 07:00:00	SPY	ETF	435.31	435.54	435.21	435.3	61815.0
2021-07-16 07:30:00	SPY	ETF	435.27	435.37	435.15	435.35	41728.0
2021-07-16 08:00:00	SPY	ETF	435.36	435.76	434.2	435.69	133945.0
2021-07-16 08:30:00	SPY	ETF	435.69	435.99	435.6	435.84	130449.0
2021-07-16 09:00:00	SPY	ETF	435.85	436.42	435.8	436.03	283118.0
2021-07-16 09:30:00	SPY	ETF	436.0	436.06	434.92	435.18	5444757.0
2021-07-16 10:00:00	SPY	ETF	435.19	435.27	433.14	433.23	8109096.0
2021-07-16 10:30:00	SPY	ETF	433.23	434.13	433.17	433.8001	3526761.0
2021-07-16 11:00:00	SPY	ETF	433.82	433.95	432.93	433.0711	3486374.0
2021-07-16 11:30:00	SPY	ETF	433.06	433.81	433.01	433.6519	2541040.0
2021-07-16 12:00:00	SPY	ETF	433.65	434.23	433.595	433.82	2670420.0
2021-07-16 12:30:00	SPY	ETF	433.825	434.04	433.5119	433.685	3102898.0
2021-07-16 13:00:00	SPY	ETF	433.69	434.065	433.5583	433.56	1852399.0
2021-07-16 13:30:00	SPY	ETF	433.55	433.59	433.04	433.165	2125779.0
2021-07-16 14:00:00	SPY	ETF	433.17	433.19	432.56	432.57	3063637.0
2021-07-16 14:30:00	SPY	ETF	432.57	432.84	432.04	432.2158	4141883.0
2021-07-16 15:00:00	SPY	ETF	432.22	432.34	431.55	431.78	4788051.0
2021-07-16 15:30:00	SPY	ETF	431.78	431.935	430.92	431.4	10966516.0
2021-07-16 16:00:00	SPY	ETF	431.4	434.6767	430.92	431.17	3085869.0
2021-07-16 16:30:00	SPY	ETF	431.16	431.381	430.99	431.33	432413.0
2021-07-16 17:00:00	SPY	ETF	431.33	431.38	431.11	431.15	38592.0
2021-07-16 17:30:00	SPY	ETF	431.12	431.34	431.12	431.2	31944.0
2021-07-16 18:00:00	SPY	ETF	431.29	431.3	431.15	431.23	16763.0
2021-07-16 18:30:00	SPY	ETF	431.24	431.4	431.24	431.38	32539.0
2021-07-16 19:00:00	SPY	ETF	431.38	431.39	431.2	431.2	26804.0
2021-07-16 19:30:00	SPY	ETF	431.25	431.36	431.22	431.28	12427.0
2021-07-16 04:00:00	QQQ	ETF	360.82	360.88	360.17	360.29	10833.0
2021-07-16 04:30:00	QQQ	ETF	360.21	360.68	360.21	360.66	4710.0
2021-07-16 05:00:00	QQQ	ETF	360.48	360.95	360.47	360.81	12097.0
2021-07-16 05:30:00	QQQ	ETF	360.77	360.92	360.68	360.89	8705.0
2021-07-16 06:00:00	QQQ	ETF	360.97	361.0	360.51	360.7	17723.0
2021-07-16 06:30:00	QQQ	ETF	360.63	361.13	360.63	361.13	18752.0
2021-07-16 07:00:00	QQQ	ETF	361.11	361.29	360.95	360.95	107466.0
2021-07-16 07:30:00	QQQ	ETF	361.11	361.13	360.87	361.0	23289.0
2021-07-16 08:00:00	QQQ	ETF	361.05	361.45	359.81	361.26	170249.0
2021-07-16 08:30:00	QQQ	ETF	361.32	361.81	361.22	361.62	167657.0
2021-07-16 09:00:00	QQQ	ETF	361.63	362.03	361.42	361.47	318348.0
2021-07-16 09:30:00	QQQ	ETF	361.41	362.41	360.78	361.11	4793854.0
2021-07-16 10:00:00	QQQ	ETF	361.1	361.2	359.2	359.29	3241386.0
2021-07-16 10:30:00	QQQ	ETF	359.29	360.359	359.21	359.78	2599870.0
2021-07-16 11:00:00	QQQ	ETF	359.81	359.98	358.52	358.52	2465819.0
2021-07-16 11:30:00	QQQ	ETF	358.5	359.25	358.17	358.9	2013513.0
2021-07-16 12:00:00	QQQ	ETF	358.92	359.985	358.85	359.69	1211579.0
2021-07-16 12:30:00	QQQ	ETF	359.69	359.94	359.34	359.7	1045028.0

> showing 50 of 22,676 rows — these rows as CSV

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