PREVIEW / etf_30min / 2019-05-07

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-05-07.parquet
  size:    517 KB
  rows:    18,062

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-05-07 04:00:00	SPY	ETF	291.81	292.07	291.73	291.75	26194.0
2019-05-07 04:30:00	SPY	ETF	291.81	291.81	291.48	291.48	8795.0
2019-05-07 05:00:00	SPY	ETF	291.41	291.46	291.37	291.37	900.0
2019-05-07 05:30:00	SPY	ETF	291.25	291.43	291.15	291.4	5575.0
2019-05-07 06:00:00	SPY	ETF	291.39	291.43	291.3	291.3	5200.0
2019-05-07 06:30:00	SPY	ETF	291.35	291.41	290.88	290.91	101713.0
2019-05-07 07:00:00	SPY	ETF	290.93	291.02	290.81	290.99	131993.0
2019-05-07 07:30:00	SPY	ETF	290.99	291.25	290.43	290.55	371403.0
2019-05-07 08:00:00	SPY	ETF	290.55	292.5	290.4	290.94	487533.0
2019-05-07 08:30:00	SPY	ETF	290.92	291.02	290.79	290.79	250165.0
2019-05-07 09:00:00	SPY	ETF	290.79	290.81	289.84	290.14	1394921.0
2019-05-07 09:30:00	SPY	ETF	290.15	290.81	289.1	289.81	12680136.0
2019-05-07 10:00:00	SPY	ETF	289.81	289.82	288.58	289.61	10392836.0
2019-05-07 10:30:00	SPY	ETF	289.605	289.69	288.27	288.4732	7521330.0
2019-05-07 11:00:00	SPY	ETF	288.47	288.97	287.97	288.64	10506244.0
2019-05-07 11:30:00	SPY	ETF	288.65	289.06	287.81	288.16	6464795.0
2019-05-07 12:00:00	SPY	ETF	288.15	289.01	287.7	288.92	5387169.0
2019-05-07 12:30:00	SPY	ETF	288.94	289.11	288.39	288.41	4621643.0
2019-05-07 13:00:00	SPY	ETF	288.41	288.49	286.945	287.1	6097763.0
2019-05-07 13:30:00	SPY	ETF	287.105	287.65	286.66	287.2325	7898226.0
2019-05-07 14:00:00	SPY	ETF	287.24	287.65	286.68	286.74	7078393.0
2019-05-07 14:30:00	SPY	ETF	286.75	287.24	286.26	287.02	9210260.0
2019-05-07 15:00:00	SPY	ETF	287.01	287.39	286.46	286.6481	7872197.0
2019-05-07 15:30:00	SPY	ETF	286.64	288.2	285.81	288.04	22667027.0
2019-05-07 16:00:00	SPY	ETF	288.03	288.69	287.1757	288.53	15246126.0
2019-05-07 16:30:00	SPY	ETF	288.53	288.6	287.93	288.59	708621.0
2019-05-07 17:00:00	SPY	ETF	288.54	288.6	288.47	288.49	2278416.0
2019-05-07 17:30:00	SPY	ETF	288.49	288.51	287.93	288.43	104659.0
2019-05-07 18:00:00	SPY	ETF	288.49	288.55	287.93	288.18	347690.0
2019-05-07 18:30:00	SPY	ETF	288.2	288.43	288.15	288.27	68954.0
2019-05-07 19:00:00	SPY	ETF	288.27	288.39	288.18	288.19	32792.0
2019-05-07 19:30:00	SPY	ETF	288.18	288.24	287.95	288.05	75325.0
2019-05-07 04:00:00	QQQ	ETF	189.42	189.44	189.13	189.21	9410.0
2019-05-07 04:30:00	QQQ	ETF	189.22	189.22	188.97	188.97	4064.0
2019-05-07 05:00:00	QQQ	ETF	189.0	189.03	188.83	188.83	9032.0
2019-05-07 05:30:00	QQQ	ETF	188.83	188.94	188.69	188.91	17331.0
2019-05-07 06:00:00	QQQ	ETF	188.9	188.96	188.78	188.83	11869.0
2019-05-07 06:30:00	QQQ	ETF	188.86	188.86	188.47	188.49	10547.0
2019-05-07 07:00:00	QQQ	ETF	188.52	188.63	188.45	188.63	39679.0
2019-05-07 07:30:00	QQQ	ETF	188.58	188.75	188.04	188.1	128573.0
2019-05-07 08:00:00	QQQ	ETF	188.09	189.75	187.87	188.42	382295.0
2019-05-07 08:30:00	QQQ	ETF	188.42	188.54	188.32	188.34	93902.0
2019-05-07 09:00:00	QQQ	ETF	188.35	188.35	187.45	187.88	853023.0
2019-05-07 09:30:00	QQQ	ETF	187.86	188.67	187.26	187.61	5981958.0
2019-05-07 10:00:00	QQQ	ETF	187.59	187.62	186.9479	187.55	3576168.0
2019-05-07 10:30:00	QQQ	ETF	187.53	187.64	186.26	186.52	3623897.0
2019-05-07 11:00:00	QQQ	ETF	186.51	186.91	185.95	186.7575	3136430.0
2019-05-07 11:30:00	QQQ	ETF	186.75	187.07	186.18	186.42	2599097.0
2019-05-07 12:00:00	QQQ	ETF	186.4	187.08	186.09	187.01	1566605.0
2019-05-07 12:30:00	QQQ	ETF	187.02	187.12	186.4301	186.44	1215241.0

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

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