PREVIEW / etf_30min / 2022-07-27

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-07-27.parquet
  size:    638 KB
  rows:    25,508

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-27 04:00:00	SPY	ETF	394.5	395.42	394.28	394.75	29218.0
2022-07-27 04:30:00	SPY	ETF	394.92	395.13	394.84	395.04	34680.0
2022-07-27 05:00:00	SPY	ETF	394.89	395.05	394.75	394.85	16200.0
2022-07-27 05:30:00	SPY	ETF	394.89	395.15	394.5	394.57	13071.0
2022-07-27 06:00:00	SPY	ETF	394.41	394.51	394.2	394.27	62547.0
2022-07-27 06:30:00	SPY	ETF	394.24	394.5	394.1	394.4	46073.0
2022-07-27 07:00:00	SPY	ETF	394.41	394.41	393.93	394.24	69437.0
2022-07-27 07:30:00	SPY	ETF	394.24	394.36	393.97	393.99	111348.0
2022-07-27 08:00:00	SPY	ETF	394.03	395.3604	393.94	394.37	113595.0
2022-07-27 08:30:00	SPY	ETF	394.29	394.74	394.0	394.6	76084.0
2022-07-27 09:00:00	SPY	ETF	394.61	394.91	394.34	394.35	207090.0
2022-07-27 09:30:00	SPY	ETF	394.36	395.699	394.05	395.33	4430555.0
2022-07-27 10:00:00	SPY	ETF	395.31	395.98	394.96	395.73	2933971.0
2022-07-27 10:30:00	SPY	ETF	395.72	396.16	395.27	396.12	2047913.0
2022-07-27 11:00:00	SPY	ETF	396.14	396.79	395.79	396.1299	2629137.0
2022-07-27 11:30:00	SPY	ETF	396.12	396.87	396.115	396.65	1628233.0
2022-07-27 12:00:00	SPY	ETF	396.65	397.07	396.54	396.81	1793223.0
2022-07-27 12:30:00	SPY	ETF	396.82	396.88	396.0	396.03	1747324.0
2022-07-27 13:00:00	SPY	ETF	396.02	396.22	395.72	396.193	1371673.0
2022-07-27 13:30:00	SPY	ETF	396.2	396.545	396.0	396.31	1739566.0
2022-07-27 14:00:00	SPY	ETF	396.34	397.53	395.47	396.6	5369395.0
2022-07-27 14:30:00	SPY	ETF	396.61	400.85	395.47	399.86	10849302.0
2022-07-27 15:00:00	SPY	ETF	399.87	402.7992	399.49	402.77	7691911.0
2022-07-27 15:30:00	SPY	ETF	402.8	402.88	400.9	401.0	12579424.0
2022-07-27 16:00:00	SPY	ETF	401.0	401.1	400.03	400.65	4635775.0
2022-07-27 16:30:00	SPY	ETF	400.65	401.04	400.6	400.66	161377.0
2022-07-27 17:00:00	SPY	ETF	400.64	400.78	400.5	400.7	54135.0
2022-07-27 17:30:00	SPY	ETF	400.72	400.79	400.57	400.59	18774.0
2022-07-27 18:00:00	SPY	ETF	400.68	400.71	400.44	400.5	79981.0
2022-07-27 18:30:00	SPY	ETF	400.55	400.77	400.45	400.49	19735.0
2022-07-27 19:00:00	SPY	ETF	400.58	400.83	400.58	400.63	14622.0
2022-07-27 19:30:00	SPY	ETF	400.68	400.75	400.4	400.5	32378.0
2022-07-27 04:00:00	QQQ	ETF	299.0	299.79	298.9	299.25	102112.0
2022-07-27 04:30:00	QQQ	ETF	299.21	299.52	299.21	299.37	42845.0
2022-07-27 05:00:00	QQQ	ETF	299.32	299.38	299.07	299.07	14902.0
2022-07-27 05:30:00	QQQ	ETF	299.14	299.23	298.8	298.87	58259.0
2022-07-27 06:00:00	QQQ	ETF	298.94	298.94	298.54	298.6	14586.0
2022-07-27 06:30:00	QQQ	ETF	298.58	298.87	298.4	298.87	27490.0
2022-07-27 07:00:00	QQQ	ETF	298.8	298.86	298.14	298.53	105945.0
2022-07-27 07:30:00	QQQ	ETF	298.6	298.6	298.26	298.26	54506.0
2022-07-27 08:00:00	QQQ	ETF	298.7591	299.5804	294.59	298.56	202385.0
2022-07-27 08:30:00	QQQ	ETF	298.56	299.12	298.13	298.93	283729.0
2022-07-27 09:00:00	QQQ	ETF	298.93	299.24	298.89	299.03	244997.0
2022-07-27 09:30:00	QQQ	ETF	299.04	301.48	298.46	301.11	5266595.0
2022-07-27 10:00:00	QQQ	ETF	301.11	302.28	300.78	301.69	3292689.0
2022-07-27 10:30:00	QQQ	ETF	301.69	302.12	301.16	302.0748	2005276.0
2022-07-27 11:00:00	QQQ	ETF	302.06	302.63	301.6	301.98	2348663.0
2022-07-27 11:30:00	QQQ	ETF	301.9918	302.59	301.98	302.42	1895624.0
2022-07-27 12:00:00	QQQ	ETF	302.41	303.27	302.2003	302.9818	1853461.0
2022-07-27 12:30:00	QQQ	ETF	302.9817	303.04	302.09	302.17	1245784.0

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

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