PREVIEW / etf_30min / 2021-09-16

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-09-16.parquet
  size:    609 KB
  rows:    22,975

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-16 04:00:00	SPY	ETF	447.97	448.03	447.7	447.83	45049.0
2021-09-16 04:30:00	SPY	ETF	447.85	447.92	447.62	447.64	21300.0
2021-09-16 05:00:00	SPY	ETF	447.63	447.68	447.58	447.59	7700.0
2021-09-16 05:30:00	SPY	ETF	447.48	447.49	447.11	447.2	25640.0
2021-09-16 06:00:00	SPY	ETF	447.25	447.38	447.22	447.22	52897.0
2021-09-16 06:30:00	SPY	ETF	447.25	447.37	447.12	447.37	126794.0
2021-09-16 07:00:00	SPY	ETF	447.38	447.6	447.27	447.3	85060.0
2021-09-16 07:30:00	SPY	ETF	447.37	447.37	446.88	446.95	105112.0
2021-09-16 08:00:00	SPY	ETF	447.37	448.215	446.35	446.67	541373.0
2021-09-16 08:30:00	SPY	ETF	446.74	447.7	446.6	447.52	353225.0
2021-09-16 09:00:00	SPY	ETF	447.61	447.68	447.22	447.37	340546.0
2021-09-16 09:30:00	SPY	ETF	447.32	448.27	445.82	446.14	6890146.0
2021-09-16 10:00:00	SPY	ETF	446.13	446.135	444.55	445.295	6652004.0
2021-09-16 10:30:00	SPY	ETF	445.27	445.7	444.02	444.58	4245490.0
2021-09-16 11:00:00	SPY	ETF	444.58	445.16	444.37	444.9301	3769811.0
2021-09-16 11:30:00	SPY	ETF	444.93	445.32	444.62	445.3	2228516.0
2021-09-16 12:00:00	SPY	ETF	445.305	445.94	445.005	445.67	2229107.0
2021-09-16 12:30:00	SPY	ETF	445.67	446.4571	445.66	445.99	1840349.0
2021-09-16 13:00:00	SPY	ETF	445.98	446.2	445.585	445.9884	1787687.0
2021-09-16 13:30:00	SPY	ETF	445.99	446.76	445.42	446.745	2605634.0
2021-09-16 14:00:00	SPY	ETF	446.75	447.24	446.48	446.85	3103117.0
2021-09-16 14:30:00	SPY	ETF	446.86	447.55	446.79	447.46	2356423.0
2021-09-16 15:00:00	SPY	ETF	447.46	448.36	447.37	447.435	4783847.0
2021-09-16 15:30:00	SPY	ETF	447.43	447.81	446.99	447.15	8951286.0
2021-09-16 16:00:00	SPY	ETF	447.15	447.21	446.76	446.84	1527925.0
2021-09-16 16:30:00	SPY	ETF	446.84	447.17	446.69	446.75	541491.0
2021-09-16 17:00:00	SPY	ETF	446.74	446.85	446.63	446.74	33609.0
2021-09-16 17:30:00	SPY	ETF	446.71	446.76	446.66	446.73	9585.0
2021-09-16 18:00:00	SPY	ETF	446.73	446.83	446.64	446.8	86911.0
2021-09-16 18:30:00	SPY	ETF	447.17	447.17	446.77	446.78	13060.0
2021-09-16 19:00:00	SPY	ETF	446.79	446.81	446.75	446.81	3928.0
2021-09-16 19:30:00	SPY	ETF	446.79	446.79	446.3	446.51	60384.0
2021-09-16 04:00:00	QQQ	ETF	378.15	378.15	377.52	377.6	91776.0
2021-09-16 04:30:00	QQQ	ETF	377.63	377.73	377.37	377.43	11123.0
2021-09-16 05:00:00	QQQ	ETF	377.44	377.5	377.31	377.37	9640.0
2021-09-16 05:30:00	QQQ	ETF	377.28	377.33	376.94	377.04	12367.0
2021-09-16 06:00:00	QQQ	ETF	377.02	377.29	377.02	377.17	5225.0
2021-09-16 06:30:00	QQQ	ETF	377.18	377.3	377.08	377.28	10794.0
2021-09-16 07:00:00	QQQ	ETF	377.28	377.47	377.12	377.2	26424.0
2021-09-16 07:30:00	QQQ	ETF	377.21	377.21	376.84	376.9	39362.0
2021-09-16 08:00:00	QQQ	ETF	377.2901	378.333	376.48	376.6301	114800.0
2021-09-16 08:30:00	QQQ	ETF	376.66	377.14	376.45	377.07	113087.0
2021-09-16 09:00:00	QQQ	ETF	377.15	378.05	376.67	376.74	339705.0
2021-09-16 09:30:00	QQQ	ETF	376.71	377.45	375.37	375.94	3493212.0
2021-09-16 10:00:00	QQQ	ETF	375.89	376.0599	374.81	375.67	2827290.0
2021-09-16 10:30:00	QQQ	ETF	375.65	375.98	374.87	375.37	1842202.0
2021-09-16 11:00:00	QQQ	ETF	375.37	375.75	374.695	375.22	1648465.0
2021-09-16 11:30:00	QQQ	ETF	375.19	375.8025	374.96	375.79	1097335.0
2021-09-16 12:00:00	QQQ	ETF	375.79	376.4	375.68	376.02	1077204.0
2021-09-16 12:30:00	QQQ	ETF	376.04	376.63	376.02	376.4525	993959.0

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

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