PREVIEW / etf_30min / 2021-04-22

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-04-22.parquet
  size:    618 KB
  rows:    23,317

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-22 04:00:00	SPY	ETF	415.61	415.87	415.52	415.77	31061.0
2021-04-22 04:30:00	SPY	ETF	415.88	416.02	415.59	415.6	9800.0
2021-04-22 05:00:00	SPY	ETF	415.62	415.77	415.59	415.77	4900.0
2021-04-22 05:30:00	SPY	ETF	415.69	415.87	415.54	415.85	13697.0
2021-04-22 06:00:00	SPY	ETF	415.9	415.9	415.53	415.57	7877.0
2021-04-22 06:30:00	SPY	ETF	415.55	415.8	415.4	415.55	11190.0
2021-04-22 07:00:00	SPY	ETF	415.53	415.73	415.4	415.59	38742.0
2021-04-22 07:30:00	SPY	ETF	415.58	415.64	415.42	415.52	70838.0
2021-04-22 08:00:00	SPY	ETF	415.5099	416.12	415.41	415.74	155887.0
2021-04-22 08:30:00	SPY	ETF	415.69	416.14	415.69	415.85	239084.0
2021-04-22 09:00:00	SPY	ETF	415.83	416.16	415.76	415.9	114924.0
2021-04-22 09:30:00	SPY	ETF	415.88	415.91	414.715	415.3	5719384.0
2021-04-22 10:00:00	SPY	ETF	415.295	415.53	414.535	415.33	3764988.0
2021-04-22 10:30:00	SPY	ETF	415.34	416.16	415.29	415.86	3085681.0
2021-04-22 11:00:00	SPY	ETF	415.86	416.2599	415.82	415.89	2156153.0
2021-04-22 11:30:00	SPY	ETF	415.88	416.45	415.71	416.075	2041248.0
2021-04-22 12:00:00	SPY	ETF	416.075	416.38	415.77	416.36	1796239.0
2021-04-22 12:30:00	SPY	ETF	416.36	416.76	416.36	416.75	2014716.0
2021-04-22 13:00:00	SPY	ETF	416.75	416.78	413.15	414.69	14021874.0
2021-04-22 13:30:00	SPY	ETF	414.7	414.76	411.5	411.82	9729055.0
2021-04-22 14:00:00	SPY	ETF	411.83	413.08	411.13	413.079	8739668.0
2021-04-22 14:30:00	SPY	ETF	413.08	413.45	412.76	412.995	4605616.0
2021-04-22 15:00:00	SPY	ETF	413.0	413.44	411.7599	412.175	5746390.0
2021-04-22 15:30:00	SPY	ETF	412.17	413.05	412.06	412.32	12068252.0
2021-04-22 16:00:00	SPY	ETF	412.33	412.54	411.99	412.3	3257407.0
2021-04-22 16:30:00	SPY	ETF	412.34	412.6	412.3	412.58	266319.0
2021-04-22 17:00:00	SPY	ETF	412.57	412.58	412.36	412.42	24459.0
2021-04-22 17:30:00	SPY	ETF	412.4	412.42	412.2999	412.35	43606.0
2021-04-22 18:00:00	SPY	ETF	412.37	412.86	412.37	412.5	138159.0
2021-04-22 18:30:00	SPY	ETF	412.27	412.84	412.27	412.81	15971.0
2021-04-22 19:00:00	SPY	ETF	412.8	412.85	412.7	412.75	7230.0
2021-04-22 19:30:00	SPY	ETF	412.77	412.79	412.42	412.59	38696.0
2021-04-22 04:00:00	QQQ	ETF	339.22	339.36	339.14	339.3	28310.0
2021-04-22 04:30:00	QQQ	ETF	339.38	339.51	339.22	339.22	8599.0
2021-04-22 05:00:00	QQQ	ETF	339.21	339.36	339.09	339.15	14439.0
2021-04-22 05:30:00	QQQ	ETF	339.08	339.21	338.92	339.14	7818.0
2021-04-22 06:00:00	QQQ	ETF	339.15	339.17	338.44	338.85	24147.0
2021-04-22 06:30:00	QQQ	ETF	338.9	339.1	338.71	338.79	10113.0
2021-04-22 07:00:00	QQQ	ETF	338.8	338.99	338.64	338.75	63317.0
2021-04-22 07:30:00	QQQ	ETF	338.78	338.85	338.45	338.63	64135.0
2021-04-22 08:00:00	QQQ	ETF	338.82	339.6	338.4	338.69	104644.0
2021-04-22 08:30:00	QQQ	ETF	338.75	339.23	338.65	338.8996	109742.0
2021-04-22 09:00:00	QQQ	ETF	338.88	339.18	338.77	338.87	65468.0
2021-04-22 09:30:00	QQQ	ETF	338.88	339.13	337.752	338.41	3331144.0
2021-04-22 10:00:00	QQQ	ETF	338.4	339.31	337.79	339.11	2790900.0
2021-04-22 10:30:00	QQQ	ETF	339.15	339.9	339.09	339.42	1694641.0
2021-04-22 11:00:00	QQQ	ETF	339.43	339.629	338.89	338.9551	1328661.0
2021-04-22 11:30:00	QQQ	ETF	338.96	339.51	338.7501	339.01	1206763.0
2021-04-22 12:00:00	QQQ	ETF	339.04	339.49	338.63	339.46	1035868.0
2021-04-22 12:30:00	QQQ	ETF	339.455	339.835	339.455	339.7713	945259.0

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

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