PREVIEW / etf_1hour / 2018-01-26

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-01-26.parquet
  size:    309 KB
  rows:    10,090

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-01-26 04:00:00	SPY	ETF	283.85	284.02	283.74	284.02	8160.0
2018-01-26 05:00:00	SPY	ETF	283.96	284.3	283.96	284.3	6046.0
2018-01-26 06:00:00	SPY	ETF	284.33	284.47	284.26	284.46	9129.0
2018-01-26 07:00:00	SPY	ETF	284.48	284.5	284.13	284.31	238185.0
2018-01-26 08:00:00	SPY	ETF	284.28	284.5	284.04	284.35	435401.0
2018-01-26 09:00:00	SPY	ETF	284.35	284.56	283.96	284.44	5938053.0
2018-01-26 10:00:00	SPY	ETF	284.44	284.93	284.1	284.67	8815413.0
2018-01-26 11:00:00	SPY	ETF	284.675	284.89	284.52	284.68	8430920.0
2018-01-26 12:00:00	SPY	ETF	284.68	285.21	284.59	285.1	6535430.0
2018-01-26 13:00:00	SPY	ETF	285.11	285.535	285.105	285.453	6641406.0
2018-01-26 14:00:00	SPY	ETF	285.46	285.59	285.22	285.49	10423718.0
2018-01-26 15:00:00	SPY	ETF	285.5	286.58	285.46	286.57	29170614.0
2018-01-26 16:00:00	SPY	ETF	286.56	286.87	284.4097	286.77	23272273.0
2018-01-26 17:00:00	SPY	ETF	286.78	286.92	286.58	286.58	161005.0
2018-01-26 18:00:00	SPY	ETF	286.85	286.91	286.81	286.86	46825.0
2018-01-26 19:00:00	SPY	ETF	286.9	286.96	286.86	286.96	28361.0
2018-01-26 04:00:00	QQQ	ETF	168.88	169.29	168.88	169.14	8600.0
2018-01-26 05:00:00	QQQ	ETF	169.17	169.43	169.17	169.43	7792.0
2018-01-26 06:00:00	QQQ	ETF	169.46	169.5	169.33	169.36	31340.0
2018-01-26 07:00:00	QQQ	ETF	169.39	169.39	169.15	169.25	99883.0
2018-01-26 08:00:00	QQQ	ETF	169.23	169.43	169.15	169.34	163695.0
2018-01-26 09:00:00	QQQ	ETF	169.35	169.43	168.96	169.33	3193155.0
2018-01-26 10:00:00	QQQ	ETF	169.32	169.87	169.07	169.74	2972543.0
2018-01-26 11:00:00	QQQ	ETF	169.75	169.851	169.55	169.64	1595436.0
2018-01-26 12:00:00	QQQ	ETF	169.63	169.82	169.49	169.72	1472294.0
2018-01-26 13:00:00	QQQ	ETF	169.74	170.1564	169.74	170.12	2271122.0
2018-01-26 14:00:00	QQQ	ETF	170.12	170.3	169.93	170.17	1789789.0
2018-01-26 15:00:00	QQQ	ETF	170.17	170.88	170.13	170.86	6918632.0
2018-01-26 16:00:00	QQQ	ETF	170.86	171.03	170.7	170.97	3901184.0
2018-01-26 17:00:00	QQQ	ETF	170.95	171.02	170.93	170.98	14325.0
2018-01-26 18:00:00	QQQ	ETF	171.0	171.1	170.96	171.07	12512.0
2018-01-26 19:00:00	QQQ	ETF	171.07	171.07	171.04	171.07	3568.0
2018-01-26 04:00:00	IWM	ETF	159.42	159.46	159.42	159.46	1600.0
2018-01-26 05:00:00	IWM	ETF	159.54	159.54	159.54	159.54	400.0
2018-01-26 06:00:00	IWM	ETF	159.62	159.66	159.53	159.66	7536.0
2018-01-26 07:00:00	IWM	ETF	159.68	159.72	159.41	159.47	12686.0
2018-01-26 08:00:00	IWM	ETF	159.53	159.75	159.51	159.71	42257.0
2018-01-26 09:00:00	IWM	ETF	159.7	159.72	158.77	159.24	1838261.0
2018-01-26 10:00:00	IWM	ETF	159.24	159.51	158.9	158.91	2774257.0
2018-01-26 11:00:00	IWM	ETF	158.91	159.25	158.78	158.96	1437131.0
2018-01-26 12:00:00	IWM	ETF	158.96	159.18	158.86	159.17	835516.0
2018-01-26 13:00:00	IWM	ETF	159.17	159.39	159.16	159.33	825826.0
2018-01-26 14:00:00	IWM	ETF	159.335	159.42	159.22	159.31	817764.0
2018-01-26 15:00:00	IWM	ETF	159.29	159.685	159.25	159.62	2990662.0
2018-01-26 16:00:00	IWM	ETF	159.62	159.74	159.53	159.61	1944834.0
2018-01-26 17:00:00	IWM	ETF	159.7	159.97	159.65	159.74	9690.0
2018-01-26 18:00:00	IWM	ETF	159.75	159.76	159.73	159.73	1360.0
2018-01-26 19:00:00	IWM	ETF	159.88	159.88	159.73	159.74	1283.0
2018-01-26 06:00:00	DIA	ETF	264.25	264.46	264.25	264.46	300.0
2018-01-26 07:00:00	DIA	ETF	264.5	264.6	264.18	264.18	1540.0

> showing 50 of 10,090 rows — these rows as CSV

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