PREVIEW / etf_30min / 2022-09-22

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-09-22.parquet
  size:    671 KB
  rows:    27,394

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-09-22 04:00:00	SPY	ETF	378.23	379.23	377.02	378.99	44865.0
2022-09-22 04:30:00	SPY	ETF	379.18	380.32	379.02	379.29	67645.0
2022-09-22 05:00:00	SPY	ETF	379.23	379.23	378.06	378.2	49483.0
2022-09-22 05:30:00	SPY	ETF	378.43	378.64	377.3	377.88	44976.0
2022-09-22 06:00:00	SPY	ETF	377.75	378.08	377.21	378.05	25324.0
2022-09-22 06:30:00	SPY	ETF	378.06	378.6	377.87	378.4	47112.0
2022-09-22 07:00:00	SPY	ETF	378.31	378.57	376.17	376.21	287755.0
2022-09-22 07:30:00	SPY	ETF	376.21	377.93	376.21	377.79	185935.0
2022-09-22 08:00:00	SPY	ETF	378.48	379.15	375.19	378.0	567983.0
2022-09-22 08:30:00	SPY	ETF	377.7	379.12	377.1	378.39	482084.0
2022-09-22 09:00:00	SPY	ETF	378.34	378.4	376.33	376.54	955884.0
2022-09-22 09:30:00	SPY	ETF	376.58	377.66	374.44	374.93	9020433.0
2022-09-22 10:00:00	SPY	ETF	374.95	376.57	374.29	375.65	5841397.0
2022-09-22 10:30:00	SPY	ETF	375.63	376.19	373.96	374.09	5001199.0
2022-09-22 11:00:00	SPY	ETF	374.09	374.76	373.44	374.29	4159873.0
2022-09-22 11:30:00	SPY	ETF	374.3	375.37	374.0899	374.4484	3205136.0
2022-09-22 12:00:00	SPY	ETF	374.43	375.99	374.15	375.0594	3139093.0
2022-09-22 12:30:00	SPY	ETF	375.06	375.93	374.62	375.2	2798545.0
2022-09-22 13:00:00	SPY	ETF	375.1666	375.4	373.9438	374.95	2276405.0
2022-09-22 13:30:00	SPY	ETF	374.95	375.79	374.66	375.43	2488628.0
2022-09-22 14:00:00	SPY	ETF	375.38	375.63	373.72	374.25	2781806.0
2022-09-22 14:30:00	SPY	ETF	374.26	375.6599	373.98	375.42	2893972.0
2022-09-22 15:00:00	SPY	ETF	375.43	377.07	375.22	376.06	5669653.0
2022-09-22 15:30:00	SPY	ETF	376.07	377.54	374.13	374.23	9939507.0
2022-09-22 16:00:00	SPY	ETF	374.23	374.89	373.87	374.35	4399916.0
2022-09-22 16:30:00	SPY	ETF	374.32	374.62	374.07	374.44	343049.0
2022-09-22 17:00:00	SPY	ETF	374.48	374.58	374.22	374.55	43242.0
2022-09-22 17:30:00	SPY	ETF	374.58	374.84	374.54	374.79	41653.0
2022-09-22 18:00:00	SPY	ETF	374.74	374.94	374.47	374.89	62634.0
2022-09-22 18:30:00	SPY	ETF	374.74	374.9	374.24	374.55	36572.0
2022-09-22 19:00:00	SPY	ETF	374.55	374.82	374.47	374.71	14041.0
2022-09-22 19:30:00	SPY	ETF	374.76	375.03	374.67	374.99	44822.0
2022-09-22 20:00:00	SPY	ETF	375.0	375.0	375.0	375.0	500.0
2022-09-22 04:00:00	QQQ	ETF	283.06	284.79	283.06	284.47	90715.0
2022-09-22 04:30:00	QQQ	ETF	284.65	285.7	284.53	284.77	51224.0
2022-09-22 05:00:00	QQQ	ETF	284.78	284.78	283.73	283.9	41944.0
2022-09-22 05:30:00	QQQ	ETF	283.95	284.17	283.0	283.53	33558.0
2022-09-22 06:00:00	QQQ	ETF	283.28	283.77	282.96	283.75	85258.0
2022-09-22 06:30:00	QQQ	ETF	283.78	284.2	283.52	284.04	39773.0
2022-09-22 07:00:00	QQQ	ETF	283.96	284.23	281.96	281.96	207941.0
2022-09-22 07:30:00	QQQ	ETF	282.02	283.59	282.01	283.36	245235.0
2022-09-22 08:00:00	QQQ	ETF	284.0	285.67	281.53	283.4	441078.0
2022-09-22 08:30:00	QQQ	ETF	283.36	284.6	282.54	283.76	592791.0
2022-09-22 09:00:00	QQQ	ETF	283.769	283.87	281.76	282.0	895738.0
2022-09-22 09:30:00	QQQ	ETF	282.0	282.94	280.3	280.81	8184698.0
2022-09-22 10:00:00	QQQ	ETF	280.81	281.97	280.175	280.99	4785822.0
2022-09-22 10:30:00	QQQ	ETF	280.93	281.56	279.45	279.625	4327620.0
2022-09-22 11:00:00	QQQ	ETF	279.62	280.19	278.815	279.5602	3250542.0
2022-09-22 11:30:00	QQQ	ETF	279.57	280.765	279.43	280.12	2684212.0
2022-09-22 12:00:00	QQQ	ETF	280.11	281.08	279.55	280.36	2022008.0

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

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