PREVIEW / etf_30min / 2022-11-14

all etf 30-min files

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

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-14 04:00:00	SPY	ETF	398.0	398.0	396.38	396.55	54482.0
2022-11-14 04:30:00	SPY	ETF	396.65	397.1	396.43	396.43	31561.0
2022-11-14 05:00:00	SPY	ETF	396.51	397.07	396.2	397.07	25691.0
2022-11-14 05:30:00	SPY	ETF	396.94	396.97	396.5	396.93	9420.0
2022-11-14 06:00:00	SPY	ETF	396.91	397.05	396.62	396.95	15213.0
2022-11-14 06:30:00	SPY	ETF	396.9	397.3	396.82	396.9	27927.0
2022-11-14 07:00:00	SPY	ETF	396.96	397.31	396.8	397.3	74137.0
2022-11-14 07:30:00	SPY	ETF	397.37	397.6	397.23	397.57	43895.0
2022-11-14 08:00:00	SPY	ETF	397.55	397.91	396.5	397.38	178804.0
2022-11-14 08:30:00	SPY	ETF	397.41	397.69	396.89	397.04	196167.0
2022-11-14 09:00:00	SPY	ETF	397.08	397.58	396.45	396.64	316328.0
2022-11-14 09:30:00	SPY	ETF	396.66	397.8	395.92	397.1255	6175674.0
2022-11-14 10:00:00	SPY	ETF	397.14	398.97	397.13	397.9	4154811.0
2022-11-14 10:30:00	SPY	ETF	397.915	398.81	397.61	398.43	2943219.0
2022-11-14 11:00:00	SPY	ETF	398.425	398.62	396.35	396.8361	3458243.0
2022-11-14 11:30:00	SPY	ETF	396.8201	398.49	396.58	397.89	2830435.0
2022-11-14 12:00:00	SPY	ETF	397.8899	398.69	397.39	398.39	2166639.0
2022-11-14 12:30:00	SPY	ETF	398.4	399.23	398.35	398.62	2082606.0
2022-11-14 13:00:00	SPY	ETF	398.62	400.09	398.39	399.97	2597439.0
2022-11-14 13:30:00	SPY	ETF	399.97	400.17	399.621	400.1001	2266933.0
2022-11-14 14:00:00	SPY	ETF	400.1	400.1799	399.2054	399.75	2640207.0
2022-11-14 14:30:00	SPY	ETF	399.76	399.875	398.53	398.75	2287996.0
2022-11-14 15:00:00	SPY	ETF	398.78	399.49	397.44	397.82	3261702.0
2022-11-14 15:30:00	SPY	ETF	397.84	397.91	394.83	395.18	10110490.0
2022-11-14 16:00:00	SPY	ETF	395.18	397.9008	394.9763	395.51	3879564.0
2022-11-14 16:30:00	SPY	ETF	395.47	395.98	395.37	395.93	267549.0
2022-11-14 17:00:00	SPY	ETF	396.0	396.07	395.73	395.81	111522.0
2022-11-14 17:30:00	SPY	ETF	395.89	396.06	395.88	396.0	32049.0
2022-11-14 18:00:00	SPY	ETF	395.97	396.12	395.87	396.03	60156.0
2022-11-14 18:30:00	SPY	ETF	396.1	396.3	395.86	395.86	61085.0
2022-11-14 19:00:00	SPY	ETF	395.85	396.03	395.73	395.86	26909.0
2022-11-14 19:30:00	SPY	ETF	395.9	396.0	395.61	395.68	66455.0
2022-11-14 04:00:00	QQQ	ETF	286.51	286.85	285.68	285.8	33747.0
2022-11-14 04:30:00	QQQ	ETF	286.02	286.22	285.75	285.75	12304.0
2022-11-14 05:00:00	QQQ	ETF	285.78	286.22	285.5	286.17	37123.0
2022-11-14 05:30:00	QQQ	ETF	286.23	286.26	285.75	286.06	19020.0
2022-11-14 06:00:00	QQQ	ETF	286.0	286.11	285.78	286.0	18250.0
2022-11-14 06:30:00	QQQ	ETF	286.0	286.32	285.98	286.04	35828.0
2022-11-14 07:00:00	QQQ	ETF	286.13	286.71	285.98	286.7	66648.0
2022-11-14 07:30:00	QQQ	ETF	286.66	286.84	286.48	286.77	103096.0
2022-11-14 08:00:00	QQQ	ETF	286.13	288.175	285.8296	286.47	206288.0
2022-11-14 08:30:00	QQQ	ETF	286.47	286.73	286.02	286.16	189940.0
2022-11-14 09:00:00	QQQ	ETF	286.15	286.54	285.66	285.84	295586.0
2022-11-14 09:30:00	QQQ	ETF	285.86	286.46	284.44	285.49	5462096.0
2022-11-14 10:00:00	QQQ	ETF	285.5	287.21	285.5	286.3419	4199314.0
2022-11-14 10:30:00	QQQ	ETF	286.38	287.25	285.91	286.73	3082501.0
2022-11-14 11:00:00	QQQ	ETF	286.72	286.8599	285.12	285.53	2455749.0
2022-11-14 11:30:00	QQQ	ETF	285.53	287.48	285.3201	286.9086	3159682.0
2022-11-14 12:00:00	QQQ	ETF	286.92	287.78	286.43	287.37	2384904.0
2022-11-14 12:30:00	QQQ	ETF	287.36	288.115	287.34	287.49	1622083.0

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

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