PREVIEW / etf_30min / 2022-02-01

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-02-01.parquet
  size:    681 KB
  rows:    26,824

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-01 04:00:00	SPY	ETF	450.2	450.55	448.5	448.5	52576.0
2022-02-01 04:30:00	SPY	ETF	448.48	448.92	447.78	448.66	22785.0
2022-02-01 05:00:00	SPY	ETF	448.84	449.11	448.63	448.88	8550.0
2022-02-01 05:30:00	SPY	ETF	448.83	449.31	448.33	448.65	7795.0
2022-02-01 06:00:00	SPY	ETF	448.82	449.67	448.52	448.89	74412.0
2022-02-01 06:30:00	SPY	ETF	448.88	449.23	448.68	448.68	14506.0
2022-02-01 07:00:00	SPY	ETF	448.74	449.33	448.6	449.33	62162.0
2022-02-01 07:30:00	SPY	ETF	449.36	449.81	449.26	449.5	100257.0
2022-02-01 08:00:00	SPY	ETF	448.9	450.75	448.61	450.14	271365.0
2022-02-01 08:30:00	SPY	ETF	450.25	450.49	449.58	450.45	115024.0
2022-02-01 09:00:00	SPY	ETF	450.5	450.75	450.06	450.68	293072.0
2022-02-01 09:30:00	SPY	ETF	450.72	451.02	448.62	449.77	11494101.0
2022-02-01 10:00:00	SPY	ETF	449.76	450.04	446.9384	448.77	7897847.0
2022-02-01 10:30:00	SPY	ETF	448.79	450.03	447.89	450.01	4391575.0
2022-02-01 11:00:00	SPY	ETF	450.0	450.84	449.4	449.89	4385867.0
2022-02-01 11:30:00	SPY	ETF	449.89	451.02	448.98	450.68	5590926.0
2022-02-01 12:00:00	SPY	ETF	450.685	450.91	449.55	450.07	3205720.0
2022-02-01 12:30:00	SPY	ETF	450.06	450.48	448.97	450.45	3368048.0
2022-02-01 13:00:00	SPY	ETF	450.43	450.475	449.53	450.339	2386131.0
2022-02-01 13:30:00	SPY	ETF	450.34	450.7	449.61	450.43	2673571.0
2022-02-01 14:00:00	SPY	ETF	450.44	450.89	449.5	450.15	3416832.0
2022-02-01 14:30:00	SPY	ETF	450.15	450.62	449.81	450.44	2842578.0
2022-02-01 15:00:00	SPY	ETF	450.43	452.475	450.26	452.32	5788806.0
2022-02-01 15:30:00	SPY	ETF	452.32	453.63	451.84	452.97	14527397.0
2022-02-01 16:00:00	SPY	ETF	452.98	454.47	452.91	454.46	3812372.0
2022-02-01 16:30:00	SPY	ETF	454.48	454.97	452.95	454.52	2662076.0
2022-02-01 17:00:00	SPY	ETF	454.5	454.7	454.39	454.47	88979.0
2022-02-01 17:30:00	SPY	ETF	454.47	454.75	452.95	454.75	670509.0
2022-02-01 18:00:00	SPY	ETF	454.7	454.8	454.22	454.71	91006.0
2022-02-01 18:30:00	SPY	ETF	452.95	454.69	452.95	454.6	49036.0
2022-02-01 19:00:00	SPY	ETF	454.67	455.11	454.67	455.11	51051.0
2022-02-01 19:30:00	SPY	ETF	455.1	455.16	454.96	455.11	35587.0
2022-02-01 04:00:00	QQQ	ETF	364.0	364.72	362.69	362.69	78197.0
2022-02-01 04:30:00	QQQ	ETF	362.7	363.13	362.0	362.84	49061.0
2022-02-01 05:00:00	QQQ	ETF	362.9	363.5	362.62	363.28	41691.0
2022-02-01 05:30:00	QQQ	ETF	363.28	363.6	362.5	362.76	38679.0
2022-02-01 06:00:00	QQQ	ETF	362.94	363.5	362.37	362.55	32677.0
2022-02-01 06:30:00	QQQ	ETF	362.58	363.02	362.4	362.74	32324.0
2022-02-01 07:00:00	QQQ	ETF	362.67	363.76	362.61	363.76	142750.0
2022-02-01 07:30:00	QQQ	ETF	363.79	364.27	363.7	363.98	225065.0
2022-02-01 08:00:00	QQQ	ETF	362.99	364.8	362.1504	364.52	286230.0
2022-02-01 08:30:00	QQQ	ETF	364.49	364.57	363.84	364.47	222904.0
2022-02-01 09:00:00	QQQ	ETF	364.57	364.8	364.05	364.36	320495.0
2022-02-01 09:30:00	QQQ	ETF	364.43	364.63	360.53	361.852	9998462.0
2022-02-01 10:00:00	QQQ	ETF	361.87	362.41	359.14	361.32	6955451.0
2022-02-01 10:30:00	QQQ	ETF	361.38	362.309	359.83	362.275	4328347.0
2022-02-01 11:00:00	QQQ	ETF	362.26	363.7	361.91	363.08	3691441.0
2022-02-01 11:30:00	QQQ	ETF	363.07	364.3199	362.29	363.88	3099439.0
2022-02-01 12:00:00	QQQ	ETF	363.8714	364.02	362.381	363.04	2198448.0
2022-02-01 12:30:00	QQQ	ETF	363.05	363.4599	361.87	363.395	2599242.0

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

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