PREVIEW / etf_30min / 2022-03-24

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-03-24.parquet
  size:    670 KB
  rows:    25,961

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-24 04:00:00	SPY	ETF	445.29	446.6	445.21	446.6	13675.0
2022-03-24 04:30:00	SPY	ETF	446.62	447.0	446.48	446.72	14378.0
2022-03-24 05:00:00	SPY	ETF	446.65	446.93	446.51	446.51	10486.0
2022-03-24 05:30:00	SPY	ETF	446.5	446.61	446.4	446.4	4787.0
2022-03-24 06:00:00	SPY	ETF	446.25	446.25	445.6	445.85	10225.0
2022-03-24 06:30:00	SPY	ETF	445.85	446.02	445.75	445.87	47712.0
2022-03-24 07:00:00	SPY	ETF	445.8	447.1	445.64	446.68	133789.0
2022-03-24 07:30:00	SPY	ETF	446.62	446.87	445.36	445.92	453448.0
2022-03-24 08:00:00	SPY	ETF	446.69	447.0	445.25	445.8	153073.0
2022-03-24 08:30:00	SPY	ETF	445.61	446.22	445.33	445.99	141466.0
2022-03-24 09:00:00	SPY	ETF	445.99	446.29	445.8096	445.92	152710.0
2022-03-24 09:30:00	SPY	ETF	445.93	446.35	444.76	445.58	4732424.0
2022-03-24 10:00:00	SPY	ETF	445.5701	446.97	445.29	445.45	3791561.0
2022-03-24 10:30:00	SPY	ETF	445.44	446.93	445.23	446.37	3186255.0
2022-03-24 11:00:00	SPY	ETF	446.36	448.3	446.2373	448.2199	3728042.0
2022-03-24 11:30:00	SPY	ETF	448.25	448.94	448.04	448.415	2917488.0
2022-03-24 12:00:00	SPY	ETF	448.41	448.57	447.01	447.23	2491129.0
2022-03-24 12:30:00	SPY	ETF	447.22	447.83	446.805	447.7502	2039561.0
2022-03-24 13:00:00	SPY	ETF	447.75	448.41	447.4	448.1799	1928705.0
2022-03-24 13:30:00	SPY	ETF	448.16	448.55	447.81	448.24	1442021.0
2022-03-24 14:00:00	SPY	ETF	448.24	448.85	447.82	448.1099	2118062.0
2022-03-24 14:30:00	SPY	ETF	448.113	448.29	447.42	448.17	2164173.0
2022-03-24 15:00:00	SPY	ETF	448.16	449.82	447.7505	449.595	3596451.0
2022-03-24 15:30:00	SPY	ETF	449.6	450.46	448.83	450.41	9465139.0
2022-03-24 16:00:00	SPY	ETF	450.4	450.73	450.17	450.7	3647601.0
2022-03-24 16:30:00	SPY	ETF	450.7	450.79	450.49	450.64	185431.0
2022-03-24 17:00:00	SPY	ETF	450.67	450.68	450.55	450.68	11145.0
2022-03-24 17:30:00	SPY	ETF	450.69	450.69	450.5	450.65	21783.0
2022-03-24 18:00:00	SPY	ETF	450.65	450.76	450.39	450.52	102887.0
2022-03-24 18:30:00	SPY	ETF	450.39	450.39	450.2	450.21	12235.0
2022-03-24 19:00:00	SPY	ETF	450.19	450.4	450.0	450.3	25144.0
2022-03-24 19:30:00	SPY	ETF	450.25	450.3	450.13	450.23	66108.0
2022-03-24 04:00:00	QQQ	ETF	353.33	354.67	353.33	354.52	92485.0
2022-03-24 04:30:00	QQQ	ETF	354.44	354.88	354.44	354.6	21272.0
2022-03-24 05:00:00	QQQ	ETF	354.57	354.89	354.45	354.5	32770.0
2022-03-24 05:30:00	QQQ	ETF	354.45	354.75	354.24	354.24	10072.0
2022-03-24 06:00:00	QQQ	ETF	354.17	354.17	353.35	353.62	55249.0
2022-03-24 06:30:00	QQQ	ETF	353.64	353.81	353.5	353.58	35355.0
2022-03-24 07:00:00	QQQ	ETF	353.59	354.92	353.43	354.5	110735.0
2022-03-24 07:30:00	QQQ	ETF	354.48	354.79	353.34	353.8	210185.0
2022-03-24 08:00:00	QQQ	ETF	353.8199	354.89	351.567	353.7	218571.0
2022-03-24 08:30:00	QQQ	ETF	353.62	354.26	353.31	353.97	144666.0
2022-03-24 09:00:00	QQQ	ETF	353.94	354.29	353.66	353.75	217354.0
2022-03-24 09:30:00	QQQ	ETF	353.8	354.47	352.51	352.76	6819252.0
2022-03-24 10:00:00	QQQ	ETF	352.78	354.57	351.89	352.07	4097559.0
2022-03-24 10:30:00	QQQ	ETF	352.07	354.33	351.5939	353.75	3236276.0
2022-03-24 11:00:00	QQQ	ETF	353.73	356.38	353.455	356.26	3564771.0
2022-03-24 11:30:00	QQQ	ETF	356.28	357.17	356.11	356.475	3338584.0
2022-03-24 12:00:00	QQQ	ETF	356.47	356.6	355.44	355.7189	2420541.0
2022-03-24 12:30:00	QQQ	ETF	355.71	356.46	355.205	356.4	1732671.0

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

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