PREVIEW / etf_30min / 2022-07-20

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-07-20.parquet
  size:    654 KB
  rows:    26,127

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-07-20 04:00:00	SPY	ETF	393.11	393.57	392.52	393.0	39472.0
2022-07-20 04:30:00	SPY	ETF	393.05	393.2	392.59	392.84	7400.0
2022-07-20 05:00:00	SPY	ETF	392.82	393.19	392.82	392.99	3862.0
2022-07-20 05:30:00	SPY	ETF	392.79	393.33	392.79	393.17	9278.0
2022-07-20 06:00:00	SPY	ETF	393.24	393.25	392.75	392.96	28946.0
2022-07-20 06:30:00	SPY	ETF	392.87	392.87	391.0	391.71	100642.0
2022-07-20 07:00:00	SPY	ETF	391.76	391.93	391.33	391.88	151345.0
2022-07-20 07:30:00	SPY	ETF	391.85	391.95	391.25	391.46	126417.0
2022-07-20 08:00:00	SPY	ETF	391.49	394.32	390.89	391.22	475206.0
2022-07-20 08:30:00	SPY	ETF	391.22	392.31	391.01	391.93	262263.0
2022-07-20 09:00:00	SPY	ETF	391.91	392.55	391.72	392.49	211880.0
2022-07-20 09:30:00	SPY	ETF	392.41	392.93	391.31	391.4593	4645791.0
2022-07-20 10:00:00	SPY	ETF	391.46	393.56	391.03	393.52	3532881.0
2022-07-20 10:30:00	SPY	ETF	393.51	395.95	393.41	395.95	5444030.0
2022-07-20 11:00:00	SPY	ETF	395.95	395.97	394.65	395.17	2902474.0
2022-07-20 11:30:00	SPY	ETF	395.185	395.978	394.76	395.77	2496617.0
2022-07-20 12:00:00	SPY	ETF	395.77	396.26	395.44	395.4556	2591589.0
2022-07-20 12:30:00	SPY	ETF	395.4401	395.98	393.36	394.69	4070525.0
2022-07-20 13:00:00	SPY	ETF	394.68	394.77	392.45	393.8899	4282555.0
2022-07-20 13:30:00	SPY	ETF	393.89	394.475	392.42	392.5401	2462684.0
2022-07-20 14:00:00	SPY	ETF	392.54	394.69	392.47	394.54	3004840.0
2022-07-20 14:30:00	SPY	ETF	394.5364	394.885	393.665	394.5399	2788576.0
2022-07-20 15:00:00	SPY	ETF	394.52	395.77	394.3572	395.7301	3698193.0
2022-07-20 15:30:00	SPY	ETF	395.74	395.83	394.58	394.79	6848608.0
2022-07-20 16:00:00	SPY	ETF	394.8	395.32	394.0	394.21	3545333.0
2022-07-20 16:30:00	SPY	ETF	394.17	394.77	393.94	394.04	197346.0
2022-07-20 17:00:00	SPY	ETF	393.9	394.22	393.9	394.2	50911.0
2022-07-20 17:30:00	SPY	ETF	394.22	394.77	394.0	394.14	58674.0
2022-07-20 18:00:00	SPY	ETF	394.03	394.17	393.6	393.9	24869.0
2022-07-20 18:30:00	SPY	ETF	393.9	393.99	393.53	393.67	37143.0
2022-07-20 19:00:00	SPY	ETF	393.67	394.38	393.67	394.34	21104.0
2022-07-20 19:30:00	SPY	ETF	394.31	394.51	393.13	394.21	65454.0
2022-07-20 04:00:00	QQQ	ETF	298.6	299.44	298.49	299.02	62581.0
2022-07-20 04:30:00	QQQ	ETF	299.14	299.2	298.69	299.06	13241.0
2022-07-20 05:00:00	QQQ	ETF	299.01	299.3	299.01	299.02	9306.0
2022-07-20 05:30:00	QQQ	ETF	299.0	299.5	298.95	299.42	39714.0
2022-07-20 06:00:00	QQQ	ETF	299.35	299.42	299.08	299.33	16044.0
2022-07-20 06:30:00	QQQ	ETF	299.16	299.16	297.5	298.19	147698.0
2022-07-20 07:00:00	QQQ	ETF	298.18	298.3	297.76	298.3	203787.0
2022-07-20 07:30:00	QQQ	ETF	298.27	298.33	297.8	297.88	113401.0
2022-07-20 08:00:00	QQQ	ETF	297.88	300.0	297.4	297.77	456226.0
2022-07-20 08:30:00	QQQ	ETF	297.77	298.49	297.61	298.15	333608.0
2022-07-20 09:00:00	QQQ	ETF	298.13	298.74	298.03	298.69	374635.0
2022-07-20 09:30:00	QQQ	ETF	298.73	300.21	297.9329	298.62	7077723.0
2022-07-20 10:00:00	QQQ	ETF	298.63	301.26	298.28	301.2	4323132.0
2022-07-20 10:30:00	QQQ	ETF	301.19	303.5	301.08	303.48	4973690.0
2022-07-20 11:00:00	QQQ	ETF	303.49	303.5	302.32	303.07	3444432.0
2022-07-20 11:30:00	QQQ	ETF	303.08	304.015	302.8401	303.7005	2738547.0
2022-07-20 12:00:00	QQQ	ETF	303.71	304.24	303.415	303.415	2676047.0
2022-07-20 12:30:00	QQQ	ETF	303.415	304.13	301.43	302.81	4011869.0

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

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