PREVIEW / etf_30min / 2022-01-24

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-01-24.parquet
  size:    775 KB
  rows:    30,882

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-24 04:00:00	SPY	ETF	439.02	440.23	439.02	439.52	113903.0
2022-01-24 04:30:00	SPY	ETF	439.47	439.8	438.98	439.5	33944.0
2022-01-24 05:00:00	SPY	ETF	439.39	439.39	436.5	436.76	126034.0
2022-01-24 05:30:00	SPY	ETF	436.57	437.38	435.62	436.8	68688.0
2022-01-24 06:00:00	SPY	ETF	436.84	438.09	436.61	436.79	68089.0
2022-01-24 06:30:00	SPY	ETF	436.74	438.0	436.6	437.81	81301.0
2022-01-24 07:00:00	SPY	ETF	437.79	438.04	436.24	436.76	304126.0
2022-01-24 07:30:00	SPY	ETF	436.77	437.17	435.58	435.79	362223.0
2022-01-24 08:00:00	SPY	ETF	436.27	441.79	433.9	434.15	932870.0
2022-01-24 08:30:00	SPY	ETF	434.15	434.15	431.98	432.0	971859.0
2022-01-24 09:00:00	SPY	ETF	432.0	432.58	430.61	432.03	1433166.0
2022-01-24 09:30:00	SPY	ETF	432.03	433.46	428.45	429.07	22414789.0
2022-01-24 10:00:00	SPY	ETF	429.09	430.34	425.75	428.66	14720326.0
2022-01-24 10:30:00	SPY	ETF	428.64	430.94	427.7799	428.79	9345690.0
2022-01-24 11:00:00	SPY	ETF	428.78	428.824	426.46	427.72	7687175.0
2022-01-24 11:30:00	SPY	ETF	427.74	428.05	422.89	425.82	11403470.0
2022-01-24 12:00:00	SPY	ETF	425.79	425.79	420.76	422.58	11053961.0
2022-01-24 12:30:00	SPY	ETF	422.53	426.36	421.34	425.3	9818303.0
2022-01-24 13:00:00	SPY	ETF	425.28	429.24	424.73	426.3	10588659.0
2022-01-24 13:30:00	SPY	ETF	426.28	431.35	426.19	431.26	9041085.0
2022-01-24 14:00:00	SPY	ETF	431.27	433.04	427.87	428.49	11676716.0
2022-01-24 14:30:00	SPY	ETF	428.48	430.62	426.03	430.32	10177250.0
2022-01-24 15:00:00	SPY	ETF	430.31	434.04	429.91	433.05	10610364.0
2022-01-24 15:30:00	SPY	ETF	433.06	440.38	432.15	439.89	28834458.0
2022-01-24 16:00:00	SPY	ETF	439.88	440.49	438.6	439.68	6253112.0
2022-01-24 16:30:00	SPY	ETF	439.78	440.54	439.31	440.17	527833.0
2022-01-24 17:00:00	SPY	ETF	440.28	440.28	439.76	439.76	289853.0
2022-01-24 17:30:00	SPY	ETF	439.74	439.84	439.25	439.59	148139.0
2022-01-24 18:00:00	SPY	ETF	439.6	440.15	438.52	438.52	425792.0
2022-01-24 18:30:00	SPY	ETF	439.84	439.84	437.83	439.6	198492.0
2022-01-24 19:00:00	SPY	ETF	439.6	439.85	437.96	438.23	79228.0
2022-01-24 19:30:00	SPY	ETF	438.2	439.0	435.99	436.18	164559.0
2022-01-24 04:00:00	QQQ	ETF	352.85	354.3	352.16	352.78	88441.0
2022-01-24 04:30:00	QQQ	ETF	352.55	352.95	351.77	352.4	76893.0
2022-01-24 05:00:00	QQQ	ETF	352.13	352.13	349.06	349.09	88922.0
2022-01-24 05:30:00	QQQ	ETF	349.4	349.93	348.47	349.5	292054.0
2022-01-24 06:00:00	QQQ	ETF	349.61	351.2	349.57	349.87	248144.0
2022-01-24 06:30:00	QQQ	ETF	350.07	351.04	349.41	350.76	119912.0
2022-01-24 07:00:00	QQQ	ETF	350.9	351.07	349.08	349.44	299533.0
2022-01-24 07:30:00	QQQ	ETF	349.48	349.8	348.11	348.49	465416.0
2022-01-24 08:00:00	QQQ	ETF	348.931	355.0	346.2	346.48	850374.0
2022-01-24 08:30:00	QQQ	ETF	346.5	346.83	345.3	345.379	815868.0
2022-01-24 09:00:00	QQQ	ETF	345.32	346.1	343.89	345.71	1315610.0
2022-01-24 09:30:00	QQQ	ETF	345.88	347.66	342.53	343.58	18696503.0
2022-01-24 10:00:00	QQQ	ETF	343.59	345.33	340.71	343.23	14283033.0
2022-01-24 10:30:00	QQQ	ETF	343.25	345.31	339.94	343.47	12196934.0
2022-01-24 11:00:00	QQQ	ETF	343.45	343.46	340.77	341.87	8509142.0
2022-01-24 11:30:00	QQQ	ETF	341.89	342.18	336.87	339.67	10533354.0
2022-01-24 12:00:00	QQQ	ETF	339.66	339.67	334.15	336.1989	11469795.0
2022-01-24 12:30:00	QQQ	ETF	336.18	340.46	335.2	339.41	10755845.0

> showing 50 of 30,882 rows — these rows as CSV

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