PREVIEW / etf_30min / 2020-01-02

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-01-02.parquet
  size:    572 KB
  rows:    20,184

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-01-02 04:00:00	SPY	ETF	323.52	323.83	323.52	323.76	19351.0
2020-01-02 04:30:00	SPY	ETF	323.75	323.86	323.69	323.83	9084.0
2020-01-02 05:00:00	SPY	ETF	323.82	323.96	323.82	323.96	6969.0
2020-01-02 05:30:00	SPY	ETF	323.96	323.98	323.9	323.91	8270.0
2020-01-02 06:00:00	SPY	ETF	323.94	323.94	323.71	323.79	7895.0
2020-01-02 06:30:00	SPY	ETF	323.74	323.76	323.63	323.63	9973.0
2020-01-02 07:00:00	SPY	ETF	323.61	323.81	323.61	323.76	31096.0
2020-01-02 07:30:00	SPY	ETF	323.78	323.85	323.75	323.85	33765.0
2020-01-02 08:00:00	SPY	ETF	323.6899	323.94	322.83	323.85	167651.0
2020-01-02 08:30:00	SPY	ETF	323.86	324.08	323.85	324.03	199027.0
2020-01-02 09:00:00	SPY	ETF	324.02	324.05	323.5	323.56	403402.0
2020-01-02 09:30:00	SPY	ETF	323.54	324.03	323.41	323.87	6736509.0
2020-01-02 10:00:00	SPY	ETF	323.87	323.9	322.61	323.02	4806926.0
2020-01-02 10:30:00	SPY	ETF	323.01	323.32	322.65	323.25	2327498.0
2020-01-02 11:00:00	SPY	ETF	323.26	323.36	323.12	323.17	2389170.0
2020-01-02 11:30:00	SPY	ETF	323.18	323.18	322.53	323.05	2914832.0
2020-01-02 12:00:00	SPY	ETF	323.06	323.2994	322.92	323.15	1810471.0
2020-01-02 12:30:00	SPY	ETF	323.15	323.46	323.13	323.36	1796762.0
2020-01-02 13:00:00	SPY	ETF	323.365	323.37	323.02	323.0918	2026924.0
2020-01-02 13:30:00	SPY	ETF	323.1	323.19	322.96	323.165	1707882.0
2020-01-02 14:00:00	SPY	ETF	323.17	323.61	323.13	323.53	3529622.0
2020-01-02 14:30:00	SPY	ETF	323.54	323.87	323.5	323.78	3271610.0
2020-01-02 15:00:00	SPY	ETF	323.78	323.94	323.72	323.88	3301669.0
2020-01-02 15:30:00	SPY	ETF	323.885	324.85	323.83	324.84	11597684.0
2020-01-02 16:00:00	SPY	ETF	324.84	324.93	324.1595	324.87	8536807.0
2020-01-02 16:30:00	SPY	ETF	324.86	325.12	324.86	325.11	346764.0
2020-01-02 17:00:00	SPY	ETF	325.08	325.19	324.86	325.19	277604.0
2020-01-02 17:30:00	SPY	ETF	325.19	325.19	325.05	325.1	59981.0
2020-01-02 18:00:00	SPY	ETF	325.06	325.25	325.06	325.2	130356.0
2020-01-02 18:30:00	SPY	ETF	325.2	325.22	325.06	325.08	15809.0
2020-01-02 19:00:00	SPY	ETF	325.05	325.19	325.04	325.1	30091.0
2020-01-02 19:30:00	SPY	ETF	325.15	325.19	325.02	325.14	36908.0
2020-01-02 04:00:00	QQQ	ETF	213.98	214.2	213.95	214.17	45921.0
2020-01-02 04:30:00	QQQ	ETF	214.16	214.26	214.08	214.22	6738.0
2020-01-02 05:00:00	QQQ	ETF	214.24	214.34	214.24	214.34	9035.0
2020-01-02 05:30:00	QQQ	ETF	214.32	214.37	214.31	214.32	15075.0
2020-01-02 06:00:00	QQQ	ETF	214.3	214.3	214.11	214.18	8511.0
2020-01-02 06:30:00	QQQ	ETF	214.17	214.17	214.06	214.15	4775.0
2020-01-02 07:00:00	QQQ	ETF	214.08	214.23	214.06	214.21	52156.0
2020-01-02 07:30:00	QQQ	ETF	214.23	214.34	214.22	214.29	29166.0
2020-01-02 08:00:00	QQQ	ETF	214.15	214.48	213.5	214.41	87270.0
2020-01-02 08:30:00	QQQ	ETF	214.43	214.62	214.43	214.5502	121455.0
2020-01-02 09:00:00	QQQ	ETF	214.58	214.59	214.25	214.35	415777.0
2020-01-02 09:30:00	QQQ	ETF	214.36	215.16	214.26	215.07	4257512.0
2020-01-02 10:00:00	QQQ	ETF	215.08	215.11	213.98	214.37	2102652.0
2020-01-02 10:30:00	QQQ	ETF	214.3734	214.66	214.1	214.62	1143223.0
2020-01-02 11:00:00	QQQ	ETF	214.63	214.75	214.54	214.62	809304.0
2020-01-02 11:30:00	QQQ	ETF	214.61	214.67	214.08	214.65	1070186.0
2020-01-02 12:00:00	QQQ	ETF	214.65	214.85	214.59	214.7641	722420.0
2020-01-02 12:30:00	QQQ	ETF	214.77	215.05	214.76	215.025	723598.0

> showing 50 of 20,184 rows — these rows as CSV

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