PREVIEW / etf_30min / 2022-02-04

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-02-04.parquet
  size:    668 KB
  rows:    26,488

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-04 04:00:00	SPY	ETF	450.19	450.58	449.5	449.89	34419.0
2022-02-04 04:30:00	SPY	ETF	449.95	450.49	449.74	449.83	6433.0
2022-02-04 05:00:00	SPY	ETF	449.5	449.57	447.75	447.97	21416.0
2022-02-04 05:30:00	SPY	ETF	447.82	447.82	446.98	447.66	67913.0
2022-02-04 06:00:00	SPY	ETF	447.36	447.66	445.33	446.25	117198.0
2022-02-04 06:30:00	SPY	ETF	446.11	446.87	445.2	445.2	79746.0
2022-02-04 07:00:00	SPY	ETF	445.21	446.6	445.21	446.57	310486.0
2022-02-04 07:30:00	SPY	ETF	446.61	447.92	446.25	447.58	475362.0
2022-02-04 08:00:00	SPY	ETF	445.8299	452.04	445.41	447.0	368251.0
2022-02-04 08:30:00	SPY	ETF	446.99	446.99	443.98	444.38	1359186.0
2022-02-04 09:00:00	SPY	ETF	444.4	446.7	443.495	446.35	841720.0
2022-02-04 09:30:00	SPY	ETF	446.35	448.31	445.07	447.19	7666194.0
2022-02-04 10:00:00	SPY	ETF	447.17	448.72	446.01	446.0701	6110489.0
2022-02-04 10:30:00	SPY	ETF	446.08	446.97	444.22	444.7	5795774.0
2022-02-04 11:00:00	SPY	ETF	444.71	446.22	443.83	445.83	5580320.0
2022-02-04 11:30:00	SPY	ETF	445.83	447.86	445.6	446.84	4873543.0
2022-02-04 12:00:00	SPY	ETF	446.86	447.76	446.45	447.42	3594586.0
2022-02-04 12:30:00	SPY	ETF	447.47	448.63	446.86	448.56	3936628.0
2022-02-04 13:00:00	SPY	ETF	448.56	450.39	448.55	449.75	5934260.0
2022-02-04 13:30:00	SPY	ETF	449.76	450.83	449.6	450.64	4376919.0
2022-02-04 14:00:00	SPY	ETF	450.65	450.82	449.32	450.01	4731091.0
2022-02-04 14:30:00	SPY	ETF	450.018	451.14	449.85	451.0599	4860956.0
2022-02-04 15:00:00	SPY	ETF	451.06	452.78	451.03	451.875	6764809.0
2022-02-04 15:30:00	SPY	ETF	451.88	452.56	448.58	448.73	13054409.0
2022-02-04 16:00:00	SPY	ETF	448.76	449.06	447.78	448.03	5985411.0
2022-02-04 16:30:00	SPY	ETF	448.01	448.7	447.88	448.05	309362.0
2022-02-04 17:00:00	SPY	ETF	447.91	448.3	447.91	447.99	77065.0
2022-02-04 17:30:00	SPY	ETF	447.99	448.0	447.8	448.0	69539.0
2022-02-04 18:00:00	SPY	ETF	448.05	448.25	448.05	448.25	16871.0
2022-02-04 18:30:00	SPY	ETF	448.7	448.7	448.25	448.4	40017.0
2022-02-04 19:00:00	SPY	ETF	448.45	448.5	448.3	448.3	5397.0
2022-02-04 19:30:00	SPY	ETF	448.3	448.66	448.3	448.66	18145.0
2022-02-04 04:00:00	QQQ	ETF	359.07	359.4	357.96	358.52	147612.0
2022-02-04 04:30:00	QQQ	ETF	358.52	359.05	358.02	358.06	41954.0
2022-02-04 05:00:00	QQQ	ETF	358.0	358.4	356.24	356.51	145129.0
2022-02-04 05:30:00	QQQ	ETF	356.31	356.73	355.64	356.63	100506.0
2022-02-04 06:00:00	QQQ	ETF	356.62	356.62	354.85	355.49	165578.0
2022-02-04 06:30:00	QQQ	ETF	355.49	355.79	354.14	354.14	134237.0
2022-02-04 07:00:00	QQQ	ETF	354.19	355.42	354.15	355.39	230705.0
2022-02-04 07:30:00	QQQ	ETF	355.36	356.95	355.01	356.79	434854.0
2022-02-04 08:00:00	QQQ	ETF	354.6599	361.28	353.815	356.25	307296.0
2022-02-04 08:30:00	QQQ	ETF	355.79	355.97	351.53	351.63	2150267.0
2022-02-04 09:00:00	QQQ	ETF	351.66	354.27	350.31	354.086	1520700.0
2022-02-04 09:30:00	QQQ	ETF	354.08	356.19	351.97	355.43	8762634.0
2022-02-04 10:00:00	QQQ	ETF	355.43	357.64	354.85	355.1	7658016.0
2022-02-04 10:30:00	QQQ	ETF	355.1	356.0	353.3	353.67	6317103.0
2022-02-04 11:00:00	QQQ	ETF	353.68	354.94	352.2	354.59	4848657.0
2022-02-04 11:30:00	QQQ	ETF	354.56	356.62	354.36	355.6	3507343.0
2022-02-04 12:00:00	QQQ	ETF	355.6	356.46	354.99	355.8	3024203.0
2022-02-04 12:30:00	QQQ	ETF	355.85	357.4001	355.03	357.3	3176107.0

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

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