PREVIEW / etf_30min / 2020-10-26

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-10-26.parquet
  size:    579 KB
  rows:    21,479

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
2020-10-26 04:00:00	SPY	ETF	341.55	341.93	341.3	341.61	49720.0
2020-10-26 04:30:00	SPY	ETF	341.52	342.15	341.46	341.91	22017.0
2020-10-26 05:00:00	SPY	ETF	342.04	342.16	341.84	342.09	7212.0
2020-10-26 05:30:00	SPY	ETF	342.17	342.17	341.6	341.86	26773.0
2020-10-26 06:00:00	SPY	ETF	341.54	342.0	341.51	342.0	20145.0
2020-10-26 06:30:00	SPY	ETF	341.98	342.03	341.75	342.02	12722.0
2020-10-26 07:00:00	SPY	ETF	342.06	342.43	342.05	342.17	79996.0
2020-10-26 07:30:00	SPY	ETF	342.15	342.24	341.7	341.76	149795.0
2020-10-26 08:00:00	SPY	ETF	341.78	343.71	341.4	341.81	251244.0
2020-10-26 08:30:00	SPY	ETF	341.82	341.88	341.44	341.65	135461.0
2020-10-26 09:00:00	SPY	ETF	341.65	342.22	341.54	342.11	254298.0
2020-10-26 09:30:00	SPY	ETF	342.13	342.75	341.75	342.53	6025325.0
2020-10-26 10:00:00	SPY	ETF	342.55	342.98	341.52	341.58	5660278.0
2020-10-26 10:30:00	SPY	ETF	341.585	341.59	339.53	339.65	8205955.0
2020-10-26 11:00:00	SPY	ETF	339.65	339.65	338.15	338.8	9059607.0
2020-10-26 11:30:00	SPY	ETF	338.79	340.2	338.0	338.6345	6251035.0
2020-10-26 12:00:00	SPY	ETF	338.615	338.91	338.23	338.63	3971010.0
2020-10-26 12:30:00	SPY	ETF	338.61	338.61	337.24	337.5	4446984.0
2020-10-26 13:00:00	SPY	ETF	337.5	337.6898	336.16	336.19	4807162.0
2020-10-26 13:30:00	SPY	ETF	336.2	337.44	335.62	337.391	7064670.0
2020-10-26 14:00:00	SPY	ETF	337.39	338.655	337.13	338.5931	5425983.0
2020-10-26 14:30:00	SPY	ETF	338.595	338.68	337.62	338.176	4095639.0
2020-10-26 15:00:00	SPY	ETF	338.2	338.59	337.37	338.3699	4824175.0
2020-10-26 15:30:00	SPY	ETF	338.3681	339.47	337.35	339.415	12347114.0
2020-10-26 16:00:00	SPY	ETF	339.41	339.81	339.2	339.56	5011637.0
2020-10-26 16:30:00	SPY	ETF	339.57	339.57	339.23	339.48	1284214.0
2020-10-26 17:00:00	SPY	ETF	339.46	339.49	339.39	339.45	91965.0
2020-10-26 17:30:00	SPY	ETF	339.42	339.43	339.24	339.41	67136.0
2020-10-26 18:00:00	SPY	ETF	339.41	339.8	339.41	339.78	142817.0
2020-10-26 18:30:00	SPY	ETF	339.78	339.81	339.6	339.61	38524.0
2020-10-26 19:00:00	SPY	ETF	339.62	339.94	339.58	339.83	60984.0
2020-10-26 19:30:00	SPY	ETF	339.83	339.86	339.15	339.29	132158.0
2020-10-26 04:00:00	QQQ	ETF	282.0	282.32	281.8	282.09	37826.0
2020-10-26 04:30:00	QQQ	ETF	282.06	282.19	281.85	281.95	12456.0
2020-10-26 05:00:00	QQQ	ETF	281.93	282.29	281.93	282.2	12696.0
2020-10-26 05:30:00	QQQ	ETF	282.26	282.26	281.82	282.1	10549.0
2020-10-26 06:00:00	QQQ	ETF	282.1	282.34	281.88	282.28	43501.0
2020-10-26 06:30:00	QQQ	ETF	282.28	282.36	282.13	282.25	28699.0
2020-10-26 07:00:00	QQQ	ETF	282.29	282.82	282.29	282.57	118268.0
2020-10-26 07:30:00	QQQ	ETF	282.54	282.68	282.16	282.35	148759.0
2020-10-26 08:00:00	QQQ	ETF	282.31	284.74	281.88	282.1	126105.0
2020-10-26 08:30:00	QQQ	ETF	282.06	282.22	281.93	282.04	59284.0
2020-10-26 09:00:00	QQQ	ETF	282.04	282.48	282.04	282.42	130158.0
2020-10-26 09:30:00	QQQ	ETF	282.42	284.9	282.17	284.64	3467089.0
2020-10-26 10:00:00	QQQ	ETF	284.64	285.3	283.45	283.5267	2274178.0
2020-10-26 10:30:00	QQQ	ETF	283.49	283.54	281.29	281.47	2885217.0
2020-10-26 11:00:00	QQQ	ETF	281.45	281.45	279.95	280.31	2833893.0
2020-10-26 11:30:00	QQQ	ETF	280.32	280.82	279.37	280.03	2619846.0
2020-10-26 12:00:00	QQQ	ETF	280.04	280.57	279.66	280.21	1535023.0
2020-10-26 12:30:00	QQQ	ETF	280.14	280.14	278.33	278.52	1849630.0

> showing 50 of 21,479 rows — these rows as CSV

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