PREVIEW / etf_30min / 2022-09-08

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-09-08.parquet
  size:    639 KB
  rows:    25,603

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-09-08 04:00:00	SPY	ETF	397.25	397.51	396.81	397.32	148157.0
2022-09-08 04:30:00	SPY	ETF	397.26	397.77	397.21	397.76	2160.0
2022-09-08 05:00:00	SPY	ETF	397.89	397.91	397.5	397.64	8579.0
2022-09-08 05:30:00	SPY	ETF	397.44	397.81	397.38	397.78	59602.0
2022-09-08 06:00:00	SPY	ETF	397.9	397.9	397.5	397.78	15353.0
2022-09-08 06:30:00	SPY	ETF	397.87	398.46	397.71	398.12	23886.0
2022-09-08 07:00:00	SPY	ETF	398.24	398.83	397.95	398.14	111893.0
2022-09-08 07:30:00	SPY	ETF	398.05	398.05	397.5	397.8	131037.0
2022-09-08 08:00:00	SPY	ETF	398.3501	399.07	397.18	397.76	334526.0
2022-09-08 08:30:00	SPY	ETF	397.71	397.84	396.05	396.18	572697.0
2022-09-08 09:00:00	SPY	ETF	396.06	396.25	395.11	395.3	1005665.0
2022-09-08 09:30:00	SPY	ETF	395.3	397.7	394.12	397.32	7725523.0
2022-09-08 10:00:00	SPY	ETF	397.33	398.49	395.741	397.87	4502698.0
2022-09-08 10:30:00	SPY	ETF	397.82	399.99	397.5	399.9	3929005.0
2022-09-08 11:00:00	SPY	ETF	399.905	400.86	399.8	400.28	3639887.0
2022-09-08 11:30:00	SPY	ETF	400.33	400.68	399.18	399.49	3114312.0
2022-09-08 12:00:00	SPY	ETF	399.51	399.69	395.05	396.19	7142239.0
2022-09-08 12:30:00	SPY	ETF	396.18	398.41	396.01	397.88	4178820.0
2022-09-08 13:00:00	SPY	ETF	397.89	399.55	397.1001	399.16	3628910.0
2022-09-08 13:30:00	SPY	ETF	399.17	399.86	398.18	398.99	3073846.0
2022-09-08 14:00:00	SPY	ETF	398.97	399.63	398.68	399.305	2644614.0
2022-09-08 14:30:00	SPY	ETF	399.34	400.08	398.3	398.55	3342471.0
2022-09-08 15:00:00	SPY	ETF	398.56	399.54	397.84	399.14	3009432.0
2022-09-08 15:30:00	SPY	ETF	399.16	400.49	398.33	400.4	6792942.0
2022-09-08 16:00:00	SPY	ETF	400.4	400.94	400.37	400.8	3788808.0
2022-09-08 16:30:00	SPY	ETF	400.83	400.9	400.38	400.85	141431.0
2022-09-08 17:00:00	SPY	ETF	400.84	400.94	400.75	400.88	25127.0
2022-09-08 17:30:00	SPY	ETF	400.8	400.84	400.73	400.7999	20186.0
2022-09-08 18:00:00	SPY	ETF	400.83	400.85	400.43	400.43	53195.0
2022-09-08 18:30:00	SPY	ETF	400.43	400.65	400.4	400.6	10715.0
2022-09-08 19:00:00	SPY	ETF	400.69	401.02	400.69	400.97	10133.0
2022-09-08 19:30:00	SPY	ETF	401.01	401.01	400.38	400.77	42653.0
2022-09-08 04:00:00	QQQ	ETF	298.88	298.88	298.09	298.72	45656.0
2022-09-08 04:30:00	QQQ	ETF	298.77	299.13	298.6	299.13	3868.0
2022-09-08 05:00:00	QQQ	ETF	299.13	299.17	298.85	298.93	7523.0
2022-09-08 05:30:00	QQQ	ETF	298.78	299.02	298.67	298.95	3748.0
2022-09-08 06:00:00	QQQ	ETF	299.01	299.09	298.75	299.04	8604.0
2022-09-08 06:30:00	QQQ	ETF	299.07	299.48	298.89	299.2	21063.0
2022-09-08 07:00:00	QQQ	ETF	299.27	299.76	299.0	299.15	82552.0
2022-09-08 07:30:00	QQQ	ETF	299.15	299.15	298.55	298.75	119874.0
2022-09-08 08:00:00	QQQ	ETF	298.85	300.25	298.33	298.78	325863.0
2022-09-08 08:30:00	QQQ	ETF	298.71	298.81	296.93	297.11	698712.0
2022-09-08 09:00:00	QQQ	ETF	297.04	297.3	296.36	296.88	880956.0
2022-09-08 09:30:00	QQQ	ETF	296.85	299.23	295.45	298.62	6314453.0
2022-09-08 10:00:00	QQQ	ETF	298.66	299.62	296.98	298.78	3245060.0
2022-09-08 10:30:00	QQQ	ETF	298.71	300.96	298.3801	300.94	2817676.0
2022-09-08 11:00:00	QQQ	ETF	300.93	301.87	300.9075	301.35	2391229.0
2022-09-08 11:30:00	QQQ	ETF	301.36	301.62	300.085	300.34	2071302.0
2022-09-08 12:00:00	QQQ	ETF	300.3	300.5	295.99	296.9124	5053864.0
2022-09-08 12:30:00	QQQ	ETF	296.93	298.6683	296.77	298.2	2463141.0

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

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