PREVIEW / etf_30min / 2021-07-20

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-07-20.parquet
  size:    619 KB
  rows:    23,572

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-20 04:00:00	SPY	ETF	426.74	427.22	426.54	427.22	69793.0
2021-07-20 04:30:00	SPY	ETF	427.37	427.37	426.68	426.86	10209.0
2021-07-20 05:00:00	SPY	ETF	426.92	427.06	426.54	426.79	6900.0
2021-07-20 05:30:00	SPY	ETF	426.78	426.88	425.91	426.14	10047.0
2021-07-20 06:00:00	SPY	ETF	425.96	427.03	425.96	426.81	26686.0
2021-07-20 06:30:00	SPY	ETF	426.9	426.95	426.22	426.77	20154.0
2021-07-20 07:00:00	SPY	ETF	426.7	426.9	426.25	426.83	137174.0
2021-07-20 07:30:00	SPY	ETF	426.83	427.15	426.67	426.95	202301.0
2021-07-20 08:00:00	SPY	ETF	426.3801	427.2	425.4	426.68	629785.0
2021-07-20 08:30:00	SPY	ETF	426.64	426.77	425.97	426.15	511330.0
2021-07-20 09:00:00	SPY	ETF	426.14	426.33	425.26	425.61	455783.0
2021-07-20 09:30:00	SPY	ETF	425.68	428.39	424.83	428.24	10227096.0
2021-07-20 10:00:00	SPY	ETF	428.25	429.47	427.95	429.02	7293574.0
2021-07-20 10:30:00	SPY	ETF	429.02	430.27	428.81	430.23	5156233.0
2021-07-20 11:00:00	SPY	ETF	430.22	430.56	429.91	429.92	4140457.0
2021-07-20 11:30:00	SPY	ETF	429.92	431.16	429.84	431.11	3707164.0
2021-07-20 12:00:00	SPY	ETF	431.12	431.44	430.85	431.22	3979441.0
2021-07-20 12:30:00	SPY	ETF	431.22	432.02	431.22	431.99	3133130.0
2021-07-20 13:00:00	SPY	ETF	432.0	432.08	430.84	430.96	4029932.0
2021-07-20 13:30:00	SPY	ETF	430.96	431.3	430.74	431.075	2468809.0
2021-07-20 14:00:00	SPY	ETF	431.0719	431.83	431.0719	431.7901	3784758.0
2021-07-20 14:30:00	SPY	ETF	431.79	431.92	431.39	431.5389	3683830.0
2021-07-20 15:00:00	SPY	ETF	431.54	432.42	431.53	432.07	5220651.0
2021-07-20 15:30:00	SPY	ETF	432.08	432.1499	431.03	431.03	15205191.0
2021-07-20 16:00:00	SPY	ETF	431.03	431.7105	430.95	431.48	3409833.0
2021-07-20 16:30:00	SPY	ETF	431.47	431.53	431.06	431.5	422201.0
2021-07-20 17:00:00	SPY	ETF	431.31	431.5	431.3	431.32	53490.0
2021-07-20 17:30:00	SPY	ETF	431.34	431.45	431.06	431.45	54282.0
2021-07-20 18:00:00	SPY	ETF	431.39	431.81	431.34	431.65	45467.0
2021-07-20 18:30:00	SPY	ETF	431.06	431.77	431.06	431.77	19219.0
2021-07-20 19:00:00	SPY	ETF	431.74	432.15	431.7	432.15	39241.0
2021-07-20 19:30:00	SPY	ETF	432.09	432.09	431.89	432.0	27548.0
2021-07-20 04:00:00	QQQ	ETF	355.92	356.28	355.76	356.28	117936.0
2021-07-20 04:30:00	QQQ	ETF	356.31	356.4	355.97	356.18	16911.0
2021-07-20 05:00:00	QQQ	ETF	356.28	356.28	355.94	356.13	15359.0
2021-07-20 05:30:00	QQQ	ETF	356.13	356.24	355.47	355.71	27718.0
2021-07-20 06:00:00	QQQ	ETF	355.72	356.25	355.6	356.08	16094.0
2021-07-20 06:30:00	QQQ	ETF	356.18	356.36	355.77	356.33	60887.0
2021-07-20 07:00:00	QQQ	ETF	356.33	356.49	355.89	356.09	122172.0
2021-07-20 07:30:00	QQQ	ETF	356.04	356.2	355.63	356.05	133290.0
2021-07-20 08:00:00	QQQ	ETF	356.05	356.93	355.6	356.0	148322.0
2021-07-20 08:30:00	QQQ	ETF	355.93	356.04	355.65	355.92	125121.0
2021-07-20 09:00:00	QQQ	ETF	355.84	356.01	355.13	355.59	309723.0
2021-07-20 09:30:00	QQQ	ETF	355.65	355.87	353.8	355.5009	5142082.0
2021-07-20 10:00:00	QQQ	ETF	355.51	356.23	354.54	355.64	2993161.0
2021-07-20 10:30:00	QQQ	ETF	355.65	357.32	355.3906	357.13	2421526.0
2021-07-20 11:00:00	QQQ	ETF	357.1	357.745	356.81	357.35	1762782.0
2021-07-20 11:30:00	QQQ	ETF	357.35	358.4	357.27	358.35	1384636.0
2021-07-20 12:00:00	QQQ	ETF	358.362	358.85	358.3	358.56	1231170.0
2021-07-20 12:30:00	QQQ	ETF	358.58	359.37	358.58	359.33	1439031.0

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

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