PREVIEW / etf_30min / 2020-05-18

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-05-18.parquet
  size:    569 KB
  rows:    21,433

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-05-18 04:00:00	SPY	ETF	289.1	289.97	289.1	289.45	81374.0
2020-05-18 04:30:00	SPY	ETF	289.59	289.9	289.29	289.57	42805.0
2020-05-18 05:00:00	SPY	ETF	289.5	289.61	289.0	289.0	19927.0
2020-05-18 05:30:00	SPY	ETF	288.97	289.29	288.76	289.29	30637.0
2020-05-18 06:00:00	SPY	ETF	289.17	289.45	289.14	289.2	44993.0
2020-05-18 06:30:00	SPY	ETF	289.16	289.7	288.99	289.7	56125.0
2020-05-18 07:00:00	SPY	ETF	289.78	289.79	289.45	289.61	134515.0
2020-05-18 07:30:00	SPY	ETF	289.6	291.94	289.43	291.78	1137210.0
2020-05-18 08:00:00	SPY	ETF	291.76	293.4	287.9	293.1	1708694.0
2020-05-18 08:30:00	SPY	ETF	293.1	293.76	292.8	293.68	1082001.0
2020-05-18 09:00:00	SPY	ETF	293.63	293.68	292.88	293.05	889362.0
2020-05-18 09:30:00	SPY	ETF	293.05	294.19	292.7	293.28	14709769.0
2020-05-18 10:00:00	SPY	ETF	293.28	293.69	292.87	293.32	5841198.0
2020-05-18 10:30:00	SPY	ETF	293.33	294.69	293.33	294.53	8840859.0
2020-05-18 11:00:00	SPY	ETF	294.525	295.58	294.48	295.24	8085514.0
2020-05-18 11:30:00	SPY	ETF	295.25	295.48	294.74	295.04	6001802.0
2020-05-18 12:00:00	SPY	ETF	295.03	295.25	294.64	295.0	5785128.0
2020-05-18 12:30:00	SPY	ETF	295.01	295.06	294.53	294.81	4586893.0
2020-05-18 13:00:00	SPY	ETF	294.82	295.78	294.7638	295.7701	3954473.0
2020-05-18 13:30:00	SPY	ETF	295.775	295.79	295.34	295.585	2842436.0
2020-05-18 14:00:00	SPY	ETF	295.592	295.94	295.39	295.64	3966408.0
2020-05-18 14:30:00	SPY	ETF	295.65	296.07	295.41	295.68	4457738.0
2020-05-18 15:00:00	SPY	ETF	295.68	295.98	295.3401	295.7849	6858370.0
2020-05-18 15:30:00	SPY	ETF	295.785	296.75	294.94	294.995	24625973.0
2020-05-18 16:00:00	SPY	ETF	294.99	295.28	294.63	295.14	10655450.0
2020-05-18 16:30:00	SPY	ETF	295.13	295.13	294.65	294.79	2037369.0
2020-05-18 17:00:00	SPY	ETF	294.82	294.91	294.66	294.84	301683.0
2020-05-18 17:30:00	SPY	ETF	294.8	295.0	294.71	294.71	129802.0
2020-05-18 18:00:00	SPY	ETF	294.8	295.42	294.45	295.04	266069.0
2020-05-18 18:30:00	SPY	ETF	295.0	295.63	295.0	295.49	105666.0
2020-05-18 19:00:00	SPY	ETF	295.47	295.4899	295.15	295.23	80093.0
2020-05-18 19:30:00	SPY	ETF	295.16	295.52	294.82	295.46	144519.0
2020-05-18 04:00:00	QQQ	ETF	224.85	225.59	224.85	225.25	26341.0
2020-05-18 04:30:00	QQQ	ETF	225.27	225.53	225.15	225.31	4497.0
2020-05-18 05:00:00	QQQ	ETF	225.4	225.4	224.7	224.7	11540.0
2020-05-18 05:30:00	QQQ	ETF	224.66	224.92	224.57	224.92	5318.0
2020-05-18 06:00:00	QQQ	ETF	224.82	224.93	224.66	224.66	13194.0
2020-05-18 06:30:00	QQQ	ETF	224.56	225.17	224.5	225.17	13965.0
2020-05-18 07:00:00	QQQ	ETF	225.22	225.3	224.99	225.2	69532.0
2020-05-18 07:30:00	QQQ	ETF	225.2	226.49	225.03	226.43	308551.0
2020-05-18 08:00:00	QQQ	ETF	226.43	226.88	224.37	226.66	376743.0
2020-05-18 08:30:00	QQQ	ETF	226.59	226.85	226.18	226.76	170643.0
2020-05-18 09:00:00	QQQ	ETF	226.66	226.74	226.1	226.27	425069.0
2020-05-18 09:30:00	QQQ	ETF	226.27	226.9314	225.47	226.08	5749479.0
2020-05-18 10:00:00	QQQ	ETF	226.08	227.11	225.85	226.77	4411994.0
2020-05-18 10:30:00	QQQ	ETF	226.76	227.79	226.76	227.775	2560229.0
2020-05-18 11:00:00	QQQ	ETF	227.76	228.1	227.47	227.69	2075685.0
2020-05-18 11:30:00	QQQ	ETF	227.71	227.89	227.3512	227.6701	1947134.0
2020-05-18 12:00:00	QQQ	ETF	227.67	227.79	227.335	227.65	1214420.0
2020-05-18 12:30:00	QQQ	ETF	227.65	227.7	227.13	227.53	1103961.0

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

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