PREVIEW / etf_30min / 2023-01-18

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-01-18.parquet
  size:    713 KB
  rows:    28,448

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-18 04:00:00	SPY	ETF	398.22	398.33	397.77	398.02	14530.0
2023-01-18 04:30:00	SPY	ETF	397.91	398.08	397.82	398.08	4032.0
2023-01-18 05:00:00	SPY	ETF	397.95	398.14	397.85	397.85	5778.0
2023-01-18 05:30:00	SPY	ETF	397.73	398.36	397.72	398.19	25917.0
2023-01-18 06:00:00	SPY	ETF	398.15	398.4	398.15	398.31	88889.0
2023-01-18 06:30:00	SPY	ETF	398.16	398.5	398.1	398.42	15115.0
2023-01-18 07:00:00	SPY	ETF	398.39	398.65	398.39	398.65	78643.0
2023-01-18 07:30:00	SPY	ETF	398.67	399.14	398.64	399.11	223776.0
2023-01-18 08:00:00	SPY	ETF	398.92	399.15	398.01	398.72	208985.0
2023-01-18 08:30:00	SPY	ETF	398.99	400.05	397.9	399.22	1243273.0
2023-01-18 09:00:00	SPY	ETF	399.22	399.65	398.01	398.97	602329.0
2023-01-18 09:30:00	SPY	ETF	399.03	399.69	398.4	399.54	5735249.0
2023-01-18 10:00:00	SPY	ETF	399.54	400.12	398.54	399.415	4951185.0
2023-01-18 10:30:00	SPY	ETF	399.44	399.49	396.48	397.25	6646977.0
2023-01-18 11:00:00	SPY	ETF	397.24	397.415	394.95	395.365	6852398.0
2023-01-18 11:30:00	SPY	ETF	395.36	395.36	394.21	394.8631	5302251.0
2023-01-18 12:00:00	SPY	ETF	394.86	395.07	393.51	393.72	3690199.0
2023-01-18 12:30:00	SPY	ETF	393.71	394.1	393.2	393.36	3624164.0
2023-01-18 13:00:00	SPY	ETF	393.37	393.62	392.53	393.3299	4054383.0
2023-01-18 13:30:00	SPY	ETF	393.33	394.06	393.04	393.5889	4026951.0
2023-01-18 14:00:00	SPY	ETF	393.59	393.79	393.08	393.73	2479809.0
2023-01-18 14:30:00	SPY	ETF	393.72	393.9101	393.05	393.1201	2380537.0
2023-01-18 15:00:00	SPY	ETF	393.13	393.5814	392.71	392.8215	3859520.0
2023-01-18 15:30:00	SPY	ETF	392.81	392.86	391.28	391.54	12230446.0
2023-01-18 16:00:00	SPY	ETF	391.55	391.62	391.37	391.44	7768926.0
2023-01-18 16:30:00	SPY	ETF	391.43	391.6	391.42	391.47	467174.0
2023-01-18 17:00:00	SPY	ETF	391.53	391.53	391.35	391.43	385259.0
2023-01-18 17:30:00	SPY	ETF	391.43	391.43	391.35	391.37	13482.0
2023-01-18 18:00:00	SPY	ETF	391.35	391.67	391.25	391.61	80229.0
2023-01-18 18:30:00	SPY	ETF	391.6	391.71	391.48	391.54	25280.0
2023-01-18 19:00:00	SPY	ETF	391.5	391.53	390.86	391.04	60832.0
2023-01-18 19:30:00	SPY	ETF	391.05	391.2	390.77	390.86	63295.0
2023-01-18 04:00:00	QQQ	ETF	281.68	281.83	281.54	281.6	17003.0
2023-01-18 04:30:00	QQQ	ETF	281.6	281.64	281.34	281.64	30018.0
2023-01-18 05:00:00	QQQ	ETF	281.5	281.63	281.34	281.37	9844.0
2023-01-18 05:30:00	QQQ	ETF	281.37	281.95	281.18	281.81	13179.0
2023-01-18 06:00:00	QQQ	ETF	281.75	281.91	281.69	281.79	14689.0
2023-01-18 06:30:00	QQQ	ETF	281.7	282.02	281.63	282.0	17803.0
2023-01-18 07:00:00	QQQ	ETF	281.9	282.16	281.87	282.14	63362.0
2023-01-18 07:30:00	QQQ	ETF	282.15	282.61	282.09	282.55	87296.0
2023-01-18 08:00:00	QQQ	ETF	281.9533	282.6	281.5	282.44	178680.0
2023-01-18 08:30:00	QQQ	ETF	282.47	283.78	281.85	283.05	1065253.0
2023-01-18 09:00:00	QQQ	ETF	283.05	283.55	282.84	283.0904	551692.0
2023-01-18 09:30:00	QQQ	ETF	283.15	283.9	282.59	283.745	4940858.0
2023-01-18 10:00:00	QQQ	ETF	283.78	284.69	282.72	283.7	3901508.0
2023-01-18 10:30:00	QQQ	ETF	283.7	283.715	280.49	281.242	3517349.0
2023-01-18 11:00:00	QQQ	ETF	281.22	281.43	279.42	279.95	2778719.0
2023-01-18 11:30:00	QQQ	ETF	279.94	279.94	278.86	279.64	2364438.0
2023-01-18 12:00:00	QQQ	ETF	279.64	279.85	278.76	278.9801	1742072.0
2023-01-18 12:30:00	QQQ	ETF	278.955	279.33	278.57	278.73	1563893.0

> showing 50 of 28,448 rows — these rows as CSV

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