PREVIEW / etf_30min / 2021-04-21

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-04-21.parquet
  size:    613 KB
  rows:    23,131

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-04-21 04:00:00	SPY	ETF	411.8	412.49	411.8	412.36	6413.0
2021-04-21 04:30:00	SPY	ETF	412.25	412.29	412.08	412.08	879.0
2021-04-21 05:00:00	SPY	ETF	412.17	412.36	412.16	412.35	56085.0
2021-04-21 05:30:00	SPY	ETF	412.2	412.2	411.75	412.04	27023.0
2021-04-21 06:00:00	SPY	ETF	412.17	412.17	411.8	411.93	23398.0
2021-04-21 06:30:00	SPY	ETF	412.12	412.66	412.03	412.66	19461.0
2021-04-21 07:00:00	SPY	ETF	412.77	412.77	412.15	412.19	107774.0
2021-04-21 07:30:00	SPY	ETF	412.19	412.3	411.98	412.11	73743.0
2021-04-21 08:00:00	SPY	ETF	412.41	412.7104	411.5	411.52	146999.0
2021-04-21 08:30:00	SPY	ETF	411.57	411.6	411.07	411.47	293685.0
2021-04-21 09:00:00	SPY	ETF	411.42	411.59	411.32	411.53	147369.0
2021-04-21 09:30:00	SPY	ETF	411.51	413.43	411.36	413.41	6415156.0
2021-04-21 10:00:00	SPY	ETF	413.41	414.1	412.995	413.9801	4838144.0
2021-04-21 10:30:00	SPY	ETF	413.98	414.03	413.43	413.7659	3220660.0
2021-04-21 11:00:00	SPY	ETF	413.77	414.34	413.61	414.205	3622298.0
2021-04-21 11:30:00	SPY	ETF	414.2	414.93	414.16	414.89	3354271.0
2021-04-21 12:00:00	SPY	ETF	414.89	414.92	414.505	414.525	1948208.0
2021-04-21 12:30:00	SPY	ETF	414.5201	414.68	414.361	414.465	2197455.0
2021-04-21 13:00:00	SPY	ETF	414.4644	414.94	414.45	414.701	1657507.0
2021-04-21 13:30:00	SPY	ETF	414.71	414.94	414.705	414.915	1461490.0
2021-04-21 14:00:00	SPY	ETF	414.915	415.26	414.83	414.945	2089928.0
2021-04-21 14:30:00	SPY	ETF	414.94	415.19	414.76	414.96	1574114.0
2021-04-21 15:00:00	SPY	ETF	414.95	415.24	414.825	415.13	2743883.0
2021-04-21 15:30:00	SPY	ETF	415.135	416.29	415.135	416.09	12955592.0
2021-04-21 16:00:00	SPY	ETF	416.08	416.0962	415.33	415.45	5738026.0
2021-04-21 16:30:00	SPY	ETF	415.45	416.0932	415.24	415.3	232059.0
2021-04-21 17:00:00	SPY	ETF	415.39	415.4	415.11	415.2	82383.0
2021-04-21 17:30:00	SPY	ETF	415.2	415.29	415.16	415.29	15321.0
2021-04-21 18:00:00	SPY	ETF	415.29	415.43	415.25	415.29	87935.0
2021-04-21 18:30:00	SPY	ETF	416.07	416.07	415.07	415.2	50220.0
2021-04-21 19:00:00	SPY	ETF	415.16	415.32	415.05	415.1	166332.0
2021-04-21 19:30:00	SPY	ETF	415.1	415.12	414.93	414.94	196406.0
2021-04-21 04:00:00	QQQ	ETF	335.0	335.55	335.0	335.34	17883.0
2021-04-21 04:30:00	QQQ	ETF	335.25	335.37	335.15	335.2	9956.0
2021-04-21 05:00:00	QQQ	ETF	335.33	335.88	335.33	335.74	17269.0
2021-04-21 05:30:00	QQQ	ETF	335.6	335.6	335.14	335.42	13287.0
2021-04-21 06:00:00	QQQ	ETF	335.41	335.75	335.41	335.49	13303.0
2021-04-21 06:30:00	QQQ	ETF	335.55	336.06	335.46	336.06	25466.0
2021-04-21 07:00:00	QQQ	ETF	336.06	336.06	335.52	335.55	67871.0
2021-04-21 07:30:00	QQQ	ETF	335.59	335.63	335.37	335.51	63008.0
2021-04-21 08:00:00	QQQ	ETF	336.0	336.0	334.54	334.95	129087.0
2021-04-21 08:30:00	QQQ	ETF	334.96	335.25	334.56	335.19	217073.0
2021-04-21 09:00:00	QQQ	ETF	335.18	335.33	334.64	335.1	155442.0
2021-04-21 09:30:00	QQQ	ETF	335.08	336.51	333.97	336.45	4693174.0
2021-04-21 10:00:00	QQQ	ETF	336.45	336.9	335.4099	336.8	2814296.0
2021-04-21 10:30:00	QQQ	ETF	336.78	336.8	335.63	335.98	2441244.0
2021-04-21 11:00:00	QQQ	ETF	336.0	337.67	335.83	337.55	2453656.0
2021-04-21 11:30:00	QQQ	ETF	337.5401	338.23	337.51	338.155	1774655.0
2021-04-21 12:00:00	QQQ	ETF	338.17	338.1984	337.617	337.66	1066992.0
2021-04-21 12:30:00	QQQ	ETF	337.66	337.82	337.19	337.295	920998.0

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

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