PREVIEW / etf_30min / 2019-11-19

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-11-19.parquet
  size:    516 KB
  rows:    18,182

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-11-19 04:00:00	SPY	ETF	312.56	312.82	312.56	312.78	6918.0
2019-11-19 04:30:00	SPY	ETF	312.75	313.12	312.75	313.09	6990.0
2019-11-19 05:00:00	SPY	ETF	313.08	313.12	313.05	313.12	2495.0
2019-11-19 05:30:00	SPY	ETF	313.09	313.1	313.0	313.03	8246.0
2019-11-19 06:00:00	SPY	ETF	312.99	313.13	312.85	312.86	18325.0
2019-11-19 06:30:00	SPY	ETF	312.9	312.94	312.78	312.92	11652.0
2019-11-19 07:00:00	SPY	ETF	312.9	312.9	312.75	312.79	47109.0
2019-11-19 07:30:00	SPY	ETF	312.77	312.91	312.75	312.9	56137.0
2019-11-19 08:00:00	SPY	ETF	312.92	312.92	312.54	312.81	62704.0
2019-11-19 08:30:00	SPY	ETF	312.78	312.84	312.63	312.67	111996.0
2019-11-19 09:00:00	SPY	ETF	312.67	312.87	312.66	312.67	154318.0
2019-11-19 09:30:00	SPY	ETF	312.68	312.69	311.97	312.04	3662119.0
2019-11-19 10:00:00	SPY	ETF	312.035	312.12	311.76	311.97	3507659.0
2019-11-19 10:30:00	SPY	ETF	311.97	311.99	311.22	311.36	3154768.0
2019-11-19 11:00:00	SPY	ETF	311.36	311.89	311.33	311.84	2825963.0
2019-11-19 11:30:00	SPY	ETF	311.85	312.47	311.82	312.14	14227720.0
2019-11-19 12:00:00	SPY	ETF	312.13	312.2	311.6	311.98	4585127.0
2019-11-19 12:30:00	SPY	ETF	311.975	311.975	311.63	311.91	1329955.0
2019-11-19 13:00:00	SPY	ETF	311.91	312.09	311.7	311.95	1306770.0
2019-11-19 13:30:00	SPY	ETF	311.95	312.13	311.92	311.93	5815716.0
2019-11-19 14:00:00	SPY	ETF	311.94	312.4	311.935	312.36	2822356.0
2019-11-19 14:30:00	SPY	ETF	312.36	312.37	312.0	312.04	3512026.0
2019-11-19 15:00:00	SPY	ETF	312.04	312.34	311.98	312.0	5298231.0
2019-11-19 15:30:00	SPY	ETF	312.0	312.28	311.81	311.89	6543734.0
2019-11-19 16:00:00	SPY	ETF	311.88	312.0694	311.71	311.71	7255951.0
2019-11-19 16:30:00	SPY	ETF	311.72	311.885	311.62	311.62	80112.0
2019-11-19 17:00:00	SPY	ETF	311.65	311.68	311.58	311.66	33111.0
2019-11-19 17:30:00	SPY	ETF	311.62	312.68	311.51	311.55	241297.0
2019-11-19 18:00:00	SPY	ETF	311.55	311.58	311.07	311.2501	158696.0
2019-11-19 18:30:00	SPY	ETF	311.25	311.39	311.01	311.14	21678.0
2019-11-19 19:00:00	SPY	ETF	311.18	311.56	311.08	311.38	69124.0
2019-11-19 19:30:00	SPY	ETF	311.38	311.48	311.35	311.38	10623.0
2019-11-19 04:00:00	QQQ	ETF	203.61	203.77	203.6	203.73	2250.0
2019-11-19 04:30:00	QQQ	ETF	203.73	203.98	203.73	203.97	19962.0
2019-11-19 05:00:00	QQQ	ETF	203.96	203.96	203.9	203.93	8515.0
2019-11-19 05:30:00	QQQ	ETF	203.94	203.99	203.91	203.95	7600.0
2019-11-19 06:00:00	QQQ	ETF	203.92	204.15	203.89	203.93	13150.0
2019-11-19 06:30:00	QQQ	ETF	203.96	204.01	203.93	203.93	7715.0
2019-11-19 07:00:00	QQQ	ETF	203.94	203.96	203.84	203.85	31206.0
2019-11-19 07:30:00	QQQ	ETF	203.86	203.97	203.85	203.97	8997.0
2019-11-19 08:00:00	QQQ	ETF	203.89	204.0	203.42	203.91	32345.0
2019-11-19 08:30:00	QQQ	ETF	203.9	203.92	203.8	203.81	26606.0
2019-11-19 09:00:00	QQQ	ETF	203.84	203.98	203.83	203.84	43708.0
2019-11-19 09:30:00	QQQ	ETF	203.84	203.84	203.2199	203.28	1787520.0
2019-11-19 10:00:00	QQQ	ETF	203.27	203.47	203.01	203.3537	1131229.0
2019-11-19 10:30:00	QQQ	ETF	203.35	203.38	202.59	202.71	1136764.0
2019-11-19 11:00:00	QQQ	ETF	202.71	203.23	202.69	203.22	1038665.0
2019-11-19 11:30:00	QQQ	ETF	203.22	203.66	203.19	203.58	1116050.0
2019-11-19 12:00:00	QQQ	ETF	203.57	203.65	203.24	203.4844	760508.0
2019-11-19 12:30:00	QQQ	ETF	203.47	203.4799	203.19	203.42	774866.0

> showing 50 of 18,182 rows — these rows as CSV

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