PREVIEW / etf_30min / 2024-06-06

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-06-06.parquet
  size:    789 KB
  rows:    31,639

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
2024-06-06 04:00:00	SPY	ETF	534.67	535.01	534.67	535.0	2833.0
2024-06-06 04:30:00	SPY	ETF	534.96	534.96	534.57	534.57	4208.0
2024-06-06 05:00:00	SPY	ETF	534.65	534.68	534.6	534.63	4519.0
2024-06-06 05:30:00	SPY	ETF	534.52	534.52	534.41	534.48	5326.0
2024-06-06 06:00:00	SPY	ETF	534.64	534.64	534.55	534.57	1100.0
2024-06-06 06:30:00	SPY	ETF	534.65	534.72	534.61	534.72	1151.0
2024-06-06 07:00:00	SPY	ETF	534.71	534.86	534.65	534.85	13756.0
2024-06-06 07:30:00	SPY	ETF	534.84	534.86	534.65	534.86	34450.0
2024-06-06 08:00:00	SPY	ETF	534.72	535.16	534.4204	534.62	142903.0
2024-06-06 08:30:00	SPY	ETF	534.88	535.09	533.98	534.72	189811.0
2024-06-06 09:00:00	SPY	ETF	534.74	535.05	534.43	535.03	94713.0
2024-06-06 09:30:00	SPY	ETF	534.98	535.42	534.33	534.345	3788552.0
2024-06-06 10:00:00	SPY	ETF	534.34	535.2	534.34	535.06	2026788.0
2024-06-06 10:30:00	SPY	ETF	535.05	535.05	534.34	534.4575	1183724.0
2024-06-06 11:00:00	SPY	ETF	534.45	534.78	534.21	534.485	954646.0
2024-06-06 11:30:00	SPY	ETF	534.47	534.53	534.055	534.132	1054039.0
2024-06-06 12:00:00	SPY	ETF	534.13	534.27	533.5324	533.74	1457961.0
2024-06-06 12:30:00	SPY	ETF	533.74	533.76	533.2401	533.4499	1016416.0
2024-06-06 13:00:00	SPY	ETF	533.445	534.27	533.3	534.14	1140112.0
2024-06-06 13:30:00	SPY	ETF	534.14	534.4599	533.99	534.19	844178.0
2024-06-06 14:00:00	SPY	ETF	534.16	534.27	532.68	533.645	1870152.0
2024-06-06 14:30:00	SPY	ETF	533.65	534.58	533.37	534.405	1059521.0
2024-06-06 15:00:00	SPY	ETF	534.405	534.64	534.0	534.49	1239972.0
2024-06-06 15:30:00	SPY	ETF	534.49	534.67	533.9901	534.63	3618598.0
2024-06-06 16:00:00	SPY	ETF	534.62	534.67	534.09	534.45	2047665.0
2024-06-06 16:30:00	SPY	ETF	534.44	534.46	534.3	534.42	85915.0
2024-06-06 17:00:00	SPY	ETF	534.43	534.43	534.2	534.26	22469.0
2024-06-06 17:30:00	SPY	ETF	534.29	534.66	534.25	534.28	16752.0
2024-06-06 18:00:00	SPY	ETF	534.3	534.41	534.24	534.41	20051.0
2024-06-06 18:30:00	SPY	ETF	534.3802	534.59	534.3802	534.54	22497.0
2024-06-06 19:00:00	SPY	ETF	534.48	534.58	534.46	534.57	11634.0
2024-06-06 19:30:00	SPY	ETF	534.53	534.58	534.46	534.49	7885.0
2024-06-06 04:00:00	QQQ	ETF	463.97	464.41	463.91	464.38	64626.0
2024-06-06 04:30:00	QQQ	ETF	464.26	464.4	463.97	463.97	17265.0
2024-06-06 05:00:00	QQQ	ETF	464.03	464.21	464.03	464.04	6787.0
2024-06-06 05:30:00	QQQ	ETF	464.02	464.08	463.52	463.72	18614.0
2024-06-06 06:00:00	QQQ	ETF	463.72	463.97	463.72	463.84	17755.0
2024-06-06 06:30:00	QQQ	ETF	463.86	464.11	463.83	463.95	35793.0
2024-06-06 07:00:00	QQQ	ETF	463.95	464.2	463.89	464.2	28338.0
2024-06-06 07:30:00	QQQ	ETF	464.18	464.2	463.93	464.12	21079.0
2024-06-06 08:00:00	QQQ	ETF	464.0605	464.7389	463.67	464.03	108650.0
2024-06-06 08:30:00	QQQ	ETF	464.21	464.5	463.2	464.09	152389.0
2024-06-06 09:00:00	QQQ	ETF	464.02	464.52	463.89	464.23	93939.0
2024-06-06 09:30:00	QQQ	ETF	464.22	464.54	462.48	462.5	3164822.0
2024-06-06 10:00:00	QQQ	ETF	462.51	463.84	462.48	463.7	1498553.0
2024-06-06 10:30:00	QQQ	ETF	463.684	464.33	463.5319	463.76	1177739.0
2024-06-06 11:00:00	QQQ	ETF	463.72	464.08	463.32	463.4301	587378.0
2024-06-06 11:30:00	QQQ	ETF	463.42	463.59	463.03	463.3	778835.0
2024-06-06 12:00:00	QQQ	ETF	463.29	463.62	462.71	463.13	778384.0
2024-06-06 12:30:00	QQQ	ETF	463.14	463.25	462.6109	463.13	607849.0

> showing 50 of 31,639 rows — these rows as CSV

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