PREVIEW / etf_30min / 2021-09-08

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-09-08.parquet
  size:    615 KB
  rows:    23,287

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-09-08 04:00:00	SPY	ETF	450.5	450.5	449.39	449.86	30480.0
2021-09-08 04:30:00	SPY	ETF	449.72	450.4	449.59	450.19	9775.0
2021-09-08 05:00:00	SPY	ETF	450.17	450.53	450.15	450.51	5500.0
2021-09-08 05:30:00	SPY	ETF	450.49	451.12	450.49	451.08	4294.0
2021-09-08 06:00:00	SPY	ETF	451.09	451.15	450.99	451.05	9388.0
2021-09-08 06:30:00	SPY	ETF	451.16	451.5	451.09	451.4	43445.0
2021-09-08 07:00:00	SPY	ETF	451.24	451.78	451.18	451.44	53088.0
2021-09-08 07:30:00	SPY	ETF	451.45	451.57	451.34	451.35	28843.0
2021-09-08 08:00:00	SPY	ETF	451.1004	451.798	449.8	450.95	103570.0
2021-09-08 08:30:00	SPY	ETF	450.97	451.38	450.82	451.28	138902.0
2021-09-08 09:00:00	SPY	ETF	451.34	451.35	450.8	450.89	173884.0
2021-09-08 09:30:00	SPY	ETF	450.89	451.43	450.35	451.26	5745159.0
2021-09-08 10:00:00	SPY	ETF	451.27	451.67	450.7	450.8	3777057.0
2021-09-08 10:30:00	SPY	ETF	450.81	450.832	448.86	449.43	6616534.0
2021-09-08 11:00:00	SPY	ETF	449.43	450.39	449.37	450.03	3666459.0
2021-09-08 11:30:00	SPY	ETF	450.02	450.23	449.15	449.375	2762595.0
2021-09-08 12:00:00	SPY	ETF	449.375	450.86	449.15	450.73	3093004.0
2021-09-08 12:30:00	SPY	ETF	450.73	450.7656	450.19	450.26	1485477.0
2021-09-08 13:00:00	SPY	ETF	450.27	450.62	450.06	450.56	1564829.0
2021-09-08 13:30:00	SPY	ETF	450.55	450.76	450.2925	450.33	1414877.0
2021-09-08 14:00:00	SPY	ETF	450.33	451.05	450.3	450.72	2531044.0
2021-09-08 14:30:00	SPY	ETF	450.71	450.81	450.48	450.76	1548910.0
2021-09-08 15:00:00	SPY	ETF	450.78	451.13	450.6624	450.72	1850219.0
2021-09-08 15:30:00	SPY	ETF	450.72	450.98	450.39	450.95	5578486.0
2021-09-08 16:00:00	SPY	ETF	450.96	450.96	450.4935	450.83	1557907.0
2021-09-08 16:30:00	SPY	ETF	450.82	450.91	450.73	450.8	72193.0
2021-09-08 17:00:00	SPY	ETF	450.76	450.92	450.65	450.74	42968.0
2021-09-08 17:30:00	SPY	ETF	450.71	450.75	450.71	450.71	770.0
2021-09-08 18:00:00	SPY	ETF	450.74	450.76	450.61	450.64	35811.0
2021-09-08 18:30:00	SPY	ETF	450.91	450.91	450.45	450.46	9072.0
2021-09-08 19:00:00	SPY	ETF	450.45	450.53	450.4	450.46	13025.0
2021-09-08 19:30:00	SPY	ETF	450.41	450.54	450.29	450.41	22659.0
2021-09-08 04:00:00	QQQ	ETF	381.55	381.55	380.65	381.02	15438.0
2021-09-08 04:30:00	QQQ	ETF	381.05	381.33	380.92	381.18	16371.0
2021-09-08 05:00:00	QQQ	ETF	381.23	381.54	381.22	381.48	19001.0
2021-09-08 05:30:00	QQQ	ETF	381.46	381.91	381.46	381.85	17123.0
2021-09-08 06:00:00	QQQ	ETF	381.86	381.95	381.79	381.84	14835.0
2021-09-08 06:30:00	QQQ	ETF	382.0	382.0	381.79	381.84	39365.0
2021-09-08 07:00:00	QQQ	ETF	381.77	382.22	381.77	381.97	103959.0
2021-09-08 07:30:00	QQQ	ETF	381.97	382.1	381.91	382.03	30953.0
2021-09-08 08:00:00	QQQ	ETF	381.83	382.23	380.54	381.74	93313.0
2021-09-08 08:30:00	QQQ	ETF	381.75	382.07	381.73	382.02	54625.0
2021-09-08 09:00:00	QQQ	ETF	382.04	382.04	381.83	381.91	75122.0
2021-09-08 09:30:00	QQQ	ETF	381.93	381.93	380.62	381.1601	4106474.0
2021-09-08 10:00:00	QQQ	ETF	381.17	381.74	380.82	381.0	2195762.0
2021-09-08 10:30:00	QQQ	ETF	381.01	381.12	378.72	379.1	4253644.0
2021-09-08 11:00:00	QQQ	ETF	379.08	380.085	379.06	379.89	1970585.0
2021-09-08 11:30:00	QQQ	ETF	379.89	380.01	378.5503	378.89	1551558.0
2021-09-08 12:00:00	QQQ	ETF	378.89	380.42	378.45	380.29	2258420.0
2021-09-08 12:30:00	QQQ	ETF	380.29	380.35	379.71	379.72	1186176.0

> showing 50 of 23,287 rows — these rows as CSV

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