PREVIEW / etf_30min / 2022-08-31

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-08-31.parquet
  size:    647 KB
  rows:    26,097

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-08-31 04:00:00	SPY	ETF	398.98	399.52	398.34	398.51	25953.0
2022-08-31 04:30:00	SPY	ETF	398.48	399.11	398.18	398.66	19448.0
2022-08-31 05:00:00	SPY	ETF	398.62	398.62	397.7	397.86	30746.0
2022-08-31 05:30:00	SPY	ETF	397.77	398.17	397.58	398.0	20887.0
2022-08-31 06:00:00	SPY	ETF	398.06	399.08	397.59	398.96	23528.0
2022-08-31 06:30:00	SPY	ETF	398.77	399.92	398.39	399.35	59553.0
2022-08-31 07:00:00	SPY	ETF	399.26	399.84	399.01	399.25	97142.0
2022-08-31 07:30:00	SPY	ETF	399.37	399.46	398.76	399.32	60221.0
2022-08-31 08:00:00	SPY	ETF	399.25	401.11	397.7696	399.74	292022.0
2022-08-31 08:30:00	SPY	ETF	399.77	400.2	399.16	399.91	264803.0
2022-08-31 09:00:00	SPY	ETF	399.99	400.76	399.89	399.92	432185.0
2022-08-31 09:30:00	SPY	ETF	399.93	401.24	398.2	399.6018	6678963.0
2022-08-31 10:00:00	SPY	ETF	399.61	399.74	397.85	398.11	4100950.0
2022-08-31 10:30:00	SPY	ETF	398.11	399.65	397.55	398.29	3261318.0
2022-08-31 11:00:00	SPY	ETF	398.28	398.33	396.75	397.55	2999743.0
2022-08-31 11:30:00	SPY	ETF	397.53	399.2801	397.1	399.0168	2298817.0
2022-08-31 12:00:00	SPY	ETF	399.02	399.2199	397.79	398.03	2013327.0
2022-08-31 12:30:00	SPY	ETF	398.08	398.44	397.28	397.6975	1629066.0
2022-08-31 13:00:00	SPY	ETF	397.68	398.378	396.63	397.1	1743876.0
2022-08-31 13:30:00	SPY	ETF	397.11	397.32	396.1601	396.7553	2024277.0
2022-08-31 14:00:00	SPY	ETF	396.755	397.27	396.22	396.6	2646946.0
2022-08-31 14:30:00	SPY	ETF	396.5999	396.68	395.24	395.908	3353688.0
2022-08-31 15:00:00	SPY	ETF	395.91	397.95	395.57	396.7	4479517.0
2022-08-31 15:30:00	SPY	ETF	396.7	397.885	395.04	395.13	11864373.0
2022-08-31 16:00:00	SPY	ETF	395.13	395.62	394.86	395.1495	5385670.0
2022-08-31 16:30:00	SPY	ETF	395.62	395.73	395.142	395.59	220344.0
2022-08-31 17:00:00	SPY	ETF	395.5	395.64	395.07	395.27	47707.0
2022-08-31 17:30:00	SPY	ETF	395.33	395.35	395.06	395.2	78973.0
2022-08-31 18:00:00	SPY	ETF	395.2	395.56	394.08	394.24	143335.0
2022-08-31 18:30:00	SPY	ETF	394.27	394.32	393.75	394.23	65522.0
2022-08-31 19:00:00	SPY	ETF	394.19	394.19	392.84	392.84	75145.0
2022-08-31 19:30:00	SPY	ETF	392.82	393.3	392.52	393.18	124521.0
2022-08-31 04:00:00	QQQ	ETF	302.14	302.55	301.4	301.68	39155.0
2022-08-31 04:30:00	QQQ	ETF	301.72	302.51	301.5	302.0	45660.0
2022-08-31 05:00:00	QQQ	ETF	301.87	301.87	301.27	301.45	35619.0
2022-08-31 05:30:00	QQQ	ETF	301.35	301.93	301.24	301.7	38467.0
2022-08-31 06:00:00	QQQ	ETF	301.7	303.02	301.62	302.8	63765.0
2022-08-31 06:30:00	QQQ	ETF	302.83	303.84	302.49	303.46	73568.0
2022-08-31 07:00:00	QQQ	ETF	303.16	303.46	302.8	302.97	141734.0
2022-08-31 07:30:00	QQQ	ETF	303.07	303.2	302.43	303.02	108283.0
2022-08-31 08:00:00	QQQ	ETF	302.94	303.78	301.245	303.38	312386.0
2022-08-31 08:30:00	QQQ	ETF	303.41	303.93	302.68	303.49	378596.0
2022-08-31 09:00:00	QQQ	ETF	303.55	304.5	303.31	304.02	485301.0
2022-08-31 09:30:00	QQQ	ETF	304.0	304.91	301.97	303.565	5747498.0
2022-08-31 10:00:00	QQQ	ETF	303.57	303.79	301.56	301.8	2856591.0
2022-08-31 10:30:00	QQQ	ETF	301.76	302.6799	301.01	301.22	2314870.0
2022-08-31 11:00:00	QQQ	ETF	301.2	301.225	299.77	300.5086	2456198.0
2022-08-31 11:30:00	QQQ	ETF	300.47	302.27	300.08	301.94	1698355.0
2022-08-31 12:00:00	QQQ	ETF	301.95	302.17	301.02	301.34	1016290.0
2022-08-31 12:30:00	QQQ	ETF	301.37	301.69	300.5	300.8299	1123697.0

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

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