PREVIEW / etf_30min / 2022-04-28

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-04-28.parquet
  size:    677 KB
  rows:    26,986

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-28 04:00:00	SPY	ETF	423.06	424.22	422.21	424.22	48318.0
2022-04-28 04:30:00	SPY	ETF	424.24	424.78	424.17	424.78	41646.0
2022-04-28 05:00:00	SPY	ETF	425.0	425.09	424.01	424.1	33650.0
2022-04-28 05:30:00	SPY	ETF	424.2	424.4	423.62	423.83	72589.0
2022-04-28 06:00:00	SPY	ETF	423.86	424.04	423.05	423.05	64036.0
2022-04-28 06:30:00	SPY	ETF	423.1	423.45	422.72	423.07	131466.0
2022-04-28 07:00:00	SPY	ETF	423.12	424.2	423.08	423.6	124791.0
2022-04-28 07:30:00	SPY	ETF	423.59	423.68	422.85	423.08	254144.0
2022-04-28 08:00:00	SPY	ETF	423.13	424.8004	420.1	422.5	531604.0
2022-04-28 08:30:00	SPY	ETF	422.4	423.35	421.4	421.82	886224.0
2022-04-28 09:00:00	SPY	ETF	421.81	422.59	421.64	422.24	225209.0
2022-04-28 09:30:00	SPY	ETF	422.29	423.08	419.56	420.48	8256730.0
2022-04-28 10:00:00	SPY	ETF	420.445	420.68	418.41	418.48	6357723.0
2022-04-28 10:30:00	SPY	ETF	418.45	419.58	417.6	419.2801	4770789.0
2022-04-28 11:00:00	SPY	ETF	419.31	421.3	419.085	420.74	4262025.0
2022-04-28 11:30:00	SPY	ETF	420.79	421.35	419.47	420.55	3092660.0
2022-04-28 12:00:00	SPY	ETF	420.53	423.22	420.02	423.2121	3375749.0
2022-04-28 12:30:00	SPY	ETF	423.22	425.8	423.09	425.6	6122505.0
2022-04-28 13:00:00	SPY	ETF	425.6	427.3	425.23	426.8601	5368711.0
2022-04-28 13:30:00	SPY	ETF	426.87	427.63	426.32	427.17	4540277.0
2022-04-28 14:00:00	SPY	ETF	427.17	427.68	426.72	427.535	3206260.0
2022-04-28 14:30:00	SPY	ETF	427.55	429.1999	427.13	428.65	5318103.0
2022-04-28 15:00:00	SPY	ETF	428.63	429.64	428.3	428.77	5503565.0
2022-04-28 15:30:00	SPY	ETF	428.78	428.87	426.37	427.79	16408537.0
2022-04-28 16:00:00	SPY	ETF	427.78	427.93	424.7	425.66	4694990.0
2022-04-28 16:30:00	SPY	ETF	425.72	428.1	425.08	425.31	991574.0
2022-04-28 17:00:00	SPY	ETF	425.43	425.5	421.7	422.7	341330.0
2022-04-28 17:30:00	SPY	ETF	422.7	424.0	422.34	423.48	215271.0
2022-04-28 18:00:00	SPY	ETF	423.6	424.7	422.96	424.21	189460.0
2022-04-28 18:30:00	SPY	ETF	424.2	424.54	423.66	423.84	86371.0
2022-04-28 19:00:00	SPY	ETF	423.85	424.28	423.71	424.0501	37273.0
2022-04-28 19:30:00	SPY	ETF	424.12	424.15	423.73	423.91	43355.0
2022-04-28 04:00:00	QQQ	ETF	322.2	324.38	322.2	324.24	128878.0
2022-04-28 04:30:00	QQQ	ETF	324.2	324.9	323.95	324.9	41283.0
2022-04-28 05:00:00	QQQ	ETF	324.99	325.08	323.74	323.75	64965.0
2022-04-28 05:30:00	QQQ	ETF	323.95	324.05	323.4	323.57	93496.0
2022-04-28 06:00:00	QQQ	ETF	323.45	323.78	322.96	323.0	110090.0
2022-04-28 06:30:00	QQQ	ETF	323.02	323.42	322.85	323.25	123333.0
2022-04-28 07:00:00	QQQ	ETF	323.27	324.3	323.2	323.71	221890.0
2022-04-28 07:30:00	QQQ	ETF	323.69	323.77	322.9	323.13	97191.0
2022-04-28 08:00:00	QQQ	ETF	323.2587	325.0804	316.76	322.3604	449957.0
2022-04-28 08:30:00	QQQ	ETF	322.2	323.12	320.78	321.36	866007.0
2022-04-28 09:00:00	QQQ	ETF	321.43	322.46	321.15	321.82	391120.0
2022-04-28 09:30:00	QQQ	ETF	321.85	323.505	319.03	320.03	11997255.0
2022-04-28 10:00:00	QQQ	ETF	320.02	321.22	318.26	318.3	6242589.0
2022-04-28 10:30:00	QQQ	ETF	318.28	319.595	317.52	319.2601	4035699.0
2022-04-28 11:00:00	QQQ	ETF	319.29	321.879	318.945	320.995	4137034.0
2022-04-28 11:30:00	QQQ	ETF	321.0	321.83	319.38	320.0507	2850278.0
2022-04-28 12:00:00	QQQ	ETF	320.07	322.94	319.53	322.88	2727933.0
2022-04-28 12:30:00	QQQ	ETF	322.9101	325.76	322.725	325.3931	4739386.0

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

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