PREVIEW / etf_30min / 2021-08-26

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-08-26.parquet
  size:    598 KB
  rows:    22,496

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-26 04:00:00	SPY	ETF	448.16	448.71	448.16	448.59	4495.0
2021-08-26 04:30:00	SPY	ETF	448.56	448.63	448.51	448.51	6961.0
2021-08-26 05:00:00	SPY	ETF	448.36	448.36	448.23	448.36	4207.0
2021-08-26 05:30:00	SPY	ETF	448.21	448.51	448.21	448.51	5477.0
2021-08-26 06:00:00	SPY	ETF	448.63	448.63	448.44	448.49	2905.0
2021-08-26 06:30:00	SPY	ETF	448.51	448.7	448.51	448.61	2112.0
2021-08-26 07:00:00	SPY	ETF	448.6	448.91	448.53	448.82	42726.0
2021-08-26 07:30:00	SPY	ETF	448.8	448.88	448.7	448.83	34932.0
2021-08-26 08:00:00	SPY	ETF	448.6104	448.94	448.5596	448.93	45022.0
2021-08-26 08:30:00	SPY	ETF	448.92	448.92	448.15	448.46	246401.0
2021-08-26 09:00:00	SPY	ETF	448.47	448.66	448.4	448.61	179462.0
2021-08-26 09:30:00	SPY	ETF	448.61	448.86	448.19	448.2	4150481.0
2021-08-26 10:00:00	SPY	ETF	448.18	448.61	446.61	447.56	4611797.0
2021-08-26 10:30:00	SPY	ETF	447.55	447.91	446.49	446.92	6389928.0
2021-08-26 11:00:00	SPY	ETF	446.91	447.91	446.18	447.49	4920764.0
2021-08-26 11:30:00	SPY	ETF	447.5	447.79	447.081	447.5015	2448298.0
2021-08-26 12:00:00	SPY	ETF	447.5	448.09	447.495	447.945	1557436.0
2021-08-26 12:30:00	SPY	ETF	447.95	448.07	447.52	447.72	1632827.0
2021-08-26 13:00:00	SPY	ETF	447.71	447.91	447.16	447.4	1718695.0
2021-08-26 13:30:00	SPY	ETF	447.4	447.79	447.3521	447.49	1416255.0
2021-08-26 14:00:00	SPY	ETF	447.49	447.495	446.81	447.06	2921871.0
2021-08-26 14:30:00	SPY	ETF	447.06	447.24	446.66	446.74	2624410.0
2021-08-26 15:00:00	SPY	ETF	446.72	446.94	446.16	446.58	4281976.0
2021-08-26 15:30:00	SPY	ETF	446.58	446.97	446.24	446.27	8237834.0
2021-08-26 16:00:00	SPY	ETF	446.28	446.65	446.26	446.65	1602146.0
2021-08-26 16:30:00	SPY	ETF	446.64	446.73	446.62	446.64	352015.0
2021-08-26 17:00:00	SPY	ETF	446.6	446.69	446.52	446.59	16008.0
2021-08-26 17:30:00	SPY	ETF	446.63	446.76	446.6	446.67	17405.0
2021-08-26 18:00:00	SPY	ETF	446.69	446.85	446.6	446.73	95829.0
2021-08-26 18:30:00	SPY	ETF	446.26	446.75	446.26	446.66	59450.0
2021-08-26 19:00:00	SPY	ETF	446.62	446.62	446.49	446.57	21991.0
2021-08-26 19:30:00	SPY	ETF	446.52	446.52	446.15	446.32	53862.0
2021-08-26 04:00:00	QQQ	ETF	374.54	374.54	373.9	373.95	13414.0
2021-08-26 04:30:00	QQQ	ETF	373.92	373.98	373.81	373.81	3430.0
2021-08-26 05:00:00	QQQ	ETF	373.71	373.72	373.5	373.6	13550.0
2021-08-26 05:30:00	QQQ	ETF	373.62	373.74	373.62	373.71	3999.0
2021-08-26 06:00:00	QQQ	ETF	373.75	373.88	373.74	373.8	13100.0
2021-08-26 06:30:00	QQQ	ETF	373.87	374.05	373.75	373.92	11138.0
2021-08-26 07:00:00	QQQ	ETF	373.95	374.34	373.91	374.29	14533.0
2021-08-26 07:30:00	QQQ	ETF	374.23	374.23	374.0	374.0	21113.0
2021-08-26 08:00:00	QQQ	ETF	373.99	375.081	373.18	374.18	56859.0
2021-08-26 08:30:00	QQQ	ETF	374.14	374.2	373.47	373.76	210104.0
2021-08-26 09:00:00	QQQ	ETF	373.79	373.96	373.64	373.89	70768.0
2021-08-26 09:30:00	QQQ	ETF	373.92	374.57	373.905	373.93	2848201.0
2021-08-26 10:00:00	QQQ	ETF	373.9	374.62	372.29	372.945	3210945.0
2021-08-26 10:30:00	QQQ	ETF	372.95	373.54	372.33	372.95	2877085.0
2021-08-26 11:00:00	QQQ	ETF	372.96	373.78	371.97	373.47	2805407.0
2021-08-26 11:30:00	QQQ	ETF	373.49	373.66	372.89	373.5201	1537508.0
2021-08-26 12:00:00	QQQ	ETF	373.52	374.28	373.51	374.07	1061820.0
2021-08-26 12:30:00	QQQ	ETF	374.08	374.15	373.64	373.85	753062.0

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

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