PREVIEW / etf_1hour / 2018-11-12

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-11-12.parquet
  size:    314 KB
  rows:    10,430

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-11-12 04:00:00	SPY	ETF	277.42	277.99	277.42	277.78	22592.0
2018-11-12 05:00:00	SPY	ETF	277.63	277.97	277.39	277.75	31559.0
2018-11-12 06:00:00	SPY	ETF	277.74	277.79	277.31	277.42	30795.0
2018-11-12 07:00:00	SPY	ETF	277.39	277.71	277.18	277.26	159380.0
2018-11-12 08:00:00	SPY	ETF	277.5618	278.83	276.62	277.13	573121.0
2018-11-12 09:00:00	SPY	ETF	277.16	277.46	275.55	275.61	8028903.0
2018-11-12 10:00:00	SPY	ETF	275.6101	275.94	274.42	274.49	12779058.0
2018-11-12 11:00:00	SPY	ETF	274.49	274.57	273.01	274.08	13218183.0
2018-11-12 12:00:00	SPY	ETF	274.07	274.64	273.69	273.69	7143045.0
2018-11-12 13:00:00	SPY	ETF	273.69	274.3644	273.01	273.97	8157180.0
2018-11-12 14:00:00	SPY	ETF	273.96	274.94	273.6	273.67	9748441.0
2018-11-12 15:00:00	SPY	ETF	273.67	274.16	271.99	272.49	28045455.0
2018-11-12 16:00:00	SPY	ETF	272.54	273.05	272.4153	272.8	8146218.0
2018-11-12 17:00:00	SPY	ETF	272.8	272.92	272.57	272.88	963243.0
2018-11-12 18:00:00	SPY	ETF	272.91	273.29	272.55	272.66	243292.0
2018-11-12 19:00:00	SPY	ETF	272.67	272.86	271.85	272.04	266491.0
2018-11-12 04:00:00	QQQ	ETF	171.5	171.93	171.5	171.68	12228.0
2018-11-12 05:00:00	QQQ	ETF	171.68	171.88	171.29	171.8	12916.0
2018-11-12 06:00:00	QQQ	ETF	171.7	171.7	171.19	171.31	12080.0
2018-11-12 07:00:00	QQQ	ETF	171.27	171.5	171.01	171.08	102235.0
2018-11-12 08:00:00	QQQ	ETF	171.08	172.41	170.09	170.35	869707.0
2018-11-12 09:00:00	QQQ	ETF	170.35	170.64	168.58	168.72	6736134.0
2018-11-12 10:00:00	QQQ	ETF	168.72	168.91	167.29	167.36	7781629.0
2018-11-12 11:00:00	QQQ	ETF	167.37	167.39	166.18	167.28	8995295.0
2018-11-12 12:00:00	QQQ	ETF	167.2819	167.95	167.13	167.15	5241139.0
2018-11-12 13:00:00	QQQ	ETF	167.15	167.58	166.49	167.3199	4826525.0
2018-11-12 14:00:00	QQQ	ETF	167.31	168.18	167.1	167.2	6248036.0
2018-11-12 15:00:00	QQQ	ETF	167.21	167.6	166.22	166.48	12961038.0
2018-11-12 16:00:00	QQQ	ETF	166.48	167.149	166.24	166.55	2624431.0
2018-11-12 17:00:00	QQQ	ETF	166.55	166.65	166.33	166.49	40837.0
2018-11-12 18:00:00	QQQ	ETF	166.67	166.86	166.4	166.4	109508.0
2018-11-12 19:00:00	QQQ	ETF	166.45	166.66	165.74	165.93	145846.0
2018-11-12 04:00:00	IWM	ETF	154.38	154.4	154.38	154.39	1178.0
2018-11-12 07:00:00	IWM	ETF	154.22	154.3	154.17	154.2	63228.0
2018-11-12 08:00:00	IWM	ETF	154.12	154.12	153.78	154.03	112553.0
2018-11-12 09:00:00	IWM	ETF	154.09	154.17	152.58	152.58	1701603.0
2018-11-12 10:00:00	IWM	ETF	152.57	152.935	151.91	151.95	2397116.0
2018-11-12 11:00:00	IWM	ETF	151.9494	152.25	151.05	152.22	3057794.0
2018-11-12 12:00:00	IWM	ETF	152.23	152.87	152.11	152.29	1641815.0
2018-11-12 13:00:00	IWM	ETF	152.28	152.37	151.58	152.065	1621762.0
2018-11-12 14:00:00	IWM	ETF	152.06	152.9933	151.95	152.34	2088280.0
2018-11-12 15:00:00	IWM	ETF	152.32	152.49	150.84	151.07	5087822.0
2018-11-12 16:00:00	IWM	ETF	152.6754	152.6754	150.83	151.24	914486.0
2018-11-12 17:00:00	IWM	ETF	151.25	151.25	151.03	151.1	693691.0
2018-11-12 18:00:00	IWM	ETF	151.17	151.46	151.11	151.11	13967.0
2018-11-12 19:00:00	IWM	ETF	151.05	151.13	150.61	150.69	16350.0
2018-11-12 06:00:00	DIA	ETF	259.51	259.51	259.51	259.51	1100.0
2018-11-12 07:00:00	DIA	ETF	259.62	259.62	259.62	259.62	200.0
2018-11-12 08:00:00	DIA	ETF	259.28	259.56	259.0	259.54	17112.0
2018-11-12 09:00:00	DIA	ETF	259.46	259.92	258.17	258.23	526997.0

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

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