PREVIEW / etf_30min / 2022-05-23

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-05-23.parquet
  size:    678 KB
  rows:    27,037

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-05-23 04:00:00	SPY	ETF	394.1	394.59	391.53	392.3	70644.0
2022-05-23 04:30:00	SPY	ETF	392.21	392.21	391.0	391.83	32287.0
2022-05-23 05:00:00	SPY	ETF	391.5	392.35	391.28	392.35	13164.0
2022-05-23 05:30:00	SPY	ETF	392.33	393.01	391.73	392.05	15398.0
2022-05-23 06:00:00	SPY	ETF	392.05	392.63	391.99	392.63	11150.0
2022-05-23 06:30:00	SPY	ETF	392.61	394.55	392.61	394.4	87171.0
2022-05-23 07:00:00	SPY	ETF	394.4	394.54	393.38	393.63	125392.0
2022-05-23 07:30:00	SPY	ETF	393.65	393.67	392.85	393.38	113367.0
2022-05-23 08:00:00	SPY	ETF	393.46	395.0	391.23	393.5	328295.0
2022-05-23 08:30:00	SPY	ETF	393.55	393.55	392.77	393.06	212812.0
2022-05-23 09:00:00	SPY	ETF	393.1	393.89	392.72	392.73	292880.0
2022-05-23 09:30:00	SPY	ETF	392.83	394.44	391.1	392.1863	7860914.0
2022-05-23 10:00:00	SPY	ETF	392.23	394.04	390.38	394.0	5857409.0
2022-05-23 10:30:00	SPY	ETF	394.03	395.01	392.72	393.88	4926343.0
2022-05-23 11:00:00	SPY	ETF	393.9	396.13	393.5	395.91	4145122.0
2022-05-23 11:30:00	SPY	ETF	395.94	397.02	395.745	396.44	3711173.0
2022-05-23 12:00:00	SPY	ETF	396.45	397.61	396.18	396.53	3035809.0
2022-05-23 12:30:00	SPY	ETF	396.52	396.94	395.26	395.9474	3291837.0
2022-05-23 13:00:00	SPY	ETF	395.97	396.03	394.02	395.12	2986833.0
2022-05-23 13:30:00	SPY	ETF	395.12	396.83	394.73	396.72	2613622.0
2022-05-23 14:00:00	SPY	ETF	396.74	397.33	396.17	396.84	2888134.0
2022-05-23 14:30:00	SPY	ETF	396.86	397.73	396.09	396.23	3239509.0
2022-05-23 15:00:00	SPY	ETF	396.23	397.25	395.59	396.1139	3431703.0
2022-05-23 15:30:00	SPY	ETF	396.11	397.06	394.93	396.93	9114040.0
2022-05-23 16:00:00	SPY	ETF	396.95	397.9	396.92	397.3	3289923.0
2022-05-23 16:30:00	SPY	ETF	397.3	397.63	397.28	397.54	162818.0
2022-05-23 17:00:00	SPY	ETF	397.56	397.67	395.04	395.45	346321.0
2022-05-23 17:30:00	SPY	ETF	395.45	395.45	394.58	394.84	302013.0
2022-05-23 18:00:00	SPY	ETF	394.8	394.83	392.62	393.55	410043.0
2022-05-23 18:30:00	SPY	ETF	393.47	394.27	393.37	394.17	79783.0
2022-05-23 19:00:00	SPY	ETF	394.27	394.52	393.69	393.82	86503.0
2022-05-23 19:30:00	SPY	ETF	393.83	394.66	393.76	394.5	99934.0
2022-05-23 04:00:00	QQQ	ETF	291.86	292.66	289.76	290.58	71909.0
2022-05-23 04:30:00	QQQ	ETF	290.57	290.57	289.4	290.03	68888.0
2022-05-23 05:00:00	QQQ	ETF	289.84	290.6	289.65	290.5	22641.0
2022-05-23 05:30:00	QQQ	ETF	290.57	291.08	289.77	289.98	68995.0
2022-05-23 06:00:00	QQQ	ETF	290.03	290.51	289.87	290.44	25875.0
2022-05-23 06:30:00	QQQ	ETF	290.41	291.85	290.41	291.8	67919.0
2022-05-23 07:00:00	QQQ	ETF	291.72	291.85	290.68	291.15	264287.0
2022-05-23 07:30:00	QQQ	ETF	291.05	291.12	290.21	290.63	217619.0
2022-05-23 08:00:00	QQQ	ETF	291.49	293.34	288.896	290.64	312675.0
2022-05-23 08:30:00	QQQ	ETF	290.6	290.6	289.8	290.0	207368.0
2022-05-23 09:00:00	QQQ	ETF	290.08	290.779	289.7	289.73	351963.0
2022-05-23 09:30:00	QQQ	ETF	289.75	292.005	288.1306	289.0	8850449.0
2022-05-23 10:00:00	QQQ	ETF	289.03	290.08	287.29	290.0399	5922737.0
2022-05-23 10:30:00	QQQ	ETF	290.04	291.13	288.63	289.58	4508279.0
2022-05-23 11:00:00	QQQ	ETF	289.61	291.73	289.22	291.4393	3358165.0
2022-05-23 11:30:00	QQQ	ETF	291.44	292.93	291.29	292.3	2638402.0
2022-05-23 12:00:00	QQQ	ETF	292.3104	293.84	292.02	292.91	2125416.0
2022-05-23 12:30:00	QQQ	ETF	292.9	293.18	291.6984	292.165	2209820.0

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

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