PREVIEW / etf_1hour / 2018-12-27

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-12-27.parquet
  size:    348 KB
  rows:    11,462

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-12-27 04:00:00	SPY	ETF	243.88	243.99	241.77	241.78	119264.0
2018-12-27 05:00:00	SPY	ETF	241.72	243.21	241.6	242.24	237600.0
2018-12-27 06:00:00	SPY	ETF	242.21	243.05	241.96	242.58	158310.0
2018-12-27 07:00:00	SPY	ETF	242.72	243.2	242.18	242.63	844081.0
2018-12-27 08:00:00	SPY	ETF	242.83	247.12	242.08	242.52	1463678.0
2018-12-27 09:00:00	SPY	ETF	242.52	243.81	241.16	241.9954	19460895.0
2018-12-27 10:00:00	SPY	ETF	241.97	242.98	240.48	241.64	26200303.0
2018-12-27 11:00:00	SPY	ETF	241.63	243.63	241.03	242.5323	15705302.0
2018-12-27 12:00:00	SPY	ETF	242.55	242.6	240.81	241.7	12623580.0
2018-12-27 13:00:00	SPY	ETF	241.68	242.07	239.57	239.99	15187767.0
2018-12-27 14:00:00	SPY	ETF	239.9936	242.19	238.96	242.07	20673542.0
2018-12-27 15:00:00	SPY	ETF	242.065	248.2	241.08	248.17	49835826.0
2018-12-27 16:00:00	SPY	ETF	248.18	248.97	247.64	248.08	16774104.0
2018-12-27 17:00:00	SPY	ETF	248.1	248.5	248.02	248.34	385841.0
2018-12-27 18:00:00	SPY	ETF	248.32	248.36	247.1	247.57	1298364.0
2018-12-27 19:00:00	SPY	ETF	247.55	248.17	247.5	248.01	159835.0
2018-12-27 04:00:00	QQQ	ETF	151.23	151.54	149.31	149.31	61096.0
2018-12-27 05:00:00	QQQ	ETF	149.33	150.34	149.33	149.55	79166.0
2018-12-27 06:00:00	QQQ	ETF	149.65	150.6	149.58	150.19	49193.0
2018-12-27 07:00:00	QQQ	ETF	150.2	150.75	150.09	150.39	205833.0
2018-12-27 08:00:00	QQQ	ETF	150.6	153.05	149.95	150.37	481765.0
2018-12-27 09:00:00	QQQ	ETF	150.35	151.3	149.33	149.95	8125224.0
2018-12-27 10:00:00	QQQ	ETF	149.95	150.51	148.35	148.99	10890880.0
2018-12-27 11:00:00	QQQ	ETF	148.97	150.22	148.56	149.44	7373904.0
2018-12-27 12:00:00	QQQ	ETF	149.4351	149.49	148.19	148.92	5933858.0
2018-12-27 13:00:00	QQQ	ETF	148.91	149.13	147.29	147.64	6830927.0
2018-12-27 14:00:00	QQQ	ETF	147.63	149.43	147.08	149.41	9246686.0
2018-12-27 15:00:00	QQQ	ETF	149.41	153.17	148.74	153.15	17708072.0
2018-12-27 16:00:00	QQQ	ETF	153.15	153.84	153.04	153.32	5033568.0
2018-12-27 17:00:00	QQQ	ETF	153.27	153.42	153.09	153.3	67885.0
2018-12-27 18:00:00	QQQ	ETF	153.34	153.43	152.48	152.89	281015.0
2018-12-27 19:00:00	QQQ	ETF	152.84	153.24	152.84	153.12	115040.0
2018-12-27 04:00:00	IWM	ETF	130.87	130.87	129.61	129.61	4136.0
2018-12-27 05:00:00	IWM	ETF	130.01	130.01	129.96	130.0	10172.0
2018-12-27 06:00:00	IWM	ETF	129.99	130.1	129.72	129.75	7740.0
2018-12-27 07:00:00	IWM	ETF	129.87	130.09	129.53	130.05	100592.0
2018-12-27 08:00:00	IWM	ETF	129.95	132.06	129.61	130.13	159211.0
2018-12-27 09:00:00	IWM	ETF	130.14	131.23	129.53	130.17	3580372.0
2018-12-27 10:00:00	IWM	ETF	130.16	130.65	129.74	129.79	3371089.0
2018-12-27 11:00:00	IWM	ETF	129.77	130.87	129.43	130.4	3238980.0
2018-12-27 12:00:00	IWM	ETF	130.39	130.43	129.11	129.56	2768562.0
2018-12-27 13:00:00	IWM	ETF	129.56	129.8	128.245	128.5	3088604.0
2018-12-27 14:00:00	IWM	ETF	128.48	129.235	127.8701	129.03	5408665.0
2018-12-27 15:00:00	IWM	ETF	129.0561	132.43	128.56	132.37	8820145.0
2018-12-27 16:00:00	IWM	ETF	132.37	132.62	131.96	132.3	2002595.0
2018-12-27 17:00:00	IWM	ETF	132.06	132.48	131.89	132.2	95718.0
2018-12-27 18:00:00	IWM	ETF	132.2	132.48	131.71	131.99	22233.0
2018-12-27 19:00:00	IWM	ETF	131.95	132.28	131.91	132.28	2750.0
2018-12-27 04:00:00	DIA	ETF	227.29	227.29	224.66	224.66	1728.0
2018-12-27 05:00:00	DIA	ETF	224.65	225.93	224.65	224.93	2300.0

> showing 50 of 11,462 rows — these rows as CSV

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