PREVIEW / etf_1hour / 2018-05-22

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-05-22.parquet
  size:    295 KB
  rows:    9,699

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-22 04:00:00	SPY	ETF	273.7	273.82	273.7	273.82	15317.0
2018-05-22 05:00:00	SPY	ETF	273.85	273.94	273.8	273.88	5215.0
2018-05-22 06:00:00	SPY	ETF	273.93	273.99	273.73	273.86	20775.0
2018-05-22 07:00:00	SPY	ETF	273.9	273.95	273.79	273.9	74931.0
2018-05-22 08:00:00	SPY	ETF	273.9	273.96	273.389	273.81	300846.0
2018-05-22 09:00:00	SPY	ETF	273.79	274.25	273.75	273.94	5007605.0
2018-05-22 10:00:00	SPY	ETF	273.94	274.18	273.34	273.57	7413942.0
2018-05-22 11:00:00	SPY	ETF	273.56	273.99	273.56	273.7851	3854897.0
2018-05-22 12:00:00	SPY	ETF	273.79	273.915	273.44	273.5695	4414611.0
2018-05-22 13:00:00	SPY	ETF	273.58	273.69	273.4	273.51	2874369.0
2018-05-22 14:00:00	SPY	ETF	273.52	273.85	273.19	273.191	4397992.0
2018-05-22 15:00:00	SPY	ETF	273.2	273.31	272.24	272.56	16782878.0
2018-05-22 16:00:00	SPY	ETF	272.57	272.82	272.4978	272.65	5911017.0
2018-05-22 17:00:00	SPY	ETF	273.3513	273.3513	272.52	272.6	2875946.0
2018-05-22 18:00:00	SPY	ETF	272.6	272.68	272.52	272.68	52637.0
2018-05-22 19:00:00	SPY	ETF	272.65	272.66	272.5	272.52	18759.0
2018-05-22 04:00:00	QQQ	ETF	168.65	168.83	168.65	168.83	3160.0
2018-05-22 05:00:00	QQQ	ETF	168.94	169.06	168.94	169.04	6800.0
2018-05-22 06:00:00	QQQ	ETF	169.13	169.25	169.05	169.25	18545.0
2018-05-22 07:00:00	QQQ	ETF	169.25	169.26	168.98	169.02	199453.0
2018-05-22 08:00:00	QQQ	ETF	169.1999	169.23	168.98	169.01	99041.0
2018-05-22 09:00:00	QQQ	ETF	169.0	169.45	168.87	168.99	2208548.0
2018-05-22 10:00:00	QQQ	ETF	168.995	169.05	168.28	168.56	3717476.0
2018-05-22 11:00:00	QQQ	ETF	168.5401	168.79	168.34	168.519	1566953.0
2018-05-22 12:00:00	QQQ	ETF	168.53	168.69	168.141	168.3751	1680919.0
2018-05-22 13:00:00	QQQ	ETF	168.375	168.645	168.32	168.57	1343818.0
2018-05-22 14:00:00	QQQ	ETF	168.58	168.9	168.49	168.515	1649788.0
2018-05-22 15:00:00	QQQ	ETF	168.51	168.65	167.88	168.17	4265287.0
2018-05-22 16:00:00	QQQ	ETF	168.17	168.43	168.125	168.32	828174.0
2018-05-22 17:00:00	QQQ	ETF	168.31	168.31	168.26	168.26	5720.0
2018-05-22 18:00:00	QQQ	ETF	168.27	168.31	168.14	168.31	30015.0
2018-05-22 19:00:00	QQQ	ETF	168.23	168.28	168.12	168.17	31504.0
2018-05-22 05:00:00	IWM	ETF	163.42	163.42	163.42	163.42	301.0
2018-05-22 06:00:00	IWM	ETF	163.45	163.45	163.29	163.38	1899.0
2018-05-22 07:00:00	IWM	ETF	163.38	163.39	109.519	135.33	14423.0
2018-05-22 08:00:00	IWM	ETF	163.37	163.4	163.25	163.25	20382.0
2018-05-22 09:00:00	IWM	ETF	163.27	163.33	162.88	163.0	1862142.0
2018-05-22 10:00:00	IWM	ETF	162.995	163.3	162.55	162.81	2054031.0
2018-05-22 11:00:00	IWM	ETF	162.8025	163.2	162.8	163.069	906468.0
2018-05-22 12:00:00	IWM	ETF	163.09	163.09	162.64	162.76	516589.0
2018-05-22 13:00:00	IWM	ETF	162.75	162.82	162.55	162.62	635399.0
2018-05-22 14:00:00	IWM	ETF	162.61	162.75	162.14	162.15	1063029.0
2018-05-22 15:00:00	IWM	ETF	162.14	162.21	161.63	161.75	3910758.0
2018-05-22 16:00:00	IWM	ETF	161.75	163.0436	161.67	161.71	737488.0
2018-05-22 17:00:00	IWM	ETF	161.7	161.76	161.68	161.68	102400.0
2018-05-22 18:00:00	IWM	ETF	161.7	161.71	161.65	161.71	5772.0
2018-05-22 19:00:00	IWM	ETF	161.67	161.7	161.65	161.69	1060.0
2018-05-22 04:00:00	DIA	ETF	250.38	250.38	250.38	250.38	100.0
2018-05-22 05:00:00	DIA	ETF	250.38	250.38	250.38	250.38	1000.0
2018-05-22 06:00:00	DIA	ETF	250.5	250.5	250.5	250.5	100.0

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

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