PREVIEW / etf_30min / 2022-02-16

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-02-16.parquet
  size:    651 KB
  rows:    25,681

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-02-16 04:00:00	SPY	ETF	446.99	447.75	446.01	446.42	31614.0
2022-02-16 04:30:00	SPY	ETF	446.75	446.76	445.88	445.9	39947.0
2022-02-16 05:00:00	SPY	ETF	445.8	445.98	444.75	445.09	34858.0
2022-02-16 05:30:00	SPY	ETF	445.07	445.73	445.07	445.67	12147.0
2022-02-16 06:00:00	SPY	ETF	445.64	445.87	445.18	445.36	14767.0
2022-02-16 06:30:00	SPY	ETF	445.33	445.95	445.33	445.85	17659.0
2022-02-16 07:00:00	SPY	ETF	445.64	446.0	445.61	445.81	72842.0
2022-02-16 07:30:00	SPY	ETF	445.8	445.82	444.73	445.02	161644.0
2022-02-16 08:00:00	SPY	ETF	445.9001	447.0996	444.77	445.11	133185.0
2022-02-16 08:30:00	SPY	ETF	445.02	446.04	444.02	444.15	408362.0
2022-02-16 09:00:00	SPY	ETF	444.32	444.32	443.61	443.97	374769.0
2022-02-16 09:30:00	SPY	ETF	443.93	444.81	442.42	442.77	7163605.0
2022-02-16 10:00:00	SPY	ETF	442.77	443.42	442.25	443.29	4689886.0
2022-02-16 10:30:00	SPY	ETF	443.29	443.59	442.8	443.0	3106544.0
2022-02-16 11:00:00	SPY	ETF	443.03	443.76	442.761	443.67	2606440.0
2022-02-16 11:30:00	SPY	ETF	443.66	443.73	442.98	443.62	2204006.0
2022-02-16 12:00:00	SPY	ETF	443.61	443.97	443.25	443.305	2042205.0
2022-02-16 12:30:00	SPY	ETF	443.3	443.305	441.94	442.88	3376111.0
2022-02-16 13:00:00	SPY	ETF	442.86	443.36	442.52	443.07	1719332.0
2022-02-16 13:30:00	SPY	ETF	443.08	443.18	442.5	442.97	2058286.0
2022-02-16 14:00:00	SPY	ETF	442.9603	446.29	442.02	446.175	9196871.0
2022-02-16 14:30:00	SPY	ETF	446.18	447.21	445.29	446.58	6196011.0
2022-02-16 15:00:00	SPY	ETF	446.6	447.68	446.33	447.41	5836575.0
2022-02-16 15:30:00	SPY	ETF	447.415	448.055	446.26	446.61	9800796.0
2022-02-16 16:00:00	SPY	ETF	446.62	446.78	446.01	446.47	3920596.0
2022-02-16 16:30:00	SPY	ETF	446.35	446.54	446.0	446.16	114359.0
2022-02-16 17:00:00	SPY	ETF	446.1	446.51	446.09	446.5	31047.0
2022-02-16 17:30:00	SPY	ETF	446.49	446.52	446.11	446.13	82683.0
2022-02-16 18:00:00	SPY	ETF	446.16	446.95	446.16	446.89	91664.0
2022-02-16 18:30:00	SPY	ETF	446.89	447.04	445.68	445.75	209135.0
2022-02-16 19:00:00	SPY	ETF	445.8	445.84	445.49	445.69	30055.0
2022-02-16 19:30:00	SPY	ETF	445.7	446.02	445.64	445.8199	60716.0
2022-02-16 04:00:00	QQQ	ETF	356.86	357.61	356.14	356.27	46082.0
2022-02-16 04:30:00	QQQ	ETF	356.54	356.56	356.09	356.17	21975.0
2022-02-16 05:00:00	QQQ	ETF	356.09	356.35	355.24	355.51	18772.0
2022-02-16 05:30:00	QQQ	ETF	355.46	356.0	355.46	355.88	8546.0
2022-02-16 06:00:00	QQQ	ETF	356.04	356.05	355.61	355.89	22057.0
2022-02-16 06:30:00	QQQ	ETF	355.9	356.33	355.85	356.28	47488.0
2022-02-16 07:00:00	QQQ	ETF	356.19	356.56	356.06	356.22	64956.0
2022-02-16 07:30:00	QQQ	ETF	356.11	356.12	355.02	355.4	148280.0
2022-02-16 08:00:00	QQQ	ETF	356.5005	357.44	355.05	355.54	170050.0
2022-02-16 08:30:00	QQQ	ETF	355.46	356.16	354.0	354.22	464746.0
2022-02-16 09:00:00	QQQ	ETF	354.25	354.34	353.51	353.91	352201.0
2022-02-16 09:30:00	QQQ	ETF	353.92	353.95	350.71	351.365	6688735.0
2022-02-16 10:00:00	QQQ	ETF	351.33	352.2	350.83	351.945	4331302.0
2022-02-16 10:30:00	QQQ	ETF	351.94	352.78	351.54	352.26	2949612.0
2022-02-16 11:00:00	QQQ	ETF	352.28	353.0887	351.69	352.415	2311953.0
2022-02-16 11:30:00	QQQ	ETF	352.41	352.66	351.83	352.5816	1528681.0
2022-02-16 12:00:00	QQQ	ETF	352.5798	352.9569	351.89	352.12	1568576.0
2022-02-16 12:30:00	QQQ	ETF	352.11	352.14	350.81	351.5	2532759.0

> showing 50 of 25,681 rows — these rows as CSV

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