PREVIEW / etf_1hour / 2018-06-11

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-06-11.parquet
  size:    298 KB
  rows:    9,836

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-06-11 04:00:00	SPY	ETF	278.45	278.54	278.34	278.34	18405.0
2018-06-11 05:00:00	SPY	ETF	278.44	278.51	278.35	278.42	6533.0
2018-06-11 06:00:00	SPY	ETF	278.32	278.39	278.11	278.19	45160.0
2018-06-11 07:00:00	SPY	ETF	278.2	278.25	278.02	278.08	118744.0
2018-06-11 08:00:00	SPY	ETF	278.05	278.24	277.93	278.22	255210.0
2018-06-11 09:00:00	SPY	ETF	278.23	278.8	278.15	278.475	4531706.0
2018-06-11 10:00:00	SPY	ETF	278.475	278.86	278.39	278.55	7716280.0
2018-06-11 11:00:00	SPY	ETF	278.56	279.13	278.37	279.08	6482808.0
2018-06-11 12:00:00	SPY	ETF	279.09	279.34	279.01	279.25	4785477.0
2018-06-11 13:00:00	SPY	ETF	279.25	279.37	279.03	279.16	3382941.0
2018-06-11 14:00:00	SPY	ETF	279.15	279.17	278.9	279.06	4930302.0
2018-06-11 15:00:00	SPY	ETF	279.06	279.23	278.44	278.565	12345371.0
2018-06-11 16:00:00	SPY	ETF	278.58	279.0	278.36	278.58	12856657.0
2018-06-11 17:00:00	SPY	ETF	278.59	278.65	278.52	278.52	670581.0
2018-06-11 18:00:00	SPY	ETF	278.5	278.88	278.48	278.87	53060.0
2018-06-11 19:00:00	SPY	ETF	278.82	278.99	278.82	278.87	32599.0
2018-06-11 04:00:00	QQQ	ETF	174.58	174.58	174.49	174.5	20700.0
2018-06-11 05:00:00	QQQ	ETF	174.49	174.55	174.38	174.47	6700.0
2018-06-11 06:00:00	QQQ	ETF	174.41	174.5	174.35	174.35	18765.0
2018-06-11 07:00:00	QQQ	ETF	174.41	174.45	174.34	174.36	90267.0
2018-06-11 08:00:00	QQQ	ETF	174.37	174.39	174.07	174.22	162101.0
2018-06-11 09:00:00	QQQ	ETF	174.2	174.89	174.17	174.74	2002263.0
2018-06-11 10:00:00	QQQ	ETF	174.75	174.79	174.28	174.6552	2987946.0
2018-06-11 11:00:00	QQQ	ETF	174.66	175.08	174.51	175.005	1990943.0
2018-06-11 12:00:00	QQQ	ETF	175.02	175.34	174.98	175.18	1604811.0
2018-06-11 13:00:00	QQQ	ETF	175.18	175.3	175.01	175.12	2531746.0
2018-06-11 14:00:00	QQQ	ETF	175.12	175.17	174.91	175.16	2542862.0
2018-06-11 15:00:00	QQQ	ETF	175.1684	175.25	174.8	174.89	3447805.0
2018-06-11 16:00:00	QQQ	ETF	174.89	174.94	174.73	174.78	1113589.0
2018-06-11 17:00:00	QQQ	ETF	174.88	174.88	174.73	174.8	3082.0
2018-06-11 18:00:00	QQQ	ETF	174.8	175.0	174.75	175.0	27899.0
2018-06-11 19:00:00	QQQ	ETF	175.0	175.11	175.0	175.03	12638.0
2018-06-11 04:00:00	IWM	ETF	166.54	166.54	166.41	166.41	625.0
2018-06-11 06:00:00	IWM	ETF	166.32	166.32	166.32	166.32	130.0
2018-06-11 07:00:00	IWM	ETF	166.25	166.25	166.18	166.2	43206.0
2018-06-11 08:00:00	IWM	ETF	166.21	166.39	166.16	166.37	50928.0
2018-06-11 09:00:00	IWM	ETF	166.37	166.9036	166.37	166.77	1681523.0
2018-06-11 10:00:00	IWM	ETF	166.77	167.01	166.45	166.5	1748324.0
2018-06-11 11:00:00	IWM	ETF	166.51	166.8249	166.395	166.74	1124075.0
2018-06-11 12:00:00	IWM	ETF	166.74	166.86	166.59	166.645	677273.0
2018-06-11 13:00:00	IWM	ETF	166.645	166.645	166.29	166.56	1439697.0
2018-06-11 14:00:00	IWM	ETF	166.56	166.84	166.45	166.81	1366586.0
2018-06-11 15:00:00	IWM	ETF	166.81	167.1125	166.73	166.78	3808745.0
2018-06-11 16:00:00	IWM	ETF	166.79	166.91	166.7122	166.75	1491152.0
2018-06-11 17:00:00	IWM	ETF	166.76	166.84	166.75	166.76	3016.0
2018-06-11 18:00:00	IWM	ETF	166.75	166.75	166.75	166.75	500.0
2018-06-11 19:00:00	IWM	ETF	166.89	166.92	166.88	166.9	9500.0
2018-06-11 04:00:00	DIA	ETF	253.45	253.45	253.45	253.45	147.0
2018-06-11 05:00:00	DIA	ETF	253.72	253.79	253.68	253.68	453.0
2018-06-11 07:00:00	DIA	ETF	253.24	253.34	253.14	253.17	2950.0

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

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