PREVIEW / etf_1hour / 2018-01-10

all etf 1-hour files

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

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-10 04:00:00	SPY	ETF	273.99	274.13	273.84	273.98	50252.0
2018-01-10 05:00:00	SPY	ETF	273.95	274.03	273.02	273.07	136479.0
2018-01-10 06:00:00	SPY	ETF	273.09	273.54	273.09	273.3	208526.0
2018-01-10 07:00:00	SPY	ETF	273.3	273.64	273.14	273.36	855193.0
2018-01-10 08:00:00	SPY	ETF	273.31	273.65	273.23	273.61	550838.0
2018-01-10 09:00:00	SPY	ETF	273.6	273.94	272.92	273.37	8563474.0
2018-01-10 10:00:00	SPY	ETF	273.38	274.06	273.13	273.77	11093063.0
2018-01-10 11:00:00	SPY	ETF	273.77	274.21	273.77	274.0353	5103566.0
2018-01-10 12:00:00	SPY	ETF	274.03	274.25	273.84	274.22	3570765.0
2018-01-10 13:00:00	SPY	ETF	274.22	274.42	273.6305	274.29	4917663.0
2018-01-10 14:00:00	SPY	ETF	274.285	274.34	273.64	273.855	6583833.0
2018-01-10 15:00:00	SPY	ETF	273.855	274.19	273.67	274.1	12002616.0
2018-01-10 16:00:00	SPY	ETF	274.11	274.35	274.04	274.3	14764535.0
2018-01-10 17:00:00	SPY	ETF	274.31	274.31	274.26	274.27	56794.0
2018-01-10 18:00:00	SPY	ETF	274.26	274.31	274.18	274.31	83972.0
2018-01-10 19:00:00	SPY	ETF	274.25	274.66	274.23	274.53	63276.0
2018-01-10 04:00:00	QQQ	ETF	162.3	162.3	162.12	162.16	22707.0
2018-01-10 05:00:00	QQQ	ETF	162.16	162.19	161.54	161.62	48310.0
2018-01-10 06:00:00	QQQ	ETF	161.5	161.77	161.5	161.56	32816.0
2018-01-10 07:00:00	QQQ	ETF	161.58	161.74	161.44	161.63	184401.0
2018-01-10 08:00:00	QQQ	ETF	161.57	161.83	161.43	161.68	429973.0
2018-01-10 09:00:00	QQQ	ETF	161.67	162.09	161.24	161.5	4509383.0
2018-01-10 10:00:00	QQQ	ETF	161.5	161.81	161.12	161.635	4618923.0
2018-01-10 11:00:00	QQQ	ETF	161.63	161.98	161.57	161.8	4184205.0
2018-01-10 12:00:00	QQQ	ETF	161.8	161.965	161.675	161.915	1302429.0
2018-01-10 13:00:00	QQQ	ETF	161.92	162.18	161.75	162.115	2271003.0
2018-01-10 14:00:00	QQQ	ETF	162.1174	162.15	161.56	161.89	2492317.0
2018-01-10 15:00:00	QQQ	ETF	161.88	162.21	161.79	162.18	3783424.0
2018-01-10 16:00:00	QQQ	ETF	162.17	162.28	162.12	162.28	636716.0
2018-01-10 17:00:00	QQQ	ETF	162.25	162.28	162.18	162.26	836999.0
2018-01-10 18:00:00	QQQ	ETF	162.25	162.26	162.13	162.23	33331.0
2018-01-10 19:00:00	QQQ	ETF	162.23	162.45	162.17	162.36	16881.0
2018-01-10 04:00:00	IWM	ETF	154.2	154.35	154.2	154.25	3795.0
2018-01-10 05:00:00	IWM	ETF	154.2	154.2	153.74	153.89	4813.0
2018-01-10 06:00:00	IWM	ETF	153.77	154.01	153.77	153.97	10209.0
2018-01-10 07:00:00	IWM	ETF	153.93	154.32	153.9	154.15	16954.0
2018-01-10 08:00:00	IWM	ETF	154.08	154.38	154.05	154.33	141313.0
2018-01-10 09:00:00	IWM	ETF	154.3	154.66	153.92	154.479	2580162.0
2018-01-10 10:00:00	IWM	ETF	154.47	154.6	154.08	154.2	2189958.0
2018-01-10 11:00:00	IWM	ETF	154.2	154.67	154.18	154.6306	1008979.0
2018-01-10 12:00:00	IWM	ETF	154.63	155.01	154.55	155.0	1193134.0
2018-01-10 13:00:00	IWM	ETF	155.005	155.17	154.85	155.04	1335458.0
2018-01-10 14:00:00	IWM	ETF	155.035	155.07	154.61	154.685	931280.0
2018-01-10 15:00:00	IWM	ETF	154.69	154.85	154.59	154.82	2928596.0
2018-01-10 16:00:00	IWM	ETF	154.82	154.97	154.78	154.82	2541675.0
2018-01-10 17:00:00	IWM	ETF	154.84	154.84	154.84	154.84	505725.0
2018-01-10 18:00:00	IWM	ETF	154.85	154.85	154.79	154.81	11147.0
2018-01-10 19:00:00	IWM	ETF	154.84	155.12	154.81	155.02	7722.0
2018-01-10 04:00:00	DIA	ETF	253.51	253.51	253.51	253.51	200.0
2018-01-10 05:00:00	DIA	ETF	253.3	253.3	252.5	252.51	1260.0

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

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