PREVIEW / etf_1hour / 2018-05-04

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-05-04.parquet
  size:    291 KB
  rows:    9,585

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-04 04:00:00	SPY	ETF	262.96	263.18	262.6	262.8	9389.0
2018-05-04 05:00:00	SPY	ETF	262.85	262.87	262.51	262.87	5840.0
2018-05-04 06:00:00	SPY	ETF	262.85	263.01	262.48	262.54	54030.0
2018-05-04 07:00:00	SPY	ETF	262.53	262.62	262.18	262.26	98739.0
2018-05-04 08:00:00	SPY	ETF	262.27	263.14	261.62	262.36	1311247.0
2018-05-04 09:00:00	SPY	ETF	262.36	262.71	261.15	262.5511	7853621.0
2018-05-04 10:00:00	SPY	ETF	262.56	264.69	262.28	264.4258	13325953.0
2018-05-04 11:00:00	SPY	ETF	264.43	265.33	264.37	265.18	8902616.0
2018-05-04 12:00:00	SPY	ETF	265.185	265.62	265.02	265.44	5038170.0
2018-05-04 13:00:00	SPY	ETF	265.45	266.05	265.34	266.03	6477673.0
2018-05-04 14:00:00	SPY	ETF	266.04	266.7892	265.92	266.28	8609372.0
2018-05-04 15:00:00	SPY	ETF	266.28	266.63	265.56	266.0	18046902.0
2018-05-04 16:00:00	SPY	ETF	265.99	266.24	265.83	266.2	12310137.0
2018-05-04 17:00:00	SPY	ETF	266.17	266.22	266.02	266.15	4084833.0
2018-05-04 18:00:00	SPY	ETF	266.15	266.38	266.15	266.36	34836.0
2018-05-04 19:00:00	SPY	ETF	266.36	266.44	266.36	266.36	24682.0
2018-05-04 04:00:00	QQQ	ETF	162.05	162.3	161.83	161.93	25178.0
2018-05-04 05:00:00	QQQ	ETF	161.92	162.0	161.78	161.98	10220.0
2018-05-04 06:00:00	QQQ	ETF	162.09	162.09	161.88	161.88	13175.0
2018-05-04 07:00:00	QQQ	ETF	161.89	162.03	161.7	161.71	81387.0
2018-05-04 08:00:00	QQQ	ETF	161.91	162.06	161.19	161.7	574639.0
2018-05-04 09:00:00	QQQ	ETF	161.71	162.25	160.98	162.19	3155952.0
2018-05-04 10:00:00	QQQ	ETF	162.19	163.99	161.865	163.82	6814502.0
2018-05-04 11:00:00	QQQ	ETF	163.83	164.42	163.83	164.23	4685138.0
2018-05-04 12:00:00	QQQ	ETF	164.24	164.54	164.11	164.3199	3429564.0
2018-05-04 13:00:00	QQQ	ETF	164.33	164.79	164.13	164.765	3397354.0
2018-05-04 14:00:00	QQQ	ETF	164.7692	165.25	164.67	164.96	4263664.0
2018-05-04 15:00:00	QQQ	ETF	164.95	165.17	164.59	164.875	6743754.0
2018-05-04 16:00:00	QQQ	ETF	164.88	165.04	164.84	165.03	2489949.0
2018-05-04 17:00:00	QQQ	ETF	165.0	165.06	164.95	164.95	68797.0
2018-05-04 18:00:00	QQQ	ETF	164.9	165.06	164.9	165.04	10870.0
2018-05-04 19:00:00	QQQ	ETF	165.01	165.08	165.0	165.07	13160.0
2018-05-04 04:00:00	IWM	ETF	154.09	154.09	154.09	154.09	700.0
2018-05-04 05:00:00	IWM	ETF	153.86	153.99	153.86	153.99	2000.0
2018-05-04 06:00:00	IWM	ETF	154.02	154.02	153.85	153.85	2000.0
2018-05-04 07:00:00	IWM	ETF	153.85	153.9	153.65	153.65	43552.0
2018-05-04 08:00:00	IWM	ETF	153.81	153.95	153.37	153.72	218754.0
2018-05-04 09:00:00	IWM	ETF	153.75	153.887	152.8	153.74	1243590.0
2018-05-04 10:00:00	IWM	ETF	153.75	154.85	153.52	154.77	1898142.0
2018-05-04 11:00:00	IWM	ETF	154.78	155.74	154.75	155.47	1864306.0
2018-05-04 12:00:00	IWM	ETF	155.48	155.865	155.25	155.86	1179878.0
2018-05-04 13:00:00	IWM	ETF	155.86	156.25	155.78	156.245	1624753.0
2018-05-04 14:00:00	IWM	ETF	156.23	156.5	156.14	156.15	2044832.0
2018-05-04 15:00:00	IWM	ETF	156.15	156.37	155.45	155.68	3428304.0
2018-05-04 16:00:00	IWM	ETF	155.68	155.78	155.48	155.76	1067778.0
2018-05-04 17:00:00	IWM	ETF	155.65	155.73	155.65	155.66	2007.0
2018-05-04 18:00:00	IWM	ETF	155.71	155.71	155.71	155.71	2410.0
2018-05-04 19:00:00	IWM	ETF	155.78	155.79	155.78	155.79	1400.0
2018-05-04 04:00:00	DIA	ETF	239.49	239.49	239.23	239.23	600.0
2018-05-04 05:00:00	DIA	ETF	239.0	239.0	239.0	239.0	100.0

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

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