PREVIEW / etf_30min / 2022-01-27

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-01-27.parquet
  size:    690 KB
  rows:    27,689

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-01-27 04:00:00	SPY	ETF	432.27	433.95	431.91	433.68	111275.0
2022-01-27 04:30:00	SPY	ETF	433.1	434.47	432.9	434.27	40949.0
2022-01-27 05:00:00	SPY	ETF	434.06	434.79	433.38	434.05	30318.0
2022-01-27 05:30:00	SPY	ETF	433.99	434.18	431.6	431.89	66138.0
2022-01-27 06:00:00	SPY	ETF	431.99	434.15	431.99	434.1	37588.0
2022-01-27 06:30:00	SPY	ETF	433.9	434.58	433.0	434.43	107018.0
2022-01-27 07:00:00	SPY	ETF	434.5	435.25	433.06	433.75	249078.0
2022-01-27 07:30:00	SPY	ETF	433.54	435.29	432.73	434.74	274231.0
2022-01-27 08:00:00	SPY	ETF	434.0499	436.44	426.85	435.53	485006.0
2022-01-27 08:30:00	SPY	ETF	435.96	437.14	434.97	437.07	1077544.0
2022-01-27 09:00:00	SPY	ETF	437.0	438.32	436.86	438.18	1098712.0
2022-01-27 09:30:00	SPY	ETF	438.26	441.27	436.98	440.28	12640508.0
2022-01-27 10:00:00	SPY	ETF	440.3	441.59	437.4	437.46	7211768.0
2022-01-27 10:30:00	SPY	ETF	437.4	439.46	435.88	439.19	6652611.0
2022-01-27 11:00:00	SPY	ETF	439.19	440.38	437.03	437.66	6307255.0
2022-01-27 11:30:00	SPY	ETF	437.65	439.78	437.45	438.9	4019609.0
2022-01-27 12:00:00	SPY	ETF	438.92	439.03	434.82	435.23	6463546.0
2022-01-27 12:30:00	SPY	ETF	435.21	435.57	432.54	434.0	7776815.0
2022-01-27 13:00:00	SPY	ETF	434.01	434.5	430.08	430.32	7883000.0
2022-01-27 13:30:00	SPY	ETF	430.33	432.5	430.06	431.99	7079917.0
2022-01-27 14:00:00	SPY	ETF	431.98	434.27	430.52	430.86	7181059.0
2022-01-27 14:30:00	SPY	ETF	430.88	433.02	429.85	431.11	7206531.0
2022-01-27 15:00:00	SPY	ETF	431.16	432.75	429.45	431.59	8041291.0
2022-01-27 15:30:00	SPY	ETF	431.58	433.98	430.76	431.27	13596215.0
2022-01-27 16:00:00	SPY	ETF	431.28	433.0	430.77	431.73	3965178.0
2022-01-27 16:30:00	SPY	ETF	431.83	440.0	431.1	433.82	906564.0
2022-01-27 17:00:00	SPY	ETF	433.71	435.83	433.42	433.42	244075.0
2022-01-27 17:30:00	SPY	ETF	433.42	434.65	433.1	434.65	176949.0
2022-01-27 18:00:00	SPY	ETF	434.4	434.76	431.24	431.24	304863.0
2022-01-27 18:30:00	SPY	ETF	431.24	434.28	431.24	433.1	73871.0
2022-01-27 19:00:00	SPY	ETF	433.0	433.55	432.55	432.7	48931.0
2022-01-27 19:30:00	SPY	ETF	432.62	433.72	431.7	433.34	175989.0
2022-01-27 04:00:00	QQQ	ETF	344.37	345.89	343.0	345.74	178372.0
2022-01-27 04:30:00	QQQ	ETF	345.38	346.9	345.09	346.44	76108.0
2022-01-27 05:00:00	QQQ	ETF	346.43	347.27	345.52	346.18	42921.0
2022-01-27 05:30:00	QQQ	ETF	346.04	346.25	343.2	343.62	123715.0
2022-01-27 06:00:00	QQQ	ETF	343.64	346.27	343.64	346.13	108939.0
2022-01-27 06:30:00	QQQ	ETF	346.16	346.67	344.75	346.59	119471.0
2022-01-27 07:00:00	QQQ	ETF	346.69	347.24	345.47	346.05	202151.0
2022-01-27 07:30:00	QQQ	ETF	345.8	347.72	345.14	346.98	260318.0
2022-01-27 08:00:00	QQQ	ETF	346.42	348.15	338.6	347.55	399219.0
2022-01-27 08:30:00	QQQ	ETF	347.75	348.75	346.5	348.56	474240.0
2022-01-27 09:00:00	QQQ	ETF	348.52	349.6	348.44	349.46	439172.0
2022-01-27 09:30:00	QQQ	ETF	349.39	350.94	346.96	349.955	8759850.0
2022-01-27 10:00:00	QQQ	ETF	349.95	351.27	347.43	347.4797	6408472.0
2022-01-27 10:30:00	QQQ	ETF	347.425	348.8	345.6899	348.5	5754827.0
2022-01-27 11:00:00	QQQ	ETF	348.49	349.86	346.88	347.4	5127924.0
2022-01-27 11:30:00	QQQ	ETF	347.4	349.81	347.25	348.48	3650838.0
2022-01-27 12:00:00	QQQ	ETF	348.4815	348.59	344.72	345.19	3462317.0
2022-01-27 12:30:00	QQQ	ETF	345.16	345.53	343.16	344.89	4254727.0

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

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