PREVIEW / etf_30min / 2023-08-18

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-08-18.parquet
  size:    703 KB
  rows:    28,117

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-08-18 04:00:00	SPY	ETF	435.87	436.37	435.8	435.83	26480.0
2023-08-18 04:30:00	SPY	ETF	435.9	436.19	435.77	436.19	28186.0
2023-08-18 05:00:00	SPY	ETF	436.15	436.26	435.3	435.3	20353.0
2023-08-18 05:30:00	SPY	ETF	435.3	435.76	435.29	435.65	17082.0
2023-08-18 06:00:00	SPY	ETF	435.63	436.04	435.58	435.69	14675.0
2023-08-18 06:30:00	SPY	ETF	435.74	435.74	435.3	435.42	35706.0
2023-08-18 07:00:00	SPY	ETF	435.45	435.52	434.52	434.57	124426.0
2023-08-18 07:30:00	SPY	ETF	434.585	434.7	433.93	434.22	246726.0
2023-08-18 08:00:00	SPY	ETF	435.2119	436.77	433.58	433.74	598005.0
2023-08-18 08:30:00	SPY	ETF	433.7	433.89	433.36	433.89	509794.0
2023-08-18 09:00:00	SPY	ETF	433.81	434.26	433.35	433.37	560735.0
2023-08-18 09:30:00	SPY	ETF	433.37	435.24	433.01	434.24	8608358.0
2023-08-18 10:00:00	SPY	ETF	434.22	434.63	433.455	433.85	5903982.0
2023-08-18 10:30:00	SPY	ETF	433.88	435.1	433.77	435.05	4566032.0
2023-08-18 11:00:00	SPY	ETF	435.05	436.09	435.04	435.265	4457429.0
2023-08-18 11:30:00	SPY	ETF	435.26	436.52	434.71	436.42	3576965.0
2023-08-18 12:00:00	SPY	ETF	436.42	436.5511	435.685	435.705	2953670.0
2023-08-18 12:30:00	SPY	ETF	435.735	436.53	435.61	435.84	2668280.0
2023-08-18 13:00:00	SPY	ETF	435.85	436.15	434.75	435.55	3192778.0
2023-08-18 13:30:00	SPY	ETF	435.55	436.085	435.16	435.905	2926313.0
2023-08-18 14:00:00	SPY	ETF	435.91	436.29	435.49	435.955	2724079.0
2023-08-18 14:30:00	SPY	ETF	435.94	436.76	435.88	435.93	4024329.0
2023-08-18 15:00:00	SPY	ETF	435.96	436.23	435.36	436.14	3684020.0
2023-08-18 15:30:00	SPY	ETF	436.14	437.57	435.87	436.46	13746974.0
2023-08-18 16:00:00	SPY	ETF	436.46	436.97	434.38	436.25	3273399.0
2023-08-18 16:30:00	SPY	ETF	436.25	436.38	435.96	436.05	210477.0
2023-08-18 17:00:00	SPY	ETF	436.01	436.06	435.97	436.04	39376.0
2023-08-18 17:30:00	SPY	ETF	435.98	436.11	435.97	436.11	47613.0
2023-08-18 18:00:00	SPY	ETF	436.06	436.09	435.9	435.9	24814.0
2023-08-18 18:30:00	SPY	ETF	435.95	436.03	435.9	436.0	15601.0
2023-08-18 19:00:00	SPY	ETF	436.0	436.06	436.0	436.06	6524.0
2023-08-18 19:30:00	SPY	ETF	436.06	436.24	436.03	436.22	45050.0
2023-08-18 04:00:00	QQQ	ETF	358.16	358.41	357.92	357.97	50299.0
2023-08-18 04:30:00	QQQ	ETF	357.95	358.25	357.81	358.25	15235.0
2023-08-18 05:00:00	QQQ	ETF	358.18	358.34	357.5	357.56	21309.0
2023-08-18 05:30:00	QQQ	ETF	357.47	357.79	357.36	357.59	57430.0
2023-08-18 06:00:00	QQQ	ETF	357.7	357.92	357.56	357.65	30301.0
2023-08-18 06:30:00	QQQ	ETF	357.51	357.58	357.04	357.18	49880.0
2023-08-18 07:00:00	QQQ	ETF	357.2	357.32	356.0	356.06	162915.0
2023-08-18 07:30:00	QQQ	ETF	356.09	356.22	355.48	355.92	236719.0
2023-08-18 08:00:00	QQQ	ETF	356.7381	358.848	355.26	355.59	384308.0
2023-08-18 08:30:00	QQQ	ETF	355.4999	355.7	355.2	355.669	454513.0
2023-08-18 09:00:00	QQQ	ETF	355.63	355.95	354.92	355.19	525700.0
2023-08-18 09:30:00	QQQ	ETF	355.26	356.83	355.02	355.48	7032832.0
2023-08-18 10:00:00	QQQ	ETF	355.46	356.26	354.71	355.39	4401793.0
2023-08-18 10:30:00	QQQ	ETF	355.37	356.89	355.33	356.441	3237197.0
2023-08-18 11:00:00	QQQ	ETF	356.44	357.26	356.21	356.21	3359174.0
2023-08-18 11:30:00	QQQ	ETF	356.2	357.93	355.67	357.8	3100392.0
2023-08-18 12:00:00	QQQ	ETF	357.8	358.1499	357.06	357.12	2640023.0
2023-08-18 12:30:00	QQQ	ETF	357.14	358.075	357.01	357.27	1820050.0

> showing 50 of 28,117 rows — these rows as CSV

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