PREVIEW / etf_30min / 2022-08-19

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-08-19.parquet
  size:    647 KB
  rows:    25,608

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-08-19 04:00:00	SPY	ETF	426.49	426.49	424.6	424.68	38464.0
2022-08-19 04:30:00	SPY	ETF	424.63	424.63	424.1	424.55	40238.0
2022-08-19 05:00:00	SPY	ETF	424.48	424.75	424.31	424.62	19181.0
2022-08-19 05:30:00	SPY	ETF	424.63	424.94	424.4	424.4	24821.0
2022-08-19 06:00:00	SPY	ETF	424.39	424.56	424.08	424.29	22445.0
2022-08-19 06:30:00	SPY	ETF	424.41	424.43	423.22	423.44	98348.0
2022-08-19 07:00:00	SPY	ETF	423.51	423.85	423.31	423.65	155934.0
2022-08-19 07:30:00	SPY	ETF	423.65	424.06	423.32	424.06	233989.0
2022-08-19 08:00:00	SPY	ETF	423.5501	427.15	423.2496	423.68	362159.0
2022-08-19 08:30:00	SPY	ETF	423.69	424.41	423.54	424.1	234951.0
2022-08-19 09:00:00	SPY	ETF	424.05	425.07	423.89	424.98	407310.0
2022-08-19 09:30:00	SPY	ETF	424.98	425.26	422.82	423.17	7127544.0
2022-08-19 10:00:00	SPY	ETF	423.17	423.55	422.66	423.22	4359506.0
2022-08-19 10:30:00	SPY	ETF	423.22	423.53	422.44	422.5	3427464.0
2022-08-19 11:00:00	SPY	ETF	422.4901	422.72	421.71	422.28	2969288.0
2022-08-19 11:30:00	SPY	ETF	422.29	423.1	421.88	422.5099	2993298.0
2022-08-19 12:00:00	SPY	ETF	422.5	423.05	422.16	422.585	2262069.0
2022-08-19 12:30:00	SPY	ETF	422.59	423.7	422.455	423.3	2087508.0
2022-08-19 13:00:00	SPY	ETF	423.31	423.65	422.74	422.8	1720177.0
2022-08-19 13:30:00	SPY	ETF	422.775	423.0	422.03	422.845	2405864.0
2022-08-19 14:00:00	SPY	ETF	422.86	422.94	422.0	422.405	2449075.0
2022-08-19 14:30:00	SPY	ETF	422.41	422.55	421.56	421.8	1953613.0
2022-08-19 15:00:00	SPY	ETF	421.8	422.42	421.22	422.29	3462004.0
2022-08-19 15:30:00	SPY	ETF	422.3	422.78	421.91	422.15	7930189.0
2022-08-19 16:00:00	SPY	ETF	422.14	422.3	422.0	422.01	3160037.0
2022-08-19 16:30:00	SPY	ETF	422.05	422.05	421.9	421.93	233525.0
2022-08-19 17:00:00	SPY	ETF	421.99	422.1	421.88	422.0	103006.0
2022-08-19 17:30:00	SPY	ETF	422.0	422.0	421.79	421.8	15804.0
2022-08-19 18:00:00	SPY	ETF	421.79	421.79	421.65	421.65	8983.0
2022-08-19 18:30:00	SPY	ETF	421.65	421.66	421.56	421.66	3782.0
2022-08-19 19:00:00	SPY	ETF	421.61	421.62	421.4	421.5	5878.0
2022-08-19 19:30:00	SPY	ETF	421.42	422.0	421.25	421.4	42783.0
2022-08-19 04:00:00	QQQ	ETF	327.98	328.62	325.98	326.03	65366.0
2022-08-19 04:30:00	QQQ	ETF	326.13	326.13	325.55	326.07	47346.0
2022-08-19 05:00:00	QQQ	ETF	326.12	326.43	326.0	326.26	40884.0
2022-08-19 05:30:00	QQQ	ETF	326.25	326.72	326.06	326.06	70950.0
2022-08-19 06:00:00	QQQ	ETF	326.1	326.34	325.8	326.2	18398.0
2022-08-19 06:30:00	QQQ	ETF	326.29	326.29	325.22	325.57	55706.0
2022-08-19 07:00:00	QQQ	ETF	325.59	325.91	325.35	325.8	129350.0
2022-08-19 07:30:00	QQQ	ETF	325.83	326.0	325.42	326.0	123238.0
2022-08-19 08:00:00	QQQ	ETF	325.8	329.526	325.31	325.6	325719.0
2022-08-19 08:30:00	QQQ	ETF	325.61	326.06	325.45	325.79	156818.0
2022-08-19 09:00:00	QQQ	ETF	325.77	326.47	325.47	326.18	487834.0
2022-08-19 09:30:00	QQQ	ETF	326.17	326.84	323.845	324.0298	5156037.0
2022-08-19 10:00:00	QQQ	ETF	324.03	324.47	323.35	323.73	3558442.0
2022-08-19 10:30:00	QQQ	ETF	323.71	324.05	322.92	322.955	2825748.0
2022-08-19 11:00:00	QQQ	ETF	322.959	323.25	322.53	322.98	2759694.0
2022-08-19 11:30:00	QQQ	ETF	322.99	323.78	322.62	323.035	2233670.0
2022-08-19 12:00:00	QQQ	ETF	323.02	323.55	322.735	323.095	1322740.0
2022-08-19 12:30:00	QQQ	ETF	323.09	324.08	322.94	323.72	1463273.0

> showing 50 of 25,608 rows — these rows as CSV

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