PREVIEW / etf_30min / 2022-04-25

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-04-25.parquet
  size:    705 KB
  rows:    28,431

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-04-25 04:00:00	SPY	ETF	422.26	423.68	422.13	422.63	42607.0
2022-04-25 04:30:00	SPY	ETF	422.59	423.09	421.2	421.77	27007.0
2022-04-25 05:00:00	SPY	ETF	421.72	422.04	421.17	421.64	49559.0
2022-04-25 05:30:00	SPY	ETF	421.53	422.94	421.49	422.39	41076.0
2022-04-25 06:00:00	SPY	ETF	422.2	422.71	421.99	422.5	28822.0
2022-04-25 06:30:00	SPY	ETF	422.41	422.58	421.84	422.53	29022.0
2022-04-25 07:00:00	SPY	ETF	422.6	423.46	421.45	422.1	301293.0
2022-04-25 07:30:00	SPY	ETF	421.98	423.5	421.98	422.71	311315.0
2022-04-25 08:00:00	SPY	ETF	422.64	425.721	421.2696	423.15	308619.0
2022-04-25 08:30:00	SPY	ETF	423.22	424.7	422.68	424.56	538560.0
2022-04-25 09:00:00	SPY	ETF	424.57	424.69	423.57	423.71	824346.0
2022-04-25 09:30:00	SPY	ETF	423.66	423.87	420.27	420.2993	11003596.0
2022-04-25 10:00:00	SPY	ETF	420.3	423.0	419.99	422.6599	7438835.0
2022-04-25 10:30:00	SPY	ETF	422.6595	424.4	420.58	420.72	6301093.0
2022-04-25 11:00:00	SPY	ETF	420.7	422.21	419.96	420.74	5083789.0
2022-04-25 11:30:00	SPY	ETF	420.78	421.7	418.84	419.77	5416328.0
2022-04-25 12:00:00	SPY	ETF	419.76	422.6821	419.16	421.68	5450548.0
2022-04-25 12:30:00	SPY	ETF	421.71	423.29	421.41	422.0399	4133872.0
2022-04-25 13:00:00	SPY	ETF	422.075	423.79	420.98	422.995	4077622.0
2022-04-25 13:30:00	SPY	ETF	423.03	423.692	421.96	422.49	3467857.0
2022-04-25 14:00:00	SPY	ETF	422.49	425.62	421.75	425.5599	5726826.0
2022-04-25 14:30:00	SPY	ETF	425.54	426.76	424.72	425.51	5382452.0
2022-04-25 15:00:00	SPY	ETF	425.49	427.42	423.84	427.205	7427583.0
2022-04-25 15:30:00	SPY	ETF	427.18	428.69	426.84	428.49	15014036.0
2022-04-25 16:00:00	SPY	ETF	428.49	429.0	428.07	428.55	3437709.0
2022-04-25 16:30:00	SPY	ETF	428.55	428.81	428.35	428.65	217716.0
2022-04-25 17:00:00	SPY	ETF	428.65	428.66	428.38	428.56	767376.0
2022-04-25 17:30:00	SPY	ETF	428.51	428.52	428.44	428.48	44460.0
2022-04-25 18:00:00	SPY	ETF	428.52	428.55	428.05	428.21	74610.0
2022-04-25 18:30:00	SPY	ETF	428.21	428.46	428.07	428.42	35054.0
2022-04-25 19:00:00	SPY	ETF	428.49	428.67	428.43	428.53	20491.0
2022-04-25 19:30:00	SPY	ETF	428.51	428.55	428.23	428.4	50282.0
2022-04-25 04:00:00	QQQ	ETF	323.5	324.03	322.66	323.19	170551.0
2022-04-25 04:30:00	QQQ	ETF	323.13	323.59	321.94	322.36	64070.0
2022-04-25 05:00:00	QQQ	ETF	322.45	322.77	321.89	322.38	63599.0
2022-04-25 05:30:00	QQQ	ETF	322.13	323.5	322.12	322.89	70815.0
2022-04-25 06:00:00	QQQ	ETF	323.08	323.21	322.56	323.0	84281.0
2022-04-25 06:30:00	QQQ	ETF	323.0	323.03	322.25	322.78	83380.0
2022-04-25 07:00:00	QQQ	ETF	322.79	323.0	321.2	321.7	369484.0
2022-04-25 07:30:00	QQQ	ETF	321.7	323.09	321.7	322.74	290997.0
2022-04-25 08:00:00	QQQ	ETF	322.8	325.644	321.2605	323.15	439545.0
2022-04-25 08:30:00	QQQ	ETF	323.23	324.5199	322.88	324.36	373711.0
2022-04-25 09:00:00	QQQ	ETF	324.38	324.38	323.5	323.7	623619.0
2022-04-25 09:30:00	QQQ	ETF	323.73	325.6	322.43	322.74	11250121.0
2022-04-25 10:00:00	QQQ	ETF	322.73	326.55	322.63	326.16	8185761.0
2022-04-25 10:30:00	QQQ	ETF	326.18	328.01	324.47	324.62	8177954.0
2022-04-25 11:00:00	QQQ	ETF	324.65	325.73	323.15	324.215	5635816.0
2022-04-25 11:30:00	QQQ	ETF	324.21	325.33	322.51	323.16	5009572.0
2022-04-25 12:00:00	QQQ	ETF	323.142	325.9	322.56	324.966	4506948.0
2022-04-25 12:30:00	QQQ	ETF	324.97	326.57	324.63	324.99	3683530.0

> showing 50 of 28,431 rows — these rows as CSV

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