PREVIEW / etf_30min / 2018-10-03

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-10-03.parquet
  size:    496 KB
  rows:    16,837

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
2018-10-03 04:00:00	SPY	ETF	292.18	292.24	292.18	292.22	5943.0
2018-10-03 04:30:00	SPY	ETF	292.28	292.3	292.22	292.3	6098.0
2018-10-03 05:00:00	SPY	ETF	292.27	292.27	291.99	291.99	10810.0
2018-10-03 05:30:00	SPY	ETF	292.18	292.21	292.16	292.21	1900.0
2018-10-03 06:00:00	SPY	ETF	292.32	292.38	292.26	292.31	21610.0
2018-10-03 06:30:00	SPY	ETF	292.29	292.4	292.26	292.29	15500.0
2018-10-03 07:00:00	SPY	ETF	292.3	292.59	292.28	292.52	65904.0
2018-10-03 07:30:00	SPY	ETF	292.53	292.59	292.47	292.53	35965.0
2018-10-03 08:00:00	SPY	ETF	291.56	292.72	291.56	292.53	105690.0
2018-10-03 08:30:00	SPY	ETF	292.53	292.74	292.53	292.74	227287.0
2018-10-03 09:00:00	SPY	ETF	292.71	292.72	292.57	292.71	193510.0
2018-10-03 09:30:00	SPY	ETF	292.74	292.88	292.48	292.5	3571280.0
2018-10-03 10:00:00	SPY	ETF	292.5	293.21	292.49	292.94	4548674.0
2018-10-03 10:30:00	SPY	ETF	292.93	292.97	292.5891	292.64	6271711.0
2018-10-03 11:00:00	SPY	ETF	292.65	292.77	292.33	292.74	5017393.0
2018-10-03 11:30:00	SPY	ETF	292.75	292.87	292.36	292.87	2729374.0
2018-10-03 12:00:00	SPY	ETF	292.8635	292.96	292.645	292.9	1685002.0
2018-10-03 12:30:00	SPY	ETF	292.91	292.94	292.59	292.8	1675951.0
2018-10-03 13:00:00	SPY	ETF	292.79	292.93	292.64	292.78	1550104.0
2018-10-03 13:30:00	SPY	ETF	292.79	292.85	292.62	292.76	1960713.0
2018-10-03 14:00:00	SPY	ETF	292.76	292.94	292.63	292.6901	2452518.0
2018-10-03 14:30:00	SPY	ETF	292.695	292.7199	291.59	291.91	7872862.0
2018-10-03 15:00:00	SPY	ETF	291.91	292.03	291.32	291.56	6405626.0
2018-10-03 15:30:00	SPY	ETF	291.56	291.93	291.53	291.78	8920709.0
2018-10-03 16:00:00	SPY	ETF	291.78	291.98	291.67	291.91	6812316.0
2018-10-03 16:30:00	SPY	ETF	291.91	291.96	291.3	291.45	543245.0
2018-10-03 17:00:00	SPY	ETF	291.46	291.55	291.45	291.47	644916.0
2018-10-03 17:30:00	SPY	ETF	291.4701	291.49	291.32	291.37	47974.0
2018-10-03 18:00:00	SPY	ETF	291.37	291.37	291.18	291.29	52267.0
2018-10-03 18:30:00	SPY	ETF	291.27	291.32	291.14	291.32	17598.0
2018-10-03 19:00:00	SPY	ETF	291.29	291.32	291.22	291.3	13132.0
2018-10-03 19:30:00	SPY	ETF	291.33	291.34	291.2	291.3	30398.0
2018-10-03 04:00:00	QQQ	ETF	186.12	186.24	186.12	186.24	800.0
2018-10-03 04:30:00	QQQ	ETF	186.29	186.29	186.29	186.29	1000.0
2018-10-03 05:00:00	QQQ	ETF	186.24	186.24	186.07	186.09	1200.0
2018-10-03 05:30:00	QQQ	ETF	186.09	186.12	186.09	186.12	300.0
2018-10-03 06:00:00	QQQ	ETF	186.25	186.25	186.2	186.25	3770.0
2018-10-03 06:30:00	QQQ	ETF	186.21	186.24	186.19	186.19	11300.0
2018-10-03 07:00:00	QQQ	ETF	186.18	186.45	186.17	186.37	25020.0
2018-10-03 07:30:00	QQQ	ETF	186.4	186.46	186.37	186.42	29752.0
2018-10-03 08:00:00	QQQ	ETF	185.75	186.56	185.75	186.36	99535.0
2018-10-03 08:30:00	QQQ	ETF	186.38	186.63	186.38	186.63	160685.0
2018-10-03 09:00:00	QQQ	ETF	186.59	186.64	186.51	186.51	89006.0
2018-10-03 09:30:00	QQQ	ETF	186.52	186.84	186.28	186.48	3272356.0
2018-10-03 10:00:00	QQQ	ETF	186.5	186.97	186.48	186.75	2077644.0
2018-10-03 10:30:00	QQQ	ETF	186.75	186.895	186.21	186.31	2075510.0
2018-10-03 11:00:00	QQQ	ETF	186.3	186.56	186.0	186.54	1904654.0
2018-10-03 11:30:00	QQQ	ETF	186.5301	186.6679	186.13	186.66	1750245.0
2018-10-03 12:00:00	QQQ	ETF	186.67	186.78	186.51	186.68	837880.0
2018-10-03 12:30:00	QQQ	ETF	186.68	186.681	186.28	186.56	1089952.0

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

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