PREVIEW / etf_30min / 2022-10-05

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-10-05.parquet
  size:    668 KB
  rows:    27,378

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-10-05 04:00:00	SPY	ETF	375.32	376.3	374.11	374.11	66002.0
2022-10-05 04:30:00	SPY	ETF	374.36	375.31	374.0	375.0	28285.0
2022-10-05 05:00:00	SPY	ETF	374.98	375.16	374.47	375.0	47539.0
2022-10-05 05:30:00	SPY	ETF	375.04	375.04	373.81	374.1	74042.0
2022-10-05 06:00:00	SPY	ETF	374.11	374.78	374.11	374.7	46119.0
2022-10-05 06:30:00	SPY	ETF	374.85	375.25	374.72	375.25	58910.0
2022-10-05 07:00:00	SPY	ETF	375.3	375.39	374.45	374.89	95356.0
2022-10-05 07:30:00	SPY	ETF	374.88	375.38	374.19	374.56	158034.0
2022-10-05 08:00:00	SPY	ETF	375.24	376.4	373.79	374.16	501203.0
2022-10-05 08:30:00	SPY	ETF	374.16	374.66	373.7	374.03	279594.0
2022-10-05 09:00:00	SPY	ETF	373.99	374.29	373.2	373.37	471674.0
2022-10-05 09:30:00	SPY	ETF	373.39	375.18	373.3	374.309	6691952.0
2022-10-05 10:00:00	SPY	ETF	374.28	374.34	371.43	371.52	7634185.0
2022-10-05 10:30:00	SPY	ETF	371.49	372.285	370.95	371.35	4574158.0
2022-10-05 11:00:00	SPY	ETF	371.34	372.83	371.21	372.57	3569572.0
2022-10-05 11:30:00	SPY	ETF	372.56	373.43	372.25	373.0399	2866683.0
2022-10-05 12:00:00	SPY	ETF	373.05	375.19	372.23	374.475	3761257.0
2022-10-05 12:30:00	SPY	ETF	374.49	376.02	374.17	375.2539	3602426.0
2022-10-05 13:00:00	SPY	ETF	375.27	377.54	375.145	376.64	4606229.0
2022-10-05 13:30:00	SPY	ETF	376.63	377.01	375.78	375.83	3302616.0
2022-10-05 14:00:00	SPY	ETF	375.83	377.24	375.68	377.02	3305913.0
2022-10-05 14:30:00	SPY	ETF	377.02	377.75	376.5	377.68	3047572.0
2022-10-05 15:00:00	SPY	ETF	377.69	379.46	377.69	378.505	5691213.0
2022-10-05 15:30:00	SPY	ETF	378.52	378.86	376.47	377.15	11020951.0
2022-10-05 16:00:00	SPY	ETF	377.15	377.9462	377.0481	377.11	3133037.0
2022-10-05 16:30:00	SPY	ETF	377.16	377.34	376.97	377.04	373221.0
2022-10-05 17:00:00	SPY	ETF	376.94	377.04	376.88	377.0	35593.0
2022-10-05 17:30:00	SPY	ETF	376.96	376.96	376.66	376.92	65799.0
2022-10-05 18:00:00	SPY	ETF	376.92	377.15	376.63	377.0	55317.0
2022-10-05 18:30:00	SPY	ETF	376.97	377.5	376.86	377.4	46348.0
2022-10-05 19:00:00	SPY	ETF	377.5	377.71	377.2	377.53	31833.0
2022-10-05 19:30:00	SPY	ETF	377.55	378.62	377.55	378.59	102888.0
2022-10-05 04:00:00	QQQ	ETF	280.29	280.41	278.96	278.96	103383.0
2022-10-05 04:30:00	QQQ	ETF	279.2	280.07	278.89	279.97	48017.0
2022-10-05 05:00:00	QQQ	ETF	279.81	280.07	279.64	279.9	10011.0
2022-10-05 05:30:00	QQQ	ETF	279.99	280.04	279.08	279.3	38125.0
2022-10-05 06:00:00	QQQ	ETF	279.45	279.85	279.35	279.85	38441.0
2022-10-05 06:30:00	QQQ	ETF	279.93	280.24	279.77	280.23	56323.0
2022-10-05 07:00:00	QQQ	ETF	280.23	280.3	279.6	279.9	69179.0
2022-10-05 07:30:00	QQQ	ETF	279.95	280.29	279.43	279.73	133163.0
2022-10-05 08:00:00	QQQ	ETF	280.19	282.341	278.9	279.29	318808.0
2022-10-05 08:30:00	QQQ	ETF	279.2605	279.61	278.73	278.97	245796.0
2022-10-05 09:00:00	QQQ	ETF	278.93	279.16	278.11	278.28	516189.0
2022-10-05 09:30:00	QQQ	ETF	278.29	279.62	277.84	278.6948	5174104.0
2022-10-05 10:00:00	QQQ	ETF	278.66	278.71	275.92	275.9761	5288067.0
2022-10-05 10:30:00	QQQ	ETF	275.95	276.64	275.42	275.86	3285406.0
2022-10-05 11:00:00	QQQ	ETF	275.85	277.215	275.73	276.99	2493987.0
2022-10-05 11:30:00	QQQ	ETF	277.0	277.755	276.72	277.62	2141440.0
2022-10-05 12:00:00	QQQ	ETF	277.64	279.62	276.9408	279.025	3036181.0
2022-10-05 12:30:00	QQQ	ETF	279.025	280.345	278.68	279.74	2316706.0

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

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