PREVIEW / etf_30min / 2021-07-21

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-07-21.parquet
  size:    609 KB
  rows:    23,378

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
2021-07-21 04:00:00	SPY	ETF	432.86	433.24	432.52	432.96	10906.0
2021-07-21 04:30:00	SPY	ETF	433.21	433.28	433.05	433.05	9496.0
2021-07-21 05:00:00	SPY	ETF	433.11	433.2	432.8	433.1	16015.0
2021-07-21 05:30:00	SPY	ETF	433.07	433.07	432.84	432.97	5300.0
2021-07-21 06:00:00	SPY	ETF	432.9	432.96	432.5	432.9	10037.0
2021-07-21 06:30:00	SPY	ETF	432.86	432.86	432.52	432.62	49990.0
2021-07-21 07:00:00	SPY	ETF	432.59	432.59	431.71	431.771	97423.0
2021-07-21 07:30:00	SPY	ETF	431.84	431.87	431.11	431.33	137563.0
2021-07-21 08:00:00	SPY	ETF	432.5399	432.9196	431.23	431.97	168121.0
2021-07-21 08:30:00	SPY	ETF	431.96	432.29	431.6296	431.99	253497.0
2021-07-21 09:00:00	SPY	ETF	432.0	432.43	431.83	432.36	181640.0
2021-07-21 09:30:00	SPY	ETF	432.34	433.69	432.14	433.66	6344019.0
2021-07-21 10:00:00	SPY	ETF	433.66	433.72	433.03	433.04	3422341.0
2021-07-21 10:30:00	SPY	ETF	433.03	433.57	432.855	433.44	2463696.0
2021-07-21 11:00:00	SPY	ETF	433.45	433.69	433.1919	433.2188	2271096.0
2021-07-21 11:30:00	SPY	ETF	433.21	434.02	433.11	434.001	2367692.0
2021-07-21 12:00:00	SPY	ETF	434.02	434.02	433.59	433.62	3123803.0
2021-07-21 12:30:00	SPY	ETF	433.62	433.77	433.4117	433.455	1784134.0
2021-07-21 13:00:00	SPY	ETF	433.4599	433.88	433.44	433.8306	1875531.0
2021-07-21 13:30:00	SPY	ETF	433.84	434.04	433.71	433.9117	1448411.0
2021-07-21 14:00:00	SPY	ETF	433.915	433.97	433.62	433.86	1628936.0
2021-07-21 14:30:00	SPY	ETF	433.87	434.17	433.86	434.165	1780664.0
2021-07-21 15:00:00	SPY	ETF	434.1699	434.38	434.0	434.1001	2873000.0
2021-07-21 15:30:00	SPY	ETF	434.11	434.7	433.54	434.56	11596087.0
2021-07-21 16:00:00	SPY	ETF	434.58	434.85	434.48	434.79	2573673.0
2021-07-21 16:30:00	SPY	ETF	434.79	435.0	434.55	434.98	213733.0
2021-07-21 17:00:00	SPY	ETF	434.9	435.05	434.9	434.98	70714.0
2021-07-21 17:30:00	SPY	ETF	434.96	434.98	434.89	434.91	118994.0
2021-07-21 18:00:00	SPY	ETF	434.88	434.89	434.72	434.78	97046.0
2021-07-21 18:30:00	SPY	ETF	434.77	434.9	434.74	434.83	22599.0
2021-07-21 19:00:00	SPY	ETF	434.85	434.96	434.83	434.89	20274.0
2021-07-21 19:30:00	SPY	ETF	434.88	435.16	434.77	434.96	39899.0
2021-07-21 04:00:00	QQQ	ETF	359.03	359.87	358.96	359.6	18850.0
2021-07-21 04:30:00	QQQ	ETF	359.64	359.64	359.23	359.28	15942.0
2021-07-21 05:00:00	QQQ	ETF	359.23	359.48	359.13	359.38	13784.0
2021-07-21 05:30:00	QQQ	ETF	359.33	359.39	359.02	359.18	27357.0
2021-07-21 06:00:00	QQQ	ETF	359.15	359.21	358.75	359.21	24929.0
2021-07-21 06:30:00	QQQ	ETF	359.14	359.16	358.85	358.93	22564.0
2021-07-21 07:00:00	QQQ	ETF	358.83	358.86	358.0	358.2	94744.0
2021-07-21 07:30:00	QQQ	ETF	358.17	358.19	357.56	357.83	93978.0
2021-07-21 08:00:00	QQQ	ETF	357.8	359.17	357.6	358.31	156491.0
2021-07-21 08:30:00	QQQ	ETF	358.37	358.56	358.03	358.39	146384.0
2021-07-21 09:00:00	QQQ	ETF	358.36	358.54	358.12	358.36	168650.0
2021-07-21 09:30:00	QQQ	ETF	358.35	359.72	358.12	359.67	4718496.0
2021-07-21 10:00:00	QQQ	ETF	359.67	359.95	358.95	359.58	2146084.0
2021-07-21 10:30:00	QQQ	ETF	359.58	359.9302	359.3785	359.8637	1516877.0
2021-07-21 11:00:00	QQQ	ETF	359.87	360.3901	359.81	360.13	1524765.0
2021-07-21 11:30:00	QQQ	ETF	360.11	360.28	359.64	360.27	1458130.0
2021-07-21 12:00:00	QQQ	ETF	360.2401	360.28	359.77	360.02	837401.0
2021-07-21 12:30:00	QQQ	ETF	360.02	360.16	359.3	359.3899	753117.0

> showing 50 of 23,378 rows — these rows as CSV

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