PREVIEW / etf_30min / 2021-10-05

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-10-05.parquet
  size:    622 KB
  rows:    23,980

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-10-05 04:00:00	SPY	ETF	428.43	429.61	428.25	429.53	16652.0
2021-10-05 04:30:00	SPY	ETF	429.53	429.91	429.42	429.88	25424.0
2021-10-05 05:00:00	SPY	ETF	429.87	430.47	429.8	430.27	51423.0
2021-10-05 05:30:00	SPY	ETF	430.21	430.52	430.08	430.52	15914.0
2021-10-05 06:00:00	SPY	ETF	430.53	430.53	430.15	430.19	8600.0
2021-10-05 06:30:00	SPY	ETF	430.18	430.31	429.84	430.14	19043.0
2021-10-05 07:00:00	SPY	ETF	430.14	430.72	430.05	430.7	71779.0
2021-10-05 07:30:00	SPY	ETF	430.69	430.97	430.47	430.6	214945.0
2021-10-05 08:00:00	SPY	ETF	430.1396	430.98	428.64	430.39	177746.0
2021-10-05 08:30:00	SPY	ETF	430.39	430.7	430.32	430.7	162690.0
2021-10-05 09:00:00	SPY	ETF	430.71	430.77	430.07	430.27	315251.0
2021-10-05 09:30:00	SPY	ETF	430.24	431.739	429.39	431.27	9593837.0
2021-10-05 10:00:00	SPY	ETF	431.25	433.79	431.17	433.74	7705793.0
2021-10-05 10:30:00	SPY	ETF	433.74	434.51	433.16	434.4759	6557187.0
2021-10-05 11:00:00	SPY	ETF	434.47	435.18	434.21	434.65	4649563.0
2021-10-05 11:30:00	SPY	ETF	434.64	434.95	433.78	434.535	3999568.0
2021-10-05 12:00:00	SPY	ETF	434.54	435.17	433.97	434.225	3551610.0
2021-10-05 12:30:00	SPY	ETF	434.23	434.55	433.85	434.51	2422672.0
2021-10-05 13:00:00	SPY	ETF	434.51	434.72	434.08	434.54	2794908.0
2021-10-05 13:30:00	SPY	ETF	434.53	435.26	434.43	435.0001	2895852.0
2021-10-05 14:00:00	SPY	ETF	435.0	435.37	434.66	435.14	3149897.0
2021-10-05 14:30:00	SPY	ETF	435.14	435.49	434.92	434.965	3514025.0
2021-10-05 15:00:00	SPY	ETF	434.97	435.335	434.35	434.445	4819951.0
2021-10-05 15:30:00	SPY	ETF	434.45	434.85	432.85	433.05	10878954.0
2021-10-05 16:00:00	SPY	ETF	433.06	433.31	432.95	433.04	3201794.0
2021-10-05 16:30:00	SPY	ETF	433.07	433.2	432.66	433.11	426526.0
2021-10-05 17:00:00	SPY	ETF	433.18	433.18	433.01	433.09	43533.0
2021-10-05 17:30:00	SPY	ETF	433.09	433.09	433.0	433.04	24062.0
2021-10-05 18:00:00	SPY	ETF	433.01	433.44	433.0	433.39	71028.0
2021-10-05 18:30:00	SPY	ETF	433.1	433.36	433.1	433.29	42593.0
2021-10-05 19:00:00	SPY	ETF	433.32	433.32	432.44	432.5	101426.0
2021-10-05 19:30:00	SPY	ETF	432.42	432.66	432.29	432.4	70510.0
2021-10-05 04:00:00	QQQ	ETF	352.82	353.89	352.78	353.79	74459.0
2021-10-05 04:30:00	QQQ	ETF	353.97	354.26	353.76	354.23	21777.0
2021-10-05 05:00:00	QQQ	ETF	354.26	354.7	354.26	354.51	71269.0
2021-10-05 05:30:00	QQQ	ETF	354.53	354.7	354.21	354.5	17408.0
2021-10-05 06:00:00	QQQ	ETF	354.6	354.6	353.95	353.95	60637.0
2021-10-05 06:30:00	QQQ	ETF	353.98	354.14	353.61	353.92	89276.0
2021-10-05 07:00:00	QQQ	ETF	353.9	354.17	353.45	354.11	105488.0
2021-10-05 07:30:00	QQQ	ETF	354.12	354.53	353.96	354.07	156934.0
2021-10-05 08:00:00	QQQ	ETF	353.89	354.5004	352.7	353.93	160488.0
2021-10-05 08:30:00	QQQ	ETF	353.939	354.01	353.7	354.0	143678.0
2021-10-05 09:00:00	QQQ	ETF	354.0	354.06	353.44	353.68	235578.0
2021-10-05 09:30:00	QQQ	ETF	353.71	355.91	353.48	355.52	6215928.0
2021-10-05 10:00:00	QQQ	ETF	355.51	356.86	355.39	356.71	4248360.0
2021-10-05 10:30:00	QQQ	ETF	356.72	357.89	356.23	357.8699	3533706.0
2021-10-05 11:00:00	QQQ	ETF	357.85	358.669	357.67	358.12	3130743.0
2021-10-05 11:30:00	QQQ	ETF	358.12	358.595	357.505	358.37	2710183.0
2021-10-05 12:00:00	QQQ	ETF	358.39	359.17	358.07	358.73	2216547.0
2021-10-05 12:30:00	QQQ	ETF	358.74	359.0699	358.4299	358.93	1555397.0

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

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