PREVIEW / etf_30min / 2021-08-25

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-08-25.parquet
  size:    601 KB
  rows:    22,571

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-08-25 04:00:00	SPY	ETF	447.98	448.42	447.84	448.26	5228.0
2021-08-25 04:30:00	SPY	ETF	448.31	448.31	448.13	448.18	300.0
2021-08-25 05:00:00	SPY	ETF	448.12	448.28	448.1	448.17	3100.0
2021-08-25 05:30:00	SPY	ETF	448.16	448.16	448.09	448.14	2745.0
2021-08-25 06:00:00	SPY	ETF	448.15	448.15	448.12	448.14	4286.0
2021-08-25 06:30:00	SPY	ETF	448.09	448.14	448.0	448.14	3659.0
2021-08-25 07:00:00	SPY	ETF	448.12	448.13	447.7	447.75	25374.0
2021-08-25 07:30:00	SPY	ETF	447.72	447.85	447.48	447.85	34925.0
2021-08-25 08:00:00	SPY	ETF	447.84	448.305	447.53	447.8	44564.0
2021-08-25 08:30:00	SPY	ETF	447.76	448.18	447.72	448.17	73055.0
2021-08-25 09:00:00	SPY	ETF	448.17	448.18	448.05	448.17	143091.0
2021-08-25 09:30:00	SPY	ETF	448.17	448.34	447.77	448.3	3194952.0
2021-08-25 10:00:00	SPY	ETF	448.315	448.5	448.12	448.24	1913051.0
2021-08-25 10:30:00	SPY	ETF	448.25	448.54	448.07	448.42	1453314.0
2021-08-25 11:00:00	SPY	ETF	448.42	448.845	448.38	448.845	1515824.0
2021-08-25 11:30:00	SPY	ETF	448.845	449.215	448.72	449.085	1465014.0
2021-08-25 12:00:00	SPY	ETF	449.08	449.33	449.035	449.3	1048904.0
2021-08-25 12:30:00	SPY	ETF	449.29	449.37	449.06	449.2699	920933.0
2021-08-25 13:00:00	SPY	ETF	449.26	449.2721	449.0401	449.06	900196.0
2021-08-25 13:30:00	SPY	ETF	449.0696	449.24	449.03	449.06	1174254.0
2021-08-25 14:00:00	SPY	ETF	449.07	449.295	449.0	449.18	1681386.0
2021-08-25 14:30:00	SPY	ETF	449.17	449.2	448.87	449.109	1592962.0
2021-08-25 15:00:00	SPY	ETF	449.1	449.16	448.78	448.97	2159169.0
2021-08-25 15:30:00	SPY	ETF	448.98	449.457	448.84	448.88	9262256.0
2021-08-25 16:00:00	SPY	ETF	448.88	449.07	448.81	448.92	2298190.0
2021-08-25 16:30:00	SPY	ETF	448.92	449.02	448.91	449.0	412531.0
2021-08-25 17:00:00	SPY	ETF	449.0	449.05	448.85	448.91	258259.0
2021-08-25 17:30:00	SPY	ETF	448.99	449.05	448.99	449.05	3486.0
2021-08-25 18:00:00	SPY	ETF	449.06	449.06	448.9	448.91	26521.0
2021-08-25 18:30:00	SPY	ETF	448.94	448.99	448.91	448.97	20090.0
2021-08-25 19:00:00	SPY	ETF	448.95	448.98	448.91	448.91	10317.0
2021-08-25 19:30:00	SPY	ETF	448.98	449.01	448.88	448.9	22760.0
2021-08-25 04:00:00	QQQ	ETF	374.85	375.12	374.59	374.92	16443.0
2021-08-25 04:30:00	QQQ	ETF	374.96	374.97	374.89	374.93	3435.0
2021-08-25 05:00:00	QQQ	ETF	374.9	374.97	374.76	374.84	8251.0
2021-08-25 05:30:00	QQQ	ETF	374.83	374.83	374.7	374.7	2700.0
2021-08-25 06:00:00	QQQ	ETF	374.75	374.83	374.59	374.62	10348.0
2021-08-25 06:30:00	QQQ	ETF	374.63	374.7	374.41	374.47	22183.0
2021-08-25 07:00:00	QQQ	ETF	374.47	374.47	373.98	374.03	95820.0
2021-08-25 07:30:00	QQQ	ETF	374.05	374.28	373.846	374.25	42019.0
2021-08-25 08:00:00	QQQ	ETF	374.34	374.75	373.85	374.16	88486.0
2021-08-25 08:30:00	QQQ	ETF	374.11	374.68	374.04	374.63	59841.0
2021-08-25 09:00:00	QQQ	ETF	374.62	374.73	374.52	374.62	92324.0
2021-08-25 09:30:00	QQQ	ETF	374.63	375.39	374.51	374.91	2578650.0
2021-08-25 10:00:00	QQQ	ETF	374.93	375.13	374.35	374.505	1781944.0
2021-08-25 10:30:00	QQQ	ETF	374.51	374.65	373.855	374.14	1835298.0
2021-08-25 11:00:00	QQQ	ETF	374.15	374.59	374.1	374.51	809915.0
2021-08-25 11:30:00	QQQ	ETF	374.52	374.65	374.26	374.345	803295.0
2021-08-25 12:00:00	QQQ	ETF	374.35	374.485	373.98	374.48	857953.0
2021-08-25 12:30:00	QQQ	ETF	374.4704	374.77	374.38	374.735	661544.0

> showing 50 of 22,571 rows — these rows as CSV

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