PREVIEW / etf_30min / 2023-02-16

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-02-16.parquet
  size:    703 KB
  rows:    27,734

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
2023-02-16 04:00:00	SPY	ETF	414.25	414.81	414.05	414.51	14346.0
2023-02-16 04:30:00	SPY	ETF	414.43	414.45	414.04	414.12	11513.0
2023-02-16 05:00:00	SPY	ETF	414.0	414.17	413.93	414.17	17881.0
2023-02-16 05:30:00	SPY	ETF	414.25	414.27	413.87	413.91	9043.0
2023-02-16 06:00:00	SPY	ETF	413.85	414.03	413.72	413.77	13404.0
2023-02-16 06:30:00	SPY	ETF	413.75	413.97	413.67	413.97	16167.0
2023-02-16 07:00:00	SPY	ETF	413.92	414.05	413.0	413.05	116640.0
2023-02-16 07:30:00	SPY	ETF	413.04	413.26	413.03	413.05	34518.0
2023-02-16 08:00:00	SPY	ETF	413.3487	414.79	412.2	412.3	242015.0
2023-02-16 08:30:00	SPY	ETF	412.3	412.3	409.17	409.77	1275505.0
2023-02-16 09:00:00	SPY	ETF	409.76	409.79	408.54	408.79	752578.0
2023-02-16 09:30:00	SPY	ETF	408.79	409.75	408.26	408.86	7383865.0
2023-02-16 10:00:00	SPY	ETF	408.83	410.64	408.4	410.53	5688832.0
2023-02-16 10:30:00	SPY	ETF	410.51	411.67	410.4	411.34	5073783.0
2023-02-16 11:00:00	SPY	ETF	411.36	411.88	410.77	411.3801	3671411.0
2023-02-16 11:30:00	SPY	ETF	411.4	412.05	410.98	411.42	2614018.0
2023-02-16 12:00:00	SPY	ETF	411.415	412.15	410.85	411.91	2702110.0
2023-02-16 12:30:00	SPY	ETF	411.92	412.89	411.75	412.14	3455730.0
2023-02-16 13:00:00	SPY	ETF	412.17	412.6625	411.3991	411.46	2214244.0
2023-02-16 13:30:00	SPY	ETF	411.48	412.42	411.305	412.15	1990141.0
2023-02-16 14:00:00	SPY	ETF	412.14	412.72	411.84	412.5	2152439.0
2023-02-16 14:30:00	SPY	ETF	412.5097	412.91	412.15	412.18	1925001.0
2023-02-16 15:00:00	SPY	ETF	412.19	412.32	409.27	409.3	6948484.0
2023-02-16 15:30:00	SPY	ETF	409.31	409.54	408.14	408.33	13181354.0
2023-02-16 16:00:00	SPY	ETF	408.33	409.0	407.85	407.93	3611908.0
2023-02-16 16:30:00	SPY	ETF	407.92	408.28	407.91	407.96	188647.0
2023-02-16 17:00:00	SPY	ETF	407.95	408.04	407.93	408.0	48243.0
2023-02-16 17:30:00	SPY	ETF	407.98	408.0247	407.95	407.95	18729.0
2023-02-16 18:00:00	SPY	ETF	407.94	407.94	407.0	407.43	123983.0
2023-02-16 18:30:00	SPY	ETF	407.39	407.41	407.07	407.22	47281.0
2023-02-16 19:00:00	SPY	ETF	407.16	407.46	407.07	407.11	14222.0
2023-02-16 19:30:00	SPY	ETF	407.13	407.4	407.1	407.3	64743.0
2023-02-16 04:00:00	QQQ	ETF	309.69	309.97	309.47	309.85	35516.0
2023-02-16 04:30:00	QQQ	ETF	309.77	309.81	309.3	309.3	34853.0
2023-02-16 05:00:00	QQQ	ETF	309.32	309.51	309.11	309.29	10732.0
2023-02-16 05:30:00	QQQ	ETF	309.36	309.44	309.23	309.26	5338.0
2023-02-16 06:00:00	QQQ	ETF	309.22	309.42	309.11	309.14	10840.0
2023-02-16 06:30:00	QQQ	ETF	309.13	309.24	309.0	309.16	18125.0
2023-02-16 07:00:00	QQQ	ETF	309.21	309.289	308.1	308.15	150723.0
2023-02-16 07:30:00	QQQ	ETF	308.24	308.48	308.22	308.3	81128.0
2023-02-16 08:00:00	QQQ	ETF	309.24	310.41	307.55	307.8	351223.0
2023-02-16 08:30:00	QQQ	ETF	307.76	307.76	304.58	305.2	1201434.0
2023-02-16 09:00:00	QQQ	ETF	305.15	305.2	304.14	304.4	556116.0
2023-02-16 09:30:00	QQQ	ETF	304.38	306.0	303.71	305.33	7455167.0
2023-02-16 10:00:00	QQQ	ETF	305.32	306.72	304.6402	306.55	3772500.0
2023-02-16 10:30:00	QQQ	ETF	306.53	307.88	306.47	307.35	2831166.0
2023-02-16 11:00:00	QQQ	ETF	307.39	307.94	306.645	307.2099	2394607.0
2023-02-16 11:30:00	QQQ	ETF	307.22	307.81	306.86	307.18	1946190.0
2023-02-16 12:00:00	QQQ	ETF	307.15	307.56	306.3	307.42	1996033.0
2023-02-16 12:30:00	QQQ	ETF	307.448	308.43	307.23	307.4309	2155657.0

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

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