PREVIEW / etf_30min / 2022-09-01

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-09-01.parquet
  size:    671 KB
  rows:    27,254

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-01 04:00:00	SPY	ETF	392.79	393.0	392.0	392.24	16579.0
2022-09-01 04:30:00	SPY	ETF	392.22	392.35	391.84	392.11	16177.0
2022-09-01 05:00:00	SPY	ETF	392.25	392.56	391.82	392.06	11974.0
2022-09-01 05:30:00	SPY	ETF	392.29	392.96	391.93	392.61	21509.0
2022-09-01 06:00:00	SPY	ETF	392.61	392.71	392.39	392.41	6949.0
2022-09-01 06:30:00	SPY	ETF	392.53	392.82	392.28	392.7	20470.0
2022-09-01 07:00:00	SPY	ETF	392.58	393.64	392.58	393.46	191329.0
2022-09-01 07:30:00	SPY	ETF	393.36	394.5	393.29	393.85	255563.0
2022-09-01 08:00:00	SPY	ETF	393.9	394.48	391.81	393.48	275307.0
2022-09-01 08:30:00	SPY	ETF	393.47	393.78	392.51	392.59	412216.0
2022-09-01 09:00:00	SPY	ETF	392.61	393.08	392.23	392.87	297029.0
2022-09-01 09:30:00	SPY	ETF	392.89	393.46	391.95	392.805	6550339.0
2022-09-01 10:00:00	SPY	ETF	392.8	393.2794	390.55	392.62	6119594.0
2022-09-01 10:30:00	SPY	ETF	392.63	392.65	390.12	390.3404	4678528.0
2022-09-01 11:00:00	SPY	ETF	390.33	392.02	390.04	390.87	4448492.0
2022-09-01 11:30:00	SPY	ETF	390.87	392.62	390.64	391.178	4103664.0
2022-09-01 12:00:00	SPY	ETF	391.17	392.31	391.12	391.72	2850889.0
2022-09-01 12:30:00	SPY	ETF	391.705	391.87	390.28	390.728	2331818.0
2022-09-01 13:00:00	SPY	ETF	390.75	393.09	390.51	392.96	3413368.0
2022-09-01 13:30:00	SPY	ETF	392.96	393.15	391.87	392.13	2439753.0
2022-09-01 14:00:00	SPY	ETF	392.14	394.43	391.8201	394.17	4235662.0
2022-09-01 14:30:00	SPY	ETF	394.15	395.01	393.54	394.27	4823577.0
2022-09-01 15:00:00	SPY	ETF	394.26	395.53	393.995	394.015	4259923.0
2022-09-01 15:30:00	SPY	ETF	394.01	396.78	393.63	396.4	8124307.0
2022-09-01 16:00:00	SPY	ETF	396.39	396.49	395.69	396.42	2605442.0
2022-09-01 16:30:00	SPY	ETF	396.43	396.62	396.25	396.45	80199.0
2022-09-01 17:00:00	SPY	ETF	396.48	396.65	396.43	396.6	51008.0
2022-09-01 17:30:00	SPY	ETF	396.62	396.63	396.5	396.6	45129.0
2022-09-01 18:00:00	SPY	ETF	396.49	397.07	396.42	396.75	306820.0
2022-09-01 18:30:00	SPY	ETF	396.75	396.75	396.12	396.45	65387.0
2022-09-01 19:00:00	SPY	ETF	396.4	396.4	396.21	396.37	28714.0
2022-09-01 19:30:00	SPY	ETF	396.39	397.67	396.11	396.6	32892.0
2022-09-01 04:00:00	QQQ	ETF	296.37	296.66	295.98	296.03	43338.0
2022-09-01 04:30:00	QQQ	ETF	296.02	296.12	295.57	295.92	41329.0
2022-09-01 05:00:00	QQQ	ETF	295.99	296.27	295.39	295.54	33915.0
2022-09-01 05:30:00	QQQ	ETF	295.82	296.4	295.66	296.21	27579.0
2022-09-01 06:00:00	QQQ	ETF	296.16	296.44	296.11	296.44	11310.0
2022-09-01 06:30:00	QQQ	ETF	296.4	296.74	296.16	296.74	31169.0
2022-09-01 07:00:00	QQQ	ETF	296.57	297.54	296.56	297.34	313950.0
2022-09-01 07:30:00	QQQ	ETF	297.32	298.26	297.17	297.52	282429.0
2022-09-01 08:00:00	QQQ	ETF	297.54	298.24	295.4896	297.18	373534.0
2022-09-01 08:30:00	QQQ	ETF	297.3	297.73	296.41	296.82	505096.0
2022-09-01 09:00:00	QQQ	ETF	296.82	297.2	296.41	296.71	359081.0
2022-09-01 09:30:00	QQQ	ETF	296.72	297.9373	295.89	297.01	5719927.0
2022-09-01 10:00:00	QQQ	ETF	297.0337	297.4399	294.84	296.55	4986821.0
2022-09-01 10:30:00	QQQ	ETF	296.56	296.56	293.785	293.79	3818585.0
2022-09-01 11:00:00	QQQ	ETF	293.79	294.7886	293.17	293.31	3647259.0
2022-09-01 11:30:00	QQQ	ETF	293.32	294.92	293.12	293.545	2718463.0
2022-09-01 12:00:00	QQQ	ETF	293.545	294.53	293.485	294.02	2342435.0
2022-09-01 12:30:00	QQQ	ETF	294.04	294.1794	292.95	293.43	1828093.0

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

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