PREVIEW / etf_30min / 2022-08-30

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-08-30.parquet
  size:    651 KB
  rows:    26,016

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-08-30 04:00:00	SPY	ETF	404.9	406.73	404.9	406.48	135850.0
2022-08-30 04:30:00	SPY	ETF	406.43	406.46	405.9	406.0	60760.0
2022-08-30 05:00:00	SPY	ETF	406.05	406.05	405.47	405.8	29476.0
2022-08-30 05:30:00	SPY	ETF	405.79	406.39	405.79	406.15	148977.0
2022-08-30 06:00:00	SPY	ETF	406.13	406.65	406.01	406.13	193853.0
2022-08-30 06:30:00	SPY	ETF	406.2	406.32	405.81	405.81	95321.0
2022-08-30 07:00:00	SPY	ETF	405.71	406.03	405.42	405.65	139906.0
2022-08-30 07:30:00	SPY	ETF	405.63	405.82	405.08	405.22	128172.0
2022-08-30 08:00:00	SPY	ETF	405.25	406.37	403.36	404.78	395624.0
2022-08-30 08:30:00	SPY	ETF	404.71	404.71	404.03	404.04	258731.0
2022-08-30 09:00:00	SPY	ETF	404.06	404.3	403.66	403.83	281329.0
2022-08-30 09:30:00	SPY	ETF	403.85	404.1	401.5415	401.865	5250923.0
2022-08-30 10:00:00	SPY	ETF	401.88	402.4	399.61	400.05	5293938.0
2022-08-30 10:30:00	SPY	ETF	400.05	400.29	396.38	398.3699	7704830.0
2022-08-30 11:00:00	SPY	ETF	398.38	399.34	397.78	398.7499	5523890.0
2022-08-30 11:30:00	SPY	ETF	398.72	399.605	398.06	398.731	3549553.0
2022-08-30 12:00:00	SPY	ETF	398.74	399.96	398.35	398.78	3376883.0
2022-08-30 12:30:00	SPY	ETF	398.77	398.81	397.41	398.0	2665604.0
2022-08-30 13:00:00	SPY	ETF	398.01	398.4	396.6	397.21	2809037.0
2022-08-30 13:30:00	SPY	ETF	397.21	397.82	396.0	397.395	3216860.0
2022-08-30 14:00:00	SPY	ETF	397.4	398.08	396.92	396.95	3460320.0
2022-08-30 14:30:00	SPY	ETF	396.97	397.85	396.84	397.33	3010398.0
2022-08-30 15:00:00	SPY	ETF	397.336	399.38	397.2	398.48	5258600.0
2022-08-30 15:30:00	SPY	ETF	398.47	398.83	397.08	398.18	9372694.0
2022-08-30 16:00:00	SPY	ETF	398.17	398.75	398.09	398.33	3231862.0
2022-08-30 16:30:00	SPY	ETF	398.38	398.52	397.97	398.23	123308.0
2022-08-30 17:00:00	SPY	ETF	398.16	398.22	398.03	398.15	30142.0
2022-08-30 17:30:00	SPY	ETF	398.1	398.17	398.0	398.17	18602.0
2022-08-30 18:00:00	SPY	ETF	398.19	398.32	397.91	397.95	53253.0
2022-08-30 18:30:00	SPY	ETF	398.0	398.46	398.0	398.4	28075.0
2022-08-30 19:00:00	SPY	ETF	398.4	398.4	398.0	398.1	114682.0
2022-08-30 19:30:00	SPY	ETF	397.96	398.34	397.8	398.34	29914.0
2022-08-30 04:00:00	QQQ	ETF	307.0	308.39	307.0	308.35	66427.0
2022-08-30 04:30:00	QQQ	ETF	308.24	308.24	307.77	307.81	21229.0
2022-08-30 05:00:00	QQQ	ETF	307.82	307.92	307.33	307.6	22191.0
2022-08-30 05:30:00	QQQ	ETF	307.58	308.14	307.58	307.95	152314.0
2022-08-30 06:00:00	QQQ	ETF	307.69	308.27	307.69	308.02	30908.0
2022-08-30 06:30:00	QQQ	ETF	308.12	308.12	307.7	307.7	22514.0
2022-08-30 07:00:00	QQQ	ETF	307.72	307.89	307.44	307.57	258011.0
2022-08-30 07:30:00	QQQ	ETF	307.55	307.7	307.03	307.2	181590.0
2022-08-30 08:00:00	QQQ	ETF	307.2	308.3796	304.638	306.67	162660.0
2022-08-30 08:30:00	QQQ	ETF	306.63	306.63	306.04	306.1	238958.0
2022-08-30 09:00:00	QQQ	ETF	306.08	306.48	305.86	306.09	271545.0
2022-08-30 09:30:00	QQQ	ETF	306.1	306.73	303.68	304.09	4849414.0
2022-08-30 10:00:00	QQQ	ETF	304.13	304.48	301.78	302.25	3891102.0
2022-08-30 10:30:00	QQQ	ETF	302.24	302.4599	298.97	300.83	5673328.0
2022-08-30 11:00:00	QQQ	ETF	300.83	301.33	299.88	300.8	3815058.0
2022-08-30 11:30:00	QQQ	ETF	300.76	301.69	300.1606	300.815	2080103.0
2022-08-30 12:00:00	QQQ	ETF	300.76	302.0283	300.48	300.84	1903632.0
2022-08-30 12:30:00	QQQ	ETF	300.79	300.86	299.48	300.05	1653757.0

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

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