PREVIEW / etf_1hour / 2018-01-12

all etf 1-hour files

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

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-01-12 04:00:00	SPY	ETF	276.76	276.92	276.45	276.85	15224.0
2018-01-12 05:00:00	SPY	ETF	276.75	276.88	276.71	276.83	8800.0
2018-01-12 06:00:00	SPY	ETF	276.85	276.9	276.78	276.8	67372.0
2018-01-12 07:00:00	SPY	ETF	276.84	276.91	276.68	276.68	275949.0
2018-01-12 08:00:00	SPY	ETF	276.68	276.9	275.96	276.2	1022518.0
2018-01-12 09:00:00	SPY	ETF	276.23	277.03	276.15	277.03	5947472.0
2018-01-12 10:00:00	SPY	ETF	277.025	277.81	276.829	277.6297	10034107.0
2018-01-12 11:00:00	SPY	ETF	277.63	277.68	277.15	277.63	6432888.0
2018-01-12 12:00:00	SPY	ETF	277.63	277.71	277.36	277.66	5943459.0
2018-01-12 13:00:00	SPY	ETF	277.66	277.82	277.44	277.715	5725338.0
2018-01-12 14:00:00	SPY	ETF	277.715	277.92	277.53	277.755	14330823.0
2018-01-12 15:00:00	SPY	ETF	277.755	278.11	277.39	277.91	21979300.0
2018-01-12 16:00:00	SPY	ETF	277.91	278.26	277.85	278.18	16078719.0
2018-01-12 17:00:00	SPY	ETF	277.92	278.2	277.92	277.97	639801.0
2018-01-12 18:00:00	SPY	ETF	277.98	277.98	277.54	277.93	76722.0
2018-01-12 19:00:00	SPY	ETF	277.93	278.04	277.93	278.01	23108.0
2018-01-12 04:00:00	QQQ	ETF	163.86	163.89	163.76	163.77	27400.0
2018-01-12 05:00:00	QQQ	ETF	163.76	163.85	163.72	163.76	60913.0
2018-01-12 06:00:00	QQQ	ETF	163.74	163.76	163.68	163.7	30800.0
2018-01-12 07:00:00	QQQ	ETF	163.72	163.74	163.67	163.71	142550.0
2018-01-12 08:00:00	QQQ	ETF	163.74	163.89	162.98	163.06	807788.0
2018-01-12 09:00:00	QQQ	ETF	163.06	163.545	162.94	163.535	3722023.0
2018-01-12 10:00:00	QQQ	ETF	163.53	164.29	163.485	164.2	3476057.0
2018-01-12 11:00:00	QQQ	ETF	164.201	164.33	164.03	164.25	1923505.0
2018-01-12 12:00:00	QQQ	ETF	164.26	164.5	164.13	164.48	1744127.0
2018-01-12 13:00:00	QQQ	ETF	164.48	164.52	164.28	164.42	1780940.0
2018-01-12 14:00:00	QQQ	ETF	164.43	164.605	164.33	164.41	2006531.0
2018-01-12 15:00:00	QQQ	ETF	164.41	164.66	164.19	164.47	4553243.0
2018-01-12 16:00:00	QQQ	ETF	164.47	164.74	164.46	164.65	1403848.0
2018-01-12 17:00:00	QQQ	ETF	164.67	164.7	164.63	164.7	26247.0
2018-01-12 18:00:00	QQQ	ETF	164.65	164.65	164.59	164.59	12395.0
2018-01-12 19:00:00	QQQ	ETF	164.58	164.69	164.58	164.69	4224.0
2018-01-12 04:00:00	IWM	ETF	157.93	157.99	157.93	157.97	20000.0
2018-01-12 05:00:00	IWM	ETF	157.97	157.97	157.92	157.96	6900.0
2018-01-12 06:00:00	IWM	ETF	157.93	157.98	157.88	157.89	29935.0
2018-01-12 07:00:00	IWM	ETF	157.91	157.97	157.76	157.78	32100.0
2018-01-12 08:00:00	IWM	ETF	157.94	157.94	157.2	157.41	181592.0
2018-01-12 09:00:00	IWM	ETF	157.48	157.93	157.47	157.84	3413254.0
2018-01-12 10:00:00	IWM	ETF	157.84	158.42	157.605	158.42	2715343.0
2018-01-12 11:00:00	IWM	ETF	158.43	158.8599	158.22	158.66	2984832.0
2018-01-12 12:00:00	IWM	ETF	158.67	158.69	158.16	158.285	1413291.0
2018-01-12 13:00:00	IWM	ETF	158.29	158.32	157.9	157.95	1281050.0
2018-01-12 14:00:00	IWM	ETF	157.95	158.1	157.78	157.925	1741254.0
2018-01-12 15:00:00	IWM	ETF	157.92	158.17	157.7748	158.15	3843620.0
2018-01-12 16:00:00	IWM	ETF	158.15	158.31	157.9053	158.31	3326607.0
2018-01-12 17:00:00	IWM	ETF	158.22	158.27	158.12	158.24	2355.0
2018-01-12 18:00:00	IWM	ETF	158.25	158.28	158.25	158.28	4285.0
2018-01-12 19:00:00	IWM	ETF	158.2	158.28	158.2	158.28	1920.0
2018-01-12 05:00:00	DIA	ETF	256.69	256.69	256.69	256.69	1000.0
2018-01-12 06:00:00	DIA	ETF	256.72	256.8	256.7	256.7	1600.0

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

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