PREVIEW / etf_30min / 2022-05-26

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-05-26.parquet
  size:    680 KB
  rows:    26,398

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-05-26 04:00:00	SPY	ETF	398.7	398.76	397.48	397.53	40710.0
2022-05-26 04:30:00	SPY	ETF	397.5	397.5	396.64	397.0	21126.0
2022-05-26 05:00:00	SPY	ETF	396.89	397.77	396.89	397.45	11028.0
2022-05-26 05:30:00	SPY	ETF	397.48	398.54	397.43	398.33	10650.0
2022-05-26 06:00:00	SPY	ETF	398.3	398.75	398.0	398.03	25092.0
2022-05-26 06:30:00	SPY	ETF	398.0	398.95	397.76	398.88	39197.0
2022-05-26 07:00:00	SPY	ETF	398.66	400.7	398.56	400.6	187022.0
2022-05-26 07:30:00	SPY	ETF	400.57	400.66	399.71	399.92	122032.0
2022-05-26 08:00:00	SPY	ETF	399.16	400.65	396.0	399.4	324943.0
2022-05-26 08:30:00	SPY	ETF	399.05	400.2	398.47	399.8	289667.0
2022-05-26 09:00:00	SPY	ETF	399.8	399.85	398.51	398.69	388229.0
2022-05-26 09:30:00	SPY	ETF	398.67	402.81	398.45	402.57	6520901.0
2022-05-26 10:00:00	SPY	ETF	402.56	403.99	402.34	403.3083	4743418.0
2022-05-26 10:30:00	SPY	ETF	403.305	404.04	402.8479	404.0	3368299.0
2022-05-26 11:00:00	SPY	ETF	404.0	404.92	403.88	404.21	3377002.0
2022-05-26 11:30:00	SPY	ETF	404.22	404.67	403.68	404.44	2332172.0
2022-05-26 12:00:00	SPY	ETF	404.395	405.71	404.21	405.7023	2719454.0
2022-05-26 12:30:00	SPY	ETF	405.705	406.37	405.32	406.3273	3012383.0
2022-05-26 13:00:00	SPY	ETF	406.33	407.005	405.445	405.58	3820353.0
2022-05-26 13:30:00	SPY	ETF	405.62	406.35	405.51	406.25	2322163.0
2022-05-26 14:00:00	SPY	ETF	406.225	406.62	405.71	406.11	3332030.0
2022-05-26 14:30:00	SPY	ETF	406.13	406.27	405.38	406.015	2764559.0
2022-05-26 15:00:00	SPY	ETF	406.0	406.08	404.53	405.09	4930513.0
2022-05-26 15:30:00	SPY	ETF	405.07	407.04	404.96	405.29	12225828.0
2022-05-26 16:00:00	SPY	ETF	405.29	405.39	404.43	404.69	4000322.0
2022-05-26 16:30:00	SPY	ETF	404.69	405.31	404.6	404.9	186399.0
2022-05-26 17:00:00	SPY	ETF	404.93	405.04	404.65	404.74	68118.0
2022-05-26 17:30:00	SPY	ETF	404.72	404.85	404.4	404.4	38099.0
2022-05-26 18:00:00	SPY	ETF	404.54	405.46	404.53	405.13	104486.0
2022-05-26 18:30:00	SPY	ETF	405.15	405.26	404.92	405.06	27464.0
2022-05-26 19:00:00	SPY	ETF	405.03	405.3	405.0	405.28	47010.0
2022-05-26 19:30:00	SPY	ETF	405.27	405.6	405.25	405.42	40817.0
2022-05-26 04:00:00	QQQ	ETF	291.25	291.95	290.31	290.31	59393.0
2022-05-26 04:30:00	QQQ	ETF	290.35	290.43	289.52	290.02	46626.0
2022-05-26 05:00:00	QQQ	ETF	289.96	290.47	289.67	290.33	39806.0
2022-05-26 05:30:00	QQQ	ETF	290.35	291.11	290.3	290.95	29981.0
2022-05-26 06:00:00	QQQ	ETF	291.0	291.5	290.74	290.75	32716.0
2022-05-26 06:30:00	QQQ	ETF	290.74	291.65	290.59	291.34	60851.0
2022-05-26 07:00:00	QQQ	ETF	291.29	293.05	291.22	292.95	318784.0
2022-05-26 07:30:00	QQQ	ETF	292.98	292.99	291.89	292.0	219520.0
2022-05-26 08:00:00	QQQ	ETF	291.374	292.99	289.4	291.84	205237.0
2022-05-26 08:30:00	QQQ	ETF	292.03	292.47	291.01	292.05	326585.0
2022-05-26 09:00:00	QQQ	ETF	291.99	292.06	290.43	290.43	554397.0
2022-05-26 09:30:00	QQQ	ETF	290.44	295.66	290.15	295.385	6664591.0
2022-05-26 10:00:00	QQQ	ETF	295.4	297.35	294.95	296.4005	4611886.0
2022-05-26 10:30:00	QQQ	ETF	296.42	297.37	295.665	297.34	3742194.0
2022-05-26 11:00:00	QQQ	ETF	297.34	298.4	297.19	297.56	2694273.0
2022-05-26 11:30:00	QQQ	ETF	297.56	298.3388	297.01	298.15	1950998.0
2022-05-26 12:00:00	QQQ	ETF	298.1799	299.99	297.79	299.98	2662949.0
2022-05-26 12:30:00	QQQ	ETF	299.9807	300.35	299.4401	300.317	2441338.0

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

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