PREVIEW / etf_30min / 2022-07-18

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-07-18.parquet
  size:    662 KB
  rows:    26,161

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-07-18 04:00:00	SPY	ETF	388.24	389.29	386.71	389.19	26289.0
2022-07-18 04:30:00	SPY	ETF	389.27	389.45	389.01	389.35	11607.0
2022-07-18 05:00:00	SPY	ETF	389.35	389.37	388.92	388.96	8481.0
2022-07-18 05:30:00	SPY	ETF	389.02	389.02	388.6	388.76	21330.0
2022-07-18 06:00:00	SPY	ETF	388.75	389.05	388.68	388.98	15533.0
2022-07-18 06:30:00	SPY	ETF	388.99	389.0	388.62	388.77	12835.0
2022-07-18 07:00:00	SPY	ETF	388.73	389.29	388.46	389.12	124060.0
2022-07-18 07:30:00	SPY	ETF	389.15	389.2	388.76	388.8	65496.0
2022-07-18 08:00:00	SPY	ETF	388.5001	389.29	385.8	387.66	214292.0
2022-07-18 08:30:00	SPY	ETF	387.61	388.25	387.6	388.2	152209.0
2022-07-18 09:00:00	SPY	ETF	388.18	388.48	387.86	388.32	216761.0
2022-07-18 09:30:00	SPY	ETF	388.38	389.09	387.67	388.3	6098085.0
2022-07-18 10:00:00	SPY	ETF	388.28	388.7	387.2	387.755	2987341.0
2022-07-18 10:30:00	SPY	ETF	387.76	388.265	387.28	387.94	2246774.0
2022-07-18 11:00:00	SPY	ETF	387.94	388.05	387.3	387.625	1826306.0
2022-07-18 11:30:00	SPY	ETF	387.64	388.45	387.4	388.3606	2333692.0
2022-07-18 12:00:00	SPY	ETF	388.36	388.4	387.815	387.87	1464332.0
2022-07-18 12:30:00	SPY	ETF	387.865	388.125	387.0	387.155	1692959.0
2022-07-18 13:00:00	SPY	ETF	387.15	387.3594	386.52	387.0901	1893403.0
2022-07-18 13:30:00	SPY	ETF	387.09	387.13	384.33	384.5171	3528810.0
2022-07-18 14:00:00	SPY	ETF	384.51	385.12	383.93	384.0	3476012.0
2022-07-18 14:30:00	SPY	ETF	384.01	384.77	382.97	383.12	3271883.0
2022-07-18 15:00:00	SPY	ETF	383.12	383.99	382.67	382.7	3512421.0
2022-07-18 15:30:00	SPY	ETF	382.71	382.7585	380.66	381.99	9064673.0
2022-07-18 16:00:00	SPY	ETF	382.0	382.49	381.79	382.34	3842295.0
2022-07-18 16:30:00	SPY	ETF	382.39	382.48	382.25	382.41	164318.0
2022-07-18 17:00:00	SPY	ETF	382.26	382.42	382.14	382.35	67354.0
2022-07-18 17:30:00	SPY	ETF	382.34	382.41	382.3	382.39	17722.0
2022-07-18 18:00:00	SPY	ETF	382.4	382.47	382.05	382.31	42544.0
2022-07-18 18:30:00	SPY	ETF	382.33	382.68	382.3	382.53	18003.0
2022-07-18 19:00:00	SPY	ETF	382.53	382.61	382.2	382.48	13268.0
2022-07-18 19:30:00	SPY	ETF	382.52	383.03	382.52	383.01	77980.0
2022-07-18 04:00:00	QQQ	ETF	294.02	295.87	293.04	295.83	88790.0
2022-07-18 04:30:00	QQQ	ETF	295.85	296.0	295.66	295.79	44826.0
2022-07-18 05:00:00	QQQ	ETF	295.79	295.8	295.35	295.35	17907.0
2022-07-18 05:30:00	QQQ	ETF	295.42	295.42	295.17	295.31	58703.0
2022-07-18 06:00:00	QQQ	ETF	295.2	295.46	295.19	295.37	18746.0
2022-07-18 06:30:00	QQQ	ETF	295.31	295.4	295.1	295.2	67834.0
2022-07-18 07:00:00	QQQ	ETF	295.16	295.62	294.9	295.49	111114.0
2022-07-18 07:30:00	QQQ	ETF	295.56	295.59	295.22	295.28	141204.0
2022-07-18 08:00:00	QQQ	ETF	295.3697	295.7304	293.8	294.3	389666.0
2022-07-18 08:30:00	QQQ	ETF	294.29	294.79	294.19	294.75	247085.0
2022-07-18 09:00:00	QQQ	ETF	294.73	294.87	294.41	294.68	272643.0
2022-07-18 09:30:00	QQQ	ETF	294.72	296.16	293.85	295.6	5860507.0
2022-07-18 10:00:00	QQQ	ETF	295.57	296.09	294.18	294.7	3384748.0
2022-07-18 10:30:00	QQQ	ETF	294.71	295.26	293.97	294.96	2077377.0
2022-07-18 11:00:00	QQQ	ETF	294.98	295.34	294.59	295.0393	1635948.0
2022-07-18 11:30:00	QQQ	ETF	295.0399	296.08	294.85	296.0095	1688325.0
2022-07-18 12:00:00	QQQ	ETF	296.0287	296.1	295.562	295.68	1165693.0
2022-07-18 12:30:00	QQQ	ETF	295.6519	295.876	295.03	295.125	1012659.0

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

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