PREVIEW / etf_30min / 2023-01-25

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-01-25.parquet
  size:    692 KB
  rows:    27,685

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
2023-01-25 04:00:00	SPY	ETF	398.8	398.8	398.25	398.5	28932.0
2023-01-25 04:30:00	SPY	ETF	398.5	398.59	397.56	397.56	26423.0
2023-01-25 05:00:00	SPY	ETF	397.6	397.77	396.85	397.23	22078.0
2023-01-25 05:30:00	SPY	ETF	397.22	397.71	397.19	397.5	164575.0
2023-01-25 06:00:00	SPY	ETF	397.4	397.84	397.38	397.73	13585.0
2023-01-25 06:30:00	SPY	ETF	397.64	397.64	396.95	397.17	25656.0
2023-01-25 07:00:00	SPY	ETF	397.27	397.6	397.06	397.22	99385.0
2023-01-25 07:30:00	SPY	ETF	397.2	397.46	397.03	397.36	138323.0
2023-01-25 08:00:00	SPY	ETF	397.32	399.25	396.76	396.97	270251.0
2023-01-25 08:30:00	SPY	ETF	396.97	400.2	395.95	396.1	472708.0
2023-01-25 09:00:00	SPY	ETF	396.1	396.34	395.77	395.95	368984.0
2023-01-25 09:30:00	SPY	ETF	395.95	396.65	394.32	394.41	7446662.0
2023-01-25 10:00:00	SPY	ETF	394.41	395.86	394.22	394.85	6841762.0
2023-01-25 10:30:00	SPY	ETF	394.84	395.38	393.56	394.92	5744952.0
2023-01-25 11:00:00	SPY	ETF	394.9301	396.43	394.69	396.088	4359612.0
2023-01-25 11:30:00	SPY	ETF	396.11	397.725	395.955	397.185	4399712.0
2023-01-25 12:00:00	SPY	ETF	397.195	397.45	396.51	396.6794	2830350.0
2023-01-25 12:30:00	SPY	ETF	396.685	397.48	396.66	397.22	1718464.0
2023-01-25 13:00:00	SPY	ETF	397.23	398.89	397.1	398.755	3020608.0
2023-01-25 13:30:00	SPY	ETF	398.76	399.36	398.415	398.99	3770375.0
2023-01-25 14:00:00	SPY	ETF	399.0	400.21	398.69	399.32	4561380.0
2023-01-25 14:30:00	SPY	ETF	399.35	400.06	398.7801	399.77	3106156.0
2023-01-25 15:00:00	SPY	ETF	399.77	400.7	399.55	399.975	3934005.0
2023-01-25 15:30:00	SPY	ETF	399.98	400.38	399.22	400.36	8026454.0
2023-01-25 16:00:00	SPY	ETF	400.36	401.02	399.73	400.12	2799217.0
2023-01-25 16:30:00	SPY	ETF	400.13	400.33	399.99	400.08	2867883.0
2023-01-25 17:00:00	SPY	ETF	400.12	400.2	399.89	399.95	88521.0
2023-01-25 17:30:00	SPY	ETF	400.0	400.14	399.95	400.1	10482.0
2023-01-25 18:00:00	SPY	ETF	400.14	400.93	399.99	400.72	186538.0
2023-01-25 18:30:00	SPY	ETF	400.77	401.03	400.75	400.84	34107.0
2023-01-25 19:00:00	SPY	ETF	400.98	401.08	400.83	401.01	50636.0
2023-01-25 19:30:00	SPY	ETF	400.98	401.01	400.64	400.7	67340.0
2023-01-25 04:00:00	QQQ	ETF	286.6	286.7	286.19	286.4	97864.0
2023-01-25 04:30:00	QQQ	ETF	286.5	286.53	285.44	285.44	32494.0
2023-01-25 05:00:00	QQQ	ETF	285.51	285.58	284.76	284.97	83938.0
2023-01-25 05:30:00	QQQ	ETF	285.14	285.36	284.99	285.07	34925.0
2023-01-25 06:00:00	QQQ	ETF	285.17	285.35	285.01	285.22	28615.0
2023-01-25 06:30:00	QQQ	ETF	285.22	285.22	284.3	284.56	110160.0
2023-01-25 07:00:00	QQQ	ETF	284.59	285.0	284.5	284.92	172728.0
2023-01-25 07:30:00	QQQ	ETF	284.86	285.12	284.66	284.97	106823.0
2023-01-25 08:00:00	QQQ	ETF	284.61	288.586	284.3804	284.7	336195.0
2023-01-25 08:30:00	QQQ	ETF	284.72	284.72	283.59	283.73	449004.0
2023-01-25 09:00:00	QQQ	ETF	283.73	284.06	283.55	283.755	565853.0
2023-01-25 09:30:00	QQQ	ETF	283.77	284.08	281.62	281.655	7142029.0
2023-01-25 10:00:00	QQQ	ETF	281.65	282.61	281.43	282.2	3806123.0
2023-01-25 10:30:00	QQQ	ETF	282.21	282.8	281.18	282.682	2971833.0
2023-01-25 11:00:00	QQQ	ETF	282.67	284.54	282.48	284.05	3232229.0
2023-01-25 11:30:00	QQQ	ETF	284.06	285.6	283.97	285.04	2719620.0
2023-01-25 12:00:00	QQQ	ETF	285.08	285.235	284.29	284.405	1760335.0
2023-01-25 12:30:00	QQQ	ETF	284.405	285.0	284.2501	284.775	1054662.0

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

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