PREVIEW / etf_1hour / 2018-04-12

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-04-12.parquet
  size:    295 KB
  rows:    9,662

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-12 04:00:00	SPY	ETF	264.06	264.21	263.73	263.73	1663.0
2018-04-12 05:00:00	SPY	ETF	263.58	264.18	263.58	264.18	5652.0
2018-04-12 06:00:00	SPY	ETF	264.2	265.24	264.2	265.12	100290.0
2018-04-12 07:00:00	SPY	ETF	265.17	265.2	264.8	265.01	269920.0
2018-04-12 08:00:00	SPY	ETF	265.13	265.24	263.98	264.95	572771.0
2018-04-12 09:00:00	SPY	ETF	264.96	266.54	264.95	266.49	7814901.0
2018-04-12 10:00:00	SPY	ETF	266.48	266.6699	265.66	265.83	9394237.0
2018-04-12 11:00:00	SPY	ETF	265.83	266.53	265.57	266.02	5584930.0
2018-04-12 12:00:00	SPY	ETF	266.02	266.8	265.84	266.645	5187692.0
2018-04-12 13:00:00	SPY	ETF	266.65	266.72	265.1	265.615	10150414.0
2018-04-12 14:00:00	SPY	ETF	265.61	266.545	265.51	266.475	6644149.0
2018-04-12 15:00:00	SPY	ETF	266.48	267.0	265.88	265.91	17644991.0
2018-04-12 16:00:00	SPY	ETF	265.9	266.1	265.73	266.03	3206396.0
2018-04-12 17:00:00	SPY	ETF	266.04	266.04	265.85	265.95	304131.0
2018-04-12 18:00:00	SPY	ETF	265.9	265.9	264.81	265.0	300081.0
2018-04-12 19:00:00	SPY	ETF	265.0	265.23	264.91	265.2	144768.0
2018-04-12 20:00:00	SPY	ETF	265.93	265.93	265.25	265.25	480.0
2018-04-12 04:00:00	QQQ	ETF	160.71	160.81	160.35	160.35	8781.0
2018-04-12 05:00:00	QQQ	ETF	160.28	160.68	160.28	160.68	22660.0
2018-04-12 06:00:00	QQQ	ETF	160.79	161.45	160.78	161.28	23965.0
2018-04-12 07:00:00	QQQ	ETF	161.28	161.42	161.13	161.28	120684.0
2018-04-12 08:00:00	QQQ	ETF	161.28	161.4	161.15	161.19	150117.0
2018-04-12 09:00:00	QQQ	ETF	161.24	162.31	161.16	162.31	4808938.0
2018-04-12 10:00:00	QQQ	ETF	162.305	162.7052	162.01	162.16	4516485.0
2018-04-12 11:00:00	QQQ	ETF	162.14	162.5562	161.81	162.14	2199812.0
2018-04-12 12:00:00	QQQ	ETF	162.14	162.58	161.93	162.52	1742209.0
2018-04-12 13:00:00	QQQ	ETF	162.53	162.627	161.45	161.74	4422443.0
2018-04-12 14:00:00	QQQ	ETF	161.741	162.4	161.66	162.34	2935023.0
2018-04-12 15:00:00	QQQ	ETF	162.35	162.77	162.08	162.12	5910894.0
2018-04-12 16:00:00	QQQ	ETF	162.13	162.37	162.04	162.34	891236.0
2018-04-12 17:00:00	QQQ	ETF	162.29	162.34	162.22	162.34	14267.0
2018-04-12 18:00:00	QQQ	ETF	162.28	162.28	161.68	161.75	72080.0
2018-04-12 19:00:00	QQQ	ETF	161.81	161.89	161.73	161.84	56016.0
2018-04-12 04:00:00	IWM	ETF	154.03	154.03	154.0	154.0	503.0
2018-04-12 06:00:00	IWM	ETF	154.22	154.57	154.22	154.55	13016.0
2018-04-12 07:00:00	IWM	ETF	154.43	154.59	154.38	154.52	6688.0
2018-04-12 08:00:00	IWM	ETF	154.4	154.51	154.28	154.28	27937.0
2018-04-12 09:00:00	IWM	ETF	154.32	154.77	153.93	154.65	1787320.0
2018-04-12 10:00:00	IWM	ETF	154.66	155.14	154.49	154.56	2004131.0
2018-04-12 11:00:00	IWM	ETF	154.55	155.04	154.48	154.63	1162273.0
2018-04-12 12:00:00	IWM	ETF	154.63	155.06	154.6	154.99	963047.0
2018-04-12 13:00:00	IWM	ETF	155.0	155.15	154.42	154.73	1780226.0
2018-04-12 14:00:00	IWM	ETF	154.71	155.11	154.66	155.04	1364601.0
2018-04-12 15:00:00	IWM	ETF	155.04	155.41	154.7	154.73	3133595.0
2018-04-12 16:00:00	IWM	ETF	154.71	155.04	154.63	154.82	805409.0
2018-04-12 17:00:00	IWM	ETF	154.83	154.83	154.7	154.7	25787.0
2018-04-12 18:00:00	IWM	ETF	154.7	154.7	154.39	154.46	34342.0
2018-04-12 19:00:00	IWM	ETF	154.24	154.49	154.24	154.28	3935.0
2018-04-12 06:00:00	DIA	ETF	242.71	243.13	242.71	243.1	1300.0
2018-04-12 07:00:00	DIA	ETF	243.1	243.4	243.04	243.4	3658.0

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

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