PREVIEW / etf_1hour / 2018-05-18

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-05-18.parquet
  size:    285 KB
  rows:    9,463

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-05-18 04:00:00	SPY	ETF	272.31	272.35	272.08	272.29	10645.0
2018-05-18 05:00:00	SPY	ETF	272.2	272.55	272.2	272.55	5272.0
2018-05-18 06:00:00	SPY	ETF	272.54	272.61	272.39	272.39	16348.0
2018-05-18 07:00:00	SPY	ETF	272.39	272.45	272.16	272.25	109551.0
2018-05-18 08:00:00	SPY	ETF	272.45	272.64	271.3	271.36	486219.0
2018-05-18 09:00:00	SPY	ETF	271.33	271.98	271.26	271.59	6038850.0
2018-05-18 10:00:00	SPY	ETF	271.59	272.01	270.93	271.48	13919379.0
2018-05-18 11:00:00	SPY	ETF	271.49	272.03	271.42	271.89	6966239.0
2018-05-18 12:00:00	SPY	ETF	271.9	271.9	271.32	271.6	5362063.0
2018-05-18 13:00:00	SPY	ETF	271.595	271.79	271.31	271.43	3810566.0
2018-05-18 14:00:00	SPY	ETF	271.44	271.71	271.2952	271.6399	6199752.0
2018-05-18 15:00:00	SPY	ETF	271.63	271.66	271.31	271.34	13598480.0
2018-05-18 16:00:00	SPY	ETF	271.35	271.46	271.3	271.32	5339334.0
2018-05-18 17:00:00	SPY	ETF	271.33	271.44	271.15	271.15	739142.0
2018-05-18 18:00:00	SPY	ETF	271.15	271.19	270.95	271.06	102549.0
2018-05-18 19:00:00	SPY	ETF	271.09	271.25	271.06	271.25	13264.0
2018-05-18 04:00:00	QQQ	ETF	168.5	168.66	168.5	168.66	400.0
2018-05-18 05:00:00	QQQ	ETF	168.67	168.77	168.62	168.72	16652.0
2018-05-18 06:00:00	QQQ	ETF	168.75	168.75	168.62	168.66	22016.0
2018-05-18 07:00:00	QQQ	ETF	168.65	168.66	168.45	168.5	71652.0
2018-05-18 08:00:00	QQQ	ETF	168.5899	168.62	167.38	167.4	598514.0
2018-05-18 09:00:00	QQQ	ETF	167.39	168.01	167.36	167.65	3088123.0
2018-05-18 10:00:00	QQQ	ETF	167.65	168.01	167.21	167.61	3726770.0
2018-05-18 11:00:00	QQQ	ETF	167.62	168.26	167.59	168.0942	2540553.0
2018-05-18 12:00:00	QQQ	ETF	168.1	168.1	167.7	167.89	1700655.0
2018-05-18 13:00:00	QQQ	ETF	167.9	167.98	167.57	167.67	2127826.0
2018-05-18 14:00:00	QQQ	ETF	167.68	167.81	167.55	167.73	1353444.0
2018-05-18 15:00:00	QQQ	ETF	167.75	167.7566	167.44	167.46	4399683.0
2018-05-18 16:00:00	QQQ	ETF	167.46	167.59	167.43	167.47	1999259.0
2018-05-18 17:00:00	QQQ	ETF	167.49	167.63	167.43	167.52	58964.0
2018-05-18 18:00:00	QQQ	ETF	167.41	167.45	167.38	167.45	2636.0
2018-05-18 19:00:00	QQQ	ETF	167.41	167.48	167.32	167.48	8766.0
2018-05-18 04:00:00	IWM	ETF	161.84	162.02	161.83	162.02	3000.0
2018-05-18 05:00:00	IWM	ETF	161.99	162.12	161.99	162.06	3489.0
2018-05-18 06:00:00	IWM	ETF	162.13	162.13	162.13	162.13	500.0
2018-05-18 07:00:00	IWM	ETF	161.99	161.99	161.87	161.92	31324.0
2018-05-18 08:00:00	IWM	ETF	161.84	161.84	161.45	161.45	46919.0
2018-05-18 09:00:00	IWM	ETF	161.45	162.19	161.45	162.02	1992670.0
2018-05-18 10:00:00	IWM	ETF	162.02	162.13	161.55	161.85	2597738.0
2018-05-18 11:00:00	IWM	ETF	161.86	162.13	161.82	162.09	1373676.0
2018-05-18 12:00:00	IWM	ETF	162.09	162.15	161.885	162.1	933258.0
2018-05-18 13:00:00	IWM	ETF	162.11	162.3178	162.0	162.05	1396352.0
2018-05-18 14:00:00	IWM	ETF	162.04	162.09	161.88	162.07	1218606.0
2018-05-18 15:00:00	IWM	ETF	162.08	162.105	161.84	161.855	2550726.0
2018-05-18 16:00:00	IWM	ETF	161.87	161.87	161.75	161.75	1722413.0
2018-05-18 17:00:00	IWM	ETF	161.72	161.76	161.72	161.74	1445.0
2018-05-18 19:00:00	IWM	ETF	161.7	161.8	161.7	161.79	2800.0
2018-05-18 05:00:00	DIA	ETF	247.59	247.59	247.59	247.59	100.0
2018-05-18 07:00:00	DIA	ETF	247.58	247.58	247.46	247.54	4251.0
2018-05-18 08:00:00	DIA	ETF	247.46	247.57	246.74	246.82	17194.0

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

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