PREVIEW / etf_1hour / 2015-02-23

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-02-23.parquet
  size:    238 KB
  rows:    7,659

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-02-23 04:00:00	SPY	ETF	211.0	211.0	210.8	210.8	4520.0
2015-02-23 05:00:00	SPY	ETF	210.7	210.8	210.7	210.8	5800.0
2015-02-23 06:00:00	SPY	ETF	210.79	210.8	210.65	210.77	149873.0
2015-02-23 07:00:00	SPY	ETF	210.77	210.92	210.66	210.85	308810.0
2015-02-23 08:00:00	SPY	ETF	210.85	210.9	210.74	210.81	448648.0
2015-02-23 09:00:00	SPY	ETF	210.82	211.0	210.48	210.76	8796564.0
2015-02-23 10:00:00	SPY	ETF	210.76	210.94	210.51	210.875	10033720.0
2015-02-23 11:00:00	SPY	ETF	210.88	211.11	210.84	211.02	6258070.0
2015-02-23 12:00:00	SPY	ETF	211.02	211.08	210.65	210.8	6920028.0
2015-02-23 13:00:00	SPY	ETF	210.8	211.09	210.72	210.895	5670757.0
2015-02-23 14:00:00	SPY	ETF	210.895	211.04	210.67	210.75	8277648.0
2015-02-23 15:00:00	SPY	ETF	210.75	211.21	210.53	211.21	13647527.0
2015-02-23 16:00:00	SPY	ETF	211.21	211.31	210.72	211.16	4039466.0
2015-02-23 17:00:00	SPY	ETF	211.18	211.18	211.13	211.16	80529.0
2015-02-23 18:00:00	SPY	ETF	211.16	211.18	211.09	211.09	116405.0
2015-02-23 19:00:00	SPY	ETF	211.09	211.14	211.07	211.12	26305.0
2015-02-23 04:00:00	QQQ	ETF	108.41	108.41	108.21	108.21	1100.0
2015-02-23 06:00:00	QQQ	ETF	108.27	108.32	108.27	108.31	1500.0
2015-02-23 07:00:00	QQQ	ETF	108.3	108.35	108.29	108.35	8860.0
2015-02-23 08:00:00	QQQ	ETF	108.3	108.36	108.3	108.32	58472.0
2015-02-23 09:00:00	QQQ	ETF	108.32	108.46	108.22	108.352	2440696.0
2015-02-23 10:00:00	QQQ	ETF	108.36	108.39	108.11	108.27	4274626.0
2015-02-23 11:00:00	QQQ	ETF	108.28	108.44	108.265	108.38	1722728.0
2015-02-23 12:00:00	QQQ	ETF	108.38	108.45	108.25	108.3572	1097993.0
2015-02-23 13:00:00	QQQ	ETF	108.36	108.43	108.3	108.3599	1183873.0
2015-02-23 14:00:00	QQQ	ETF	108.36	108.48	108.32	108.3201	1496828.0
2015-02-23 15:00:00	QQQ	ETF	108.32	108.55	108.14	108.53	3191681.0
2015-02-23 16:00:00	QQQ	ETF	108.54	108.5712	108.3333	108.5	1643253.0
2015-02-23 17:00:00	QQQ	ETF	108.5	108.5	108.47	108.47	26226.0
2015-02-23 18:00:00	QQQ	ETF	108.47	108.52	108.45	108.45	24822.0
2015-02-23 19:00:00	QQQ	ETF	108.46	108.49	108.46	108.49	8050.0
2015-02-23 06:00:00	IWM	ETF	121.9	121.9	121.9	121.9	100.0
2015-02-23 07:00:00	IWM	ETF	121.96	122.03	121.9	121.98	16558.0
2015-02-23 08:00:00	IWM	ETF	121.97	122.01	121.83	121.9	55569.0
2015-02-23 09:00:00	IWM	ETF	121.88	122.19	121.27	121.59	3025345.0
2015-02-23 10:00:00	IWM	ETF	121.6	121.82	121.45	121.56	4295497.0
2015-02-23 11:00:00	IWM	ETF	121.57	122.301	121.56	122.245	1427913.0
2015-02-23 12:00:00	IWM	ETF	122.245	122.39	121.99	122.09	1108177.0
2015-02-23 13:00:00	IWM	ETF	122.1	122.3	122.04	122.1199	847272.0
2015-02-23 14:00:00	IWM	ETF	122.12	122.25	121.87	121.96	1571716.0
2015-02-23 15:00:00	IWM	ETF	121.96	122.51	121.81	122.51	3154947.0
2015-02-23 16:00:00	IWM	ETF	122.51	122.64	122.46	122.49	944996.0
2015-02-23 17:00:00	IWM	ETF	122.52	122.54	122.48	122.48	11400.0
2015-02-23 18:00:00	IWM	ETF	122.48	122.51	122.48	122.51	300.0
2015-02-23 06:00:00	DIA	ETF	180.76	180.76	180.69	180.69	800.0
2015-02-23 07:00:00	DIA	ETF	180.68	180.75	180.59	180.67	4750.0
2015-02-23 08:00:00	DIA	ETF	180.67	180.7	180.6	180.62	10978.0
2015-02-23 09:00:00	DIA	ETF	180.58	180.83	180.32	180.51	544297.0
2015-02-23 10:00:00	DIA	ETF	180.53	180.74	180.37	180.713	477840.0
2015-02-23 11:00:00	DIA	ETF	180.71	180.87	180.65	180.79	430215.0

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

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