PREVIEW / etf_30min / 2022-03-07

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-03-07.parquet
  size:    720 KB
  rows:    29,140

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-07 04:00:00	SPY	ETF	425.95	427.85	425.64	426.32	81523.0
2022-03-07 04:30:00	SPY	ETF	426.38	426.42	424.98	425.85	52466.0
2022-03-07 05:00:00	SPY	ETF	425.98	426.49	425.64	425.86	7990.0
2022-03-07 05:30:00	SPY	ETF	425.63	426.46	425.22	425.22	57649.0
2022-03-07 06:00:00	SPY	ETF	425.29	426.1	424.25	425.77	80786.0
2022-03-07 06:30:00	SPY	ETF	425.78	427.34	425.54	427.16	75308.0
2022-03-07 07:00:00	SPY	ETF	427.24	430.22	427.18	430.09	477050.0
2022-03-07 07:30:00	SPY	ETF	430.1	430.57	428.76	428.76	491728.0
2022-03-07 08:00:00	SPY	ETF	427.955	432.424	423.54	429.79	470883.0
2022-03-07 08:30:00	SPY	ETF	429.78	431.24	424.75	430.88	937464.0
2022-03-07 09:00:00	SPY	ETF	430.91	432.2	430.4	431.55	734675.0
2022-03-07 09:30:00	SPY	ETF	431.55	431.84	427.81	427.8267	9026746.0
2022-03-07 10:00:00	SPY	ETF	427.8	428.72	426.03	426.06	7224890.0
2022-03-07 10:30:00	SPY	ETF	426.08	426.78	425.05	425.5501	5425551.0
2022-03-07 11:00:00	SPY	ETF	425.56	427.22	425.18	426.38	4798711.0
2022-03-07 11:30:00	SPY	ETF	426.36	426.5	424.05	424.17	5503820.0
2022-03-07 12:00:00	SPY	ETF	424.16	424.31	422.2	423.0046	6149933.0
2022-03-07 12:30:00	SPY	ETF	423.01	424.46	422.26	423.02	6332218.0
2022-03-07 13:00:00	SPY	ETF	423.01	424.34	422.04	422.92	5555321.0
2022-03-07 13:30:00	SPY	ETF	422.91	424.05	422.48	422.6602	3568952.0
2022-03-07 14:00:00	SPY	ETF	422.66	423.93	422.03	422.79	4622484.0
2022-03-07 14:30:00	SPY	ETF	422.79	423.02	421.32	421.7599	5312120.0
2022-03-07 15:00:00	SPY	ETF	421.74	422.06	420.36	421.57	8037769.0
2022-03-07 15:30:00	SPY	ETF	421.57	421.59	419.36	419.46	17876810.0
2022-03-07 16:00:00	SPY	ETF	419.47	419.77	418.2	418.33	6186035.0
2022-03-07 16:30:00	SPY	ETF	418.32	419.572	418.26	418.34	664812.0
2022-03-07 17:00:00	SPY	ETF	418.35	418.42	418.0	418.38	105887.0
2022-03-07 17:30:00	SPY	ETF	418.395	418.45	418.02	418.39	54993.0
2022-03-07 18:00:00	SPY	ETF	418.16	418.9	418.0	418.5	111570.0
2022-03-07 18:30:00	SPY	ETF	418.44	418.5	417.89	418.3	46322.0
2022-03-07 19:00:00	SPY	ETF	418.5	419.35	418.25	419.11	131333.0
2022-03-07 19:30:00	SPY	ETF	419.11	419.25	418.55	419.04	165622.0
2022-03-07 04:00:00	QQQ	ETF	332.92	332.92	331.62	332.1	121713.0
2022-03-07 04:30:00	QQQ	ETF	332.18	332.18	331.03	331.57	77346.0
2022-03-07 05:00:00	QQQ	ETF	331.8	332.41	331.7	331.86	30808.0
2022-03-07 05:30:00	QQQ	ETF	331.93	332.33	331.44	331.44	19702.0
2022-03-07 06:00:00	QQQ	ETF	331.46	332.02	330.97	331.77	83151.0
2022-03-07 06:30:00	QQQ	ETF	332.0	332.96	331.75	332.94	44911.0
2022-03-07 07:00:00	QQQ	ETF	332.91	335.46	332.91	335.46	425704.0
2022-03-07 07:30:00	QQQ	ETF	335.45	335.92	334.28	334.33	483494.0
2022-03-07 08:00:00	QQQ	ETF	332.96	335.9	330.8	335.26	257556.0
2022-03-07 08:30:00	QQQ	ETF	335.24	336.5	335.24	336.2	429483.0
2022-03-07 09:00:00	QQQ	ETF	336.26	337.65	336.02	337.27	528404.0
2022-03-07 09:30:00	QQQ	ETF	337.29	338.48	333.42	333.43	8884587.0
2022-03-07 10:00:00	QQQ	ETF	333.44	333.92	331.02	331.08	6224197.0
2022-03-07 10:30:00	QQQ	ETF	331.061	331.98	330.19	330.75	5688139.0
2022-03-07 11:00:00	QQQ	ETF	330.75	332.72	330.5	332.01	4509508.0
2022-03-07 11:30:00	QQQ	ETF	331.99	332.45	330.45	330.6	3719840.0
2022-03-07 12:00:00	QQQ	ETF	330.61	330.9801	329.33	329.8	4029650.0
2022-03-07 12:30:00	QQQ	ETF	329.79	331.36	329.08	329.7	4299342.0

> showing 50 of 29,140 rows — these rows as CSV

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