PREVIEW / etf_30min / 2022-09-30

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-09-30.parquet
  size:    681 KB
  rows:    27,335

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-30 04:00:00	SPY	ETF	366.02	366.23	365.48	365.8	42643.0
2022-09-30 04:30:00	SPY	ETF	365.9	366.75	365.51	366.66	34034.0
2022-09-30 05:00:00	SPY	ETF	366.5	366.5	365.15	365.46	52591.0
2022-09-30 05:30:00	SPY	ETF	365.58	365.84	364.9	365.18	28618.0
2022-09-30 06:00:00	SPY	ETF	365.2	366.36	365.2	366.18	45190.0
2022-09-30 06:30:00	SPY	ETF	366.03	366.3	364.34	364.5	223077.0
2022-09-30 07:00:00	SPY	ETF	364.6	364.76	363.69	364.43	313352.0
2022-09-30 07:30:00	SPY	ETF	364.35	364.39	363.0	363.7	313764.0
2022-09-30 08:00:00	SPY	ETF	363.68	366.5604	361.6	364.79	889099.0
2022-09-30 08:30:00	SPY	ETF	364.85	364.85	361.6	363.54	1614233.0
2022-09-30 09:00:00	SPY	ETF	363.52	364.5	361.79	361.86	865156.0
2022-09-30 09:30:00	SPY	ETF	361.8	363.69	360.1623	363.1	9219836.0
2022-09-30 10:00:00	SPY	ETF	363.08	363.49	361.59	363.05	5413496.0
2022-09-30 10:30:00	SPY	ETF	363.06	364.61	362.93	364.1599	4991231.0
2022-09-30 11:00:00	SPY	ETF	364.2	365.91	363.5801	365.28	4377500.0
2022-09-30 11:30:00	SPY	ETF	365.29	365.62	362.71	362.95	4452144.0
2022-09-30 12:00:00	SPY	ETF	362.96	362.98	361.8021	362.43	3800732.0
2022-09-30 12:30:00	SPY	ETF	362.4364	363.385	362.3712	362.6574	3186388.0
2022-09-30 13:00:00	SPY	ETF	362.63	362.98	362.02	362.69	2227203.0
2022-09-30 13:30:00	SPY	ETF	362.7	362.9199	360.67	360.99	3995593.0
2022-09-30 14:00:00	SPY	ETF	360.98	361.77	360.33	360.74	4539532.0
2022-09-30 14:30:00	SPY	ETF	360.7305	361.2301	359.13	359.32	6054949.0
2022-09-30 15:00:00	SPY	ETF	359.33	360.77	358.85	360.07	7063553.0
2022-09-30 15:30:00	SPY	ETF	360.08	360.7	357.11	357.19	27038466.0
2022-09-30 16:00:00	SPY	ETF	357.19	358.74	357.02	358.29	8511420.0
2022-09-30 16:30:00	SPY	ETF	358.29	358.3	357.72	357.94	435689.0
2022-09-30 17:00:00	SPY	ETF	357.95	358.04	357.18	357.8	274944.0
2022-09-30 17:30:00	SPY	ETF	357.8	358.08	357.18	358.08	181192.0
2022-09-30 18:00:00	SPY	ETF	358.08	358.15	357.18	357.8	177008.0
2022-09-30 18:30:00	SPY	ETF	357.79	357.96	357.79	357.86	37184.0
2022-09-30 19:00:00	SPY	ETF	357.86	358.08	357.62	357.81	20570.0
2022-09-30 19:30:00	SPY	ETF	357.9	357.97	357.8	357.88	8355.0
2022-09-30 04:00:00	QQQ	ETF	274.0	274.84	273.97	274.31	70012.0
2022-09-30 04:30:00	QQQ	ETF	274.18	274.97	273.96	274.9	66667.0
2022-09-30 05:00:00	QQQ	ETF	274.76	274.76	273.45	273.81	95710.0
2022-09-30 05:30:00	QQQ	ETF	273.79	274.1	273.39	273.39	34123.0
2022-09-30 06:00:00	QQQ	ETF	273.6	274.5	273.57	274.34	96985.0
2022-09-30 06:30:00	QQQ	ETF	274.32	274.4	273.05	273.06	72684.0
2022-09-30 07:00:00	QQQ	ETF	273.24	273.36	272.31	273.12	237278.0
2022-09-30 07:30:00	QQQ	ETF	273.11	273.11	272.0	272.54	290691.0
2022-09-30 08:00:00	QQQ	ETF	272.53	274.7	271.4	273.66	588000.0
2022-09-30 08:30:00	QQQ	ETF	273.58	273.59	270.56	272.29	1641246.0
2022-09-30 09:00:00	QQQ	ETF	272.3	273.13	270.89	271.08	697045.0
2022-09-30 09:30:00	QQQ	ETF	271.03	273.15	270.0	272.15	7597292.0
2022-09-30 10:00:00	QQQ	ETF	272.14	273.2	271.26	272.84	4267846.0
2022-09-30 10:30:00	QQQ	ETF	272.83	274.2	272.61	273.78	3174824.0
2022-09-30 11:00:00	QQQ	ETF	273.8	275.19	273.26	274.52	3191407.0
2022-09-30 11:30:00	QQQ	ETF	274.53	274.77	272.26	272.492	3641666.0
2022-09-30 12:00:00	QQQ	ETF	272.5	272.51	271.38	272.08	2545226.0
2022-09-30 12:30:00	QQQ	ETF	272.07	272.89	271.9	272.03	1617652.0

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

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