PREVIEW / etf_30min / 2022-03-01

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-03-01.parquet
  size:    687 KB
  rows:    27,483

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-01 04:00:00	SPY	ETF	436.74	437.03	434.75	434.87	62357.0
2022-03-01 04:30:00	SPY	ETF	434.71	435.16	433.81	434.03	77664.0
2022-03-01 05:00:00	SPY	ETF	434.14	434.14	433.26	433.49	50334.0
2022-03-01 05:30:00	SPY	ETF	433.4	434.46	432.66	434.43	81706.0
2022-03-01 06:00:00	SPY	ETF	434.1	434.45	433.3	434.01	37981.0
2022-03-01 06:30:00	SPY	ETF	434.03	434.6	432.07	432.73	89908.0
2022-03-01 07:00:00	SPY	ETF	432.79	434.35	432.68	434.3	281660.0
2022-03-01 07:30:00	SPY	ETF	434.28	434.28	432.78	433.33	204262.0
2022-03-01 08:00:00	SPY	ETF	432.8	439.56	432.5699	434.87	289693.0
2022-03-01 08:30:00	SPY	ETF	434.93	436.21	434.67	435.49	562759.0
2022-03-01 09:00:00	SPY	ETF	435.53	435.84	434.98	435.02	398555.0
2022-03-01 09:30:00	SPY	ETF	435.04	437.17	434.41	434.86	8529698.0
2022-03-01 10:00:00	SPY	ETF	434.86	436.23	433.41	434.78	7547962.0
2022-03-01 10:30:00	SPY	ETF	434.8	435.21	432.31	432.71	6802177.0
2022-03-01 11:00:00	SPY	ETF	432.69	434.14	432.4537	432.9603	4969458.0
2022-03-01 11:30:00	SPY	ETF	432.98	433.04	429.23	429.76	7246830.0
2022-03-01 12:00:00	SPY	ETF	429.765	430.68	428.5	430.43	6650447.0
2022-03-01 12:30:00	SPY	ETF	430.44	431.64	430.01	431.33	4781294.0
2022-03-01 13:00:00	SPY	ETF	431.33	432.04	428.28	428.32	4609083.0
2022-03-01 13:30:00	SPY	ETF	428.31	429.53	428.16	429.11	4084694.0
2022-03-01 14:00:00	SPY	ETF	429.1	430.63	427.93	430.36	5582383.0
2022-03-01 14:30:00	SPY	ETF	430.38	431.4	429.36	429.73	5597727.0
2022-03-01 15:00:00	SPY	ETF	429.74	432.29	429.41	429.4608	6995901.0
2022-03-01 15:30:00	SPY	ETF	429.47	430.335	427.11	430.01	20199085.0
2022-03-01 16:00:00	SPY	ETF	430.01	431.19	429.75	430.89	4646601.0
2022-03-01 16:30:00	SPY	ETF	430.94	431.12	430.4831	430.7	619276.0
2022-03-01 17:00:00	SPY	ETF	430.53	430.9	430.25	430.41	59359.0
2022-03-01 17:30:00	SPY	ETF	430.41	430.69	430.31	430.34	52674.0
2022-03-01 18:00:00	SPY	ETF	430.6	430.79	430.2	430.5599	82331.0
2022-03-01 18:30:00	SPY	ETF	430.56	431.38	430.54	431.38	47731.0
2022-03-01 19:00:00	SPY	ETF	431.38	431.95	431.07	431.72	47094.0
2022-03-01 19:30:00	SPY	ETF	431.65	431.7	431.01	431.6	69351.0
2022-03-01 04:00:00	QQQ	ETF	346.9	346.9	344.62	344.74	45580.0
2022-03-01 04:30:00	QQQ	ETF	344.75	345.01	344.08	344.15	29587.0
2022-03-01 05:00:00	QQQ	ETF	344.09	344.44	343.63	344.06	26313.0
2022-03-01 05:30:00	QQQ	ETF	344.03	345.45	343.5	345.15	34514.0
2022-03-01 06:00:00	QQQ	ETF	345.0	345.24	344.43	344.83	33967.0
2022-03-01 06:30:00	QQQ	ETF	344.8	345.42	343.18	343.77	59721.0
2022-03-01 07:00:00	QQQ	ETF	343.82	345.17	343.72	345.12	176674.0
2022-03-01 07:30:00	QQQ	ETF	345.0	345.0	343.82	344.33	145403.0
2022-03-01 08:00:00	QQQ	ETF	344.43	349.1	343.75	345.71	219094.0
2022-03-01 08:30:00	QQQ	ETF	345.74	346.54	345.33	345.81	337529.0
2022-03-01 09:00:00	QQQ	ETF	345.87	346.05	345.38	345.74	131160.0
2022-03-01 09:30:00	QQQ	ETF	345.75	347.635	345.18	346.41	6435772.0
2022-03-01 10:00:00	QQQ	ETF	346.42	348.078	345.04	347.38	6010096.0
2022-03-01 10:30:00	QQQ	ETF	347.39	348.02	344.6799	345.14	4743045.0
2022-03-01 11:00:00	QQQ	ETF	345.13	346.57	344.69	344.9601	3112916.0
2022-03-01 11:30:00	QQQ	ETF	344.97	345.04	341.88	342.3	3900994.0
2022-03-01 12:00:00	QQQ	ETF	342.28	343.2	341.39	342.845	2947860.0
2022-03-01 12:30:00	QQQ	ETF	342.85	343.9699	342.32	343.64	2189280.0

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

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