PREVIEW / etf_30min / 2022-10-25

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-10-25.parquet
  size:    686 KB
  rows:    27,596

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-10-25 04:00:00	SPY	ETF	378.0	379.25	378.0	378.61	38265.0
2022-10-25 04:30:00	SPY	ETF	378.61	379.02	378.01	378.11	30482.0
2022-10-25 05:00:00	SPY	ETF	378.08	378.09	377.69	377.7	10795.0
2022-10-25 05:30:00	SPY	ETF	377.6	377.65	376.96	377.38	39283.0
2022-10-25 06:00:00	SPY	ETF	377.3	377.73	376.92	377.51	16849.0
2022-10-25 06:30:00	SPY	ETF	377.48	377.85	377.31	377.76	16330.0
2022-10-25 07:00:00	SPY	ETF	377.83	378.36	377.49	378.3	101334.0
2022-10-25 07:30:00	SPY	ETF	378.24	378.42	377.53	377.54	142578.0
2022-10-25 08:00:00	SPY	ETF	377.88	379.6	376.97	377.42	481561.0
2022-10-25 08:30:00	SPY	ETF	377.39	377.86	377.0	377.8	240555.0
2022-10-25 09:00:00	SPY	ETF	377.82	379.06	377.8	378.74	385466.0
2022-10-25 09:30:00	SPY	ETF	378.79	382.6	378.71	382.37	8436285.0
2022-10-25 10:00:00	SPY	ETF	382.4	382.78	381.29	382.78	6495782.0
2022-10-25 10:30:00	SPY	ETF	382.78	382.99	381.8	382.22	3986320.0
2022-10-25 11:00:00	SPY	ETF	382.23	383.41	382.03	383.26	3513932.0
2022-10-25 11:30:00	SPY	ETF	383.26	383.89	383.06	383.49	2852878.0
2022-10-25 12:00:00	SPY	ETF	383.5	384.21	383.23	383.69	2683499.0
2022-10-25 12:30:00	SPY	ETF	383.6701	383.86	382.95	383.08	2410183.0
2022-10-25 13:00:00	SPY	ETF	383.085	383.48	382.305	382.98	3115261.0
2022-10-25 13:30:00	SPY	ETF	382.99	383.58	382.48	382.97	2998749.0
2022-10-25 14:00:00	SPY	ETF	382.97	384.04	382.8865	384.03	2883684.0
2022-10-25 14:30:00	SPY	ETF	384.015	384.46	383.48	383.55	2925084.0
2022-10-25 15:00:00	SPY	ETF	383.55	384.8	383.52	384.755	3960048.0
2022-10-25 15:30:00	SPY	ETF	384.755	385.25	384.455	384.87	10694927.0
2022-10-25 16:00:00	SPY	ETF	384.87	385.05	382.37	382.73	4436019.0
2022-10-25 16:30:00	SPY	ETF	382.73	384.92	382.6956	383.19	279550.0
2022-10-25 17:00:00	SPY	ETF	383.27	383.29	382.15	382.16	118138.0
2022-10-25 17:30:00	SPY	ETF	382.16	384.92	381.75	381.81	323265.0
2022-10-25 18:00:00	SPY	ETF	381.9	382.0	381.18	381.86	273133.0
2022-10-25 18:30:00	SPY	ETF	381.86	381.94	381.15	381.16	53674.0
2022-10-25 19:00:00	SPY	ETF	381.17	381.18	380.63	380.95	103204.0
2022-10-25 19:30:00	SPY	ETF	380.93	381.32	380.87	381.15	62057.0
2022-10-25 04:00:00	QQQ	ETF	278.88	279.2	278.7	278.75	45199.0
2022-10-25 04:30:00	QQQ	ETF	278.81	279.08	278.3	278.4	19910.0
2022-10-25 05:00:00	QQQ	ETF	278.34	278.34	278.05	278.25	12336.0
2022-10-25 05:30:00	QQQ	ETF	278.02	278.13	277.61	278.0	28006.0
2022-10-25 06:00:00	QQQ	ETF	277.92	278.2	277.64	278.04	39208.0
2022-10-25 06:30:00	QQQ	ETF	278.02	278.53	278.02	278.48	26153.0
2022-10-25 07:00:00	QQQ	ETF	278.52	278.87	278.13	278.85	97863.0
2022-10-25 07:30:00	QQQ	ETF	278.76	278.89	278.19	278.24	133766.0
2022-10-25 08:00:00	QQQ	ETF	278.22	278.99	277.78	278.29	247312.0
2022-10-25 08:30:00	QQQ	ETF	278.29	278.54	277.86	278.5	158530.0
2022-10-25 09:00:00	QQQ	ETF	278.5	279.69	278.5	279.42	804542.0
2022-10-25 09:30:00	QQQ	ETF	279.41	283.06	279.4	282.71	7138533.0
2022-10-25 10:00:00	QQQ	ETF	282.73	283.03	281.9	282.67	4353767.0
2022-10-25 10:30:00	QQQ	ETF	282.68	282.68	281.624	282.17	3384354.0
2022-10-25 11:00:00	QQQ	ETF	282.1632	283.37	282.0	283.28	2476027.0
2022-10-25 11:30:00	QQQ	ETF	283.275	283.82	283.06	283.5	2029430.0
2022-10-25 12:00:00	QQQ	ETF	283.505	284.03	283.22	283.69	1724971.0
2022-10-25 12:30:00	QQQ	ETF	283.67	283.7799	282.6	282.76	1779135.0

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

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