PREVIEW / etf_30min / 2021-09-01

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-09-01.parquet
  size:    615 KB
  rows:    23,473

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-09-01 04:00:00	SPY	ETF	453.47	453.54	453.2	453.39	33993.0
2021-09-01 04:30:00	SPY	ETF	453.35	453.36	453.29	453.29	7985.0
2021-09-01 05:00:00	SPY	ETF	453.25	453.25	453.01	453.16	9059.0
2021-09-01 05:30:00	SPY	ETF	453.17	453.27	453.0	453.05	14599.0
2021-09-01 06:00:00	SPY	ETF	453.01	453.12	452.93	453.07	59835.0
2021-09-01 06:30:00	SPY	ETF	453.01	453.31	453.01	453.31	9843.0
2021-09-01 07:00:00	SPY	ETF	453.33	453.33	453.02	453.17	30132.0
2021-09-01 07:30:00	SPY	ETF	453.13	453.31	453.1	453.31	60323.0
2021-09-01 08:00:00	SPY	ETF	453.32	453.54	451.898	453.32	250108.0
2021-09-01 08:30:00	SPY	ETF	453.32	453.44	453.03	453.03	103116.0
2021-09-01 09:00:00	SPY	ETF	453.05	453.13	452.43	452.58	323165.0
2021-09-01 09:30:00	SPY	ETF	452.58	452.69	451.82	452.0	5232094.0
2021-09-01 10:00:00	SPY	ETF	452.01	452.595	451.98	452.25	3361555.0
2021-09-01 10:30:00	SPY	ETF	452.24	452.67	452.16	452.59	3027693.0
2021-09-01 11:00:00	SPY	ETF	452.58	452.67	452.1101	452.31	2526790.0
2021-09-01 11:30:00	SPY	ETF	452.31	452.525	452.25	452.37	1206372.0
2021-09-01 12:00:00	SPY	ETF	452.3698	452.74	452.35	452.65	2481330.0
2021-09-01 12:30:00	SPY	ETF	452.65	452.995	452.595	452.96	1885721.0
2021-09-01 13:00:00	SPY	ETF	452.9799	453.05	452.86	452.98	1250976.0
2021-09-01 13:30:00	SPY	ETF	452.975	453.11	452.93	453.03	1241881.0
2021-09-01 14:00:00	SPY	ETF	453.0301	453.06	452.65	452.71	1567848.0
2021-09-01 14:30:00	SPY	ETF	452.71	452.71	452.23	452.345	2805473.0
2021-09-01 15:00:00	SPY	ETF	452.34	452.47	451.9	452.15	2618617.0
2021-09-01 15:30:00	SPY	ETF	452.15	452.2	451.545	451.82	6676259.0
2021-09-01 16:00:00	SPY	ETF	451.81	452.45	451.8	451.98	2017598.0
2021-09-01 16:30:00	SPY	ETF	451.99	452.12	451.7	451.86	246401.0
2021-09-01 17:00:00	SPY	ETF	451.99	451.99	451.77	451.8	35540.0
2021-09-01 17:30:00	SPY	ETF	451.83	451.86	451.75	451.85	33252.0
2021-09-01 18:00:00	SPY	ETF	451.85	452.0	451.84	451.96	24449.0
2021-09-01 18:30:00	SPY	ETF	451.8	452.05	451.8	451.9	5894.0
2021-09-01 19:00:00	SPY	ETF	451.91	451.94	451.86	451.88	3857.0
2021-09-01 19:30:00	SPY	ETF	451.88	452.01	451.88	451.97	13026.0
2021-09-01 20:00:00	SPY	ETF	451.8	451.98	451.8	451.98	500.0
2021-09-01 04:00:00	QQQ	ETF	380.52	381.03	380.48	380.55	23338.0
2021-09-01 04:30:00	QQQ	ETF	380.6	380.65	380.45	380.51	7649.0
2021-09-01 05:00:00	QQQ	ETF	380.43	380.47	380.0	380.31	11460.0
2021-09-01 05:30:00	QQQ	ETF	380.33	380.56	380.33	380.47	18563.0
2021-09-01 06:00:00	QQQ	ETF	380.53	380.67	380.53	380.56	8780.0
2021-09-01 06:30:00	QQQ	ETF	380.58	380.82	380.5	380.77	12471.0
2021-09-01 07:00:00	QQQ	ETF	380.77	380.84	380.57	380.73	45671.0
2021-09-01 07:30:00	QQQ	ETF	380.72	380.99	380.7	380.99	33764.0
2021-09-01 08:00:00	QQQ	ETF	380.6506	381.45	380.234	381.28	195976.0
2021-09-01 08:30:00	QQQ	ETF	381.3	381.42	381.07	381.15	61565.0
2021-09-01 09:00:00	QQQ	ETF	381.12	381.2	380.85	381.03	162332.0
2021-09-01 09:30:00	QQQ	ETF	381.05	382.71	380.86	382.04	3801603.0
2021-09-01 10:00:00	QQQ	ETF	382.04	382.44	381.79	382.07	2302641.0
2021-09-01 10:30:00	QQQ	ETF	382.06	382.48	381.8	382.18	1194011.0
2021-09-01 11:00:00	QQQ	ETF	382.18	382.37	381.78	382.17	1022165.0
2021-09-01 11:30:00	QQQ	ETF	382.17	382.44	382.0	382.16	871208.0
2021-09-01 12:00:00	QQQ	ETF	382.16	382.435	382.115	382.2602	798909.0

> showing 50 of 23,473 rows — these rows as CSV

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