PREVIEW / etf_30min / 2022-02-23

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-02-23.parquet
  size:    692 KB
  rows:    27,060

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-02-23 04:00:00	SPY	ETF	433.45	434.0	433.25	433.75	62323.0
2022-02-23 04:30:00	SPY	ETF	434.16	434.16	433.16	433.16	10720.0
2022-02-23 05:00:00	SPY	ETF	433.13	433.36	432.48	433.03	29401.0
2022-02-23 05:30:00	SPY	ETF	433.04	433.37	432.24	432.6	13877.0
2022-02-23 06:00:00	SPY	ETF	432.65	432.9	431.96	432.27	11259.0
2022-02-23 06:30:00	SPY	ETF	432.38	432.49	431.24	431.53	24202.0
2022-02-23 07:00:00	SPY	ETF	431.39	432.51	431.31	432.51	89033.0
2022-02-23 07:30:00	SPY	ETF	432.51	433.5	432.449	433.07	121710.0
2022-02-23 08:00:00	SPY	ETF	432.4801	433.9796	431.3996	432.63	269165.0
2022-02-23 08:30:00	SPY	ETF	432.63	433.15	432.2	433.09	418973.0
2022-02-23 09:00:00	SPY	ETF	433.06	433.27	432.55	432.63	205674.0
2022-02-23 09:30:00	SPY	ETF	432.69	433.26	431.0	431.16	8229002.0
2022-02-23 10:00:00	SPY	ETF	431.1675	431.17	428.13	428.36	6684694.0
2022-02-23 10:30:00	SPY	ETF	428.36	429.47	427.68	428.14	5523583.0
2022-02-23 11:00:00	SPY	ETF	428.14	428.47	426.61	427.11	5030666.0
2022-02-23 11:30:00	SPY	ETF	427.12	429.12	426.71	428.81	4920386.0
2022-02-23 12:00:00	SPY	ETF	428.83	430.21	428.18	430.09	4408389.0
2022-02-23 12:30:00	SPY	ETF	430.11	430.26	427.65	428.02	4053964.0
2022-02-23 13:00:00	SPY	ETF	428.01	428.02	425.57	425.72	4998255.0
2022-02-23 13:30:00	SPY	ETF	425.73	427.28	425.05	426.16	5168591.0
2022-02-23 14:00:00	SPY	ETF	426.16	426.64	424.15	424.4	5709251.0
2022-02-23 14:30:00	SPY	ETF	424.415	424.76	423.03	423.6101	6270681.0
2022-02-23 15:00:00	SPY	ETF	423.62	423.89	422.18	423.66	8084585.0
2022-02-23 15:30:00	SPY	ETF	423.64	423.85	421.35	421.97	23306321.0
2022-02-23 16:00:00	SPY	ETF	421.97	422.43	421.59	421.97	5012512.0
2022-02-23 16:30:00	SPY	ETF	421.95	422.07	420.99	421.16	687876.0
2022-02-23 17:00:00	SPY	ETF	421.17	421.34	421.0	421.03	29428.0
2022-02-23 17:30:00	SPY	ETF	420.95	421.3	420.82	421.3	60059.0
2022-02-23 18:00:00	SPY	ETF	421.28	422.03	420.59	421.16	163642.0
2022-02-23 18:30:00	SPY	ETF	421.95	422.15	421.2	421.48	116803.0
2022-02-23 19:00:00	SPY	ETF	421.51	421.98	419.95	420.51	126456.0
2022-02-23 19:30:00	SPY	ETF	420.51	420.7	418.78	418.85	237886.0
2022-02-23 04:00:00	QQQ	ETF	341.01	342.67	341.01	342.47	150160.0
2022-02-23 04:30:00	QQQ	ETF	342.5	342.96	342.03	342.09	38443.0
2022-02-23 05:00:00	QQQ	ETF	342.13	342.42	341.47	341.89	98217.0
2022-02-23 05:30:00	QQQ	ETF	341.91	342.25	341.01	341.5	51469.0
2022-02-23 06:00:00	QQQ	ETF	341.46	341.59	340.76	341.4	31016.0
2022-02-23 06:30:00	QQQ	ETF	341.42	341.5	340.31	340.45	81811.0
2022-02-23 07:00:00	QQQ	ETF	340.46	341.67	340.25	341.63	160516.0
2022-02-23 07:30:00	QQQ	ETF	341.67	342.24	341.645	341.96	119407.0
2022-02-23 08:00:00	QQQ	ETF	340.88	342.9196	340.0	341.51	276259.0
2022-02-23 08:30:00	QQQ	ETF	341.54	342.0	341.11	341.96	219317.0
2022-02-23 09:00:00	QQQ	ETF	341.92	342.05	341.2	341.29	341652.0
2022-02-23 09:30:00	QQQ	ETF	341.32	342.183	338.78	339.08	6615883.0
2022-02-23 10:00:00	QQQ	ETF	339.09	339.09	336.43	336.66	5470426.0
2022-02-23 10:30:00	QQQ	ETF	336.64	337.57	335.37	336.04	4391640.0
2022-02-23 11:00:00	QQQ	ETF	336.04	336.29	334.42	335.01	3608958.0
2022-02-23 11:30:00	QQQ	ETF	335.01	337.28	334.5525	336.8099	3840454.0
2022-02-23 12:00:00	QQQ	ETF	336.81	338.09	336.37	337.86	3011131.0
2022-02-23 12:30:00	QQQ	ETF	337.87	338.01	335.39	335.69	2804000.0

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

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