PREVIEW / etf_30min / 2022-03-30

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-03-30.parquet
  size:    674 KB
  rows:    26,496

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-03-30 04:00:00	SPY	ETF	460.36	460.42	459.51	459.93	26032.0
2022-03-30 04:30:00	SPY	ETF	459.89	459.99	459.45	459.62	8909.0
2022-03-30 05:00:00	SPY	ETF	459.84	460.3	459.79	460.21	13441.0
2022-03-30 05:30:00	SPY	ETF	460.19	460.57	460.05	460.1	10543.0
2022-03-30 06:00:00	SPY	ETF	460.25	460.26	459.48	459.81	26695.0
2022-03-30 06:30:00	SPY	ETF	460.0	460.37	459.95	460.22	23088.0
2022-03-30 07:00:00	SPY	ETF	460.29	460.64	460.2	460.41	65498.0
2022-03-30 07:30:00	SPY	ETF	460.4	460.66	460.38	460.43	24816.0
2022-03-30 08:00:00	SPY	ETF	460.44	461.896	459.2	459.36	302280.0
2022-03-30 08:30:00	SPY	ETF	459.4	460.28	459.4	460.0	176353.0
2022-03-30 09:00:00	SPY	ETF	460.06	460.5	459.5922	460.35	187950.0
2022-03-30 09:30:00	SPY	ETF	460.34	461.0	459.84	460.9	4879757.0
2022-03-30 10:00:00	SPY	ETF	460.9	461.195	460.04	460.15	3440725.0
2022-03-30 10:30:00	SPY	ETF	460.13	460.74	459.76	459.8401	3123743.0
2022-03-30 11:00:00	SPY	ETF	459.86	460.05	458.64	459.16	4243301.0
2022-03-30 11:30:00	SPY	ETF	459.17	459.73	458.99	459.67	3165992.0
2022-03-30 12:00:00	SPY	ETF	459.65	460.1	459.075	459.51	2677444.0
2022-03-30 12:30:00	SPY	ETF	459.51	460.12	459.35	459.9	1622570.0
2022-03-30 13:00:00	SPY	ETF	459.89	459.94	458.85	459.0	2069058.0
2022-03-30 13:30:00	SPY	ETF	458.99	459.19	458.515	458.64	3309490.0
2022-03-30 14:00:00	SPY	ETF	458.6499	459.34	458.42	458.555	3429780.0
2022-03-30 14:30:00	SPY	ETF	458.555	458.975	457.78	457.875	3157790.0
2022-03-30 15:00:00	SPY	ETF	457.89	457.9798	456.465	457.16	4917462.0
2022-03-30 15:30:00	SPY	ETF	457.16	458.73	456.87	458.72	11051878.0
2022-03-30 16:00:00	SPY	ETF	458.71	459.1	457.81	459.06	3982255.0
2022-03-30 16:30:00	SPY	ETF	459.06	459.31	458.7	459.14	370769.0
2022-03-30 17:00:00	SPY	ETF	459.14	459.27	458.7	459.06	100905.0
2022-03-30 17:30:00	SPY	ETF	459.06	459.06	459.0	459.0	15907.0
2022-03-30 18:00:00	SPY	ETF	459.0	459.13	458.87	459.11	77743.0
2022-03-30 18:30:00	SPY	ETF	459.09	459.17	459.0	459.03	33558.0
2022-03-30 19:00:00	SPY	ETF	459.09	459.15	459.0	459.01	10483.0
2022-03-30 19:30:00	SPY	ETF	459.0	459.0	458.81	458.88	46830.0
2022-03-30 04:00:00	QQQ	ETF	370.2	370.2	369.04	369.29	55480.0
2022-03-30 04:30:00	QQQ	ETF	369.4	369.45	368.92	369.21	21251.0
2022-03-30 05:00:00	QQQ	ETF	369.35	369.64	369.23	369.39	18728.0
2022-03-30 05:30:00	QQQ	ETF	369.44	369.65	369.35	369.61	7297.0
2022-03-30 06:00:00	QQQ	ETF	369.67	369.67	368.77	369.14	50159.0
2022-03-30 06:30:00	QQQ	ETF	369.11	369.61	369.08	369.33	42737.0
2022-03-30 07:00:00	QQQ	ETF	369.41	369.9	369.33	369.83	92970.0
2022-03-30 07:30:00	QQQ	ETF	369.8	370.03	369.73	369.81	55762.0
2022-03-30 08:00:00	QQQ	ETF	369.58	371.1	368.41	368.42	485162.0
2022-03-30 08:30:00	QQQ	ETF	368.41	369.29	368.41	369.1	228083.0
2022-03-30 09:00:00	QQQ	ETF	369.13	369.4	368.69	369.3	166838.0
2022-03-30 09:30:00	QQQ	ETF	369.275	370.3698	368.71	369.83	5925757.0
2022-03-30 10:00:00	QQQ	ETF	369.85	370.86	368.95	370.475	4132846.0
2022-03-30 10:30:00	QQQ	ETF	370.55	370.98	369.03	369.09	3255097.0
2022-03-30 11:00:00	QQQ	ETF	369.1	369.23	367.61	368.12	4185633.0
2022-03-30 11:30:00	QQQ	ETF	368.15	369.13	367.95	369.04	3095527.0
2022-03-30 12:00:00	QQQ	ETF	369.03	369.5271	368.42	369.13	2929404.0
2022-03-30 12:30:00	QQQ	ETF	369.1311	370.07	368.85	369.985	1680948.0

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

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