PREVIEW / etf_30min / 2022-12-06

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-12-06.parquet
  size:    689 KB
  rows:    27,470

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-12-06 04:00:00	SPY	ETF	400.65	400.72	400.22	400.57	17973.0
2022-12-06 04:30:00	SPY	ETF	400.28	400.63	399.89	399.89	13833.0
2022-12-06 05:00:00	SPY	ETF	399.93	400.1	399.3	399.36	19370.0
2022-12-06 05:30:00	SPY	ETF	399.18	400.1	399.09	399.93	31236.0
2022-12-06 06:00:00	SPY	ETF	399.79	399.86	399.43	399.51	12382.0
2022-12-06 06:30:00	SPY	ETF	399.66	400.02	399.65	400.01	17278.0
2022-12-06 07:00:00	SPY	ETF	400.01	400.54	399.94	400.43	148743.0
2022-12-06 07:30:00	SPY	ETF	400.44	400.5	399.89	399.89	97355.0
2022-12-06 08:00:00	SPY	ETF	400.3301	400.5	398.95	399.91	448831.0
2022-12-06 08:30:00	SPY	ETF	399.9	400.16	399.02	399.7	202018.0
2022-12-06 09:00:00	SPY	ETF	399.69	400.02	399.35	399.43	276956.0
2022-12-06 09:30:00	SPY	ETF	399.42	399.99	397.157	397.19	5610300.0
2022-12-06 10:00:00	SPY	ETF	397.18	397.49	395.8	395.91	6137890.0
2022-12-06 10:30:00	SPY	ETF	395.92	396.18	394.81	395.44	4468224.0
2022-12-06 11:00:00	SPY	ETF	395.445	395.86	394.6	395.4799	3698671.0
2022-12-06 11:30:00	SPY	ETF	395.465	395.885	394.75	395.07	2672937.0
2022-12-06 12:00:00	SPY	ETF	395.08	395.64	394.02	394.6	2572860.0
2022-12-06 12:30:00	SPY	ETF	394.61	394.77	393.84	394.0617	2189835.0
2022-12-06 13:00:00	SPY	ETF	394.08	394.34	392.815	392.935	3833786.0
2022-12-06 13:30:00	SPY	ETF	392.93	393.82	392.6221	393.3	2891790.0
2022-12-06 14:00:00	SPY	ETF	393.3	393.43	392.14	392.145	2889217.0
2022-12-06 14:30:00	SPY	ETF	392.15	392.834	391.64	392.49	4097550.0
2022-12-06 15:00:00	SPY	ETF	392.51	393.32	391.98	392.12	4722620.0
2022-12-06 15:30:00	SPY	ETF	392.12	394.24	392.08	393.86	10414979.0
2022-12-06 16:00:00	SPY	ETF	393.86	394.23	393.62	393.84	3736163.0
2022-12-06 16:30:00	SPY	ETF	393.8	393.99	393.7	393.98	144834.0
2022-12-06 17:00:00	SPY	ETF	393.99	394.01	393.8	393.92	944300.0
2022-12-06 17:30:00	SPY	ETF	393.84	393.95	393.8	393.86	56143.0
2022-12-06 18:00:00	SPY	ETF	393.89	394.15	393.89	394.11	89856.0
2022-12-06 18:30:00	SPY	ETF	394.11	394.4	394.06	394.25	31445.0
2022-12-06 19:00:00	SPY	ETF	394.25	394.52	394.25	394.38	22434.0
2022-12-06 19:30:00	SPY	ETF	394.34	394.45	394.06	394.08	40973.0
2022-12-06 04:00:00	QQQ	ETF	288.31	288.39	287.98	288.34	12694.0
2022-12-06 04:30:00	QQQ	ETF	288.36	288.4	287.82	287.86	18485.0
2022-12-06 05:00:00	QQQ	ETF	287.9	287.99	287.39	287.4	23973.0
2022-12-06 05:30:00	QQQ	ETF	287.27	288.03	287.26	287.92	17373.0
2022-12-06 06:00:00	QQQ	ETF	287.97	287.97	287.65	287.77	6267.0
2022-12-06 06:30:00	QQQ	ETF	288.01	288.25	287.98	288.17	7614.0
2022-12-06 07:00:00	QQQ	ETF	288.21	288.58	288.17	288.47	113853.0
2022-12-06 07:30:00	QQQ	ETF	288.53	288.55	288.0	288.0	53117.0
2022-12-06 08:00:00	QQQ	ETF	288.23	288.58	287.22	288.11	160989.0
2022-12-06 08:30:00	QQQ	ETF	288.05	288.3	287.42	288.01	147496.0
2022-12-06 09:00:00	QQQ	ETF	288.02	288.21	287.42	287.45	171917.0
2022-12-06 09:30:00	QQQ	ETF	287.48	287.62	284.19	284.21	5107849.0
2022-12-06 10:00:00	QQQ	ETF	284.19	284.44	282.9101	283.38	4287177.0
2022-12-06 10:30:00	QQQ	ETF	283.39	283.73	282.4	282.93	3145737.0
2022-12-06 11:00:00	QQQ	ETF	282.92	283.62	282.455	283.44	2554788.0
2022-12-06 11:30:00	QQQ	ETF	283.45	283.74	282.82	283.06	2280966.0
2022-12-06 12:00:00	QQQ	ETF	283.08	283.48	282.055	282.6366	2333109.0
2022-12-06 12:30:00	QQQ	ETF	282.63	282.93	282.18	282.3201	1769865.0

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

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