PREVIEW / etf_30min / 2022-09-27

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-09-27.parquet
  size:    683 KB
  rows:    27,912

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-09-27 04:00:00	SPY	ETF	369.22	369.42	367.85	368.87	49180.0
2022-09-27 04:30:00	SPY	ETF	368.8	368.9	368.14	368.53	20220.0
2022-09-27 05:00:00	SPY	ETF	368.17	368.18	366.75	366.88	27054.0
2022-09-27 05:30:00	SPY	ETF	366.84	367.47	366.75	366.79	30747.0
2022-09-27 06:00:00	SPY	ETF	366.86	368.5	366.86	368.41	52429.0
2022-09-27 06:30:00	SPY	ETF	368.35	368.87	367.95	368.48	104978.0
2022-09-27 07:00:00	SPY	ETF	368.42	368.74	367.01	368.5	348068.0
2022-09-27 07:30:00	SPY	ETF	368.5	369.6	368.42	369.23	431620.0
2022-09-27 08:00:00	SPY	ETF	368.4801	369.59	366.13	369.04	549834.0
2022-09-27 08:30:00	SPY	ETF	368.83	369.89	368.3	368.33	523710.0
2022-09-27 09:00:00	SPY	ETF	368.32	368.78	367.79	368.07	640676.0
2022-09-27 09:30:00	SPY	ETF	368.02	370.4	367.61	368.444	9021864.0
2022-09-27 10:00:00	SPY	ETF	368.45	368.6	365.88	366.8	7678500.0
2022-09-27 10:30:00	SPY	ETF	366.8	368.96	366.8	368.255	4802075.0
2022-09-27 11:00:00	SPY	ETF	368.3	368.54	364.81	365.095	5178139.0
2022-09-27 11:30:00	SPY	ETF	365.1021	365.93	364.0155	364.065	5200036.0
2022-09-27 12:00:00	SPY	ETF	364.07	364.17	361.19	362.19	7632334.0
2022-09-27 12:30:00	SPY	ETF	362.22	363.1	361.6484	362.7301	4945272.0
2022-09-27 13:00:00	SPY	ETF	362.72	362.725	361.41	361.91	4510512.0
2022-09-27 13:30:00	SPY	ETF	361.89	362.4	360.87	361.76	3977565.0
2022-09-27 14:00:00	SPY	ETF	361.76	362.69	361.36	362.1783	3738587.0
2022-09-27 14:30:00	SPY	ETF	362.18	364.59	361.7	364.03	4994277.0
2022-09-27 15:00:00	SPY	ETF	364.03	364.05	362.74	363.09	4351553.0
2022-09-27 15:30:00	SPY	ETF	363.11	364.04	362.08	363.39	9515311.0
2022-09-27 16:00:00	SPY	ETF	363.39	363.88	361.0	363.53	3814910.0
2022-09-27 16:30:00	SPY	ETF	363.51	363.9	363.2	363.77	208459.0
2022-09-27 17:00:00	SPY	ETF	363.84	365.2	363.38	363.66	84972.0
2022-09-27 17:30:00	SPY	ETF	363.66	363.99	363.38	363.9	82341.0
2022-09-27 18:00:00	SPY	ETF	363.97	364.31	363.5	363.53	127979.0
2022-09-27 18:30:00	SPY	ETF	363.57	364.1	363.41	364.07	49561.0
2022-09-27 19:00:00	SPY	ETF	364.08	364.18	363.65	363.73	47270.0
2022-09-27 19:30:00	SPY	ETF	363.85	364.4	363.5	363.57	93640.0
2022-09-27 04:00:00	QQQ	ETF	278.06	278.56	277.86	278.02	159935.0
2022-09-27 04:30:00	QQQ	ETF	277.97	278.0	277.39	277.5	69110.0
2022-09-27 05:00:00	QQQ	ETF	277.53	277.53	276.5	276.6	58199.0
2022-09-27 05:30:00	QQQ	ETF	276.67	277.13	276.49	276.6	15316.0
2022-09-27 06:00:00	QQQ	ETF	276.78	277.98	276.73	277.93	73829.0
2022-09-27 06:30:00	QQQ	ETF	277.95	278.16	277.51	277.84	104147.0
2022-09-27 07:00:00	QQQ	ETF	277.81	278.18	277.54	277.88	185304.0
2022-09-27 07:30:00	QQQ	ETF	277.93	278.86	277.93	278.52	479547.0
2022-09-27 08:00:00	QQQ	ETF	278.46	278.85	274.575	278.33	345668.0
2022-09-27 08:30:00	QQQ	ETF	278.3	279.13	277.95	277.95	369486.0
2022-09-27 09:00:00	QQQ	ETF	277.92	278.33	277.5103	277.86	606261.0
2022-09-27 09:30:00	QQQ	ETF	277.81	280.21	277.61	278.2825	7028224.0
2022-09-27 10:00:00	QQQ	ETF	278.31	278.45	276.25	276.94	5695046.0
2022-09-27 10:30:00	QQQ	ETF	276.96	278.62	276.93	278.23	3463103.0
2022-09-27 11:00:00	QQQ	ETF	278.26	278.5	275.404	275.62	3438289.0
2022-09-27 11:30:00	QQQ	ETF	275.63	276.27	274.72	274.7862	2960001.0
2022-09-27 12:00:00	QQQ	ETF	274.76	274.84	272.11	273.2111	5625264.0
2022-09-27 12:30:00	QQQ	ETF	273.2	273.98	272.77	273.735	2888213.0

> showing 50 of 27,912 rows — these rows as CSV

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