PREVIEW / etf_30min / 2021-08-03

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-08-03.parquet
  size:    611 KB
  rows:    22,900

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
2021-08-03 04:00:00	SPY	ETF	438.25	439.11	438.25	438.76	39302.0
2021-08-03 04:30:00	SPY	ETF	438.97	438.97	438.86	438.95	4255.0
2021-08-03 05:00:00	SPY	ETF	439.05	439.05	438.69	438.69	2418.0
2021-08-03 05:30:00	SPY	ETF	439.05	439.17	438.93	439.07	7659.0
2021-08-03 06:00:00	SPY	ETF	439.07	439.26	439.07	439.19	12804.0
2021-08-03 06:30:00	SPY	ETF	439.11	439.22	439.06	439.18	5089.0
2021-08-03 07:00:00	SPY	ETF	439.19	439.24	438.94	439.06	20578.0
2021-08-03 07:30:00	SPY	ETF	439.05	439.17	439.0	439.16	50442.0
2021-08-03 08:00:00	SPY	ETF	439.0101	439.2	438.15	438.21	192712.0
2021-08-03 08:30:00	SPY	ETF	438.22	438.72	438.1	438.72	112525.0
2021-08-03 09:00:00	SPY	ETF	438.69	438.72	438.24	438.41	171263.0
2021-08-03 09:30:00	SPY	ETF	438.44	438.67	436.32	436.4	5350697.0
2021-08-03 10:00:00	SPY	ETF	436.4	437.97	436.1	437.7611	4946271.0
2021-08-03 10:30:00	SPY	ETF	437.77	438.14	436.5	437.4611	3743173.0
2021-08-03 11:00:00	SPY	ETF	437.46	437.9	437.04	437.76	2857904.0
2021-08-03 11:30:00	SPY	ETF	437.76	439.84	437.74	439.7481	5331468.0
2021-08-03 12:00:00	SPY	ETF	439.745	439.84	439.063	439.24	2277590.0
2021-08-03 12:30:00	SPY	ETF	439.25	439.8	439.155	439.8	1870622.0
2021-08-03 13:00:00	SPY	ETF	439.8	440.29	439.795	440.089	1879144.0
2021-08-03 13:30:00	SPY	ETF	440.1	440.27	439.9408	440.2	1124355.0
2021-08-03 14:00:00	SPY	ETF	440.2	440.64	439.86	440.52	2281557.0
2021-08-03 14:30:00	SPY	ETF	440.52	440.605	440.15	440.4608	1887697.0
2021-08-03 15:00:00	SPY	ETF	440.46	440.975	440.46	440.855	3060985.0
2021-08-03 15:30:00	SPY	ETF	440.855	441.28	440.57	441.12	8588210.0
2021-08-03 16:00:00	SPY	ETF	441.11	441.17	440.5	440.7	2441998.0
2021-08-03 16:30:00	SPY	ETF	440.73	440.79	440.45	440.48	117833.0
2021-08-03 17:00:00	SPY	ETF	440.55	441.15	440.4	440.51	61652.0
2021-08-03 17:30:00	SPY	ETF	440.52	440.53	440.45	440.53	21626.0
2021-08-03 18:00:00	SPY	ETF	440.53	440.76	440.53	440.69	63874.0
2021-08-03 18:30:00	SPY	ETF	440.56	440.65	440.55	440.57	10846.0
2021-08-03 19:00:00	SPY	ETF	440.5	440.52	440.36	440.39	8246.0
2021-08-03 19:30:00	SPY	ETF	440.36	440.44	440.35	440.4	21141.0
2021-08-03 04:00:00	QQQ	ETF	365.27	365.28	365.15	365.2	7342.0
2021-08-03 04:30:00	QQQ	ETF	365.21	365.33	365.19	365.33	9799.0
2021-08-03 05:00:00	QQQ	ETF	365.29	365.29	364.66	364.78	11841.0
2021-08-03 05:30:00	QQQ	ETF	364.85	364.96	364.82	364.92	27237.0
2021-08-03 06:00:00	QQQ	ETF	364.88	365.17	364.83	365.1	14000.0
2021-08-03 06:30:00	QQQ	ETF	365.06	365.06	364.89	364.97	7918.0
2021-08-03 07:00:00	QQQ	ETF	364.96	365.02	364.71	364.9	44172.0
2021-08-03 07:30:00	QQQ	ETF	364.9	365.15	364.85	365.08	44922.0
2021-08-03 08:00:00	QQQ	ETF	364.7999	365.19	364.6	364.839	80835.0
2021-08-03 08:30:00	QQQ	ETF	364.84	365.33	364.84	365.33	38064.0
2021-08-03 09:00:00	QQQ	ETF	365.35	365.44	365.2	365.28	42528.0
2021-08-03 09:30:00	QQQ	ETF	365.29	365.86	363.3199	363.35	4060193.0
2021-08-03 10:00:00	QQQ	ETF	363.35	364.18	362.32	364.03	3984263.0
2021-08-03 10:30:00	QQQ	ETF	364.04	364.13	362.49	363.44	2308271.0
2021-08-03 11:00:00	QQQ	ETF	363.43	363.845	362.0	362.95	2432022.0
2021-08-03 11:30:00	QQQ	ETF	362.93	366.08	362.9	365.91	2918306.0
2021-08-03 12:00:00	QQQ	ETF	365.92	366.17	365.16	365.32	1983567.0
2021-08-03 12:30:00	QQQ	ETF	365.33	366.17	365.2699	366.16	1197208.0

> showing 50 of 22,900 rows — these rows as CSV

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