PREVIEW / etf_30min / 2019-06-14

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-06-14.parquet
  size:    475 KB
  rows:    16,676

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
2019-06-14 04:00:00	SPY	ETF	289.38	289.39	289.0	289.01	9718.0
2019-06-14 04:30:00	SPY	ETF	289.01	289.09	288.87	289.09	8069.0
2019-06-14 05:00:00	SPY	ETF	289.07	289.2	289.07	289.13	19324.0
2019-06-14 05:30:00	SPY	ETF	289.11	289.14	288.84	288.99	13678.0
2019-06-14 06:00:00	SPY	ETF	288.96	288.96	288.55	288.55	12576.0
2019-06-14 06:30:00	SPY	ETF	288.6	288.96	288.52	288.81	55503.0
2019-06-14 07:00:00	SPY	ETF	288.84	289.08	288.81	288.89	51971.0
2019-06-14 07:30:00	SPY	ETF	288.9	289.23	288.81	289.2	95464.0
2019-06-14 08:00:00	SPY	ETF	288.95	290.07	288.8501	289.09	190555.0
2019-06-14 08:30:00	SPY	ETF	289.15	289.32	289.0	289.16	238266.0
2019-06-14 09:00:00	SPY	ETF	289.14	289.51	289.1	289.29	237472.0
2019-06-14 09:30:00	SPY	ETF	289.26	289.32	288.41	288.65	5148102.0
2019-06-14 10:00:00	SPY	ETF	288.64	289.0	288.4615	288.7789	3615058.0
2019-06-14 10:30:00	SPY	ETF	288.79	289.27	288.56	289.105	2914157.0
2019-06-14 11:00:00	SPY	ETF	289.105	289.18	288.41	289.03	3319351.0
2019-06-14 11:30:00	SPY	ETF	289.03	289.24	288.83	288.91	1980124.0
2019-06-14 12:00:00	SPY	ETF	288.9	288.91	288.65	288.83	2749783.0
2019-06-14 12:30:00	SPY	ETF	288.83	289.01	288.81	288.947	1242883.0
2019-06-14 13:00:00	SPY	ETF	288.94	289.03	288.83	288.85	1886257.0
2019-06-14 13:30:00	SPY	ETF	288.86	288.9471	288.72	288.76	1522708.0
2019-06-14 14:00:00	SPY	ETF	288.75	289.2	288.72	289.16	2534256.0
2019-06-14 14:30:00	SPY	ETF	289.17	289.21	289.09	289.17	1848691.0
2019-06-14 15:00:00	SPY	ETF	289.17	289.82	289.15	289.71	4292085.0
2019-06-14 15:30:00	SPY	ETF	289.71	289.93	289.14	289.19	10795824.0
2019-06-14 16:00:00	SPY	ETF	289.2	289.5411	289.1563	289.37	5840453.0
2019-06-14 16:30:00	SPY	ETF	289.37	289.55	289.26	289.54	257722.0
2019-06-14 17:00:00	SPY	ETF	289.55	289.55	289.26	289.4	373505.0
2019-06-14 17:30:00	SPY	ETF	289.41	289.43	289.28	289.3	31917.0
2019-06-14 18:00:00	SPY	ETF	289.33	289.33	289.33	289.33	549.0
2019-06-14 18:30:00	SPY	ETF	289.31	289.33	289.31	289.33	797.0
2019-06-14 19:00:00	SPY	ETF	289.33	289.35	289.3	289.35	2520.0
2019-06-14 19:30:00	SPY	ETF	289.35	289.37	289.27	289.33	5249.0
2019-06-14 04:00:00	QQQ	ETF	182.68	182.75	182.36	182.36	19279.0
2019-06-14 04:30:00	QQQ	ETF	182.3	182.4	182.3	182.34	4120.0
2019-06-14 05:00:00	QQQ	ETF	182.35	182.44	182.35	182.35	6585.0
2019-06-14 05:30:00	QQQ	ETF	182.38	182.43	182.07	182.23	17570.0
2019-06-14 06:00:00	QQQ	ETF	182.23	182.27	181.87	181.87	10655.0
2019-06-14 06:30:00	QQQ	ETF	181.9	182.08	181.82	182.03	28710.0
2019-06-14 07:00:00	QQQ	ETF	182.08	182.2	182.0	182.07	51321.0
2019-06-14 07:30:00	QQQ	ETF	182.05	182.47	182.04	182.45	56790.0
2019-06-14 08:00:00	QQQ	ETF	182.1	183.2	182.05	182.3	173715.0
2019-06-14 08:30:00	QQQ	ETF	182.24	182.49	182.13	182.4201	158291.0
2019-06-14 09:00:00	QQQ	ETF	182.44	182.6	182.39	182.49	148696.0
2019-06-14 09:30:00	QQQ	ETF	182.4	182.54	181.94	182.17	3157774.0
2019-06-14 10:00:00	QQQ	ETF	182.17	182.51	182.02	182.3299	1999779.0
2019-06-14 10:30:00	QQQ	ETF	182.33	182.87	182.16	182.6	1231139.0
2019-06-14 11:00:00	QQQ	ETF	182.61	182.6601	181.985	182.53	1252662.0
2019-06-14 11:30:00	QQQ	ETF	182.53	182.765	182.36	182.4185	1060156.0
2019-06-14 12:00:00	QQQ	ETF	182.43	182.54	182.28	182.44	603702.0
2019-06-14 12:30:00	QQQ	ETF	182.43	182.61	182.4237	182.56	548606.0

> showing 50 of 16,676 rows — these rows as CSV

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