PREVIEW / etf_30min / 2022-06-21

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-06-21.parquet
  size:    689 KB
  rows:    27,721

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-06-21 04:00:00	SPY	ETF	372.4	373.06	371.0	372.75	127741.0
2022-06-21 04:30:00	SPY	ETF	372.66	372.86	372.3	372.84	51420.0
2022-06-21 05:00:00	SPY	ETF	372.88	373.03	372.68	372.8	11871.0
2022-06-21 05:30:00	SPY	ETF	372.73	372.89	372.19	372.19	16909.0
2022-06-21 06:00:00	SPY	ETF	372.32	372.63	372.09	372.5	56075.0
2022-06-21 06:30:00	SPY	ETF	372.51	372.65	372.31	372.45	27588.0
2022-06-21 07:00:00	SPY	ETF	372.36	372.44	371.67	372.13	146451.0
2022-06-21 07:30:00	SPY	ETF	372.1	372.16	370.88	371.11	166096.0
2022-06-21 08:00:00	SPY	ETF	372.35	372.8896	370.69	371.46	331330.0
2022-06-21 08:30:00	SPY	ETF	371.4	371.8	370.91	370.93	543157.0
2022-06-21 09:00:00	SPY	ETF	370.94	371.87	370.89	371.87	305840.0
2022-06-21 09:30:00	SPY	ETF	371.88	374.91	371.81	374.83	8463763.0
2022-06-21 10:00:00	SPY	ETF	374.84	375.54	374.39	375.11	5004855.0
2022-06-21 10:30:00	SPY	ETF	375.12	376.25	374.95	376.06	3938068.0
2022-06-21 11:00:00	SPY	ETF	376.07	376.28	375.09	375.18	3397677.0
2022-06-21 11:30:00	SPY	ETF	375.2	375.639	374.2	374.21	3382298.0
2022-06-21 12:00:00	SPY	ETF	374.2	374.96	373.91	374.74	2636020.0
2022-06-21 12:30:00	SPY	ETF	374.755	375.61	374.53	375.55	2100872.0
2022-06-21 13:00:00	SPY	ETF	375.58	375.93	375.06	375.21	1858133.0
2022-06-21 13:30:00	SPY	ETF	375.2	375.695	374.735	374.835	1932048.0
2022-06-21 14:00:00	SPY	ETF	374.85	375.4	374.52	375.28	2318920.0
2022-06-21 14:30:00	SPY	ETF	375.29	376.19	374.69	376.0817	3419407.0
2022-06-21 15:00:00	SPY	ETF	376.1	376.525	375.7	375.97	3954437.0
2022-06-21 15:30:00	SPY	ETF	375.97	376.17	374.67	375.0699	10147918.0
2022-06-21 16:00:00	SPY	ETF	375.04	375.25	374.0	375.11	3868826.0
2022-06-21 16:30:00	SPY	ETF	375.13	375.3	374.93	375.07	269158.0
2022-06-21 17:00:00	SPY	ETF	375.25	375.25	374.97	375.05	46143.0
2022-06-21 17:30:00	SPY	ETF	375.01	375.3	374.84	375.0	100658.0
2022-06-21 18:00:00	SPY	ETF	374.95	374.95	374.3	374.62	96460.0
2022-06-21 18:30:00	SPY	ETF	374.62	374.7	374.36	374.67	48855.0
2022-06-21 19:00:00	SPY	ETF	374.65	374.65	374.17	374.35	45866.0
2022-06-21 19:30:00	SPY	ETF	374.3	374.68	374.3	374.67	38416.0
2022-06-21 04:00:00	QQQ	ETF	278.56	280.25	278.06	279.88	147041.0
2022-06-21 04:30:00	QQQ	ETF	279.9	279.97	279.46	279.94	90816.0
2022-06-21 05:00:00	QQQ	ETF	279.98	280.11	279.76	279.82	59628.0
2022-06-21 05:30:00	QQQ	ETF	279.77	279.85	279.13	279.29	107185.0
2022-06-21 06:00:00	QQQ	ETF	279.3	279.44	279.0	279.34	92489.0
2022-06-21 06:30:00	QQQ	ETF	279.34	279.57	279.23	279.41	104866.0
2022-06-21 07:00:00	QQQ	ETF	279.36	279.41	278.7	278.99	198950.0
2022-06-21 07:30:00	QQQ	ETF	279.04	279.06	278.02	278.14	308504.0
2022-06-21 08:00:00	QQQ	ETF	278.14	280.1304	277.8	278.49	436224.0
2022-06-21 08:30:00	QQQ	ETF	278.47	278.94	278.14	278.16	225899.0
2022-06-21 09:00:00	QQQ	ETF	278.16	278.84	278.15	278.76	284969.0
2022-06-21 09:30:00	QQQ	ETF	278.75	282.345	278.64	282.295	6235095.0
2022-06-21 10:00:00	QQQ	ETF	282.29	283.16	281.93	282.5	3809188.0
2022-06-21 10:30:00	QQQ	ETF	282.5	283.44	282.3	283.31	2994087.0
2022-06-21 11:00:00	QQQ	ETF	283.32	283.45	282.67	282.76	2214116.0
2022-06-21 11:30:00	QQQ	ETF	282.77	283.0	281.74	281.74	2156600.0
2022-06-21 12:00:00	QQQ	ETF	281.75	282.25	281.2906	281.705	2241874.0
2022-06-21 12:30:00	QQQ	ETF	281.7	282.4	281.53	282.2923	1485484.0

> showing 50 of 27,721 rows — these rows as CSV

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