PREVIEW / etf_1hour / 2015-04-21

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-04-21.parquet
  size:    240 KB
  rows:    7,658

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
2015-04-21 04:00:00	SPY	ETF	210.8	211.05	210.62	210.66	122228.0
2015-04-21 05:00:00	SPY	ETF	210.57	210.69	210.03	210.43	40933.0
2015-04-21 06:00:00	SPY	ETF	210.43	210.6	210.26	210.26	44676.0
2015-04-21 07:00:00	SPY	ETF	210.33	210.65	210.26	210.51	208423.0
2015-04-21 08:00:00	SPY	ETF	210.51	210.61	209.85	210.59	410090.0
2015-04-21 09:00:00	SPY	ETF	210.6	210.86	210.0	210.06	11019317.0
2015-04-21 10:00:00	SPY	ETF	210.07	210.26	209.65	209.88	13184303.0
2015-04-21 11:00:00	SPY	ETF	209.88	210.15	209.495	209.65	7043670.0
2015-04-21 12:00:00	SPY	ETF	209.66	209.82	209.53	209.72	5712962.0
2015-04-21 13:00:00	SPY	ETF	209.72	209.96	209.44	209.441	6013119.0
2015-04-21 14:00:00	SPY	ETF	209.44	209.8643	209.24	209.775	7850010.0
2015-04-21 15:00:00	SPY	ETF	209.775	209.8	209.43	209.62	10881251.0
2015-04-21 16:00:00	SPY	ETF	209.61	210.7	209.52	209.66	6781288.0
2015-04-21 17:00:00	SPY	ETF	209.66	209.69	209.6	209.69	1986341.0
2015-04-21 18:00:00	SPY	ETF	209.69	209.88	209.69	209.79	619148.0
2015-04-21 19:00:00	SPY	ETF	209.8	209.84	209.75	209.81	69890.0
2015-04-21 04:00:00	QQQ	ETF	108.26	108.34	108.15	108.15	86453.0
2015-04-21 05:00:00	QQQ	ETF	108.08	108.09	107.89	107.89	7900.0
2015-04-21 06:00:00	QQQ	ETF	108.11	108.11	107.98	107.98	1500.0
2015-04-21 07:00:00	QQQ	ETF	107.91	108.14	107.91	108.08	58750.0
2015-04-21 08:00:00	QQQ	ETF	108.04	108.18	108.01	108.18	96582.0
2015-04-21 09:00:00	QQQ	ETF	108.19	108.41	107.95	108.045	5942276.0
2015-04-21 10:00:00	QQQ	ETF	108.05	108.24	107.93	108.067	6216313.0
2015-04-21 11:00:00	QQQ	ETF	108.06	108.22	107.99	108.06	1830472.0
2015-04-21 12:00:00	QQQ	ETF	108.06	108.18	107.99	108.13	803986.0
2015-04-21 13:00:00	QQQ	ETF	108.12	108.31	108.08	108.08	1196450.0
2015-04-21 14:00:00	QQQ	ETF	108.09	108.29	107.96	108.224	1504253.0
2015-04-21 15:00:00	QQQ	ETF	108.23	108.25	108.03	108.06	2720754.0
2015-04-21 16:00:00	QQQ	ETF	108.06	108.14	108.04	108.13	555596.0
2015-04-21 17:00:00	QQQ	ETF	108.12	108.12	108.09	108.11	15300.0
2015-04-21 18:00:00	QQQ	ETF	108.12	108.24	108.12	108.2	50870.0
2015-04-21 19:00:00	QQQ	ETF	108.18	108.22	108.18	108.21	27880.0
2015-04-21 04:00:00	IWM	ETF	126.26	126.26	126.25	126.25	260.0
2015-04-21 07:00:00	IWM	ETF	125.98	126.19	125.98	126.11	22582.0
2015-04-21 08:00:00	IWM	ETF	126.08	126.1	125.96	126.1	59627.0
2015-04-21 09:00:00	IWM	ETF	126.11	126.25	125.71	125.74	2986584.0
2015-04-21 10:00:00	IWM	ETF	125.74	125.97	125.6	125.84	1515743.0
2015-04-21 11:00:00	IWM	ETF	125.83	126.0	125.45	125.56	1539560.0
2015-04-21 12:00:00	IWM	ETF	125.55	125.75	125.48	125.622	869055.0
2015-04-21 13:00:00	IWM	ETF	125.62	125.81	125.515	125.586	975809.0
2015-04-21 14:00:00	IWM	ETF	125.59	125.67	125.42	125.6549	1276023.0
2015-04-21 15:00:00	IWM	ETF	125.65	125.69	125.48	125.49	2030250.0
2015-04-21 16:00:00	IWM	ETF	125.48	125.5267	125.39	125.47	673298.0
2015-04-21 17:00:00	IWM	ETF	125.47	125.48	125.44	125.44	3175.0
2015-04-21 18:00:00	IWM	ETF	125.67	125.67	125.67	125.67	100.0
2015-04-21 19:00:00	IWM	ETF	125.52	125.52	125.48	125.48	3000.0
2015-04-21 08:00:00	DIA	ETF	180.7	180.7	180.03	180.03	10715.0
2015-04-21 09:00:00	DIA	ETF	180.64	180.88	179.79	179.85	695774.0
2015-04-21 10:00:00	DIA	ETF	179.85	180.02	179.27	179.54	886565.0
2015-04-21 11:00:00	DIA	ETF	179.55	179.75	179.22	179.33	449950.0

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

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