PREVIEW / etf_1hour / 2018-08-29

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-08-29.parquet
  size:    308 KB
  rows:    10,023

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-08-29 04:00:00	SPY	ETF	290.15	290.25	290.15	290.17	4471.0
2018-08-29 05:00:00	SPY	ETF	290.1	290.26	289.94	290.02	17207.0
2018-08-29 06:00:00	SPY	ETF	290.02	290.03	289.89	289.9	16052.0
2018-08-29 07:00:00	SPY	ETF	289.94	290.18	289.91	290.17	32152.0
2018-08-29 08:00:00	SPY	ETF	290.0699	290.44	289.72	289.9	213575.0
2018-08-29 09:00:00	SPY	ETF	289.87	290.27	289.85	290.18	4222083.0
2018-08-29 10:00:00	SPY	ETF	290.18	290.93	289.96	290.88	6789085.0
2018-08-29 11:00:00	SPY	ETF	290.88	291.58	290.77	291.455	9110428.0
2018-08-29 12:00:00	SPY	ETF	291.46	291.62	291.3	291.495	6484647.0
2018-08-29 13:00:00	SPY	ETF	291.5	291.57	291.12	291.1498	3648583.0
2018-08-29 14:00:00	SPY	ETF	291.14	291.42	291.13	291.345	5123289.0
2018-08-29 15:00:00	SPY	ETF	291.35	291.74	291.35	291.47	14926066.0
2018-08-29 16:00:00	SPY	ETF	291.45	291.51	289.8279	291.5	9066402.0
2018-08-29 17:00:00	SPY	ETF	291.48	291.53	291.46	291.5	43916.0
2018-08-29 18:00:00	SPY	ETF	291.55	291.59	291.45	291.55	31114.0
2018-08-29 19:00:00	SPY	ETF	291.53	291.55	291.45	291.46	17906.0
2018-08-29 04:00:00	QQQ	ETF	184.79	185.03	184.79	185.0	7150.0
2018-08-29 05:00:00	QQQ	ETF	185.0	185.02	184.95	184.95	9995.0
2018-08-29 06:00:00	QQQ	ETF	184.86	184.88	184.8	184.8	12480.0
2018-08-29 07:00:00	QQQ	ETF	184.82	184.92	184.82	184.92	39660.0
2018-08-29 08:00:00	QQQ	ETF	184.84	185.05	184.61	184.74	230942.0
2018-08-29 09:00:00	QQQ	ETF	184.74	185.43	184.73	185.31	3113275.0
2018-08-29 10:00:00	QQQ	ETF	185.304	186.16	185.17	186.04	3388011.0
2018-08-29 11:00:00	QQQ	ETF	186.04	186.54	185.96	186.38	3751868.0
2018-08-29 12:00:00	QQQ	ETF	186.38	186.5075	186.23	186.49	2167030.0
2018-08-29 13:00:00	QQQ	ETF	186.48	186.49	186.29	186.339	1627079.0
2018-08-29 14:00:00	QQQ	ETF	186.34	186.55	186.34	186.53	1458786.0
2018-08-29 15:00:00	QQQ	ETF	186.52	186.84	186.52	186.74	6207212.0
2018-08-29 16:00:00	QQQ	ETF	186.74	186.89	184.75	186.83	2543797.0
2018-08-29 17:00:00	QQQ	ETF	186.94	186.94	186.78	186.87	7419.0
2018-08-29 18:00:00	QQQ	ETF	186.88	186.91	186.8	186.85	17044.0
2018-08-29 19:00:00	QQQ	ETF	186.83	186.84	186.78	186.78	35204.0
2018-08-29 04:00:00	IWM	ETF	172.12	172.12	172.12	172.12	300.0
2018-08-29 05:00:00	IWM	ETF	172.18	172.18	172.0	172.07	9600.0
2018-08-29 06:00:00	IWM	ETF	172.06	172.06	171.98	171.98	4000.0
2018-08-29 07:00:00	IWM	ETF	172.08	172.08	172.06	172.06	1988.0
2018-08-29 08:00:00	IWM	ETF	172.05	172.05	171.86	171.94	16882.0
2018-08-29 09:00:00	IWM	ETF	172.0	172.15	171.56	171.61	1746400.0
2018-08-29 10:00:00	IWM	ETF	171.6	172.28	171.455	172.23	2531426.0
2018-08-29 11:00:00	IWM	ETF	172.225	172.5099	172.12	172.31	1514635.0
2018-08-29 12:00:00	IWM	ETF	172.33	172.68	172.281	172.56	949680.0
2018-08-29 13:00:00	IWM	ETF	172.56	172.63	172.26	172.2662	643780.0
2018-08-29 14:00:00	IWM	ETF	172.26	172.59	172.25	172.53	998759.0
2018-08-29 15:00:00	IWM	ETF	172.525	172.77	172.48	172.5	2433561.0
2018-08-29 16:00:00	IWM	ETF	172.5	172.67	172.46	172.65	1141852.0
2018-08-29 17:00:00	IWM	ETF	172.63	172.64	172.63	172.63	1583.0
2018-08-29 18:00:00	IWM	ETF	172.64	172.7	172.62	172.7	8300.0
2018-08-29 19:00:00	IWM	ETF	172.66	172.66	172.65	172.65	600.0
2018-08-29 04:00:00	DIA	ETF	261.06	261.06	261.06	261.06	150.0
2018-08-29 05:00:00	DIA	ETF	260.85	260.85	260.85	260.85	200.0

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

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