PREVIEW / etf_1hour / 2018-01-18

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-01-18.parquet
  size:    308 KB
  rows:    10,122

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-18 04:00:00	SPY	ETF	279.32	279.53	279.29	279.52	33190.0
2018-01-18 05:00:00	SPY	ETF	279.42	279.54	279.32	279.54	9960.0
2018-01-18 06:00:00	SPY	ETF	279.54	279.86	279.49	279.86	28043.0
2018-01-18 07:00:00	SPY	ETF	279.87	279.95	279.48	279.49	122376.0
2018-01-18 08:00:00	SPY	ETF	279.54	279.86	279.2	279.36	393151.0
2018-01-18 09:00:00	SPY	ETF	279.35	279.825	279.16	279.62	5982265.0
2018-01-18 10:00:00	SPY	ETF	279.63	279.66	278.76	279.04	15394635.0
2018-01-18 11:00:00	SPY	ETF	279.04	279.5977	278.58	278.91	11673025.0
2018-01-18 12:00:00	SPY	ETF	278.92	279.35	278.87	279.22	5899405.0
2018-01-18 13:00:00	SPY	ETF	279.22	279.48	278.96	279.435	5032869.0
2018-01-18 14:00:00	SPY	ETF	279.44	279.96	279.39	279.665	17860355.0
2018-01-18 15:00:00	SPY	ETF	279.67	279.72	278.86	279.18	20637421.0
2018-01-18 16:00:00	SPY	ETF	279.17	279.33	278.63	278.87	12600903.0
2018-01-18 17:00:00	SPY	ETF	278.8	279.14	278.8	278.86	255639.0
2018-01-18 18:00:00	SPY	ETF	278.9	279.22	278.9	279.04	250564.0
2018-01-18 19:00:00	SPY	ETF	279.04	279.08	278.93	278.97	36511.0
2018-01-18 04:00:00	QQQ	ETF	165.54	165.58	165.47	165.52	19290.0
2018-01-18 05:00:00	QQQ	ETF	165.53	165.59	165.47	165.59	8900.0
2018-01-18 06:00:00	QQQ	ETF	165.61	165.72	165.61	165.7	11000.0
2018-01-18 07:00:00	QQQ	ETF	165.77	165.81	165.45	165.49	22041.0
2018-01-18 08:00:00	QQQ	ETF	165.79	165.8	165.24	165.34	381390.0
2018-01-18 09:00:00	QQQ	ETF	165.33	165.89	165.22	165.71	3597912.0
2018-01-18 10:00:00	QQQ	ETF	165.71	165.81	165.135	165.53	4229330.0
2018-01-18 11:00:00	QQQ	ETF	165.53	165.94	165.35	165.605	2688877.0
2018-01-18 12:00:00	QQQ	ETF	165.6	166.03	165.575	165.9	1214944.0
2018-01-18 13:00:00	QQQ	ETF	165.9	166.05	165.73	166.005	1397753.0
2018-01-18 14:00:00	QQQ	ETF	166.0	166.1999	165.93	166.08	1910995.0
2018-01-18 15:00:00	QQQ	ETF	166.08	166.11	165.6	165.82	5341158.0
2018-01-18 16:00:00	QQQ	ETF	165.81	165.97	165.44	165.63	934093.0
2018-01-18 17:00:00	QQQ	ETF	165.82	165.82	165.3727	165.3727	179929.0
2018-01-18 18:00:00	QQQ	ETF	165.65	165.85	165.65	165.74	30430.0
2018-01-18 19:00:00	QQQ	ETF	165.73	165.76	165.66	165.7	8875.0
2018-01-18 04:00:00	IWM	ETF	157.24	157.27	157.24	157.27	1700.0
2018-01-18 05:00:00	IWM	ETF	157.3	157.47	157.3	157.47	2288.0
2018-01-18 06:00:00	IWM	ETF	157.41	157.62	157.4	157.62	7494.0
2018-01-18 07:00:00	IWM	ETF	157.69	157.7	157.25	157.31	29940.0
2018-01-18 08:00:00	IWM	ETF	157.23	157.35	157.01	157.08	117950.0
2018-01-18 09:00:00	IWM	ETF	157.1	157.5	156.77	157.2	1283591.0
2018-01-18 10:00:00	IWM	ETF	157.19	157.23	156.51	156.52	2151966.0
2018-01-18 11:00:00	IWM	ETF	156.53	157.1	156.47	156.82	1799688.0
2018-01-18 12:00:00	IWM	ETF	156.81	157.04	156.77	156.9307	572708.0
2018-01-18 13:00:00	IWM	ETF	156.94	157.16	156.79	157.02	814778.0
2018-01-18 14:00:00	IWM	ETF	157.02	157.29	156.99	157.11	885319.0
2018-01-18 15:00:00	IWM	ETF	157.11	157.13	156.39	156.54	5567614.0
2018-01-18 16:00:00	IWM	ETF	156.54	156.69	156.12	156.54	1950425.0
2018-01-18 17:00:00	IWM	ETF	156.21	157.104	156.2	156.48	27039.0
2018-01-18 18:00:00	IWM	ETF	156.31	156.55	156.31	156.49	9749.0
2018-01-18 19:00:00	IWM	ETF	156.45	156.48	156.4	156.46	3130.0
2018-01-18 04:00:00	DIA	ETF	260.88	260.88	260.78	260.78	200.0
2018-01-18 06:00:00	DIA	ETF	261.06	261.2	261.06	261.2	300.0

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

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