PREVIEW / etf_30min / 2020-10-19

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-10-19.parquet
  size:    559 KB
  rows:    20,463

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-19 04:00:00	SPY	ETF	348.6	349.12	348.56	349.07	38013.0
2020-10-19 04:30:00	SPY	ETF	348.96	349.23	348.96	349.01	15730.0
2020-10-19 05:00:00	SPY	ETF	349.18	349.43	349.16	349.19	29035.0
2020-10-19 05:30:00	SPY	ETF	349.16	349.25	348.93	349.09	14554.0
2020-10-19 06:00:00	SPY	ETF	349.13	349.13	348.65	348.85	138344.0
2020-10-19 06:30:00	SPY	ETF	348.73	349.19	348.65	349.17	9120.0
2020-10-19 07:00:00	SPY	ETF	349.15	349.24	348.83	348.96	84428.0
2020-10-19 07:30:00	SPY	ETF	348.94	349.03	348.83	348.85	41975.0
2020-10-19 08:00:00	SPY	ETF	348.84	349.35	348.3	348.72	181450.0
2020-10-19 08:30:00	SPY	ETF	348.72	348.8	348.35	348.49	137893.0
2020-10-19 09:00:00	SPY	ETF	348.5	348.74	347.29	348.62	299163.0
2020-10-19 09:30:00	SPY	ETF	348.65	349.33	348.46	348.49	3761117.0
2020-10-19 10:00:00	SPY	ETF	348.4722	348.49	346.87	348.3	3727967.0
2020-10-19 10:30:00	SPY	ETF	348.29	348.33	346.3563	347.13	4217903.0
2020-10-19 11:00:00	SPY	ETF	347.12	347.37	345.6	346.3601	2815941.0
2020-10-19 11:30:00	SPY	ETF	346.34	346.87	346.04	346.255	2352055.0
2020-10-19 12:00:00	SPY	ETF	346.24	346.65	345.63	345.88	2195101.0
2020-10-19 12:30:00	SPY	ETF	345.8696	346.46	345.79	346.16	1533430.0
2020-10-19 13:00:00	SPY	ETF	346.164	346.3664	345.68	345.86	1499859.0
2020-10-19 13:30:00	SPY	ETF	345.87	345.93	344.55	344.84	2661035.0
2020-10-19 14:00:00	SPY	ETF	344.82	345.17	344.22	345.0	3263290.0
2020-10-19 14:30:00	SPY	ETF	345.0	345.0	342.19	342.25	6923517.0
2020-10-19 15:00:00	SPY	ETF	342.26	342.61	341.26	341.98	8946911.0
2020-10-19 15:30:00	SPY	ETF	341.97	342.71	341.04	342.02	14415932.0
2020-10-19 16:00:00	SPY	ETF	342.02	342.59	341.8151	342.51	6951937.0
2020-10-19 16:30:00	SPY	ETF	342.52	343.44	342.52	343.33	926588.0
2020-10-19 17:00:00	SPY	ETF	343.35	343.35	343.11	343.26	96875.0
2020-10-19 17:30:00	SPY	ETF	343.28	343.4	342.01	343.4	60695.0
2020-10-19 18:00:00	SPY	ETF	343.42	344.06	343.39	343.78	117491.0
2020-10-19 18:30:00	SPY	ETF	343.8	343.87	343.65	343.78	49095.0
2020-10-19 19:00:00	SPY	ETF	343.83	343.9	343.75	343.85	33410.0
2020-10-19 19:30:00	SPY	ETF	343.88	343.96	343.75	343.88	121188.0
2020-10-19 04:00:00	QQQ	ETF	290.57	290.9	290.11	290.78	44384.0
2020-10-19 04:30:00	QQQ	ETF	290.74	291.18	290.74	290.97	13276.0
2020-10-19 05:00:00	QQQ	ETF	291.03	291.41	291.0	291.12	16737.0
2020-10-19 05:30:00	QQQ	ETF	291.0	291.12	290.77	290.99	29178.0
2020-10-19 06:00:00	QQQ	ETF	290.9	290.96	290.5	290.75	17402.0
2020-10-19 06:30:00	QQQ	ETF	290.7	291.06	290.52	291.04	20312.0
2020-10-19 07:00:00	QQQ	ETF	290.96	291.03	290.5	290.72	79159.0
2020-10-19 07:30:00	QQQ	ETF	290.71	290.9	290.6	290.74	52502.0
2020-10-19 08:00:00	QQQ	ETF	290.9	291.0	289.9	290.49	126136.0
2020-10-19 08:30:00	QQQ	ETF	290.4904	290.65	290.14	290.22	79715.0
2020-10-19 09:00:00	QQQ	ETF	290.26	290.8	290.26	290.5404	109668.0
2020-10-19 09:30:00	QQQ	ETF	290.49	291.48	289.57	289.63	2940889.0
2020-10-19 10:00:00	QQQ	ETF	289.62	289.9	288.02	289.44	2722073.0
2020-10-19 10:30:00	QQQ	ETF	289.44	289.47	286.76	287.82	2717739.0
2020-10-19 11:00:00	QQQ	ETF	287.8	288.79	287.03	287.85	1531938.0
2020-10-19 11:30:00	QQQ	ETF	287.846	288.62	287.33	287.43	986394.0
2020-10-19 12:00:00	QQQ	ETF	287.39	287.99	286.51	287.04	1750123.0
2020-10-19 12:30:00	QQQ	ETF	287.01	287.95	286.96	287.6	1121195.0

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

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