PREVIEW / etf_30min / 2021-12-30

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-12-30.parquet
  size:    649 KB
  rows:    25,283

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-12-30 04:00:00	SPY	ETF	477.85	478.09	477.7	478.05	19278.0
2021-12-30 04:30:00	SPY	ETF	478.08	478.28	478.06	478.06	2633.0
2021-12-30 05:00:00	SPY	ETF	478.08	478.14	477.85	477.85	5179.0
2021-12-30 05:30:00	SPY	ETF	477.88	478.01	477.7	477.92	15104.0
2021-12-30 06:00:00	SPY	ETF	477.96	478.06	477.89	477.9	6005.0
2021-12-30 06:30:00	SPY	ETF	477.96	478.53	477.96	478.4	15418.0
2021-12-30 07:00:00	SPY	ETF	478.34	478.42	478.22	478.39	35157.0
2021-12-30 07:30:00	SPY	ETF	478.39	478.47	478.14	478.14	42654.0
2021-12-30 08:00:00	SPY	ETF	478.14	478.47	477.53	478.05	245089.0
2021-12-30 08:30:00	SPY	ETF	478.15	478.32	478.08	478.14	66934.0
2021-12-30 09:00:00	SPY	ETF	478.15	478.28	477.9	477.99	102749.0
2021-12-30 09:30:00	SPY	ETF	477.93	478.96	477.69	478.21	3815642.0
2021-12-30 10:00:00	SPY	ETF	478.21	479.0	477.95	478.775	2690396.0
2021-12-30 10:30:00	SPY	ETF	478.76	478.84	478.12	478.155	1672480.0
2021-12-30 11:00:00	SPY	ETF	478.15	478.43	478.02	478.3	1552789.0
2021-12-30 11:30:00	SPY	ETF	478.31	478.41	478.0498	478.24	1588053.0
2021-12-30 12:00:00	SPY	ETF	478.24	478.4	477.79	478.03	1868214.0
2021-12-30 12:30:00	SPY	ETF	478.04	478.34	477.885	478.3275	1224871.0
2021-12-30 13:00:00	SPY	ETF	478.325	478.33	477.91	478.06	1110604.0
2021-12-30 13:30:00	SPY	ETF	478.06	478.365	478.04	478.24	1134671.0
2021-12-30 14:00:00	SPY	ETF	478.24	478.2469	477.75	478.13	1695730.0
2021-12-30 14:30:00	SPY	ETF	478.12	478.31	477.9999	478.15	1296975.0
2021-12-30 15:00:00	SPY	ETF	478.15	478.15	477.54	477.56	1842984.0
2021-12-30 15:30:00	SPY	ETF	477.565	477.73	475.67	476.14	9710962.0
2021-12-30 16:00:00	SPY	ETF	476.14	476.47	475.92	476.24	2331293.0
2021-12-30 16:30:00	SPY	ETF	476.22	476.39	476.1	476.23	96417.0
2021-12-30 17:00:00	SPY	ETF	476.28	476.31	476.1	476.15	3409045.0
2021-12-30 17:30:00	SPY	ETF	476.15	476.2	476.11	476.2	4304.0
2021-12-30 18:00:00	SPY	ETF	476.23	476.53	476.23	476.37	47500.0
2021-12-30 18:30:00	SPY	ETF	476.32	476.32	476.14	476.28	9256.0
2021-12-30 19:00:00	SPY	ETF	476.25	476.32	474.1	474.47	92011.0
2021-12-30 19:30:00	SPY	ETF	474.45	474.64	474.27	474.53	74560.0
2021-12-30 04:00:00	QQQ	ETF	401.82	402.5	401.82	402.48	17354.0
2021-12-30 04:30:00	QQQ	ETF	402.49	402.82	402.49	402.71	5693.0
2021-12-30 05:00:00	QQQ	ETF	402.62	402.62	402.46	402.48	4673.0
2021-12-30 05:30:00	QQQ	ETF	402.45	402.54	402.27	402.49	3950.0
2021-12-30 06:00:00	QQQ	ETF	402.5	402.5	402.15	402.15	2366.0
2021-12-30 06:30:00	QQQ	ETF	402.21	402.75	402.21	402.74	10002.0
2021-12-30 07:00:00	QQQ	ETF	402.66	402.73	402.47	402.65	35603.0
2021-12-30 07:30:00	QQQ	ETF	402.59	402.88	402.449	402.45	31628.0
2021-12-30 08:00:00	QQQ	ETF	402.4899	402.8396	401.1	402.07	119903.0
2021-12-30 08:30:00	QQQ	ETF	402.15	402.3	401.97	402.09	104218.0
2021-12-30 09:00:00	QQQ	ETF	402.1	402.25	401.32	401.32	158608.0
2021-12-30 09:30:00	QQQ	ETF	401.31	402.33	400.69	401.9101	3251704.0
2021-12-30 10:00:00	QQQ	ETF	401.92	403.5699	401.89	403.3399	1835582.0
2021-12-30 10:30:00	QQQ	ETF	403.33	403.45	402.5909	402.62	1101130.0
2021-12-30 11:00:00	QQQ	ETF	402.61	403.19	402.4114	403.04	936636.0
2021-12-30 11:30:00	QQQ	ETF	403.05	403.08	402.5241	403.0	639773.0
2021-12-30 12:00:00	QQQ	ETF	403.0	403.37	402.68	402.97	954294.0
2021-12-30 12:30:00	QQQ	ETF	402.98	403.135	402.74	403.06	693560.0

> showing 50 of 25,283 rows — these rows as CSV

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