PREVIEW / etf_30min / 2022-09-06

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-09-06.parquet
  size:    653 KB
  rows:    26,640

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-06 04:00:00	SPY	ETF	394.83	394.97	393.9	394.0	25260.0
2022-09-06 04:30:00	SPY	ETF	394.18	394.8	394.03	394.8	77014.0
2022-09-06 05:00:00	SPY	ETF	394.75	394.76	393.76	394.3	11612.0
2022-09-06 05:30:00	SPY	ETF	394.46	394.75	394.3	394.59	39665.0
2022-09-06 06:00:00	SPY	ETF	394.66	395.98	394.61	395.58	55293.0
2022-09-06 06:30:00	SPY	ETF	395.3	395.33	394.85	394.92	38970.0
2022-09-06 07:00:00	SPY	ETF	394.92	395.08	394.43	394.63	180306.0
2022-09-06 07:30:00	SPY	ETF	394.53	394.67	393.87	394.66	130787.0
2022-09-06 08:00:00	SPY	ETF	394.95	395.8404	393.73	394.45	193661.0
2022-09-06 08:30:00	SPY	ETF	394.4	394.86	394.3	394.46	204140.0
2022-09-06 09:00:00	SPY	ETF	394.45	394.85	393.0	393.09	482886.0
2022-09-06 09:30:00	SPY	ETF	393.1	394.12	390.52	391.64	6433517.0
2022-09-06 10:00:00	SPY	ETF	391.65	391.65	388.42	390.4101	6712969.0
2022-09-06 10:30:00	SPY	ETF	390.4	393.74	389.67	393.11	6063343.0
2022-09-06 11:00:00	SPY	ETF	393.1	394.05	391.85	392.02	4067349.0
2022-09-06 11:30:00	SPY	ETF	391.99	393.94	391.82	393.38	3013323.0
2022-09-06 12:00:00	SPY	ETF	393.36	393.72	390.42	391.12	3654848.0
2022-09-06 12:30:00	SPY	ETF	391.13	392.07	390.65	391.6301	2275990.0
2022-09-06 13:00:00	SPY	ETF	391.63	391.69	389.14	389.54	3516830.0
2022-09-06 13:30:00	SPY	ETF	389.53	390.48	389.14	390.38	2589220.0
2022-09-06 14:00:00	SPY	ETF	390.362	391.75	390.22	391.05	2839560.0
2022-09-06 14:30:00	SPY	ETF	391.06	391.31	389.94	390.413	2518347.0
2022-09-06 15:00:00	SPY	ETF	390.43	391.79	389.89	390.9309	3844450.0
2022-09-06 15:30:00	SPY	ETF	390.94	391.27	389.71	390.79	9121335.0
2022-09-06 16:00:00	SPY	ETF	390.79	390.9	390.2	390.31	1855700.0
2022-09-06 16:30:00	SPY	ETF	390.26	390.6	390.16	390.58	99682.0
2022-09-06 17:00:00	SPY	ETF	390.56	390.66	390.35	390.45	34101.0
2022-09-06 17:30:00	SPY	ETF	390.45	390.76	390.39	390.76	478313.0
2022-09-06 18:00:00	SPY	ETF	390.44	390.84	390.34	390.7	101277.0
2022-09-06 18:30:00	SPY	ETF	390.76	390.8	390.6	390.73	11248.0
2022-09-06 19:00:00	SPY	ETF	390.7	390.76	390.21	390.44	15302.0
2022-09-06 19:30:00	SPY	ETF	390.42	390.61	390.24	390.36	20561.0
2022-09-06 04:00:00	QQQ	ETF	297.2	297.43	296.5	297.05	46521.0
2022-09-06 04:30:00	QQQ	ETF	297.05	297.66	296.84	297.64	15783.0
2022-09-06 05:00:00	QQQ	ETF	297.65	297.65	296.73	297.38	34894.0
2022-09-06 05:30:00	QQQ	ETF	297.14	297.36	297.06	297.25	19114.0
2022-09-06 06:00:00	QQQ	ETF	297.26	298.2	297.07	297.87	40306.0
2022-09-06 06:30:00	QQQ	ETF	297.9	297.9	297.2	297.31	40550.0
2022-09-06 07:00:00	QQQ	ETF	297.29	297.37	296.68	296.75	109621.0
2022-09-06 07:30:00	QQQ	ETF	296.71	296.95	296.05	296.91	129852.0
2022-09-06 08:00:00	QQQ	ETF	296.69	298.0	296.06	296.53	206363.0
2022-09-06 08:30:00	QQQ	ETF	296.5	296.92	296.37	296.65	128619.0
2022-09-06 09:00:00	QQQ	ETF	296.63	297.09	295.42	295.62	254333.0
2022-09-06 09:30:00	QQQ	ETF	295.66	296.6	293.03	293.689	5808927.0
2022-09-06 10:00:00	QQQ	ETF	293.66	293.69	290.87	292.41	5269381.0
2022-09-06 10:30:00	QQQ	ETF	292.35	295.59	291.8	295.0959	3910787.0
2022-09-06 11:00:00	QQQ	ETF	295.07	295.92	294.06	294.19	3140762.0
2022-09-06 11:30:00	QQQ	ETF	294.19	296.04	293.97	295.51	2612468.0
2022-09-06 12:00:00	QQQ	ETF	295.5	295.94	292.86	293.57	2740986.0
2022-09-06 12:30:00	QQQ	ETF	293.56	294.38	293.175	293.95	2062283.0

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

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