PREVIEW / etf_30min / 2022-06-13

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-06-13.parquet
  size:    740 KB
  rows:    29,767

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-13 04:00:00	SPY	ETF	382.07	384.5	379.81	379.97	139440.0
2022-06-13 04:30:00	SPY	ETF	380.03	381.27	379.99	380.29	45705.0
2022-06-13 05:00:00	SPY	ETF	380.06	381.25	380.0	380.65	41997.0
2022-06-13 05:30:00	SPY	ETF	380.62	380.95	379.97	380.82	188360.0
2022-06-13 06:00:00	SPY	ETF	380.86	381.7	380.64	381.1	192786.0
2022-06-13 06:30:00	SPY	ETF	381.08	381.75	380.94	381.37	239850.0
2022-06-13 07:00:00	SPY	ETF	381.43	382.07	380.8	381.19	535754.0
2022-06-13 07:30:00	SPY	ETF	381.2	381.54	380.17	380.3	371928.0
2022-06-13 08:00:00	SPY	ETF	380.28	385.44	379.9404	381.7	637560.0
2022-06-13 08:30:00	SPY	ETF	381.7	381.97	380.54	380.58	259843.0
2022-06-13 09:00:00	SPY	ETF	380.56	381.08	379.86	379.86	631820.0
2022-06-13 09:30:00	SPY	ETF	379.85	381.81	379.18	379.79	11080032.0
2022-06-13 10:00:00	SPY	ETF	379.79	380.71	376.92	377.18	8003222.0
2022-06-13 10:30:00	SPY	ETF	377.19	378.04	375.47	376.12	8206241.0
2022-06-13 11:00:00	SPY	ETF	376.14	378.3899	374.93	377.385	7875798.0
2022-06-13 11:30:00	SPY	ETF	377.36	379.29	376.7	378.28	6195544.0
2022-06-13 12:00:00	SPY	ETF	378.3	379.66	377.84	379.04	4847791.0
2022-06-13 12:30:00	SPY	ETF	379.04	381.35	378.0801	378.18	5205788.0
2022-06-13 13:00:00	SPY	ETF	378.18	378.22	377.06	377.47	3794772.0
2022-06-13 13:30:00	SPY	ETF	377.49	379.98	376.9	379.3544	4838968.0
2022-06-13 14:00:00	SPY	ETF	379.33	379.4	377.15	377.68	4346834.0
2022-06-13 14:30:00	SPY	ETF	377.67	379.0271	376.681	376.9352	4396072.0
2022-06-13 15:00:00	SPY	ETF	376.93	378.08	375.03	375.08	9089052.0
2022-06-13 15:30:00	SPY	ETF	375.08	375.83	373.3	375.02	23153786.0
2022-06-13 16:00:00	SPY	ETF	375.02	376.0	373.4	375.14	8005573.0
2022-06-13 16:30:00	SPY	ETF	375.15	375.78	375.0	375.44	482487.0
2022-06-13 17:00:00	SPY	ETF	375.43	375.75	375.35	375.74	59156.0
2022-06-13 17:30:00	SPY	ETF	375.6	375.78	375.56	375.75	44559.0
2022-06-13 18:00:00	SPY	ETF	375.75	376.68	375.75	376.6	125996.0
2022-06-13 18:30:00	SPY	ETF	376.59	376.68	376.17	376.26	61782.0
2022-06-13 19:00:00	SPY	ETF	376.3	376.3	375.6	375.96	76084.0
2022-06-13 19:30:00	SPY	ETF	375.94	376.04	375.3	376.04	68826.0
2022-06-13 04:00:00	QQQ	ETF	281.94	283.64	278.94	279.86	304698.0
2022-06-13 04:30:00	QQQ	ETF	279.8	280.88	279.8	279.97	77605.0
2022-06-13 05:00:00	QQQ	ETF	279.97	280.84	279.87	280.16	91105.0
2022-06-13 05:30:00	QQQ	ETF	280.16	280.45	279.52	280.3	94760.0
2022-06-13 06:00:00	QQQ	ETF	280.48	281.15	280.24	280.67	85282.0
2022-06-13 06:30:00	QQQ	ETF	280.55	281.33	280.54	280.91	189101.0
2022-06-13 07:00:00	QQQ	ETF	280.95	281.47	280.0	280.36	367669.0
2022-06-13 07:30:00	QQQ	ETF	280.35	280.8	279.56	279.71	411899.0
2022-06-13 08:00:00	QQQ	ETF	281.2	289.056	279.2796	280.99	748807.0
2022-06-13 08:30:00	QQQ	ETF	280.97	281.21	280.35	280.38	361532.0
2022-06-13 09:00:00	QQQ	ETF	280.36	280.76	279.61	279.75	529265.0
2022-06-13 09:30:00	QQQ	ETF	279.75	282.34	279.64	280.14	8146902.0
2022-06-13 10:00:00	QQQ	ETF	280.14	281.14	277.67	277.98	5830885.0
2022-06-13 10:30:00	QQQ	ETF	277.99	278.72	276.68	277.04	4898610.0
2022-06-13 11:00:00	QQQ	ETF	277.07	278.69	276.07	277.815	5205067.0
2022-06-13 11:30:00	QQQ	ETF	277.81	279.16	277.37	278.33	3959833.0
2022-06-13 12:00:00	QQQ	ETF	278.33	279.36	277.76	279.09	3316761.0
2022-06-13 12:30:00	QQQ	ETF	279.02	281.22	278.39	278.5	3518005.0

> showing 50 of 29,767 rows — these rows as CSV

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