PREVIEW / etf_30min / 2022-02-07

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-02-07.parquet
  size:    661 KB
  rows:    25,984

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-07 04:00:00	SPY	ETF	448.37	448.8	447.79	448.08	7985.0
2022-02-07 04:30:00	SPY	ETF	448.19	448.19	447.0	447.55	10329.0
2022-02-07 05:00:00	SPY	ETF	448.04	448.15	447.7	447.91	9341.0
2022-02-07 05:30:00	SPY	ETF	448.07	448.25	447.53	447.53	64476.0
2022-02-07 06:00:00	SPY	ETF	447.59	448.23	447.33	448.18	12805.0
2022-02-07 06:30:00	SPY	ETF	448.26	448.62	448.01	448.5	69053.0
2022-02-07 07:00:00	SPY	ETF	448.34	449.74	448.34	449.14	155768.0
2022-02-07 07:30:00	SPY	ETF	449.14	449.82	449.07	449.52	63175.0
2022-02-07 08:00:00	SPY	ETF	449.5	450.35	447.25	449.9	160303.0
2022-02-07 08:30:00	SPY	ETF	449.89	449.95	449.34	449.81	321968.0
2022-02-07 09:00:00	SPY	ETF	449.79	449.95	449.11	449.53	213579.0
2022-02-07 09:30:00	SPY	ETF	449.51	450.41	448.21	449.93	8001046.0
2022-02-07 10:00:00	SPY	ETF	449.93	450.31	448.48	449.8	4530304.0
2022-02-07 10:30:00	SPY	ETF	449.81	450.86	449.21	449.79	3904262.0
2022-02-07 11:00:00	SPY	ETF	449.79	450.09	448.65	449.18	3663885.0
2022-02-07 11:30:00	SPY	ETF	449.18	449.1807	447.11	448.19	4439855.0
2022-02-07 12:00:00	SPY	ETF	448.19	448.24	447.255	447.34	2773690.0
2022-02-07 12:30:00	SPY	ETF	447.33	448.04	446.765	447.6201	3089219.0
2022-02-07 13:00:00	SPY	ETF	447.63	449.14	447.44	448.99	2956309.0
2022-02-07 13:30:00	SPY	ETF	449.0	449.61	448.59	449.42	2434256.0
2022-02-07 14:00:00	SPY	ETF	449.43	450.08	448.84	450.078	2605032.0
2022-02-07 14:30:00	SPY	ETF	450.08	450.46	449.72	449.93	3025751.0
2022-02-07 15:00:00	SPY	ETF	449.9	450.99	448.93	449.0846	4587004.0
2022-02-07 15:30:00	SPY	ETF	449.1	449.4998	445.85	447.23	14894418.0
2022-02-07 16:00:00	SPY	ETF	447.23	447.99	447.1226	447.98	3741567.0
2022-02-07 16:30:00	SPY	ETF	447.97	448.08	447.26	447.95	299852.0
2022-02-07 17:00:00	SPY	ETF	447.96	448.03	447.87	447.91	28350.0
2022-02-07 17:30:00	SPY	ETF	447.91	448.13	447.91	448.05	34788.0
2022-02-07 18:00:00	SPY	ETF	448.05	448.3	447.75	448.21	161056.0
2022-02-07 18:30:00	SPY	ETF	447.26	448.25	447.26	448.25	13996.0
2022-02-07 19:00:00	SPY	ETF	448.3	448.4	447.75	447.87	35542.0
2022-02-07 19:30:00	SPY	ETF	447.98	448.2	447.89	448.13	18457.0
2022-02-07 04:00:00	QQQ	ETF	357.0	358.09	357.0	357.55	36717.0
2022-02-07 04:30:00	QQQ	ETF	357.56	357.84	356.64	357.5	19368.0
2022-02-07 05:00:00	QQQ	ETF	357.46	357.62	357.3	357.44	8750.0
2022-02-07 05:30:00	QQQ	ETF	357.65	358.01	357.25	357.3	100548.0
2022-02-07 06:00:00	QQQ	ETF	357.45	357.77	357.15	357.7	9904.0
2022-02-07 06:30:00	QQQ	ETF	357.74	358.3	357.63	358.0	41206.0
2022-02-07 07:00:00	QQQ	ETF	357.95	359.13	357.95	358.58	321015.0
2022-02-07 07:30:00	QQQ	ETF	358.65	359.36	358.48	359.1	176624.0
2022-02-07 08:00:00	QQQ	ETF	359.1	359.91	356.82	359.41	168788.0
2022-02-07 08:30:00	QQQ	ETF	359.39	359.42	358.77	359.15	276437.0
2022-02-07 09:00:00	QQQ	ETF	359.21	359.32	358.33	358.6	228075.0
2022-02-07 09:30:00	QQQ	ETF	358.65	361.05	357.74	360.42	6586788.0
2022-02-07 10:00:00	QQQ	ETF	360.46	360.65	358.15	359.35	4085935.0
2022-02-07 10:30:00	QQQ	ETF	359.33	360.14	358.2514	359.02	2905530.0
2022-02-07 11:00:00	QQQ	ETF	359.01	359.53	357.165	357.71	3208588.0
2022-02-07 11:30:00	QQQ	ETF	357.71	357.74	355.28	356.3001	3477203.0
2022-02-07 12:00:00	QQQ	ETF	356.28	356.85	355.74	355.8299	2172754.0
2022-02-07 12:30:00	QQQ	ETF	355.815	356.39	354.95	355.92	2395632.0

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

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