PREVIEW / etf_1hour / 2018-05-03

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-05-03.parquet
  size:    294 KB
  rows:    9,660

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-03 04:00:00	SPY	ETF	263.06	263.39	263.06	263.3	39503.0
2018-05-03 05:00:00	SPY	ETF	263.33	263.53	263.03	263.06	11003.0
2018-05-03 06:00:00	SPY	ETF	263.12	263.32	263.06	263.15	28374.0
2018-05-03 07:00:00	SPY	ETF	263.16	263.2	261.73	261.88	353094.0
2018-05-03 08:00:00	SPY	ETF	262.5301	263.17	261.64	261.87	847656.0
2018-05-03 09:00:00	SPY	ETF	261.9	263.2	261.14	262.166	10875129.0
2018-05-03 10:00:00	SPY	ETF	262.16	262.175	259.05	259.5498	31039456.0
2018-05-03 11:00:00	SPY	ETF	259.54	260.71	259.35	260.5148	18906141.0
2018-05-03 12:00:00	SPY	ETF	260.51	262.7	260.0	262.58	15362207.0
2018-05-03 13:00:00	SPY	ETF	262.58	263.13	261.78	262.65	12808021.0
2018-05-03 14:00:00	SPY	ETF	262.64	263.36	262.19	262.42	13461256.0
2018-05-03 15:00:00	SPY	ETF	262.41	263.1	262.08	262.61	16349073.0
2018-05-03 16:00:00	SPY	ETF	262.59	263.15	262.59	262.95	14162678.0
2018-05-03 17:00:00	SPY	ETF	263.02	263.07	262.62	263.0	56168.0
2018-05-03 18:00:00	SPY	ETF	263.03	263.22	263.03	263.05	26736.0
2018-05-03 19:00:00	SPY	ETF	263.09	263.09	262.43	262.56	239870.0
2018-05-03 20:00:00	SPY	ETF	262.62	262.62	262.6	262.6	1000.0
2018-05-03 04:00:00	QQQ	ETF	161.85	161.93	161.79	161.8	6244.0
2018-05-03 05:00:00	QQQ	ETF	161.88	161.91	161.73	161.73	1800.0
2018-05-03 06:00:00	QQQ	ETF	161.87	161.87	161.8	161.81	7600.0
2018-05-03 07:00:00	QQQ	ETF	161.82	161.85	160.83	160.93	108364.0
2018-05-03 08:00:00	QQQ	ETF	160.96	161.8	160.7	160.93	259801.0
2018-05-03 09:00:00	QQQ	ETF	160.97	161.66	160.48	161.51	4751797.0
2018-05-03 10:00:00	QQQ	ETF	161.5	161.54	159.22	159.5048	11332780.0
2018-05-03 11:00:00	QQQ	ETF	159.51	160.44	159.2808	160.28	7666250.0
2018-05-03 12:00:00	QQQ	ETF	160.2899	161.86	159.85	161.77	6191511.0
2018-05-03 13:00:00	QQQ	ETF	161.75	162.14	161.29	161.7	6668800.0
2018-05-03 14:00:00	QQQ	ETF	161.7	162.4	161.355	161.68	5962342.0
2018-05-03 15:00:00	QQQ	ETF	161.68	162.355	161.47	161.78	5408630.0
2018-05-03 16:00:00	QQQ	ETF	161.78	162.38	161.1611	162.29	881420.0
2018-05-03 17:00:00	QQQ	ETF	162.22	162.28	162.19	162.23	11535.0
2018-05-03 18:00:00	QQQ	ETF	162.27	162.43	162.27	162.36	57524.0
2018-05-03 19:00:00	QQQ	ETF	162.33	162.33	161.8	161.87	57767.0
2018-05-03 04:00:00	IWM	ETF	154.63	154.64	154.63	154.64	2283.0
2018-05-03 06:00:00	IWM	ETF	154.56	154.56	154.5	154.5	900.0
2018-05-03 07:00:00	IWM	ETF	154.27	154.27	153.65	153.77	45667.0
2018-05-03 08:00:00	IWM	ETF	154.26	154.26	153.62	153.87	139087.0
2018-05-03 09:00:00	IWM	ETF	153.97	154.5	153.64	154.33	2198199.0
2018-05-03 10:00:00	IWM	ETF	154.35	154.38	152.16	152.43	4339087.0
2018-05-03 11:00:00	IWM	ETF	152.42	153.45	152.17	153.38	2702540.0
2018-05-03 12:00:00	IWM	ETF	153.39	154.17	152.96	154.14	2212924.0
2018-05-03 13:00:00	IWM	ETF	154.121	154.3	153.55	153.98	2216234.0
2018-05-03 14:00:00	IWM	ETF	153.99	154.44	153.79	153.91	1716604.0
2018-05-03 15:00:00	IWM	ETF	153.92	154.15	153.61	153.8	3027161.0
2018-05-03 16:00:00	IWM	ETF	153.8	154.21	153.7613	154.15	1136866.0
2018-05-03 17:00:00	IWM	ETF	154.15	154.15	154.08	154.08	671.0
2018-05-03 18:00:00	IWM	ETF	154.15	154.22	154.15	154.17	4649.0
2018-05-03 19:00:00	IWM	ETF	154.15	154.15	153.86	153.88	6762.0
2018-05-03 04:00:00	DIA	ETF	239.15	239.15	239.15	239.15	100.0
2018-05-03 05:00:00	DIA	ETF	239.24	239.24	239.16	239.16	200.0

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

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