PREVIEW / etf_1hour / 2017-11-20

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-11-20.parquet
  size:    287 KB
  rows:    9,461

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
2017-11-20 04:00:00	SPY	ETF	257.55	257.55	257.4	257.41	3451.0
2017-11-20 05:00:00	SPY	ETF	257.41	257.6	257.41	257.6	700.0
2017-11-20 06:00:00	SPY	ETF	257.64	257.82	257.58	257.71	52631.0
2017-11-20 07:00:00	SPY	ETF	257.74	257.77	257.63	257.65	218209.0
2017-11-20 08:00:00	SPY	ETF	257.71	258.03	257.62	257.99	305429.0
2017-11-20 09:00:00	SPY	ETF	257.99	258.19	257.86	258.15	6213191.0
2017-11-20 10:00:00	SPY	ETF	258.145	258.29	257.96	258.26	6336925.0
2017-11-20 11:00:00	SPY	ETF	258.265	258.395	258.19	258.32	3867461.0
2017-11-20 12:00:00	SPY	ETF	258.32	258.36	258.11	258.33	4169257.0
2017-11-20 13:00:00	SPY	ETF	258.33	258.49	258.28	258.47	3265251.0
2017-11-20 14:00:00	SPY	ETF	258.465	258.49	258.36	258.4	5214374.0
2017-11-20 15:00:00	SPY	ETF	258.409	258.525	258.13	258.29	9655883.0
2017-11-20 16:00:00	SPY	ETF	258.28	258.44	257.9996	258.36	8011859.0
2017-11-20 17:00:00	SPY	ETF	258.39	258.42	258.33	258.33	74497.0
2017-11-20 18:00:00	SPY	ETF	258.33	258.33	258.2	258.24	100312.0
2017-11-20 19:00:00	SPY	ETF	258.22	258.35	258.12	258.2	112695.0
2017-11-20 04:00:00	QQQ	ETF	153.47	153.69	153.47	153.64	16796.0
2017-11-20 05:00:00	QQQ	ETF	153.69	153.69	153.69	153.69	200.0
2017-11-20 06:00:00	QQQ	ETF	153.79	153.94	153.79	153.85	31811.0
2017-11-20 07:00:00	QQQ	ETF	153.86	153.94	153.84	153.87	53843.0
2017-11-20 08:00:00	QQQ	ETF	153.85	154.07	153.82	154.03	237534.0
2017-11-20 09:00:00	QQQ	ETF	154.04	154.2	153.9	154.0878	2316435.0
2017-11-20 10:00:00	QQQ	ETF	154.09	154.14	153.79	153.97	2404197.0
2017-11-20 11:00:00	QQQ	ETF	153.98	154.0266	153.795	153.93	2263705.0
2017-11-20 12:00:00	QQQ	ETF	153.925	153.96	153.61	153.86	1511680.0
2017-11-20 13:00:00	QQQ	ETF	153.8653	153.97	153.82	153.91	1111410.0
2017-11-20 14:00:00	QQQ	ETF	153.911	153.92	153.79	153.84	812621.0
2017-11-20 15:00:00	QQQ	ETF	153.839	153.94	153.69	153.82	3878769.0
2017-11-20 16:00:00	QQQ	ETF	153.81	153.92	153.0	153.91	6044198.0
2017-11-20 17:00:00	QQQ	ETF	153.94	153.94	153.84	153.86	1204.0
2017-11-20 18:00:00	QQQ	ETF	153.84	153.84	153.79	153.83	6500.0
2017-11-20 19:00:00	QQQ	ETF	153.83	153.9	153.8	153.82	9230.0
2017-11-20 04:00:00	IWM	ETF	148.11	148.12	148.11	148.12	5200.0
2017-11-20 05:00:00	IWM	ETF	148.22	148.22	148.22	148.22	3194.0
2017-11-20 06:00:00	IWM	ETF	148.34	148.4	148.34	148.35	4203.0
2017-11-20 07:00:00	IWM	ETF	148.35	148.42	148.34	148.4	46081.0
2017-11-20 08:00:00	IWM	ETF	148.34	148.67	148.34	148.62	42213.0
2017-11-20 09:00:00	IWM	ETF	148.7	148.815	148.33	148.7	1688609.0
2017-11-20 10:00:00	IWM	ETF	148.7	149.1	148.42	149.03	2122494.0
2017-11-20 11:00:00	IWM	ETF	149.025	149.04	148.75	148.86	1369245.0
2017-11-20 12:00:00	IWM	ETF	148.86	149.0	148.78	148.9	906618.0
2017-11-20 13:00:00	IWM	ETF	148.89	149.25	148.84	149.24	1058087.0
2017-11-20 14:00:00	IWM	ETF	149.245	149.34	149.075	149.23	1318555.0
2017-11-20 15:00:00	IWM	ETF	149.23	149.58	149.19	149.53	4851206.0
2017-11-20 16:00:00	IWM	ETF	149.53	149.59	149.3866	149.56	1957187.0
2017-11-20 17:00:00	IWM	ETF	149.55	149.64	149.47	149.64	11940.0
2017-11-20 18:00:00	IWM	ETF	149.54	149.54	149.43	149.45	16482.0
2017-11-20 19:00:00	IWM	ETF	149.42	149.45	149.42	149.45	2107.0
2017-11-20 07:00:00	DIA	ETF	233.33	233.36	233.33	233.36	2889.0
2017-11-20 08:00:00	DIA	ETF	233.62	233.62	233.62	233.62	250.0

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

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