PREVIEW / etf_30min / 2022-06-24

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-06-24.parquet
  size:    666 KB
  rows:    26,349

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-06-24 04:00:00	SPY	ETF	380.77	381.25	380.0	380.5	31598.0
2022-06-24 04:30:00	SPY	ETF	380.61	380.95	380.48	380.84	23840.0
2022-06-24 05:00:00	SPY	ETF	380.8	381.16	380.65	380.76	13617.0
2022-06-24 05:30:00	SPY	ETF	380.8	381.28	380.65	381.28	15262.0
2022-06-24 06:00:00	SPY	ETF	381.31	381.7	381.14	381.18	81129.0
2022-06-24 06:30:00	SPY	ETF	381.2	381.5	380.95	381.11	34313.0
2022-06-24 07:00:00	SPY	ETF	381.07	381.31	380.93	381.31	156836.0
2022-06-24 07:30:00	SPY	ETF	381.39	381.6	380.6	380.84	221046.0
2022-06-24 08:00:00	SPY	ETF	381.2001	381.6	377.31	380.82	244564.0
2022-06-24 08:30:00	SPY	ETF	380.85	381.1799	380.67	380.84	258173.0
2022-06-24 09:00:00	SPY	ETF	380.8	381.6	380.74	381.4	201078.0
2022-06-24 09:30:00	SPY	ETF	381.4	384.14	381.365	383.785	8344491.0
2022-06-24 10:00:00	SPY	ETF	383.83	387.17	383.8	386.5	9143486.0
2022-06-24 10:30:00	SPY	ETF	386.53	386.84	385.67	386.49	4148788.0
2022-06-24 11:00:00	SPY	ETF	386.49	387.23	385.96	386.91	4029857.0
2022-06-24 11:30:00	SPY	ETF	386.92	387.23	386.48	387.01	2961633.0
2022-06-24 12:00:00	SPY	ETF	387.02	387.46	386.75	386.87	2217991.0
2022-06-24 12:30:00	SPY	ETF	386.8922	387.34	386.54	387.225	1982983.0
2022-06-24 13:00:00	SPY	ETF	387.23	387.63	387.05	387.2414	2344353.0
2022-06-24 13:30:00	SPY	ETF	387.24	387.45	386.81	386.99	2510313.0
2022-06-24 14:00:00	SPY	ETF	386.9953	387.46	386.77	387.33	1829121.0
2022-06-24 14:30:00	SPY	ETF	387.35	387.92	387.26	387.85	2999635.0
2022-06-24 15:00:00	SPY	ETF	387.87	388.15	387.62	388.08	4214705.0
2022-06-24 15:30:00	SPY	ETF	388.08	390.09	387.71	390.05	15811243.0
2022-06-24 16:00:00	SPY	ETF	390.04	390.08	388.69	388.79	6375815.0
2022-06-24 16:30:00	SPY	ETF	388.74	390.08	388.64	389.59	504544.0
2022-06-24 17:00:00	SPY	ETF	389.64	389.64	389.3	389.45	80381.0
2022-06-24 17:30:00	SPY	ETF	389.47	390.08	389.12	389.33	894056.0
2022-06-24 18:00:00	SPY	ETF	389.35	389.5	389.3	389.36	7552.0
2022-06-24 18:30:00	SPY	ETF	389.4	389.58	389.4	389.55	11070.0
2022-06-24 19:00:00	SPY	ETF	389.55	389.55	389.3	389.47	18280.0
2022-06-24 19:30:00	SPY	ETF	389.47	389.94	389.38	389.63	30947.0
2022-06-24 04:00:00	QQQ	ETF	286.32	288.15	286.32	287.38	130620.0
2022-06-24 04:30:00	QQQ	ETF	287.38	287.67	287.28	287.56	26070.0
2022-06-24 05:00:00	QQQ	ETF	287.51	287.81	287.35	287.42	23307.0
2022-06-24 05:30:00	QQQ	ETF	287.36	287.84	287.29	287.84	17520.0
2022-06-24 06:00:00	QQQ	ETF	287.84	288.04	287.7	287.73	54147.0
2022-06-24 06:30:00	QQQ	ETF	287.69	287.93	287.56	287.66	35477.0
2022-06-24 07:00:00	QQQ	ETF	287.55	287.73	287.44	287.73	128518.0
2022-06-24 07:30:00	QQQ	ETF	287.74	287.91	286.88	287.05	235083.0
2022-06-24 08:00:00	QQQ	ETF	287.5299	287.92	285.063	287.06	282567.0
2022-06-24 08:30:00	QQQ	ETF	287.05	287.38	286.99	287.16	159491.0
2022-06-24 09:00:00	QQQ	ETF	287.12	287.89	287.08	287.76	280465.0
2022-06-24 09:30:00	QQQ	ETF	287.77	291.04	287.5001	290.32	7115118.0
2022-06-24 10:00:00	QQQ	ETF	290.34	293.41	290.34	292.55	6367382.0
2022-06-24 10:30:00	QQQ	ETF	292.59	292.9	291.15	291.74	3113591.0
2022-06-24 11:00:00	QQQ	ETF	291.74	292.42	290.67	291.5001	2827929.0
2022-06-24 11:30:00	QQQ	ETF	291.51	291.78	290.93	291.7466	1928139.0
2022-06-24 12:00:00	QQQ	ETF	291.76	292.17	291.541	291.78	1587370.0
2022-06-24 12:30:00	QQQ	ETF	291.8	292.15	291.25	292.07	1023175.0

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

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