PREVIEW / etf_30min / 2022-12-01

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-12-01.parquet
  size:    695 KB
  rows:    28,141

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-01 04:00:00	SPY	ETF	407.46	407.8	406.74	407.03	59347.0
2022-12-01 04:30:00	SPY	ETF	407.01	407.1	406.58	407.07	26931.0
2022-12-01 05:00:00	SPY	ETF	407.1	407.26	406.97	407.11	16071.0
2022-12-01 05:30:00	SPY	ETF	407.17	407.4	406.88	406.91	24841.0
2022-12-01 06:00:00	SPY	ETF	406.91	407.31	406.8	407.13	69881.0
2022-12-01 06:30:00	SPY	ETF	407.15	407.36	406.98	407.25	41693.0
2022-12-01 07:00:00	SPY	ETF	407.3	407.48	407.14	407.35	91212.0
2022-12-01 07:30:00	SPY	ETF	407.35	407.91	407.35	407.91	268537.0
2022-12-01 08:00:00	SPY	ETF	407.94	408.6	406.85	408.33	513046.0
2022-12-01 08:30:00	SPY	ETF	408.25	409.74	407.29	408.78	923789.0
2022-12-01 09:00:00	SPY	ETF	408.71	409.27	408.5	408.8	476397.0
2022-12-01 09:30:00	SPY	ETF	408.8	409.72	408.16	409.0928	7324849.0
2022-12-01 10:00:00	SPY	ETF	409.14	410.0	405.07	405.27	8034956.0
2022-12-01 10:30:00	SPY	ETF	405.28	407.65	404.75	407.59	5396869.0
2022-12-01 11:00:00	SPY	ETF	407.59	407.645	405.9	406.42	3358034.0
2022-12-01 11:30:00	SPY	ETF	406.42	407.44	406.28	406.83	2539013.0
2022-12-01 12:00:00	SPY	ETF	406.84	407.08	405.52	406.9767	2515851.0
2022-12-01 12:30:00	SPY	ETF	406.98	407.65	406.64	407.31	2297806.0
2022-12-01 13:00:00	SPY	ETF	407.31	408.04	406.41	406.655	2637425.0
2022-12-01 13:30:00	SPY	ETF	406.64	407.4999	406.27	407.1115	1827560.0
2022-12-01 14:00:00	SPY	ETF	407.1049	407.6	406.38	407.33	2334451.0
2022-12-01 14:30:00	SPY	ETF	407.32	408.16	407.08	407.938	2687239.0
2022-12-01 15:00:00	SPY	ETF	407.95	408.32	407.06	407.36	3422958.0
2022-12-01 15:30:00	SPY	ETF	407.37	408.47	407.29	407.38	8696053.0
2022-12-01 16:00:00	SPY	ETF	407.37	407.4	406.84	407.12	2192998.0
2022-12-01 16:30:00	SPY	ETF	407.05	407.23	406.91	407.08	138060.0
2022-12-01 17:00:00	SPY	ETF	407.09	407.23	406.89	407.11	194377.0
2022-12-01 17:30:00	SPY	ETF	407.19	407.23	407.09	407.15	54193.0
2022-12-01 18:00:00	SPY	ETF	407.13	407.25	406.95	407.07	83126.0
2022-12-01 18:30:00	SPY	ETF	407.0	407.25	407.0	407.01	29681.0
2022-12-01 19:00:00	SPY	ETF	407.01	407.01	406.08	406.2	80918.0
2022-12-01 19:30:00	SPY	ETF	406.2	406.36	406.12	406.15	74798.0
2022-12-01 04:00:00	QQQ	ETF	293.02	293.33	292.32	292.6	311580.0
2022-12-01 04:30:00	QQQ	ETF	292.64	292.65	292.19	292.65	47009.0
2022-12-01 05:00:00	QQQ	ETF	292.7	292.92	292.62	292.78	21649.0
2022-12-01 05:30:00	QQQ	ETF	292.82	292.89	292.4	292.43	8808.0
2022-12-01 06:00:00	QQQ	ETF	292.39	292.75	292.31	292.45	28165.0
2022-12-01 06:30:00	QQQ	ETF	292.7	293.0	292.55	292.87	56775.0
2022-12-01 07:00:00	QQQ	ETF	292.89	293.2	292.83	292.97	185524.0
2022-12-01 07:30:00	QQQ	ETF	292.989	293.56	292.989	293.51	181441.0
2022-12-01 08:00:00	QQQ	ETF	293.11	294.09	292.4104	294.019	366219.0
2022-12-01 08:30:00	QQQ	ETF	293.98	295.54	293.0	294.14	1346103.0
2022-12-01 09:00:00	QQQ	ETF	294.2	294.45	293.64	293.67	675500.0
2022-12-01 09:30:00	QQQ	ETF	293.67	295.56	293.0698	294.94	6670018.0
2022-12-01 10:00:00	QQQ	ETF	294.96	295.75	291.18	291.37	7161890.0
2022-12-01 10:30:00	QQQ	ETF	291.36	294.06	290.88	294.02	3849138.0
2022-12-01 11:00:00	QQQ	ETF	294.05	294.11	292.39	292.84	2349027.0
2022-12-01 11:30:00	QQQ	ETF	292.83	293.64	292.5	293.02	2156335.0
2022-12-01 12:00:00	QQQ	ETF	293.02	293.27	291.88	293.1389	1938946.0
2022-12-01 12:30:00	QQQ	ETF	293.146	293.71	292.93	293.41	1429475.0

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

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