PREVIEW / etf_1hour / 2018-04-10

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-04-10.parquet
  size:    300 KB
  rows:    9,839

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-04-10 04:00:00	SPY	ETF	263.72	264.5	263.6	264.07	42151.0
2018-04-10 05:00:00	SPY	ETF	264.13	264.5	264.0	264.22	39427.0
2018-04-10 06:00:00	SPY	ETF	264.14	264.43	264.01	264.29	94329.0
2018-04-10 07:00:00	SPY	ETF	264.2	264.63	264.1	264.49	743965.0
2018-04-10 08:00:00	SPY	ETF	264.48	265.07	263.75	264.22	1409417.0
2018-04-10 09:00:00	SPY	ETF	264.21	264.56	263.32	263.51	11035138.0
2018-04-10 10:00:00	SPY	ETF	263.505	265.45	263.38	264.9801	13203798.0
2018-04-10 11:00:00	SPY	ETF	264.97	265.76	264.18	265.22	14241576.0
2018-04-10 12:00:00	SPY	ETF	265.22	265.34	262.98	264.37	16134047.0
2018-04-10 13:00:00	SPY	ETF	264.38	265.28	264.09	265.17	9709603.0
2018-04-10 14:00:00	SPY	ETF	265.19	265.685	264.21	265.49	11201587.0
2018-04-10 15:00:00	SPY	ETF	265.4892	266.04	264.95	265.14	18605294.0
2018-04-10 16:00:00	SPY	ETF	265.13	265.1715	264.78	264.86	6175745.0
2018-04-10 17:00:00	SPY	ETF	264.89	265.15	264.8	264.88	942412.0
2018-04-10 18:00:00	SPY	ETF	264.88	264.93	264.56	264.67	76197.0
2018-04-10 19:00:00	SPY	ETF	264.7	264.8	264.05	264.34	178878.0
2018-04-10 04:00:00	QQQ	ETF	159.89	160.71	159.5	160.31	37620.0
2018-04-10 05:00:00	QQQ	ETF	160.31	160.63	160.31	160.43	12959.0
2018-04-10 06:00:00	QQQ	ETF	160.43	160.48	160.22	160.33	40273.0
2018-04-10 07:00:00	QQQ	ETF	160.25	161.109	160.15	160.32	450901.0
2018-04-10 08:00:00	QQQ	ETF	160.35	160.44	159.85	160.13	306637.0
2018-04-10 09:00:00	QQQ	ETF	160.14	160.46	159.1	159.3838	5044009.0
2018-04-10 10:00:00	QQQ	ETF	159.385	160.805	159.385	160.38	6135023.0
2018-04-10 11:00:00	QQQ	ETF	160.37	160.87	159.79	160.35	5830435.0
2018-04-10 12:00:00	QQQ	ETF	160.33	160.416	159.07	159.95	5762886.0
2018-04-10 13:00:00	QQQ	ETF	159.95	160.75	159.74	160.71	4069410.0
2018-04-10 14:00:00	QQQ	ETF	160.75	161.1	160.11	161.06	4473492.0
2018-04-10 15:00:00	QQQ	ETF	161.04	161.73	160.78	161.11	8673225.0
2018-04-10 16:00:00	QQQ	ETF	161.1	161.21	160.84	161.05	3092707.0
2018-04-10 17:00:00	QQQ	ETF	160.97	161.21	160.97	161.08	113189.0
2018-04-10 18:00:00	QQQ	ETF	161.1	161.11	160.87	160.9	32196.0
2018-04-10 19:00:00	QQQ	ETF	160.97	160.99	160.6	160.76	46214.0
2018-04-10 04:00:00	IWM	ETF	152.06	152.31	152.06	152.3	6308.0
2018-04-10 05:00:00	IWM	ETF	152.43	152.58	152.41	152.52	3779.0
2018-04-10 06:00:00	IWM	ETF	152.34	152.46	152.34	152.45	5600.0
2018-04-10 07:00:00	IWM	ETF	152.33	152.46	152.27	152.35	82113.0
2018-04-10 08:00:00	IWM	ETF	152.28	152.4	152.2	152.3	102970.0
2018-04-10 09:00:00	IWM	ETF	152.26	152.42	151.67	151.78	2663945.0
2018-04-10 10:00:00	IWM	ETF	151.79	153.14	151.75	152.98	2527567.0
2018-04-10 11:00:00	IWM	ETF	152.97	153.38	152.47	153.11	1810456.0
2018-04-10 12:00:00	IWM	ETF	153.1	153.18	152.31	152.9	1665670.0
2018-04-10 13:00:00	IWM	ETF	152.91	153.54	152.84	153.47	1511778.0
2018-04-10 14:00:00	IWM	ETF	153.48	153.75	153.2	153.7468	2636249.0
2018-04-10 15:00:00	IWM	ETF	153.75	153.95	153.2701	153.34	4446919.0
2018-04-10 16:00:00	IWM	ETF	153.33	153.41	153.07	153.4	1664557.0
2018-04-10 17:00:00	IWM	ETF	153.3	153.38	153.3	153.32	351313.0
2018-04-10 18:00:00	IWM	ETF	153.32	153.38	153.25	153.25	8685.0
2018-04-10 19:00:00	IWM	ETF	153.21	153.3	152.93	153.11	7168.0
2018-04-10 04:00:00	DIA	ETF	242.45	242.45	242.45	242.45	100.0
2018-04-10 06:00:00	DIA	ETF	243.04	243.04	243.04	243.04	800.0

> showing 50 of 9,839 rows — these rows as CSV

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