PREVIEW / etf_30min / 2021-10-19

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-10-19.parquet
  size:    642 KB
  rows:    24,341

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-10-19 04:00:00	SPY	ETF	448.14	448.8	448.03	448.5	11505.0
2021-10-19 04:30:00	SPY	ETF	448.53	448.58	448.36	448.58	8963.0
2021-10-19 05:00:00	SPY	ETF	448.52	448.73	448.43	448.7	9278.0
2021-10-19 05:30:00	SPY	ETF	448.66	448.96	448.6	448.84	6612.0
2021-10-19 06:00:00	SPY	ETF	448.78	449.2	448.78	449.2	7502.0
2021-10-19 06:30:00	SPY	ETF	449.22	449.64	449.15	449.57	49191.0
2021-10-19 07:00:00	SPY	ETF	449.56	449.95	449.36	449.93	85567.0
2021-10-19 07:30:00	SPY	ETF	449.91	449.91	449.4	449.5	82493.0
2021-10-19 08:00:00	SPY	ETF	449.1604	449.93	447.3	449.15	180131.0
2021-10-19 08:30:00	SPY	ETF	449.12	449.28	448.87	448.89	129917.0
2021-10-19 09:00:00	SPY	ETF	448.89	449.04	448.7	448.93	177327.0
2021-10-19 09:30:00	SPY	ETF	448.92	449.27	448.27	448.63	5569196.0
2021-10-19 10:00:00	SPY	ETF	448.63	449.76	448.57	449.71	3448610.0
2021-10-19 10:30:00	SPY	ETF	449.72	449.95	449.02	449.85	2593774.0
2021-10-19 11:00:00	SPY	ETF	449.85	450.26	449.84	450.07	2383762.0
2021-10-19 11:30:00	SPY	ETF	450.08	450.32	449.83	450.205	2020561.0
2021-10-19 12:00:00	SPY	ETF	450.21	450.38	450.0	450.18	1580435.0
2021-10-19 12:30:00	SPY	ETF	450.18	450.56	450.17	450.53	1345336.0
2021-10-19 13:00:00	SPY	ETF	450.53	450.55	450.18	450.225	1602961.0
2021-10-19 13:30:00	SPY	ETF	450.22	450.45	450.19	450.41	1188385.0
2021-10-19 14:00:00	SPY	ETF	450.4101	450.47	450.03	450.045	1835282.0
2021-10-19 14:30:00	SPY	ETF	450.05	450.11	449.6	449.999	2368901.0
2021-10-19 15:00:00	SPY	ETF	449.99	450.69	449.89	450.395	2449037.0
2021-10-19 15:30:00	SPY	ETF	450.4	450.7	449.9726	450.68	6967674.0
2021-10-19 16:00:00	SPY	ETF	450.68	451.22	450.4	451.21	2901361.0
2021-10-19 16:30:00	SPY	ETF	451.21	451.21	451.0	451.0	175843.0
2021-10-19 17:00:00	SPY	ETF	450.86	450.99	450.83	450.87	24167.0
2021-10-19 17:30:00	SPY	ETF	450.9	450.94	450.89	450.94	16237.0
2021-10-19 18:00:00	SPY	ETF	450.96	451.05	450.69	450.74	57337.0
2021-10-19 18:30:00	SPY	ETF	450.64	450.86	450.63	450.82	13351.0
2021-10-19 19:00:00	SPY	ETF	450.77	450.94	450.7	450.74	12694.0
2021-10-19 19:30:00	SPY	ETF	450.79	451.17	450.79	451.06	44229.0
2021-10-19 04:00:00	QQQ	ETF	373.27	374.0	373.18	373.69	41387.0
2021-10-19 04:30:00	QQQ	ETF	373.66	373.75	373.54	373.74	24754.0
2021-10-19 05:00:00	QQQ	ETF	373.6	373.82	373.48	373.73	30628.0
2021-10-19 05:30:00	QQQ	ETF	373.73	373.95	373.67	373.78	14704.0
2021-10-19 06:00:00	QQQ	ETF	373.8	374.1	373.7	374.1	25893.0
2021-10-19 06:30:00	QQQ	ETF	374.0	374.25	373.96	374.21	76106.0
2021-10-19 07:00:00	QQQ	ETF	374.2	374.58	374.01	374.57	151407.0
2021-10-19 07:30:00	QQQ	ETF	374.48	374.5	374.21	374.37	64523.0
2021-10-19 08:00:00	QQQ	ETF	374.0599	374.57	372.74	373.96	162883.0
2021-10-19 08:30:00	QQQ	ETF	373.95	374.14	373.66	373.7	162075.0
2021-10-19 09:00:00	QQQ	ETF	373.7	373.83	373.47	373.74	176390.0
2021-10-19 09:30:00	QQQ	ETF	373.74	374.42	373.05	373.56	3998603.0
2021-10-19 10:00:00	QQQ	ETF	373.57	374.5	373.29	374.47	2043859.0
2021-10-19 10:30:00	QQQ	ETF	374.46	374.86	373.7	374.85	1808517.0
2021-10-19 11:00:00	QQQ	ETF	374.85	374.99	374.46	374.77	1141575.0
2021-10-19 11:30:00	QQQ	ETF	374.78	375.11	374.55	375.01	1098432.0
2021-10-19 12:00:00	QQQ	ETF	375.03	375.04	374.82	375.0	806600.0
2021-10-19 12:30:00	QQQ	ETF	375.0212	375.31	374.89	375.27	980575.0

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

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