PREVIEW / etf_30min / 2022-06-10

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-06-10.parquet
  size:    677 KB
  rows:    27,314

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-06-10 04:00:00	SPY	ETF	400.9	402.35	400.9	402.06	35879.0
2022-06-10 04:30:00	SPY	ETF	402.05	402.18	401.32	401.35	29673.0
2022-06-10 05:00:00	SPY	ETF	401.3	401.9	401.29	401.78	9939.0
2022-06-10 05:30:00	SPY	ETF	401.86	402.08	401.22	401.28	11578.0
2022-06-10 06:00:00	SPY	ETF	401.51	401.57	400.66	400.75	40502.0
2022-06-10 06:30:00	SPY	ETF	400.66	401.01	400.6	400.97	43791.0
2022-06-10 07:00:00	SPY	ETF	401.1	401.43	400.88	401.2	93219.0
2022-06-10 07:30:00	SPY	ETF	401.2	402.05	401.2	401.3	131809.0
2022-06-10 08:00:00	SPY	ETF	401.1	402.3	400.83	401.63	465529.0
2022-06-10 08:30:00	SPY	ETF	401.78	402.0	394.73	394.79	3165400.0
2022-06-10 09:00:00	SPY	ETF	394.79	396.52	393.94	394.95	1224345.0
2022-06-10 09:30:00	SPY	ETF	394.88	395.7777	392.92	393.38	9884130.0
2022-06-10 10:00:00	SPY	ETF	393.39	393.39	390.18	390.3282	8005237.0
2022-06-10 10:30:00	SPY	ETF	390.335	392.46	390.24	390.84	6640792.0
2022-06-10 11:00:00	SPY	ETF	390.85	391.6	390.17	390.42	4114282.0
2022-06-10 11:30:00	SPY	ETF	390.43	391.28	389.87	391.07	4373609.0
2022-06-10 12:00:00	SPY	ETF	391.07	391.89	390.32	390.92	3269629.0
2022-06-10 12:30:00	SPY	ETF	390.94	391.45	390.04	390.56	3518925.0
2022-06-10 13:00:00	SPY	ETF	390.57	391.57	389.93	391.52	4492766.0
2022-06-10 13:30:00	SPY	ETF	391.52	392.81	390.55	391.62	5469871.0
2022-06-10 14:00:00	SPY	ETF	391.63	392.6622	390.87	391.8	4097257.0
2022-06-10 14:30:00	SPY	ETF	391.84	393.45	391.28	393.1	4086636.0
2022-06-10 15:00:00	SPY	ETF	393.1	394.25	391.63	393.39	6469047.0
2022-06-10 15:30:00	SPY	ETF	393.36	393.67	389.75	389.82	19194174.0
2022-06-10 16:00:00	SPY	ETF	389.81	391.14	389.53	390.98	6049880.0
2022-06-10 16:30:00	SPY	ETF	390.95	391.21	390.55	390.55	304267.0
2022-06-10 17:00:00	SPY	ETF	390.73	390.95	389.8	390.55	156855.0
2022-06-10 17:30:00	SPY	ETF	390.56	390.85	390.55	390.85	40812.0
2022-06-10 18:00:00	SPY	ETF	390.85	390.89	390.49	390.65	42274.0
2022-06-10 18:30:00	SPY	ETF	390.65	390.65	390.05	390.05	62911.0
2022-06-10 19:00:00	SPY	ETF	390.11	390.33	390.11	390.28	5017.0
2022-06-10 19:30:00	SPY	ETF	390.27	390.32	390.1	390.29	25425.0
2022-06-10 04:00:00	QQQ	ETF	299.0	300.56	299.0	300.35	53808.0
2022-06-10 04:30:00	QQQ	ETF	300.3	300.48	299.74	299.74	22519.0
2022-06-10 05:00:00	QQQ	ETF	299.7	300.44	299.7	300.32	18920.0
2022-06-10 05:30:00	QQQ	ETF	300.27	300.68	300.02	300.05	10799.0
2022-06-10 06:00:00	QQQ	ETF	300.22	300.22	299.43	299.44	23876.0
2022-06-10 06:30:00	QQQ	ETF	299.4	299.69	299.34	299.56	24678.0
2022-06-10 07:00:00	QQQ	ETF	299.76	300.09	299.45	299.79	109302.0
2022-06-10 07:30:00	QQQ	ETF	299.94	300.49	299.83	299.83	164859.0
2022-06-10 08:00:00	QQQ	ETF	299.8299	300.72	299.39	300.42	450061.0
2022-06-10 08:30:00	QQQ	ETF	300.02	300.02	293.49	293.52	4030552.0
2022-06-10 09:00:00	QQQ	ETF	293.55	294.8617	292.7	293.64	1364631.0
2022-06-10 09:30:00	QQQ	ETF	293.65	294.87	291.24	291.7251	9213451.0
2022-06-10 10:00:00	QQQ	ETF	291.68	291.69	289.095	289.41	7001247.0
2022-06-10 10:30:00	QQQ	ETF	289.4	290.76	289.15	289.19	5423934.0
2022-06-10 11:00:00	QQQ	ETF	289.19	289.78	288.55	288.74	4416738.0
2022-06-10 11:30:00	QQQ	ETF	288.74	289.659	288.384	289.37	3037949.0
2022-06-10 12:00:00	QQQ	ETF	289.38	289.98	288.67	289.22	2794368.0
2022-06-10 12:30:00	QQQ	ETF	289.23	289.989	288.81	289.29	2432659.0

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

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