PREVIEW / etf_1hour / 2018-05-01

all etf 1-hour files

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

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-01 04:00:00	SPY	ETF	264.59	264.59	264.1	264.1	42284.0
2018-05-01 05:00:00	SPY	ETF	264.08	264.28	264.05	264.28	10608.0
2018-05-01 06:00:00	SPY	ETF	264.35	264.59	264.07	264.39	52280.0
2018-05-01 07:00:00	SPY	ETF	264.45	264.75	264.3	264.34	145251.0
2018-05-01 08:00:00	SPY	ETF	264.36	265.12	264.17	264.38	529233.0
2018-05-01 09:00:00	SPY	ETF	264.37	264.37	263.37	263.93	6913892.0
2018-05-01 10:00:00	SPY	ETF	263.91	263.98	262.93	262.97	8600401.0
2018-05-01 11:00:00	SPY	ETF	262.97	263.24	262.4452	262.59	7644395.0
2018-05-01 12:00:00	SPY	ETF	262.59	263.19	262.5402	262.855	4787446.0
2018-05-01 13:00:00	SPY	ETF	262.85	263.69	262.11	263.6611	8748312.0
2018-05-01 14:00:00	SPY	ETF	263.665	264.63	263.62	264.34	8140059.0
2018-05-01 15:00:00	SPY	ETF	264.33	265.1	263.76	264.99	15804040.0
2018-05-01 16:00:00	SPY	ETF	264.99	265.52	264.82	265.34	11816517.0
2018-05-01 17:00:00	SPY	ETF	265.25	265.29	264.92	265.29	154523.0
2018-05-01 18:00:00	SPY	ETF	265.31	265.44	265.3	265.38	30295.0
2018-05-01 19:00:00	SPY	ETF	265.41	265.43	265.15	265.43	31347.0
2018-05-01 04:00:00	QQQ	ETF	160.98	160.98	160.51	160.51	16532.0
2018-05-01 05:00:00	QQQ	ETF	160.55	160.69	160.5	160.69	7944.0
2018-05-01 06:00:00	QQQ	ETF	160.72	161.02	160.54	160.83	57300.0
2018-05-01 07:00:00	QQQ	ETF	160.91	161.13	160.75	160.79	85008.0
2018-05-01 08:00:00	QQQ	ETF	160.75	161.06	160.61	160.86	313918.0
2018-05-01 09:00:00	QQQ	ETF	160.76	161.14	160.14	161.05	4862752.0
2018-05-01 10:00:00	QQQ	ETF	161.03	161.47	160.58	160.86	5818032.0
2018-05-01 11:00:00	QQQ	ETF	160.86	161.1799	160.3508	160.59	3780375.0
2018-05-01 12:00:00	QQQ	ETF	160.58	161.16	160.58	160.899	2111357.0
2018-05-01 13:00:00	QQQ	ETF	160.8999	161.58	160.42	161.57	3853424.0
2018-05-01 14:00:00	QQQ	ETF	161.58	162.07	161.5	161.91	3621581.0
2018-05-01 15:00:00	QQQ	ETF	161.92	162.8	161.81	162.7	4803615.0
2018-05-01 16:00:00	QQQ	ETF	162.71	164.0	162.66	163.54	1579284.0
2018-05-01 17:00:00	QQQ	ETF	163.55	163.57	162.98	163.29	147381.0
2018-05-01 18:00:00	QQQ	ETF	163.33	163.56	163.33	163.55	85192.0
2018-05-01 19:00:00	QQQ	ETF	163.57	163.62	163.45	163.6	61795.0
2018-05-01 04:00:00	IWM	ETF	153.15	153.15	153.0	153.0	9200.0
2018-05-01 05:00:00	IWM	ETF	152.98	152.98	152.98	152.98	300.0
2018-05-01 06:00:00	IWM	ETF	152.91	152.91	152.91	152.91	342.0
2018-05-01 07:00:00	IWM	ETF	153.11	153.27	153.02	153.05	10497.0
2018-05-01 08:00:00	IWM	ETF	153.05	153.32	152.96	153.15	180926.0
2018-05-01 09:00:00	IWM	ETF	153.15	153.16	152.28	152.625	2802972.0
2018-05-01 10:00:00	IWM	ETF	152.61	152.63	151.98	152.0	3106993.0
2018-05-01 11:00:00	IWM	ETF	151.9989	152.69	151.71	152.29	2601473.0
2018-05-01 12:00:00	IWM	ETF	152.289	152.8	152.24	152.6	1784152.0
2018-05-01 13:00:00	IWM	ETF	152.595	153.17	152.22	153.16	1913938.0
2018-05-01 14:00:00	IWM	ETF	153.16	153.98	153.14	153.87	2281648.0
2018-05-01 15:00:00	IWM	ETF	153.87	154.29	153.6	154.04	4480834.0
2018-05-01 16:00:00	IWM	ETF	154.03	154.44	153.94	154.28	3455795.0
2018-05-01 17:00:00	IWM	ETF	154.22	154.33	154.1	154.29	2685.0
2018-05-01 18:00:00	IWM	ETF	154.38	154.38	154.37	154.37	885.0
2018-05-01 19:00:00	IWM	ETF	154.24	154.37	154.23	154.37	667.0
2018-05-01 06:00:00	DIA	ETF	241.1	241.1	241.1	241.1	300.0
2018-05-01 07:00:00	DIA	ETF	241.35	241.61	241.35	241.37	8582.0

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

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