PREVIEW / etf_30min / 2022-11-28

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-11-28.parquet
  size:    685 KB
  rows:    27,226

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-11-28 04:00:00	SPY	ETF	400.91	400.91	399.19	399.76	26496.0
2022-11-28 04:30:00	SPY	ETF	399.61	399.73	398.38	398.55	25638.0
2022-11-28 05:00:00	SPY	ETF	398.51	399.08	398.31	399.07	26639.0
2022-11-28 05:30:00	SPY	ETF	399.1	399.25	398.79	398.95	11525.0
2022-11-28 06:00:00	SPY	ETF	398.95	399.52	398.84	399.24	22183.0
2022-11-28 06:30:00	SPY	ETF	399.21	399.32	398.72	399.32	69839.0
2022-11-28 07:00:00	SPY	ETF	399.33	399.65	399.2	399.38	123099.0
2022-11-28 07:30:00	SPY	ETF	399.4	399.6	399.29	399.4	105825.0
2022-11-28 08:00:00	SPY	ETF	399.42	400.6	398.4596	399.3	189871.0
2022-11-28 08:30:00	SPY	ETF	399.3	399.53	399.19	399.2801	124622.0
2022-11-28 09:00:00	SPY	ETF	399.3	399.31	398.69	399.01	184509.0
2022-11-28 09:30:00	SPY	ETF	399.09	400.81	399.0	399.8671	4511199.0
2022-11-28 10:00:00	SPY	ETF	399.85	400.24	398.8252	399.35	3600587.0
2022-11-28 10:30:00	SPY	ETF	399.3	399.55	398.41	398.51	2780978.0
2022-11-28 11:00:00	SPY	ETF	398.51	398.87	398.19	398.54	2203320.0
2022-11-28 11:30:00	SPY	ETF	398.54	399.08	398.3501	398.872	2172256.0
2022-11-28 12:00:00	SPY	ETF	398.88	399.44	397.5813	398.53	4165164.0
2022-11-28 12:30:00	SPY	ETF	398.53	398.9799	397.58	397.65	2073927.0
2022-11-28 13:00:00	SPY	ETF	397.65	398.0277	397.47	397.7921	1830366.0
2022-11-28 13:30:00	SPY	ETF	397.8	397.85	396.4432	396.57	2343743.0
2022-11-28 14:00:00	SPY	ETF	396.57	396.76	395.88	396.005	3146795.0
2022-11-28 14:30:00	SPY	ETF	396.0	396.43	395.81	395.99	2107544.0
2022-11-28 15:00:00	SPY	ETF	396.025	396.09	395.11	395.2378	3797399.0
2022-11-28 15:30:00	SPY	ETF	395.24	396.27	395.12	395.92	8522543.0
2022-11-28 16:00:00	SPY	ETF	395.925	396.35	395.91	396.26	6404059.0
2022-11-28 16:30:00	SPY	ETF	396.23	396.37	396.15	396.23	90452.0
2022-11-28 17:00:00	SPY	ETF	396.22	396.28	396.05	396.28	19752.0
2022-11-28 17:30:00	SPY	ETF	396.2	396.2	396.1	396.2	15303.0
2022-11-28 18:00:00	SPY	ETF	396.25	396.29	396.04	396.15	46184.0
2022-11-28 18:30:00	SPY	ETF	396.21	396.25	396.1	396.19	28257.0
2022-11-28 19:00:00	SPY	ETF	396.13	396.46	396.02	396.43	46906.0
2022-11-28 19:30:00	SPY	ETF	396.42	396.54	396.24	396.44	38613.0
2022-11-28 04:00:00	QQQ	ETF	284.87	285.02	284.56	284.77	27037.0
2022-11-28 04:30:00	QQQ	ETF	284.68	284.81	283.6	283.66	51829.0
2022-11-28 05:00:00	QQQ	ETF	283.66	284.15	283.48	284.15	30347.0
2022-11-28 05:30:00	QQQ	ETF	284.2	284.33	284.01	284.15	10748.0
2022-11-28 06:00:00	QQQ	ETF	284.16	284.58	284.04	284.46	26606.0
2022-11-28 06:30:00	QQQ	ETF	284.38	284.71	284.08	284.66	31836.0
2022-11-28 07:00:00	QQQ	ETF	284.72	285.04	284.61	284.77	95377.0
2022-11-28 07:30:00	QQQ	ETF	284.78	284.98	284.7	284.85	27757.0
2022-11-28 08:00:00	QQQ	ETF	284.68	287.135	284.0404	284.76	139066.0
2022-11-28 08:30:00	QQQ	ETF	284.77	285.16	284.71	285.13	173627.0
2022-11-28 09:00:00	QQQ	ETF	285.16	285.16	284.6	284.86	213988.0
2022-11-28 09:30:00	QQQ	ETF	284.9	286.96	284.66	286.2095	3707091.0
2022-11-28 10:00:00	QQQ	ETF	286.205	286.475	284.36	284.8	2450259.0
2022-11-28 10:30:00	QQQ	ETF	284.79	285.22	284.29	284.45	2818071.0
2022-11-28 11:00:00	QQQ	ETF	284.4334	285.02	284.1	284.63	1442333.0
2022-11-28 11:30:00	QQQ	ETF	284.6407	285.2	284.4199	285.07	1322339.0
2022-11-28 12:00:00	QQQ	ETF	285.075	285.62	283.9	284.73	2289280.0
2022-11-28 12:30:00	QQQ	ETF	284.74	285.27	283.96	284.02	1341702.0

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

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