PREVIEW / etf_1hour / 2018-05-16

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-05-16.parquet
  size:    298 KB
  rows:    9,753

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-05-16 04:00:00	SPY	ETF	271.32	271.33	271.01	271.01	9028.0
2018-05-16 05:00:00	SPY	ETF	271.07	271.07	270.62	270.84	28325.0
2018-05-16 06:00:00	SPY	ETF	270.88	271.12	270.72	271.12	36447.0
2018-05-16 07:00:00	SPY	ETF	271.11	271.17	270.77	270.85	309229.0
2018-05-16 08:00:00	SPY	ETF	270.83	271.16	270.47	270.53	2665659.0
2018-05-16 09:00:00	SPY	ETF	270.55	271.95	270.47	271.81	5696040.0
2018-05-16 10:00:00	SPY	ETF	271.83	271.99	271.3	271.6825	5586482.0
2018-05-16 11:00:00	SPY	ETF	271.68	271.88	271.2	271.86	4146593.0
2018-05-16 12:00:00	SPY	ETF	271.88	272.71	271.86	272.425	6076499.0
2018-05-16 13:00:00	SPY	ETF	272.43	272.579	272.2	272.485	4006630.0
2018-05-16 14:00:00	SPY	ETF	272.48	272.76	272.3634	272.6414	2801517.0
2018-05-16 15:00:00	SPY	ETF	272.65	272.65	271.69	272.21	12153472.0
2018-05-16 16:00:00	SPY	ETF	272.21	272.27	272.09	272.1	8301065.0
2018-05-16 17:00:00	SPY	ETF	272.12	272.24	272.06	272.17	825408.0
2018-05-16 18:00:00	SPY	ETF	272.17	272.4	272.13	272.33	104721.0
2018-05-16 19:00:00	SPY	ETF	272.32	272.44	272.23	272.44	16776.0
2018-05-16 04:00:00	QQQ	ETF	168.02	168.13	167.93	167.93	4926.0
2018-05-16 05:00:00	QQQ	ETF	167.99	167.99	167.69	167.92	14400.0
2018-05-16 06:00:00	QQQ	ETF	167.92	168.13	167.83	168.08	9370.0
2018-05-16 07:00:00	QQQ	ETF	168.1	168.12	167.81	167.9	205086.0
2018-05-16 08:00:00	QQQ	ETF	168.09	168.09	167.7	167.77	265438.0
2018-05-16 09:00:00	QQQ	ETF	167.75	168.66	167.71	168.61	2356408.0
2018-05-16 10:00:00	QQQ	ETF	168.61	168.9693	168.33	168.66	3504179.0
2018-05-16 11:00:00	QQQ	ETF	168.65	168.77	168.24	168.77	2594628.0
2018-05-16 12:00:00	QQQ	ETF	168.78	169.37	168.775	169.17	2052160.0
2018-05-16 13:00:00	QQQ	ETF	169.18	169.25	168.9	169.1108	1505151.0
2018-05-16 14:00:00	QQQ	ETF	169.12	169.33	168.98	169.29	1597153.0
2018-05-16 15:00:00	QQQ	ETF	169.28	169.28	168.6	168.98	3527099.0
2018-05-16 16:00:00	QQQ	ETF	168.98	169.05	168.86	168.9	1087855.0
2018-05-16 17:00:00	QQQ	ETF	168.91	168.98	168.88	168.9	9579.0
2018-05-16 18:00:00	QQQ	ETF	168.92	169.07	168.91	169.03	30500.0
2018-05-16 19:00:00	QQQ	ETF	169.01	169.09	168.95	169.09	7331.0
2018-05-16 04:00:00	IWM	ETF	159.37	159.37	159.37	159.37	100.0
2018-05-16 05:00:00	IWM	ETF	159.2	159.25	159.2	159.25	333.0
2018-05-16 06:00:00	IWM	ETF	159.26	159.43	159.26	159.43	1308.0
2018-05-16 07:00:00	IWM	ETF	159.44	159.5	159.32	159.38	83147.0
2018-05-16 08:00:00	IWM	ETF	159.45	159.45	159.18	159.18	19331.0
2018-05-16 09:00:00	IWM	ETF	159.2	160.31	159.2	160.16	1782752.0
2018-05-16 10:00:00	IWM	ETF	160.2	160.26	159.8	159.9199	1671526.0
2018-05-16 11:00:00	IWM	ETF	159.9	160.44	159.68	160.44	1133757.0
2018-05-16 12:00:00	IWM	ETF	160.44	161.05	160.39	160.97	2491387.0
2018-05-16 13:00:00	IWM	ETF	160.97	161.22	160.77	161.205	1309725.0
2018-05-16 14:00:00	IWM	ETF	161.2	161.32	161.1	161.27	1898270.0
2018-05-16 15:00:00	IWM	ETF	161.25	161.27	160.54	160.91	4274477.0
2018-05-16 16:00:00	IWM	ETF	160.92	161.02	160.7764	160.95	2960648.0
2018-05-16 17:00:00	IWM	ETF	160.95	160.99	160.92	160.93	2253.0
2018-05-16 18:00:00	IWM	ETF	160.97	161.09	160.92	161.09	12657.0
2018-05-16 19:00:00	IWM	ETF	161.09	161.14	161.03	161.1	7245.0
2018-05-16 05:00:00	DIA	ETF	246.9	246.9	246.9	246.9	500.0
2018-05-16 06:00:00	DIA	ETF	247.08	247.1	247.08	247.1	1765.0

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

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