PREVIEW / etf_30min / 2022-08-25

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-08-25.parquet
  size:    650 KB
  rows:    25,265

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-25 04:00:00	SPY	ETF	417.63	417.91	416.57	417.07	47788.0
2022-08-25 04:30:00	SPY	ETF	417.0	417.45	417.0	417.21	11639.0
2022-08-25 05:00:00	SPY	ETF	417.24	417.26	416.06	416.06	14555.0
2022-08-25 05:30:00	SPY	ETF	415.92	416.15	415.39	415.61	25012.0
2022-08-25 06:00:00	SPY	ETF	415.5	415.91	415.43	415.91	18355.0
2022-08-25 06:30:00	SPY	ETF	415.93	416.02	415.7	415.95	89700.0
2022-08-25 07:00:00	SPY	ETF	415.87	416.52	415.31	416.43	65784.0
2022-08-25 07:30:00	SPY	ETF	416.4	416.4	415.85	416.13	42001.0
2022-08-25 08:00:00	SPY	ETF	415.86	417.53	414.6	415.89	144674.0
2022-08-25 08:30:00	SPY	ETF	415.81	415.81	414.94	415.43	368192.0
2022-08-25 09:00:00	SPY	ETF	415.4	415.55	415.11	415.25	151738.0
2022-08-25 09:30:00	SPY	ETF	415.25	416.52	414.09	416.4	3602579.0
2022-08-25 10:00:00	SPY	ETF	416.4	417.59	416.1	417.36	2992544.0
2022-08-25 10:30:00	SPY	ETF	417.37	417.85	417.0	417.0877	2439570.0
2022-08-25 11:00:00	SPY	ETF	417.08	417.1	415.02	415.68	2761797.0
2022-08-25 11:30:00	SPY	ETF	415.67	416.2	415.4801	416.1076	1639101.0
2022-08-25 12:00:00	SPY	ETF	416.12	416.18	415.09	415.67	1388942.0
2022-08-25 12:30:00	SPY	ETF	415.67	415.77	414.69	415.4719	1625732.0
2022-08-25 13:00:00	SPY	ETF	415.49	416.24	415.25	416.13	1382064.0
2022-08-25 13:30:00	SPY	ETF	416.14	416.97	416.06	416.75	1504853.0
2022-08-25 14:00:00	SPY	ETF	416.77	416.99	416.2	416.93	1721358.0
2022-08-25 14:30:00	SPY	ETF	416.93	417.0	416.07	416.67	1661174.0
2022-08-25 15:00:00	SPY	ETF	416.63	417.5	416.46	417.4464	2108958.0
2022-08-25 15:30:00	SPY	ETF	417.44	419.56	417.01	419.51	9918466.0
2022-08-25 16:00:00	SPY	ETF	419.5	419.56	418.72	419.0	3989917.0
2022-08-25 16:30:00	SPY	ETF	418.96	419.02	418.78	418.8	109072.0
2022-08-25 17:00:00	SPY	ETF	418.99	419.25	418.76	419.1	58655.0
2022-08-25 17:30:00	SPY	ETF	419.13	419.19	419.01	419.16	32220.0
2022-08-25 18:00:00	SPY	ETF	419.16	419.25	418.64	418.68	54927.0
2022-08-25 18:30:00	SPY	ETF	418.67	418.81	418.67	418.74	11562.0
2022-08-25 19:00:00	SPY	ETF	418.81	419.3	418.81	419.28	21324.0
2022-08-25 19:30:00	SPY	ETF	419.25	419.25	418.97	418.97	30698.0
2022-08-25 04:00:00	QQQ	ETF	317.53	318.67	317.53	318.01	149489.0
2022-08-25 04:30:00	QQQ	ETF	317.98	318.33	317.95	318.12	23989.0
2022-08-25 05:00:00	QQQ	ETF	318.11	318.18	317.08	317.09	22870.0
2022-08-25 05:30:00	QQQ	ETF	317.05	317.07	316.51	316.78	122017.0
2022-08-25 06:00:00	QQQ	ETF	316.68	317.2	316.67	317.19	36316.0
2022-08-25 06:30:00	QQQ	ETF	317.18	317.37	317.0	317.29	33285.0
2022-08-25 07:00:00	QQQ	ETF	317.22	317.77	316.95	317.67	76385.0
2022-08-25 07:30:00	QQQ	ETF	317.66	317.66	317.04	317.29	94227.0
2022-08-25 08:00:00	QQQ	ETF	317.26	318.48	315.246	317.13	161419.0
2022-08-25 08:30:00	QQQ	ETF	317.16	317.3	316.35	316.87	292645.0
2022-08-25 09:00:00	QQQ	ETF	316.858	317.15	316.5803	316.77	167394.0
2022-08-25 09:30:00	QQQ	ETF	316.85	317.85	315.7577	317.7239	3865154.0
2022-08-25 10:00:00	QQQ	ETF	317.74	319.13	317.68	318.95	2721891.0
2022-08-25 10:30:00	QQQ	ETF	319.0	319.5204	318.451	318.53	2068625.0
2022-08-25 11:00:00	QQQ	ETF	318.53	318.54	316.69	317.25	2075382.0
2022-08-25 11:30:00	QQQ	ETF	317.25	317.89	317.081	317.76	1188197.0
2022-08-25 12:00:00	QQQ	ETF	317.7507	317.95	317.045	317.5299	930180.0
2022-08-25 12:30:00	QQQ	ETF	317.54	317.64	316.6	317.36	826320.0

> showing 50 of 25,265 rows — these rows as CSV

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