PREVIEW / etf_1hour / 2018-04-26

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-04-26.parquet
  size:    295 KB
  rows:    9,615

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-04-26 04:00:00	SPY	ETF	263.94	264.22	263.93	264.12	18571.0
2018-04-26 05:00:00	SPY	ETF	264.1	264.61	264.02	264.57	11718.0
2018-04-26 06:00:00	SPY	ETF	264.59	264.89	264.45	264.84	110122.0
2018-04-26 07:00:00	SPY	ETF	264.84	265.14	264.63	264.95	218212.0
2018-04-26 08:00:00	SPY	ETF	264.6899	265.13	263.75	265.12	331148.0
2018-04-26 09:00:00	SPY	ETF	265.1	265.14	264.29	264.96	8072963.0
2018-04-26 10:00:00	SPY	ETF	264.96	266.03	264.77	265.99	9681919.0
2018-04-26 11:00:00	SPY	ETF	265.98	266.02	264.94	265.32	6931891.0
2018-04-26 12:00:00	SPY	ETF	265.33	265.97	265.2906	265.76	3935854.0
2018-04-26 13:00:00	SPY	ETF	265.761	266.65	265.76	266.63	6450774.0
2018-04-26 14:00:00	SPY	ETF	266.64	267.16	266.43	267.0011	7133989.0
2018-04-26 15:00:00	SPY	ETF	267.01	267.2452	266.08	266.31	15719368.0
2018-04-26 16:00:00	SPY	ETF	266.31	267.43	266.16	267.0	7718566.0
2018-04-26 17:00:00	SPY	ETF	266.93	267.17	266.8	267.12	119603.0
2018-04-26 18:00:00	SPY	ETF	267.18	267.27	266.9	267.01	224592.0
2018-04-26 19:00:00	SPY	ETF	267.02	267.13	266.89	266.91	52916.0
2018-04-26 04:00:00	QQQ	ETF	160.0	160.25	159.84	159.99	51954.0
2018-04-26 05:00:00	QQQ	ETF	159.97	160.45	159.92	160.4	11400.0
2018-04-26 06:00:00	QQQ	ETF	160.36	160.55	160.24	160.5	18400.0
2018-04-26 07:00:00	QQQ	ETF	160.48	160.71	160.25	160.53	110826.0
2018-04-26 08:00:00	QQQ	ETF	160.57	160.96	160.37	160.96	272341.0
2018-04-26 09:00:00	QQQ	ETF	160.97	161.04	160.18	160.83	6023912.0
2018-04-26 10:00:00	QQQ	ETF	160.83	161.7	160.67	161.66	6073324.0
2018-04-26 11:00:00	QQQ	ETF	161.66	161.77	161.05	161.22	3415219.0
2018-04-26 12:00:00	QQQ	ETF	161.21	161.76	161.21	161.52	2586162.0
2018-04-26 13:00:00	QQQ	ETF	161.54	162.18	161.5299	162.16	3871465.0
2018-04-26 14:00:00	QQQ	ETF	162.155	162.45	161.98	162.41	3864589.0
2018-04-26 15:00:00	QQQ	ETF	162.4048	162.53	161.79	161.97	8406050.0
2018-04-26 16:00:00	QQQ	ETF	161.96	164.21	161.82	164.06	4063252.0
2018-04-26 17:00:00	QQQ	ETF	164.06	164.1	163.87	164.07	115398.0
2018-04-26 18:00:00	QQQ	ETF	164.07	164.3	164.02	164.18	151725.0
2018-04-26 19:00:00	QQQ	ETF	164.19	164.34	164.19	164.2	49592.0
2018-04-26 04:00:00	IWM	ETF	154.11	154.27	154.11	154.25	8460.0
2018-04-26 05:00:00	IWM	ETF	154.15	154.4	154.15	154.38	5000.0
2018-04-26 06:00:00	IWM	ETF	154.56	154.56	154.54	154.54	1500.0
2018-04-26 07:00:00	IWM	ETF	154.65	154.69	154.49	154.63	29873.0
2018-04-26 08:00:00	IWM	ETF	154.66	154.69	154.51	154.6499	62285.0
2018-04-26 09:00:00	IWM	ETF	154.6999	154.71	153.94	154.41	2299918.0
2018-04-26 10:00:00	IWM	ETF	154.41	154.98	154.17	154.89	2283038.0
2018-04-26 11:00:00	IWM	ETF	154.88	154.95	154.28	154.46	1729357.0
2018-04-26 12:00:00	IWM	ETF	154.47	154.87	154.435	154.67	733314.0
2018-04-26 13:00:00	IWM	ETF	154.67	155.27	154.64	155.2675	1315857.0
2018-04-26 14:00:00	IWM	ETF	155.2614	155.39	155.02	155.34	1006894.0
2018-04-26 15:00:00	IWM	ETF	155.35	155.41	154.74	154.93	1731564.0
2018-04-26 16:00:00	IWM	ETF	154.935	155.39	154.88	155.18	1821501.0
2018-04-26 17:00:00	IWM	ETF	155.22	155.3	155.22	155.28	9517.0
2018-04-26 18:00:00	IWM	ETF	155.27	155.28	154.91	155.03	36965.0
2018-04-26 19:00:00	IWM	ETF	155.07	155.07	154.96	154.96	7290.0
2018-04-26 04:00:00	DIA	ETF	240.85	240.85	240.84	240.84	1070.0
2018-04-26 07:00:00	DIA	ETF	241.58	241.74	241.31	241.62	13800.0

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

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