PREVIEW / etf_30min / 2022-01-31

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-01-31.parquet
  size:    694 KB
  rows:    27,023

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-01-31 04:00:00	SPY	ETF	442.0	443.08	442.0	442.63	40555.0
2022-01-31 04:30:00	SPY	ETF	442.58	442.97	441.71	442.03	31428.0
2022-01-31 05:00:00	SPY	ETF	442.33	442.33	441.52	442.03	13320.0
2022-01-31 05:30:00	SPY	ETF	441.53	441.8	441.14	441.35	36255.0
2022-01-31 06:00:00	SPY	ETF	441.34	441.7	440.62	440.66	26693.0
2022-01-31 06:30:00	SPY	ETF	441.0	441.25	440.66	440.93	33999.0
2022-01-31 07:00:00	SPY	ETF	440.99	441.23	439.15	439.72	271469.0
2022-01-31 07:30:00	SPY	ETF	439.7	440.59	439.57	440.57	214536.0
2022-01-31 08:00:00	SPY	ETF	440.59	443.0	439.3	440.15	243154.0
2022-01-31 08:30:00	SPY	ETF	440.28	441.28	440.17	440.96	302191.0
2022-01-31 09:00:00	SPY	ETF	440.94	441.34	440.45	441.27	386728.0
2022-01-31 09:30:00	SPY	ETF	441.24	443.36	439.81	443.33	10956185.0
2022-01-31 10:00:00	SPY	ETF	443.33	445.79	443.28	444.37	9048773.0
2022-01-31 10:30:00	SPY	ETF	444.37	445.4	443.86	445.18	5486323.0
2022-01-31 11:00:00	SPY	ETF	445.17	445.51	443.93	444.175	4716687.0
2022-01-31 11:30:00	SPY	ETF	444.17	446.8	443.89	446.71	5387591.0
2022-01-31 12:00:00	SPY	ETF	446.71	446.97	445.66	446.32	4031902.0
2022-01-31 12:30:00	SPY	ETF	446.33	447.53	445.86	447.32	3465466.0
2022-01-31 13:00:00	SPY	ETF	447.32	447.62	446.63	446.895	4553179.0
2022-01-31 13:30:00	SPY	ETF	446.91	447.59	446.53	447.38	3500101.0
2022-01-31 14:00:00	SPY	ETF	447.38	448.36	447.19	448.34	4440081.0
2022-01-31 14:30:00	SPY	ETF	448.35	448.38	447.79	448.08	3881465.0
2022-01-31 15:00:00	SPY	ETF	448.08	448.28	445.69	447.22	8425551.0
2022-01-31 15:30:00	SPY	ETF	447.21	450.28	446.72	449.79	21717586.0
2022-01-31 16:00:00	SPY	ETF	449.785	450.1741	448.54	448.76	7713092.0
2022-01-31 16:30:00	SPY	ETF	448.8	448.97	448.49	448.58	161319.0
2022-01-31 17:00:00	SPY	ETF	448.49	448.76	448.49	448.75	33538.0
2022-01-31 17:30:00	SPY	ETF	448.75	448.96	448.75	448.83	64877.0
2022-01-31 18:00:00	SPY	ETF	448.83	449.2	448.66	448.71	107519.0
2022-01-31 18:30:00	SPY	ETF	449.91	449.91	448.44	448.79	534659.0
2022-01-31 19:00:00	SPY	ETF	448.84	448.95	448.68	448.9	23204.0
2022-01-31 19:30:00	SPY	ETF	448.87	449.12	448.7301	448.96	31344.0
2022-01-31 04:00:00	QQQ	ETF	352.0	354.57	352.0	354.3	62200.0
2022-01-31 04:30:00	QQQ	ETF	354.36	354.6	353.81	354.03	22210.0
2022-01-31 05:00:00	QQQ	ETF	354.03	354.09	353.14	353.49	51277.0
2022-01-31 05:30:00	QQQ	ETF	353.56	353.69	352.97	353.55	54653.0
2022-01-31 06:00:00	QQQ	ETF	353.4	353.69	352.79	352.95	70706.0
2022-01-31 06:30:00	QQQ	ETF	353.03	353.42	352.92	353.21	31128.0
2022-01-31 07:00:00	QQQ	ETF	353.24	353.37	351.08	351.65	191796.0
2022-01-31 07:30:00	QQQ	ETF	351.65	352.35	351.5	352.34	186659.0
2022-01-31 08:00:00	QQQ	ETF	352.39	354.5596	351.1201	351.93	356054.0
2022-01-31 08:30:00	QQQ	ETF	351.99	353.12	351.8	352.87	374540.0
2022-01-31 09:00:00	QQQ	ETF	352.9	353.25	352.34	353.2	322184.0
2022-01-31 09:30:00	QQQ	ETF	353.25	356.83	351.52	356.74	8473371.0
2022-01-31 10:00:00	QQQ	ETF	356.75	358.98	356.65	357.45	7033891.0
2022-01-31 10:30:00	QQQ	ETF	357.48	358.8901	357.12	358.75	4601282.0
2022-01-31 11:00:00	QQQ	ETF	358.74	359.4	357.48	357.74	4150198.0
2022-01-31 11:30:00	QQQ	ETF	357.75	360.36	357.55	360.17	3627341.0
2022-01-31 12:00:00	QQQ	ETF	360.17	360.28	358.65	359.25	3939406.0
2022-01-31 12:30:00	QQQ	ETF	359.26	360.46	358.92	360.26	2651420.0

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

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