PREVIEW / etf_30min / 2022-02-09

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-02-09.parquet
  size:    671 KB
  rows:    26,558

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
2022-02-09 04:00:00	SPY	ETF	453.43	454.04	453.43	453.68	21633.0
2022-02-09 04:30:00	SPY	ETF	453.78	454.02	453.58	453.69	20310.0
2022-02-09 05:00:00	SPY	ETF	453.55	454.19	453.55	454.1	18887.0
2022-02-09 05:30:00	SPY	ETF	454.1	454.25	453.9	454.0	8122.0
2022-02-09 06:00:00	SPY	ETF	453.95	454.09	453.67	453.93	16356.0
2022-02-09 06:30:00	SPY	ETF	453.9	454.45	453.9	454.41	24723.0
2022-02-09 07:00:00	SPY	ETF	454.31	454.91	454.18	454.55	72101.0
2022-02-09 07:30:00	SPY	ETF	454.6	454.88	454.31	454.69	101175.0
2022-02-09 08:00:00	SPY	ETF	454.4	455.25	451.278	455.04	259224.0
2022-02-09 08:30:00	SPY	ETF	455.02	455.12	454.8	454.9	87577.0
2022-02-09 09:00:00	SPY	ETF	454.99	455.299	454.9	455.26	172880.0
2022-02-09 09:30:00	SPY	ETF	455.22	456.37	455.005	455.35	9491572.0
2022-02-09 10:00:00	SPY	ETF	455.35	456.36	455.13	455.92	5879559.0
2022-02-09 10:30:00	SPY	ETF	455.93	456.79	455.82	456.775	3836610.0
2022-02-09 11:00:00	SPY	ETF	456.77	457.029	455.75	456.1901	3825714.0
2022-02-09 11:30:00	SPY	ETF	456.18	456.53	455.52	455.87	3229284.0
2022-02-09 12:00:00	SPY	ETF	455.88	456.32	455.35	456.1	2895336.0
2022-02-09 12:30:00	SPY	ETF	456.11	456.7	455.8	456.66	2421854.0
2022-02-09 13:00:00	SPY	ETF	456.66	456.86	456.1	456.5402	2176291.0
2022-02-09 13:30:00	SPY	ETF	456.55	456.82	456.32	456.76	1772532.0
2022-02-09 14:00:00	SPY	ETF	456.7701	457.43	456.76	457.37	3062013.0
2022-02-09 14:30:00	SPY	ETF	457.37	457.59	456.6026	456.66	3516176.0
2022-02-09 15:00:00	SPY	ETF	456.66	457.03	455.76	457.0101	5467309.0
2022-02-09 15:30:00	SPY	ETF	457.018	457.88	456.43	457.5	13545810.0
2022-02-09 16:00:00	SPY	ETF	457.49	458.02	457.02	457.96	4646452.0
2022-02-09 16:30:00	SPY	ETF	457.99	458.0	457.54	457.69	107553.0
2022-02-09 17:00:00	SPY	ETF	457.69	457.71	457.61	457.61	22077.0
2022-02-09 17:30:00	SPY	ETF	457.69	457.79	457.65	457.79	22197.0
2022-02-09 18:00:00	SPY	ETF	457.79	457.87	457.41	457.52	52620.0
2022-02-09 18:30:00	SPY	ETF	457.54	457.54	457.22	457.46	35888.0
2022-02-09 19:00:00	SPY	ETF	457.4	457.51	457.04	457.2	37405.0
2022-02-09 19:30:00	SPY	ETF	457.22	457.3	456.77	456.78	122428.0
2022-02-09 04:00:00	QQQ	ETF	360.77	362.34	360.77	361.86	38662.0
2022-02-09 04:30:00	QQQ	ETF	361.93	362.25	361.9	361.9	103946.0
2022-02-09 05:00:00	QQQ	ETF	361.85	362.69	361.84	362.5	30326.0
2022-02-09 05:30:00	QQQ	ETF	362.49	362.71	362.48	362.59	36469.0
2022-02-09 06:00:00	QQQ	ETF	362.54	362.67	362.25	362.59	29647.0
2022-02-09 06:30:00	QQQ	ETF	362.65	363.48	362.55	363.31	38158.0
2022-02-09 07:00:00	QQQ	ETF	363.31	364.0	363.18	363.62	140873.0
2022-02-09 07:30:00	QQQ	ETF	363.62	364.09	363.28	363.8	154314.0
2022-02-09 08:00:00	QQQ	ETF	363.65	364.38	359.389	364.09	284274.0
2022-02-09 08:30:00	QQQ	ETF	364.05	364.07	363.66	363.67	125281.0
2022-02-09 09:00:00	QQQ	ETF	363.72	363.95	363.56	363.77	233441.0
2022-02-09 09:30:00	QQQ	ETF	363.73	364.54	362.42	362.76	6734430.0
2022-02-09 10:00:00	QQQ	ETF	362.79	363.97	362.12	363.32	4025038.0
2022-02-09 10:30:00	QQQ	ETF	363.32	364.46	363.12	364.43	2769496.0
2022-02-09 11:00:00	QQQ	ETF	364.44	364.92	363.71	364.27	2627406.0
2022-02-09 11:30:00	QQQ	ETF	364.24	364.77	363.62	363.96	2616903.0
2022-02-09 12:00:00	QQQ	ETF	363.96	364.6999	363.54	364.52	2141066.0
2022-02-09 12:30:00	QQQ	ETF	364.52	365.4	364.13	365.36	2156812.0

> showing 50 of 26,558 rows — these rows as CSV

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