PREVIEW / etf_1hour / 2018-01-19

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-01-19.parquet
  size:    305 KB
  rows:    10,077

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-19 04:00:00	SPY	ETF	279.18	279.55	279.18	279.53	9320.0
2018-01-19 05:00:00	SPY	ETF	279.55	279.75	279.55	279.66	6951.0
2018-01-19 06:00:00	SPY	ETF	279.66	279.75	279.64	279.68	41180.0
2018-01-19 07:00:00	SPY	ETF	279.65	279.7	279.5	279.52	133960.0
2018-01-19 08:00:00	SPY	ETF	279.54	279.68	278.81	279.13	319012.0
2018-01-19 09:00:00	SPY	ETF	279.18	279.99	279.13	279.76	9610970.0
2018-01-19 10:00:00	SPY	ETF	279.7501	279.96	279.24	279.5	32211978.0
2018-01-19 11:00:00	SPY	ETF	279.502	279.7	279.14	279.42	9978983.0
2018-01-19 12:00:00	SPY	ETF	279.419	279.8	279.39	279.63	8164420.0
2018-01-19 13:00:00	SPY	ETF	279.63	279.69	279.43	279.58	11164798.0
2018-01-19 14:00:00	SPY	ETF	279.58	280.15	279.55	279.96	13673489.0
2018-01-19 15:00:00	SPY	ETF	279.96	280.4	279.84	280.38	25865379.0
2018-01-19 16:00:00	SPY	ETF	280.39	280.63	280.1	280.49	26240788.0
2018-01-19 17:00:00	SPY	ETF	280.43	280.49	280.32	280.44	201923.0
2018-01-19 18:00:00	SPY	ETF	280.45	280.55	280.45	280.46	16212.0
2018-01-19 19:00:00	SPY	ETF	280.5	280.57	280.46	280.55	23478.0
2018-01-19 04:00:00	QQQ	ETF	165.92	166.42	165.92	166.35	29865.0
2018-01-19 05:00:00	QQQ	ETF	166.3	166.5	166.3	166.35	9630.0
2018-01-19 06:00:00	QQQ	ETF	166.35	166.45	166.31	166.35	44508.0
2018-01-19 07:00:00	QQQ	ETF	166.35	166.4	166.25	166.26	68821.0
2018-01-19 08:00:00	QQQ	ETF	166.28	166.33	165.81	166.07	467552.0
2018-01-19 09:00:00	QQQ	ETF	166.07	166.61	165.96	166.04	3376056.0
2018-01-19 10:00:00	QQQ	ETF	166.04	166.085	165.6	165.72	6647828.0
2018-01-19 11:00:00	QQQ	ETF	165.73	166.11	165.535	165.84	2222559.0
2018-01-19 12:00:00	QQQ	ETF	165.845	166.18	165.84	166.07	1181694.0
2018-01-19 13:00:00	QQQ	ETF	166.07	166.15	165.96	166.03	968967.0
2018-01-19 14:00:00	QQQ	ETF	166.03	166.35	166.001	166.21	2197674.0
2018-01-19 15:00:00	QQQ	ETF	166.22	166.41	166.14	166.34	4461960.0
2018-01-19 16:00:00	QQQ	ETF	166.34	166.55	166.28	166.45	841968.0
2018-01-19 17:00:00	QQQ	ETF	166.48	166.5	166.34	166.4	1698507.0
2018-01-19 18:00:00	QQQ	ETF	166.4	166.5	166.34	166.47	14683.0
2018-01-19 19:00:00	QQQ	ETF	166.46	166.56	166.34	166.47	19711.0
2018-01-19 04:00:00	IWM	ETF	156.66	156.66	156.66	156.66	125.0
2018-01-19 05:00:00	IWM	ETF	156.8	156.88	156.75	156.83	14258.0
2018-01-19 06:00:00	IWM	ETF	156.98	157.01	156.95	156.95	5457.0
2018-01-19 07:00:00	IWM	ETF	157.0	157.0	156.84	156.84	12879.0
2018-01-19 08:00:00	IWM	ETF	157.57	157.57	156.32	156.56	147124.0
2018-01-19 09:00:00	IWM	ETF	156.54	156.98	156.44	156.915	1303964.0
2018-01-19 10:00:00	IWM	ETF	156.92	157.84	156.685	157.76	4104260.0
2018-01-19 11:00:00	IWM	ETF	157.77	158.07	157.4272	157.9	1906838.0
2018-01-19 12:00:00	IWM	ETF	157.89	158.21	157.84	158.1	1260893.0
2018-01-19 13:00:00	IWM	ETF	158.11	158.31	157.98	158.28	1100263.0
2018-01-19 14:00:00	IWM	ETF	158.285	158.65	158.22	158.4162	2021680.0
2018-01-19 15:00:00	IWM	ETF	158.42	158.69	158.33	158.61	4952190.0
2018-01-19 16:00:00	IWM	ETF	158.61	158.82	158.0972	158.59	18389034.0
2018-01-19 17:00:00	IWM	ETF	158.5	158.58	158.5	158.55	2600.0
2018-01-19 18:00:00	IWM	ETF	158.55	158.6	158.55	158.58	2000.0
2018-01-19 19:00:00	IWM	ETF	158.59	158.69	158.59	158.6	10230.0
2018-01-19 04:00:00	DIA	ETF	260.0	260.15	260.0	260.15	500.0
2018-01-19 05:00:00	DIA	ETF	260.17	260.2	260.17	260.19	700.0

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

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