PREVIEW / etf_1hour / 2018-02-02

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-02-02.parquet
  size:    329 KB
  rows:    10,795

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-02-02 04:00:00	SPY	ETF	280.5	280.5	279.65	279.68	97035.0
2018-02-02 05:00:00	SPY	ETF	279.68	279.85	279.17	279.61	204107.0
2018-02-02 06:00:00	SPY	ETF	279.61	280.0	279.55	279.72	162987.0
2018-02-02 07:00:00	SPY	ETF	279.72	280.13	279.68	280.02	896643.0
2018-02-02 08:00:00	SPY	ETF	279.97	281.58	279.42	280.11	1803817.0
2018-02-02 09:00:00	SPY	ETF	280.11	280.23	279.06	279.39	11722977.0
2018-02-02 10:00:00	SPY	ETF	279.3901	279.64	278.38	279.3	17657732.0
2018-02-02 11:00:00	SPY	ETF	279.3	280.04	278.24	278.26	13156266.0
2018-02-02 12:00:00	SPY	ETF	278.26	279.14	278.12	278.48	10543465.0
2018-02-02 13:00:00	SPY	ETF	278.48	278.52	277.5	277.78	14249621.0
2018-02-02 14:00:00	SPY	ETF	277.775	277.79	276.12	276.36	24567282.0
2018-02-02 15:00:00	SPY	ETF	276.35	276.91	275.41	275.52	52257455.0
2018-02-02 16:00:00	SPY	ETF	275.5	278.9346	275.09	275.27	20574990.0
2018-02-02 17:00:00	SPY	ETF	275.25	275.46	274.91	274.95	1195599.0
2018-02-02 18:00:00	SPY	ETF	274.95	275.0	274.6	274.85	135626.0
2018-02-02 19:00:00	SPY	ETF	274.85	275.45	274.71	274.79	36894.0
2018-02-02 04:00:00	QQQ	ETF	167.86	167.86	167.05	167.06	45562.0
2018-02-02 05:00:00	QQQ	ETF	167.11	167.19	166.78	167.0	37635.0
2018-02-02 06:00:00	QQQ	ETF	166.99	167.09	166.42	166.58	111222.0
2018-02-02 07:00:00	QQQ	ETF	166.56	167.39	166.54	167.37	349536.0
2018-02-02 08:00:00	QQQ	ETF	167.39	168.6	166.52	167.16	942787.0
2018-02-02 09:00:00	QQQ	ETF	167.14	167.7	166.25	166.59	7365448.0
2018-02-02 10:00:00	QQQ	ETF	166.59	166.96	165.47	166.755	8779002.0
2018-02-02 11:00:00	QQQ	ETF	166.75	166.985	166.05	166.08	3613722.0
2018-02-02 12:00:00	QQQ	ETF	166.09	166.855	165.87	166.41	3517168.0
2018-02-02 13:00:00	QQQ	ETF	166.4	166.47	165.7	166.05	4728419.0
2018-02-02 14:00:00	QQQ	ETF	166.05	166.09	165.05	165.24	7346284.0
2018-02-02 15:00:00	QQQ	ETF	165.24	165.55	164.47	164.56	15276460.0
2018-02-02 16:00:00	QQQ	ETF	164.55	165.9471	164.17	164.28	2815269.0
2018-02-02 17:00:00	QQQ	ETF	164.26	164.61	163.84	163.98	2453540.0
2018-02-02 18:00:00	QQQ	ETF	164.0	164.0	163.79	163.89	33582.0
2018-02-02 19:00:00	QQQ	ETF	163.89	163.89	163.72	163.76	18601.0
2018-02-02 04:00:00	IWM	ETF	156.3	156.3	155.44	155.44	2629.0
2018-02-02 05:00:00	IWM	ETF	155.43	155.57	155.11	155.35	79916.0
2018-02-02 06:00:00	IWM	ETF	155.41	155.72	155.38	155.49	8652.0
2018-02-02 07:00:00	IWM	ETF	155.55	155.93	155.55	155.88	92203.0
2018-02-02 08:00:00	IWM	ETF	155.61	156.41	155.61	156.23	240918.0
2018-02-02 09:00:00	IWM	ETF	156.18	156.85	155.335	155.35	3871131.0
2018-02-02 10:00:00	IWM	ETF	155.34	155.49	154.54	155.28	4541856.0
2018-02-02 11:00:00	IWM	ETF	155.27	155.3	154.56	154.58	2226201.0
2018-02-02 12:00:00	IWM	ETF	154.58	155.39	154.46	154.87	2470598.0
2018-02-02 13:00:00	IWM	ETF	154.86	155.09	154.58	154.72	1836830.0
2018-02-02 14:00:00	IWM	ETF	154.72	154.7334	153.86	153.99	3475559.0
2018-02-02 15:00:00	IWM	ETF	153.99	154.5	153.51	153.85	8359719.0
2018-02-02 16:00:00	IWM	ETF	153.84	154.02	153.2	153.47	1671531.0
2018-02-02 17:00:00	IWM	ETF	153.83	153.83	153.32	153.35	143661.0
2018-02-02 18:00:00	IWM	ETF	153.3	153.47	153.21	153.39	2935.0
2018-02-02 19:00:00	IWM	ETF	153.39	153.39	153.39	153.39	110.0
2018-02-02 04:00:00	DIA	ETF	260.79	260.79	260.17	260.17	1200.0
2018-02-02 05:00:00	DIA	ETF	259.6	259.6	258.95	259.16	1400.0

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

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