PREVIEW / etf_30min / 2021-07-06

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-07-06.parquet
  size:    617 KB
  rows:    24,190

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
2021-07-06 04:00:00	SPY	ETF	433.38	433.52	433.2	433.42	1433.0
2021-07-06 04:30:00	SPY	ETF	433.32	433.41	433.3	433.41	1900.0
2021-07-06 05:00:00	SPY	ETF	433.45	433.55	433.41	433.55	20594.0
2021-07-06 05:30:00	SPY	ETF	433.4	433.45	433.29	433.43	3100.0
2021-07-06 06:00:00	SPY	ETF	433.55	433.62	433.43	433.43	12878.0
2021-07-06 06:30:00	SPY	ETF	433.45	433.67	433.36	433.38	23603.0
2021-07-06 07:00:00	SPY	ETF	433.43	433.75	433.37	433.75	27176.0
2021-07-06 07:30:00	SPY	ETF	433.74	433.74	433.38	433.49	44289.0
2021-07-06 08:00:00	SPY	ETF	433.59	433.6996	433.34	433.5	64329.0
2021-07-06 08:30:00	SPY	ETF	433.5	433.7	433.5	433.65	53064.0
2021-07-06 09:00:00	SPY	ETF	433.65	433.79	433.42	433.76	150323.0
2021-07-06 09:30:00	SPY	ETF	433.78	434.01	432.86	432.97	3972319.0
2021-07-06 10:00:00	SPY	ETF	432.97	433.05	431.87	432.27	3648933.0
2021-07-06 10:30:00	SPY	ETF	432.26	432.26	431.0	431.01	3819124.0
2021-07-06 11:00:00	SPY	ETF	431.02	431.26	430.45	431.14	4655186.0
2021-07-06 11:30:00	SPY	ETF	431.16	431.48	431.01	431.16	2687316.0
2021-07-06 12:00:00	SPY	ETF	431.14	431.145	430.01	430.53	4430483.0
2021-07-06 12:30:00	SPY	ETF	430.52	431.035	430.1	431.03	2950454.0
2021-07-06 13:00:00	SPY	ETF	431.03	433.39	430.58	431.37	3154979.0
2021-07-06 13:30:00	SPY	ETF	431.37	431.81	431.27	431.74	2617964.0
2021-07-06 14:00:00	SPY	ETF	431.745	432.205	431.67	432.2	2400586.0
2021-07-06 14:30:00	SPY	ETF	432.2	432.45	431.86	432.11	2985850.0
2021-07-06 15:00:00	SPY	ETF	432.11	432.865	432.065	432.8019	3313365.0
2021-07-06 15:30:00	SPY	ETF	432.81	433.45	432.49	432.9	8738501.0
2021-07-06 16:00:00	SPY	ETF	432.91	432.96	432.37	432.46	2495121.0
2021-07-06 16:30:00	SPY	ETF	432.43	432.93	432.2	432.32	634980.0
2021-07-06 17:00:00	SPY	ETF	432.28	432.42	432.18	432.18	91081.0
2021-07-06 17:30:00	SPY	ETF	432.15	432.23	432.08	432.21	43973.0
2021-07-06 18:00:00	SPY	ETF	432.22	432.48	432.2	432.47	56399.0
2021-07-06 18:30:00	SPY	ETF	432.47	432.48	432.39	432.39	23824.0
2021-07-06 19:00:00	SPY	ETF	432.36	432.45	432.33	432.34	21259.0
2021-07-06 19:30:00	SPY	ETF	432.34	432.34	432.06	432.18	47371.0
2021-07-06 04:00:00	QQQ	ETF	358.26	358.43	358.07	358.36	6938.0
2021-07-06 04:30:00	QQQ	ETF	358.23	358.35	358.22	358.25	4606.0
2021-07-06 05:00:00	QQQ	ETF	358.25	358.57	358.25	358.48	6267.0
2021-07-06 05:30:00	QQQ	ETF	358.34	358.54	358.26	358.54	7031.0
2021-07-06 06:00:00	QQQ	ETF	358.51	358.63	358.49	358.52	15377.0
2021-07-06 06:30:00	QQQ	ETF	358.62	359.06	358.46	358.75	23473.0
2021-07-06 07:00:00	QQQ	ETF	358.72	359.32	358.7	359.27	57960.0
2021-07-06 07:30:00	QQQ	ETF	359.27	359.33	358.93	359.09	55085.0
2021-07-06 08:00:00	QQQ	ETF	359.33	359.33	357.83	359.14	121457.0
2021-07-06 08:30:00	QQQ	ETF	359.19	359.41	359.12	359.17	65619.0
2021-07-06 09:00:00	QQQ	ETF	359.17	359.46	359.1	359.26	80064.0
2021-07-06 09:30:00	QQQ	ETF	359.27	360.08	359.23	359.61	2922489.0
2021-07-06 10:00:00	QQQ	ETF	359.64	360.48	359.58	359.93	1827257.0
2021-07-06 10:30:00	QQQ	ETF	359.93	360.06	358.66	359.06	2207973.0
2021-07-06 11:00:00	QQQ	ETF	359.07	359.64	358.65	359.24	2413481.0
2021-07-06 11:30:00	QQQ	ETF	359.26	359.4	358.34	358.8	1861321.0
2021-07-06 12:00:00	QQQ	ETF	358.785	358.785	356.49	357.4	3329661.0
2021-07-06 12:30:00	QQQ	ETF	357.38	358.37	356.92	358.33	2435891.0

> showing 50 of 24,190 rows — these rows as CSV

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