PREVIEW / etf_1hour / 2016-03-15

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-03-15.parquet
  size:    245 KB
  rows:    7,877

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
2016-03-15 04:00:00	SPY	ETF	201.69	201.73	201.33	201.41	61342.0
2016-03-15 05:00:00	SPY	ETF	201.34	201.66	201.34	201.42	27205.0
2016-03-15 06:00:00	SPY	ETF	201.46	201.56	201.24	201.48	151489.0
2016-03-15 07:00:00	SPY	ETF	201.47	201.53	201.34	201.45	344226.0
2016-03-15 08:00:00	SPY	ETF	201.45	201.55	201.14	201.38	850460.0
2016-03-15 09:00:00	SPY	ETF	201.41	201.61	201.1	201.24	10332279.0
2016-03-15 10:00:00	SPY	ETF	201.2401	201.83	201.05	201.4801	15939036.0
2016-03-15 11:00:00	SPY	ETF	201.49	201.83	201.34	201.44	11489387.0
2016-03-15 12:00:00	SPY	ETF	201.44	201.66	201.34	201.4537	8073673.0
2016-03-15 13:00:00	SPY	ETF	201.45	201.96	201.42	201.9	6928561.0
2016-03-15 14:00:00	SPY	ETF	201.8976	202.1	201.66	201.76	7504810.0
2016-03-15 15:00:00	SPY	ETF	201.76	202.5307	201.71	202.18	18743308.0
2016-03-15 16:00:00	SPY	ETF	202.17	202.26	201.48	202.24	7365693.0
2016-03-15 17:00:00	SPY	ETF	202.23	202.31	202.21	202.21	158180.0
2016-03-15 18:00:00	SPY	ETF	202.22	202.3	202.17	202.25	73852.0
2016-03-15 19:00:00	SPY	ETF	202.27	202.44	202.22	202.44	68465.0
2016-03-15 04:00:00	QQQ	ETF	106.13	106.16	106.0	106.0	524.0
2016-03-15 05:00:00	QQQ	ETF	106.08	106.08	106.04	106.08	700.0
2016-03-15 06:00:00	QQQ	ETF	106.08	106.21	106.04	106.21	1985.0
2016-03-15 07:00:00	QQQ	ETF	106.2	106.35	106.17	106.33	54233.0
2016-03-15 08:00:00	QQQ	ETF	106.22	106.36	106.12	106.24	145252.0
2016-03-15 09:00:00	QQQ	ETF	106.26	106.438	106.07	106.16	2439694.0
2016-03-15 10:00:00	QQQ	ETF	106.16	106.49	105.95	106.35	4054910.0
2016-03-15 11:00:00	QQQ	ETF	106.35	106.65	106.2923	106.3299	2757338.0
2016-03-15 12:00:00	QQQ	ETF	106.33	106.53	106.28	106.379	2036257.0
2016-03-15 13:00:00	QQQ	ETF	106.38	106.63	106.32	106.6	1748829.0
2016-03-15 14:00:00	QQQ	ETF	106.6	106.7	106.45	106.5262	2146957.0
2016-03-15 15:00:00	QQQ	ETF	106.53	106.75	106.475	106.62	3871059.0
2016-03-15 16:00:00	QQQ	ETF	106.63	106.72	106.4029	106.72	473510.0
2016-03-15 17:00:00	QQQ	ETF	106.73	106.73	106.65	106.7	3185.0
2016-03-15 18:00:00	QQQ	ETF	106.71	106.71	106.62	106.68	7154.0
2016-03-15 19:00:00	QQQ	ETF	106.67	106.76	106.67	106.75	10861.0
2016-03-15 04:00:00	IWM	ETF	107.21	107.21	107.21	107.21	100.0
2016-03-15 05:00:00	IWM	ETF	107.2	107.21	107.2	107.2	700.0
2016-03-15 06:00:00	IWM	ETF	107.24	107.27	107.12	107.27	16500.0
2016-03-15 07:00:00	IWM	ETF	107.24	107.26	107.15	107.26	11606.0
2016-03-15 08:00:00	IWM	ETF	107.24	107.25	107.09	107.19	104635.0
2016-03-15 09:00:00	IWM	ETF	107.24	107.36	106.61	106.73	3234394.0
2016-03-15 10:00:00	IWM	ETF	106.73	106.94	106.37	106.51	4650462.0
2016-03-15 11:00:00	IWM	ETF	106.51	106.64	106.315	106.4	3437099.0
2016-03-15 12:00:00	IWM	ETF	106.41	106.44	106.17	106.23	2962201.0
2016-03-15 13:00:00	IWM	ETF	106.22	106.65	106.19	106.63	2450516.0
2016-03-15 14:00:00	IWM	ETF	106.62	106.72	106.05	106.11	3131892.0
2016-03-15 15:00:00	IWM	ETF	106.11	106.4525	106.03	106.28	7615959.0
2016-03-15 16:00:00	IWM	ETF	106.28	106.33	106.13	106.31	1199801.0
2016-03-15 17:00:00	IWM	ETF	106.2	106.4	106.2	106.34	6952.0
2016-03-15 18:00:00	IWM	ETF	106.25	106.33	106.16	106.33	2959.0
2016-03-15 19:00:00	IWM	ETF	106.37	106.37	106.37	106.37	400.0
2016-03-15 08:00:00	DIA	ETF	171.6	171.6	171.41	171.41	1600.0
2016-03-15 09:00:00	DIA	ETF	171.5	171.84	171.32	171.64	293886.0

> showing 50 of 7,877 rows — these rows as CSV

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