PREVIEW / etf_1hour / 2018-04-13

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-04-13.parquet
  size:    290 KB
  rows:    9,496

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-04-13 04:00:00	SPY	ETF	266.12	266.2	265.96	266.2	17382.0
2018-04-13 05:00:00	SPY	ETF	266.2	266.5	266.14	266.5	23154.0
2018-04-13 06:00:00	SPY	ETF	266.51	266.76	266.25	266.68	239888.0
2018-04-13 07:00:00	SPY	ETF	266.66	266.83	266.42	266.72	186159.0
2018-04-13 08:00:00	SPY	ETF	266.72	267.49	265.22	267.35	659186.0
2018-04-13 09:00:00	SPY	ETF	267.36	267.54	266.51	266.575	7171680.0
2018-04-13 10:00:00	SPY	ETF	266.56	266.75	265.03	265.04	13430036.0
2018-04-13 11:00:00	SPY	ETF	265.06	265.9	264.63	265.81	8617421.0
2018-04-13 12:00:00	SPY	ETF	265.8	266.087	265.27	265.59	6528337.0
2018-04-13 13:00:00	SPY	ETF	265.6	266.33	265.59	266.0662	7152565.0
2018-04-13 14:00:00	SPY	ETF	266.06	266.19	265.25	265.34	8010240.0
2018-04-13 15:00:00	SPY	ETF	265.34	265.415	264.01	265.16	22387515.0
2018-04-13 16:00:00	SPY	ETF	265.15	265.4	265.01	265.4	7885573.0
2018-04-13 17:00:00	SPY	ETF	265.29	265.6	265.15	265.43	254717.0
2018-04-13 18:00:00	SPY	ETF	265.41	265.48	263.69	265.15	100241.0
2018-04-13 19:00:00	SPY	ETF	265.16	265.38	265.12	265.33	27258.0
2018-04-13 04:00:00	QQQ	ETF	162.0	162.04	161.92	161.97	9200.0
2018-04-13 05:00:00	QQQ	ETF	162.05	162.21	162.0	162.21	2661.0
2018-04-13 06:00:00	QQQ	ETF	162.29	162.46	162.12	162.46	12402.0
2018-04-13 07:00:00	QQQ	ETF	162.5	162.54	162.3	162.52	53443.0
2018-04-13 08:00:00	QQQ	ETF	162.36	163.1	162.3	163.01	402320.0
2018-04-13 09:00:00	QQQ	ETF	163.03	163.26	162.34	162.45	3628491.0
2018-04-13 10:00:00	QQQ	ETF	162.44	162.57	161.221	161.54	6447885.0
2018-04-13 11:00:00	QQQ	ETF	161.55	162.04	161.13	161.879	4134111.0
2018-04-13 12:00:00	QQQ	ETF	161.87	162.09	161.55	161.94	2642693.0
2018-04-13 13:00:00	QQQ	ETF	161.94	162.37	161.88	162.225	3463592.0
2018-04-13 14:00:00	QQQ	ETF	162.21	162.32	161.601	161.67	4520066.0
2018-04-13 15:00:00	QQQ	ETF	161.67	161.69	160.67	161.4	7906074.0
2018-04-13 16:00:00	QQQ	ETF	161.39	161.59	161.35	161.53	2592672.0
2018-04-13 17:00:00	QQQ	ETF	161.47	161.59	161.46	161.56	12204.0
2018-04-13 18:00:00	QQQ	ETF	161.57	161.67	161.51	161.67	17966.0
2018-04-13 19:00:00	QQQ	ETF	161.53	161.65	161.49	161.49	9166.0
2018-04-13 04:00:00	IWM	ETF	154.74	154.93	154.74	154.93	1394.0
2018-04-13 06:00:00	IWM	ETF	155.07	155.07	155.07	155.07	125.0
2018-04-13 07:00:00	IWM	ETF	155.01	155.01	155.01	155.01	100.0
2018-04-13 08:00:00	IWM	ETF	155.05	155.35	155.01	155.26	37293.0
2018-04-13 09:00:00	IWM	ETF	155.32	155.3292	154.42	154.48	2413205.0
2018-04-13 10:00:00	IWM	ETF	154.48	154.49	153.76	153.77	3333447.0
2018-04-13 11:00:00	IWM	ETF	153.77	154.47	153.54	154.25	2897304.0
2018-04-13 12:00:00	IWM	ETF	154.24	154.55	154.15	154.39	977124.0
2018-04-13 13:00:00	IWM	ETF	154.39	154.74	154.31	154.52	935196.0
2018-04-13 14:00:00	IWM	ETF	154.51	154.661	154.08	154.13	1298948.0
2018-04-13 15:00:00	IWM	ETF	154.14	154.21	153.511	153.96	4278886.0
2018-04-13 16:00:00	IWM	ETF	153.965	154.19	153.9	154.19	1724161.0
2018-04-13 17:00:00	IWM	ETF	154.16	154.18	154.1	154.16	5656.0
2018-04-13 18:00:00	IWM	ETF	154.16	154.16	153.96	153.96	1000.0
2018-04-13 06:00:00	DIA	ETF	245.3	245.32	245.3	245.32	300.0
2018-04-13 07:00:00	DIA	ETF	245.5	245.61	245.38	245.61	2453.0
2018-04-13 08:00:00	DIA	ETF	245.71	246.3	245.71	246.27	7233.0
2018-04-13 09:00:00	DIA	ETF	246.3	246.5	245.12	245.1604	537602.0

> showing 50 of 9,496 rows — these rows as CSV

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