PREVIEW / etf_30min / 2021-03-31

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-03-31.parquet
  size:    615 KB
  rows:    23,358

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-03-31 04:00:00	SPY	ETF	394.22	394.34	394.04	394.04	4800.0
2021-03-31 04:30:00	SPY	ETF	393.99	394.4	393.93	394.4	5200.0
2021-03-31 05:00:00	SPY	ETF	394.27	394.3	394.23	394.23	2400.0
2021-03-31 05:30:00	SPY	ETF	394.2	394.5	394.18	394.35	6710.0
2021-03-31 06:00:00	SPY	ETF	394.4	394.61	394.35	394.48	25178.0
2021-03-31 06:30:00	SPY	ETF	394.46	394.83	394.46	394.75	12048.0
2021-03-31 07:00:00	SPY	ETF	394.73	394.83	394.49	394.71	42642.0
2021-03-31 07:30:00	SPY	ETF	394.71	395.05	394.68	394.95	48546.0
2021-03-31 08:00:00	SPY	ETF	394.5096	395.18	393.96	395.01	82281.0
2021-03-31 08:30:00	SPY	ETF	395.05	395.33	395.05	395.09	136052.0
2021-03-31 09:00:00	SPY	ETF	395.11	395.34	395.02	395.34	75883.0
2021-03-31 09:30:00	SPY	ETF	395.33	396.38	395.31	396.15	5807821.0
2021-03-31 10:00:00	SPY	ETF	396.13	396.56	395.99	396.08	3995721.0
2021-03-31 10:30:00	SPY	ETF	396.07	396.98	395.97	396.82	3480015.0
2021-03-31 11:00:00	SPY	ETF	396.81	397.0	396.53	396.58	2774478.0
2021-03-31 11:30:00	SPY	ETF	396.57	397.26	396.5	397.13	2698899.0
2021-03-31 12:00:00	SPY	ETF	397.13	397.5	397.125	397.34	2851849.0
2021-03-31 12:30:00	SPY	ETF	397.34	397.66	397.33	397.61	1853831.0
2021-03-31 13:00:00	SPY	ETF	397.615	398.0	397.59	397.82	2643051.0
2021-03-31 13:30:00	SPY	ETF	397.82	398.0	397.5	397.71	2817552.0
2021-03-31 14:00:00	SPY	ETF	397.71	397.7419	397.09	397.4293	4238158.0
2021-03-31 14:30:00	SPY	ETF	397.43	397.72	397.14	397.2501	5023244.0
2021-03-31 15:00:00	SPY	ETF	397.24	397.77	397.2	397.23	5600461.0
2021-03-31 15:30:00	SPY	ETF	397.24	397.565	396.02	396.25	24448326.0
2021-03-31 16:00:00	SPY	ETF	396.26	397.5002	395.8795	395.98	10119707.0
2021-03-31 16:30:00	SPY	ETF	396.03	396.33	395.93	396.22	538278.0
2021-03-31 17:00:00	SPY	ETF	396.3	396.3	396.06	396.13	58432.0
2021-03-31 17:30:00	SPY	ETF	396.12	396.24	396.12	396.2	29661.0
2021-03-31 18:00:00	SPY	ETF	396.24	396.55	396.24	396.42	42741.0
2021-03-31 18:30:00	SPY	ETF	396.33	396.5	396.33	396.42	21656.0
2021-03-31 19:00:00	SPY	ETF	396.43	396.51	396.2	396.51	20664.0
2021-03-31 19:30:00	SPY	ETF	396.51	396.66	396.46	396.64	25351.0
2021-03-31 04:00:00	QQQ	ETF	314.44	314.7	314.29	314.32	27474.0
2021-03-31 04:30:00	QQQ	ETF	314.33	314.67	314.17	314.6	46681.0
2021-03-31 05:00:00	QQQ	ETF	314.64	314.68	314.35	314.43	30830.0
2021-03-31 05:30:00	QQQ	ETF	314.45	315.22	314.37	315.15	16767.0
2021-03-31 06:00:00	QQQ	ETF	315.13	315.71	315.12	315.57	12850.0
2021-03-31 06:30:00	QQQ	ETF	315.65	316.22	315.6	315.98	55875.0
2021-03-31 07:00:00	QQQ	ETF	315.94	315.94	315.611	315.65	96375.0
2021-03-31 07:30:00	QQQ	ETF	315.71	315.97	315.71	315.81	32422.0
2021-03-31 08:00:00	QQQ	ETF	315.91	316.39	313.79	316.06	94203.0
2021-03-31 08:30:00	QQQ	ETF	316.11	316.47	316.04	316.05	86384.0
2021-03-31 09:00:00	QQQ	ETF	316.02	316.28	315.94	316.18	222729.0
2021-03-31 09:30:00	QQQ	ETF	316.18	318.29	315.81	318.2	5787469.0
2021-03-31 10:00:00	QQQ	ETF	318.19	319.4	318.19	318.74	3930335.0
2021-03-31 10:30:00	QQQ	ETF	318.74	320.0	318.74	319.5	3459714.0
2021-03-31 11:00:00	QQQ	ETF	319.49	319.84	319.16	319.37	2699896.0
2021-03-31 11:30:00	QQQ	ETF	319.36	319.9	319.12	319.88	2058666.0
2021-03-31 12:00:00	QQQ	ETF	319.89	320.28	319.865	320.105	1471032.0
2021-03-31 12:30:00	QQQ	ETF	320.1	320.49	319.98	320.1	1260790.0

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

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