PREVIEW / etf_30min / 2019-08-16

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-08-16.parquet
  size:    503 KB
  rows:    17,640

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-08-16 04:00:00	SPY	ETF	286.48	286.86	286.48	286.7	10826.0
2019-08-16 04:30:00	SPY	ETF	286.73	287.55	286.73	287.44	60401.0
2019-08-16 05:00:00	SPY	ETF	287.47	287.71	287.37	287.46	27731.0
2019-08-16 05:30:00	SPY	ETF	287.41	287.48	287.06	287.41	59200.0
2019-08-16 06:00:00	SPY	ETF	287.44	287.63	287.21	287.47	18716.0
2019-08-16 06:30:00	SPY	ETF	287.4	287.58	287.22	287.53	12867.0
2019-08-16 07:00:00	SPY	ETF	287.49	287.66	287.23	287.41	104715.0
2019-08-16 07:30:00	SPY	ETF	287.34	287.36	287.06	287.11	188309.0
2019-08-16 08:00:00	SPY	ETF	287.12	287.64	286.15	287.29	382879.0
2019-08-16 08:30:00	SPY	ETF	287.32	287.44	286.99	287.19	337288.0
2019-08-16 09:00:00	SPY	ETF	287.21	287.28	286.16	286.46	930866.0
2019-08-16 09:30:00	SPY	ETF	286.48	287.36	286.43	286.91	5851184.0
2019-08-16 10:00:00	SPY	ETF	286.91	288.27	286.79	287.49	8125757.0
2019-08-16 10:30:00	SPY	ETF	287.5	288.99	287.42	288.97	7618741.0
2019-08-16 11:00:00	SPY	ETF	288.965	289.09	288.18	288.4813	5882959.0
2019-08-16 11:30:00	SPY	ETF	288.48	288.9	288.2402	288.645	3763238.0
2019-08-16 12:00:00	SPY	ETF	288.645	288.72	288.16	288.54	2261769.0
2019-08-16 12:30:00	SPY	ETF	288.535	288.85	288.42	288.67	3060148.0
2019-08-16 13:00:00	SPY	ETF	288.67	289.11	288.65	289.03	2390823.0
2019-08-16 13:30:00	SPY	ETF	289.04	289.05	288.7	288.87	3100775.0
2019-08-16 14:00:00	SPY	ETF	288.88	288.9	288.55	288.63	1751762.0
2019-08-16 14:30:00	SPY	ETF	288.63	288.75	288.3499	288.65	3572276.0
2019-08-16 15:00:00	SPY	ETF	288.65	288.94	288.49	288.595	4871988.0
2019-08-16 15:30:00	SPY	ETF	288.59	289.33	284.7138	288.87	14515510.0
2019-08-16 16:00:00	SPY	ETF	288.85	289.06	288.64	289.05	12593382.0
2019-08-16 16:30:00	SPY	ETF	289.06	289.21	288.96	289.01	776503.0
2019-08-16 17:00:00	SPY	ETF	289.02	289.02	288.85	288.95	272916.0
2019-08-16 17:30:00	SPY	ETF	288.97	289.01	288.8	288.87	1497372.0
2019-08-16 18:00:00	SPY	ETF	288.87	288.88	288.71	288.75	284372.0
2019-08-16 18:30:00	SPY	ETF	288.78	288.89	288.78	288.89	1549.0
2019-08-16 19:00:00	SPY	ETF	288.81	288.92	288.8	288.91	2976.0
2019-08-16 19:30:00	SPY	ETF	288.89	288.99	288.85	288.92	12174.0
2019-08-16 04:00:00	QQQ	ETF	184.21	184.52	184.16	184.47	10942.0
2019-08-16 04:30:00	QQQ	ETF	184.44	185.08	184.44	185.08	23964.0
2019-08-16 05:00:00	QQQ	ETF	184.91	185.15	184.87	184.95	19750.0
2019-08-16 05:30:00	QQQ	ETF	184.96	184.98	184.6	184.86	26053.0
2019-08-16 06:00:00	QQQ	ETF	184.98	185.09	184.74	184.98	11085.0
2019-08-16 06:30:00	QQQ	ETF	184.94	185.05	184.8	184.99	14250.0
2019-08-16 07:00:00	QQQ	ETF	184.99	185.09	184.7	184.76	89468.0
2019-08-16 07:30:00	QQQ	ETF	184.74	184.74	184.44	184.49	53175.0
2019-08-16 08:00:00	QQQ	ETF	184.98	185.01	182.55	184.61	362180.0
2019-08-16 08:30:00	QQQ	ETF	184.7	184.76	184.35	184.59	179904.0
2019-08-16 09:00:00	QQQ	ETF	184.61	184.63	183.84	184.11	466607.0
2019-08-16 09:30:00	QQQ	ETF	184.11	184.73	184.1	184.44	2720797.0
2019-08-16 10:00:00	QQQ	ETF	184.43	185.3	184.26	184.74	2382220.0
2019-08-16 10:30:00	QQQ	ETF	184.74	185.85	184.68	185.83	2435824.0
2019-08-16 11:00:00	QQQ	ETF	185.83	185.95	185.25	185.32	2074353.0
2019-08-16 11:30:00	QQQ	ETF	185.31	185.51	185.025	185.34	1453344.0
2019-08-16 12:00:00	QQQ	ETF	185.359	185.41	185.0	185.32	763274.0
2019-08-16 12:30:00	QQQ	ETF	185.32	185.6	185.23	185.44	458823.0

> showing 50 of 17,640 rows — these rows as CSV

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