PREVIEW / etf_30min / 2022-05-16

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-05-16.parquet
  size:    670 KB
  rows:    26,523

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
2022-05-16 04:00:00	SPY	ETF	399.98	401.6	399.34	400.3	32969.0
2022-05-16 04:30:00	SPY	ETF	400.2	401.13	399.98	401.13	11887.0
2022-05-16 05:00:00	SPY	ETF	401.08	401.21	400.28	400.28	46453.0
2022-05-16 05:30:00	SPY	ETF	400.24	400.35	399.7	399.72	7065.0
2022-05-16 06:00:00	SPY	ETF	399.8	400.5	399.8	400.4	22414.0
2022-05-16 06:30:00	SPY	ETF	400.09	400.57	400.07	400.23	32203.0
2022-05-16 07:00:00	SPY	ETF	400.19	400.73	400.16	400.25	82636.0
2022-05-16 07:30:00	SPY	ETF	400.28	400.75	400.0	400.52	90763.0
2022-05-16 08:00:00	SPY	ETF	400.25	401.56	398.41	401.52	243919.0
2022-05-16 08:30:00	SPY	ETF	401.5	402.25	400.64	400.78	320417.0
2022-05-16 09:00:00	SPY	ETF	400.81	401.72	399.5501	399.97	629622.0
2022-05-16 09:30:00	SPY	ETF	399.98	401.29	397.6	398.7241	7879667.0
2022-05-16 10:00:00	SPY	ETF	398.7026	401.79	397.65	401.59	4965326.0
2022-05-16 10:30:00	SPY	ETF	401.59	401.75	398.36	398.52	3715855.0
2022-05-16 11:00:00	SPY	ETF	398.54	399.82	397.98	399.0952	3745872.0
2022-05-16 11:30:00	SPY	ETF	399.101	401.71	398.32	401.43	3630207.0
2022-05-16 12:00:00	SPY	ETF	401.45	402.079	399.89	400.3523	2351328.0
2022-05-16 12:30:00	SPY	ETF	400.36	401.1	399.43	399.85	2466533.0
2022-05-16 13:00:00	SPY	ETF	399.79	402.3099	399.34	402.17	2629312.0
2022-05-16 13:30:00	SPY	ETF	402.17	402.81	401.63	402.0	2768908.0
2022-05-16 14:00:00	SPY	ETF	402.03	403.63	401.49	403.5532	3391146.0
2022-05-16 14:30:00	SPY	ETF	403.56	403.97	402.32	402.9999	4003816.0
2022-05-16 15:00:00	SPY	ETF	403.0	403.37	400.625	401.01	3528986.0
2022-05-16 15:30:00	SPY	ETF	401.0	401.33	399.32	400.23	10105044.0
2022-05-16 16:00:00	SPY	ETF	400.23	400.4	399.0	399.65	2933638.0
2022-05-16 16:30:00	SPY	ETF	399.7	400.09	399.57	399.6	233818.0
2022-05-16 17:00:00	SPY	ETF	399.55	399.72	399.51	399.67	50509.0
2022-05-16 17:30:00	SPY	ETF	399.56	399.56	399.4	399.56	14273.0
2022-05-16 18:00:00	SPY	ETF	399.56	400.14	399.56	400.09	86316.0
2022-05-16 18:30:00	SPY	ETF	400.07	400.26	400.07	400.17	42823.0
2022-05-16 19:00:00	SPY	ETF	400.25	400.29	400.16	400.19	7943.0
2022-05-16 19:30:00	SPY	ETF	400.01	400.59	399.82	400.42	53481.0
2022-05-16 04:00:00	QQQ	ETF	300.36	300.45	299.51	300.06	55775.0
2022-05-16 04:30:00	QQQ	ETF	300.05	300.82	299.98	300.8	19021.0
2022-05-16 05:00:00	QQQ	ETF	300.99	301.08	300.15	300.15	51435.0
2022-05-16 05:30:00	QQQ	ETF	300.1	300.28	299.69	299.69	11002.0
2022-05-16 06:00:00	QQQ	ETF	299.72	300.25	299.72	300.24	23440.0
2022-05-16 06:30:00	QQQ	ETF	300.28	300.5	299.92	300.49	30458.0
2022-05-16 07:00:00	QQQ	ETF	300.36	300.86	300.25	300.41	101479.0
2022-05-16 07:30:00	QQQ	ETF	300.53	300.75	300.15	300.61	96552.0
2022-05-16 08:00:00	QQQ	ETF	300.3601	303.82	298.81	301.5	307025.0
2022-05-16 08:30:00	QQQ	ETF	301.54	302.55	301.06	301.2	336960.0
2022-05-16 09:00:00	QQQ	ETF	301.2	301.4	299.9	300.09	421451.0
2022-05-16 09:30:00	QQQ	ETF	300.13	301.23	297.821	298.65	8496998.0
2022-05-16 10:00:00	QQQ	ETF	298.64	301.63	297.48	301.41	5406123.0
2022-05-16 10:30:00	QQQ	ETF	301.4	301.55	297.5434	297.58	3445719.0
2022-05-16 11:00:00	QQQ	ETF	297.59	299.07	297.13	298.11	2985466.0
2022-05-16 11:30:00	QQQ	ETF	298.11	300.71	297.32	300.48	3352984.0
2022-05-16 12:00:00	QQQ	ETF	300.49	301.02	298.78	299.17	2041504.0
2022-05-16 12:30:00	QQQ	ETF	299.1533	299.8299	298.06	298.32	1671144.0

> showing 50 of 26,523 rows — these rows as CSV

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