PREVIEW / etf_30min / 2022-03-28

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-03-28.parquet
  size:    670 KB
  rows:    26,345

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-03-28 04:00:00	SPY	ETF	451.96	452.05	451.24	451.94	29456.0
2022-03-28 04:30:00	SPY	ETF	451.89	452.87	451.8	452.87	4396.0
2022-03-28 05:00:00	SPY	ETF	452.81	452.83	451.83	452.09	11565.0
2022-03-28 05:30:00	SPY	ETF	452.17	452.6	452.17	452.31	3957.0
2022-03-28 06:00:00	SPY	ETF	452.34	452.79	452.2	452.4	8984.0
2022-03-28 06:30:00	SPY	ETF	452.35	452.92	452.35	452.58	18578.0
2022-03-28 07:00:00	SPY	ETF	452.82	453.56	452.82	453.53	80771.0
2022-03-28 07:30:00	SPY	ETF	453.56	453.87	453.56	453.78	58196.0
2022-03-28 08:00:00	SPY	ETF	452.1804	453.86	450.71	453.0	140021.0
2022-03-28 08:30:00	SPY	ETF	453.07	453.1	452.27	452.3	103165.0
2022-03-28 09:00:00	SPY	ETF	452.42	452.6	451.89	452.07	157790.0
2022-03-28 09:30:00	SPY	ETF	452.06	453.649	451.67	453.54	4973844.0
2022-03-28 10:00:00	SPY	ETF	453.55	453.6	452.07	452.88	4111818.0
2022-03-28 10:30:00	SPY	ETF	452.89	453.39	451.99	453.27	2705141.0
2022-03-28 11:00:00	SPY	ETF	453.28	453.42	451.84	452.4	3489992.0
2022-03-28 11:30:00	SPY	ETF	452.41	452.44	450.27	450.44	3261355.0
2022-03-28 12:00:00	SPY	ETF	450.46	451.23	450.06	450.62	2535455.0
2022-03-28 12:30:00	SPY	ETF	450.6	451.75	450.52	451.65	2326422.0
2022-03-28 13:00:00	SPY	ETF	451.66	452.54	451.42	452.3411	2163535.0
2022-03-28 13:30:00	SPY	ETF	452.33	452.52	452.1308	452.4299	1491328.0
2022-03-28 14:00:00	SPY	ETF	452.415	452.98	452.17	452.89	1639725.0
2022-03-28 14:30:00	SPY	ETF	452.89	454.42	452.74	454.41	3255782.0
2022-03-28 15:00:00	SPY	ETF	454.41	454.5877	453.87	454.48	3240674.0
2022-03-28 15:30:00	SPY	ETF	454.48	455.89	454.33	455.8698	10711694.0
2022-03-28 16:00:00	SPY	ETF	455.87	456.2	455.73	456.04	3613807.0
2022-03-28 16:30:00	SPY	ETF	455.91	456.11	455.91	456.05	290886.0
2022-03-28 17:00:00	SPY	ETF	456.05	456.19	455.9	456.0099	92267.0
2022-03-28 17:30:00	SPY	ETF	455.96	456.0	455.87	456.0	38555.0
2022-03-28 18:00:00	SPY	ETF	455.94	455.94	455.61	455.67	63182.0
2022-03-28 18:30:00	SPY	ETF	455.73	455.95	455.73	455.9	27893.0
2022-03-28 19:00:00	SPY	ETF	455.9204	455.98	455.78	455.97	16050.0
2022-03-28 19:30:00	SPY	ETF	455.98	456.15	455.77	455.81	116689.0
2022-03-28 04:00:00	QQQ	ETF	358.52	358.52	357.69	358.27	75261.0
2022-03-28 04:30:00	QQQ	ETF	358.2	358.82	357.84	358.82	28999.0
2022-03-28 05:00:00	QQQ	ETF	358.7	358.79	357.73	358.11	11317.0
2022-03-28 05:30:00	QQQ	ETF	358.14	358.48	358.06	358.35	69897.0
2022-03-28 06:00:00	QQQ	ETF	358.19	359.18	358.19	358.69	14782.0
2022-03-28 06:30:00	QQQ	ETF	358.64	359.21	358.55	358.93	31394.0
2022-03-28 07:00:00	QQQ	ETF	359.0	360.14	359.0	360.08	130950.0
2022-03-28 07:30:00	QQQ	ETF	360.11	360.68	360.08	360.66	101099.0
2022-03-28 08:00:00	QQQ	ETF	359.9192	360.81	357.5	359.88	225765.0
2022-03-28 08:30:00	QQQ	ETF	359.91	359.96	359.25	359.38	158384.0
2022-03-28 09:00:00	QQQ	ETF	359.52	359.75	358.94	359.3	180676.0
2022-03-28 09:30:00	QQQ	ETF	359.34	363.19	359.26	362.57	7168741.0
2022-03-28 10:00:00	QQQ	ETF	362.58	362.65	359.97	361.12	5036258.0
2022-03-28 10:30:00	QQQ	ETF	361.14	362.43	360.3	362.28	3663291.0
2022-03-28 11:00:00	QQQ	ETF	362.28	362.53	360.47	361.16	4324180.0
2022-03-28 11:30:00	QQQ	ETF	361.17	361.22	358.49	358.89	3248245.0
2022-03-28 12:00:00	QQQ	ETF	358.91	359.7762	358.07	358.78	1995731.0
2022-03-28 12:30:00	QQQ	ETF	358.7899	360.24	358.66	360.1	1857794.0

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

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