PREVIEW / etf_30min / 2019-01-16

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-01-16.parquet
  size:    497 KB
  rows:    17,350

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-01-16 04:00:00	SPY	ETF	260.77	260.83	260.47	260.47	4572.0
2019-01-16 04:30:00	SPY	ETF	260.46	260.57	260.33	260.42	7300.0
2019-01-16 05:00:00	SPY	ETF	260.47	260.72	260.47	260.6	3039.0
2019-01-16 05:30:00	SPY	ETF	260.56	260.56	260.31	260.32	14423.0
2019-01-16 06:00:00	SPY	ETF	260.26	260.28	260.14	260.26	5696.0
2019-01-16 06:30:00	SPY	ETF	260.22	260.36	260.15	260.35	4968.0
2019-01-16 07:00:00	SPY	ETF	260.38	260.44	260.09	260.29	34237.0
2019-01-16 07:30:00	SPY	ETF	260.24	260.66	260.21	260.54	101654.0
2019-01-16 08:00:00	SPY	ETF	260.1501	260.83	260.1501	260.43	114382.0
2019-01-16 08:30:00	SPY	ETF	260.48	260.7	260.43	260.61	99813.0
2019-01-16 09:00:00	SPY	ETF	260.61	260.97	260.35	260.82	344169.0
2019-01-16 09:30:00	SPY	ETF	260.83	261.72	260.65	261.415	7736077.0
2019-01-16 10:00:00	SPY	ETF	261.42	261.73	261.34	261.38	6349252.0
2019-01-16 10:30:00	SPY	ETF	261.38	261.48	260.6	261.21	4728815.0
2019-01-16 11:00:00	SPY	ETF	261.215	261.52	260.66	261.46	4346862.0
2019-01-16 11:30:00	SPY	ETF	261.455	261.625	260.8	261.005	3652187.0
2019-01-16 12:00:00	SPY	ETF	261.01	261.32	260.74	261.27	2964476.0
2019-01-16 12:30:00	SPY	ETF	261.26	261.48	260.94	261.36	2347486.0
2019-01-16 13:00:00	SPY	ETF	261.36	261.4	261.08	261.29	1863220.0
2019-01-16 13:30:00	SPY	ETF	261.3	261.52	261.22	261.41	1724519.0
2019-01-16 14:00:00	SPY	ETF	261.41	261.77	261.4	261.71	4223848.0
2019-01-16 14:30:00	SPY	ETF	261.7	261.9666	261.4	261.49	5492537.0
2019-01-16 15:00:00	SPY	ETF	261.5	261.85	261.43	261.75	2941272.0
2019-01-16 15:30:00	SPY	ETF	261.745	261.75	260.86	260.95	13337088.0
2019-01-16 16:00:00	SPY	ETF	260.95	261.06	260.59	260.69	11966964.0
2019-01-16 16:30:00	SPY	ETF	260.69	260.9	260.69	260.88	134456.0
2019-01-16 17:00:00	SPY	ETF	260.86	260.98	260.77	260.77	157799.0
2019-01-16 17:30:00	SPY	ETF	260.78	260.85	260.76	260.76	19045.0
2019-01-16 18:00:00	SPY	ETF	260.78	260.85	260.65	260.8	27888.0
2019-01-16 18:30:00	SPY	ETF	260.82	260.92	260.51	260.53	35980.0
2019-01-16 19:00:00	SPY	ETF	260.53	260.56	260.29	260.44	32994.0
2019-01-16 19:30:00	SPY	ETF	260.47	260.6	260.26	260.49	37177.0
2019-01-16 20:00:00	SPY	ETF	260.9701	260.98	260.9701	260.98	28259.0
2019-01-16 04:00:00	QQQ	ETF	162.38	162.58	162.26	162.35	10622.0
2019-01-16 04:30:00	QQQ	ETF	162.31	162.38	162.27	162.35	5288.0
2019-01-16 05:00:00	QQQ	ETF	162.38	162.49	162.38	162.4	10655.0
2019-01-16 05:30:00	QQQ	ETF	162.38	162.41	162.25	162.29	16016.0
2019-01-16 06:00:00	QQQ	ETF	162.28	162.3	162.19	162.3	5601.0
2019-01-16 06:30:00	QQQ	ETF	162.3	162.37	162.29	162.35	9189.0
2019-01-16 07:00:00	QQQ	ETF	162.4	162.46	162.27	162.39	26005.0
2019-01-16 07:30:00	QQQ	ETF	162.4	162.65	162.39	162.55	76479.0
2019-01-16 08:00:00	QQQ	ETF	162.38	162.8	162.3001	162.47	148044.0
2019-01-16 08:30:00	QQQ	ETF	162.53	162.63	162.47	162.55	52927.0
2019-01-16 09:00:00	QQQ	ETF	162.55	162.79	162.55	162.63	203346.0
2019-01-16 09:30:00	QQQ	ETF	162.63	163.78	162.55	163.43	4318394.0
2019-01-16 10:00:00	QQQ	ETF	163.44	163.66	163.06	163.1	2209746.0
2019-01-16 10:30:00	QQQ	ETF	163.11	163.2198	162.37	162.69	2579499.0
2019-01-16 11:00:00	QQQ	ETF	162.7	163.14	162.29	163.03	2479960.0
2019-01-16 11:30:00	QQQ	ETF	163.03	163.24	162.37	162.53	1708757.0
2019-01-16 12:00:00	QQQ	ETF	162.5201	162.755	162.3	162.5894	1563969.0

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

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