PREVIEW / etf_30min / 2021-06-30

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-06-30.parquet
  size:    606 KB
  rows:    23,396

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-06-30 04:00:00	SPY	ETF	428.06	428.06	426.98	427.11	8639.0
2021-06-30 04:30:00	SPY	ETF	426.98	427.08	426.87	426.87	6992.0
2021-06-30 05:00:00	SPY	ETF	426.8	426.8	426.37	426.7	15046.0
2021-06-30 05:30:00	SPY	ETF	426.66	426.99	426.64	426.94	12320.0
2021-06-30 06:00:00	SPY	ETF	426.97	427.29	426.97	427.29	5000.0
2021-06-30 06:30:00	SPY	ETF	427.33	427.33	427.1	427.12	20374.0
2021-06-30 07:00:00	SPY	ETF	427.12	427.8	427.11	427.38	54040.0
2021-06-30 07:30:00	SPY	ETF	427.47	427.56	427.38	427.56	122957.0
2021-06-30 08:00:00	SPY	ETF	427.28	428.35	426.89	427.27	84475.0
2021-06-30 08:30:00	SPY	ETF	427.28	427.38	427.18	427.26	48127.0
2021-06-30 09:00:00	SPY	ETF	427.25	427.26	426.98	427.19	142956.0
2021-06-30 09:30:00	SPY	ETF	427.2	427.959	427.18	427.555	4356660.0
2021-06-30 10:00:00	SPY	ETF	427.55	428.03	427.52	427.92	2554840.0
2021-06-30 10:30:00	SPY	ETF	427.92	428.3175	427.87	428.21	2259167.0
2021-06-30 11:00:00	SPY	ETF	428.215	428.38	427.8	427.95	2370223.0
2021-06-30 11:30:00	SPY	ETF	427.96	428.0925	427.81	427.97	1431044.0
2021-06-30 12:00:00	SPY	ETF	427.97	428.12	427.77	427.81	1875474.0
2021-06-30 12:30:00	SPY	ETF	427.81	428.18	427.72	428.02	2167276.0
2021-06-30 13:00:00	SPY	ETF	428.01	428.1	427.82	427.86	1401804.0
2021-06-30 13:30:00	SPY	ETF	427.87	427.95	427.7819	427.89	834171.0
2021-06-30 14:00:00	SPY	ETF	427.9	427.92	427.58	427.885	2180853.0
2021-06-30 14:30:00	SPY	ETF	427.88	428.05	427.8	427.92	1725183.0
2021-06-30 15:00:00	SPY	ETF	427.93	428.215	427.875	428.155	2239884.0
2021-06-30 15:30:00	SPY	ETF	428.16	428.78	427.96	428.07	11011431.0
2021-06-30 16:00:00	SPY	ETF	428.07	428.72	427.97	428.63	6197195.0
2021-06-30 16:30:00	SPY	ETF	428.68	428.79	428.06	428.7	2140770.0
2021-06-30 17:00:00	SPY	ETF	428.72	428.77	428.06	428.7	66610.0
2021-06-30 17:30:00	SPY	ETF	428.68	428.74	428.63	428.74	27280.0
2021-06-30 18:00:00	SPY	ETF	428.74	428.91	428.74	428.81	56812.0
2021-06-30 18:30:00	SPY	ETF	428.06	428.91	428.06	428.91	11705.0
2021-06-30 19:00:00	SPY	ETF	428.89	428.89	428.81	428.83	4742.0
2021-06-30 19:30:00	SPY	ETF	428.82	428.88	428.7	428.85	31972.0
2021-06-30 04:00:00	QQQ	ETF	355.56	355.56	354.75	354.88	24248.0
2021-06-30 04:30:00	QQQ	ETF	354.89	354.89	354.68	354.68	11017.0
2021-06-30 05:00:00	QQQ	ETF	354.65	354.65	354.23	354.31	26655.0
2021-06-30 05:30:00	QQQ	ETF	354.34	354.42	354.14	354.39	9154.0
2021-06-30 06:00:00	QQQ	ETF	354.47	354.7	354.44	354.6	66428.0
2021-06-30 06:30:00	QQQ	ETF	354.61	354.66	354.38	354.44	15887.0
2021-06-30 07:00:00	QQQ	ETF	354.52	355.21	354.49	354.95	45199.0
2021-06-30 07:30:00	QQQ	ETF	354.95	355.06	354.79	354.91	51400.0
2021-06-30 08:00:00	QQQ	ETF	354.91	355.6	354.4204	354.59	118199.0
2021-06-30 08:30:00	QQQ	ETF	354.65	354.92	354.59	354.79	69196.0
2021-06-30 09:00:00	QQQ	ETF	354.75	354.85	354.66	354.83	85024.0
2021-06-30 09:30:00	QQQ	ETF	354.82	355.1594	353.87	354.232	3895526.0
2021-06-30 10:00:00	QQQ	ETF	354.25	354.77	354.08	354.675	1865657.0
2021-06-30 10:30:00	QQQ	ETF	354.68	355.13	354.39	355.06	1600139.0
2021-06-30 11:00:00	QQQ	ETF	355.07	355.23	354.44	354.56	1178807.0
2021-06-30 11:30:00	QQQ	ETF	354.57	354.81	354.31	354.73	1061071.0
2021-06-30 12:00:00	QQQ	ETF	354.75	354.84	353.89	354.045	1621766.0
2021-06-30 12:30:00	QQQ	ETF	354.04	354.47	353.83	354.345	1452005.0

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

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