PREVIEW / etf_1hour / 2015-07-23

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-07-23.parquet
  size:    244 KB
  rows:    7,734

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-07-23 04:00:00	SPY	ETF	211.68	211.7	211.56	211.56	1125.0
2015-07-23 05:00:00	SPY	ETF	211.68	211.71	211.63	211.7	50500.0
2015-07-23 06:00:00	SPY	ETF	211.82	211.82	211.62	211.62	82789.0
2015-07-23 07:00:00	SPY	ETF	211.69	211.73	211.4	211.6	198413.0
2015-07-23 08:00:00	SPY	ETF	211.58	211.98	211.36	211.37	513908.0
2015-07-23 09:00:00	SPY	ETF	211.38	211.65	211.03	211.17	7919423.0
2015-07-23 10:00:00	SPY	ETF	211.17	211.63	211.02	211.4306	8389760.0
2015-07-23 11:00:00	SPY	ETF	211.45	211.48	210.44	210.51	11159016.0
2015-07-23 12:00:00	SPY	ETF	210.515	210.56	210.13	210.34	12641477.0
2015-07-23 13:00:00	SPY	ETF	210.34	210.75	210.15	210.68	8160183.0
2015-07-23 14:00:00	SPY	ETF	210.69	211.3258	210.07	210.18	11826243.0
2015-07-23 15:00:00	SPY	ETF	210.17	210.23	209.75	210.17	22753385.0
2015-07-23 16:00:00	SPY	ETF	210.17	210.74	210.0	210.73	4985505.0
2015-07-23 17:00:00	SPY	ETF	210.72	210.8	210.14	210.72	224197.0
2015-07-23 18:00:00	SPY	ETF	210.72	210.75	210.62	210.66	83278.0
2015-07-23 19:00:00	SPY	ETF	210.68	210.68	210.52	210.6	51098.0
2015-07-23 06:00:00	QQQ	ETF	113.04	113.04	113.01	113.01	700.0
2015-07-23 07:00:00	QQQ	ETF	112.9	112.93	112.83	112.88	47914.0
2015-07-23 08:00:00	QQQ	ETF	112.88	112.88	112.69	112.69	88676.0
2015-07-23 09:00:00	QQQ	ETF	112.68	112.91	112.52	112.69	3031816.0
2015-07-23 10:00:00	QQQ	ETF	112.69	113.07	112.61	113.03	2765124.0
2015-07-23 11:00:00	QQQ	ETF	113.035	113.1	112.46	112.52	2618230.0
2015-07-23 12:00:00	QQQ	ETF	112.52	112.54	112.27	112.38	2698370.0
2015-07-23 13:00:00	QQQ	ETF	112.385	112.62	112.19	112.564	1741770.0
2015-07-23 14:00:00	QQQ	ETF	112.57	112.58	112.17	112.21	1889738.0
2015-07-23 15:00:00	QQQ	ETF	112.1939	112.21	111.91	112.18	4201630.0
2015-07-23 16:00:00	QQQ	ETF	112.17	113.09	112.0989	113.07	1978382.0
2015-07-23 17:00:00	QQQ	ETF	113.07	113.12	113.02	113.1	80546.0
2015-07-23 18:00:00	QQQ	ETF	113.08	113.1	113.02	113.04	40413.0
2015-07-23 19:00:00	QQQ	ETF	113.04	113.04	112.93	112.95	70538.0
2015-07-23 06:00:00	IWM	ETF	125.29	125.29	125.29	125.29	100.0
2015-07-23 07:00:00	IWM	ETF	125.17	125.25	125.16	125.25	10000.0
2015-07-23 08:00:00	IWM	ETF	125.21	125.22	125.04	125.05	129647.0
2015-07-23 09:00:00	IWM	ETF	125.02	125.31	124.74	124.94	2909441.0
2015-07-23 10:00:00	IWM	ETF	124.93	125.33	124.78	125.28	2769006.0
2015-07-23 11:00:00	IWM	ETF	125.28	125.39	124.02	124.15	4967611.0
2015-07-23 12:00:00	IWM	ETF	124.14	124.14	123.39	123.73	6469173.0
2015-07-23 13:00:00	IWM	ETF	123.73	124.02	123.5	123.94	2844175.0
2015-07-23 14:00:00	IWM	ETF	123.94	123.964	123.415	123.55	2646830.0
2015-07-23 15:00:00	IWM	ETF	123.54	123.77	123.3	123.59	5597796.0
2015-07-23 16:00:00	IWM	ETF	123.59	123.79	123.4091	123.57	1220583.0
2015-07-23 17:00:00	IWM	ETF	123.79	123.88	123.57	123.88	11905.0
2015-07-23 18:00:00	IWM	ETF	123.83	123.83	123.83	123.83	200.0
2015-07-23 19:00:00	IWM	ETF	123.84	123.84	123.82	123.82	744.0
2015-07-23 08:00:00	DIA	ETF	178.2285	178.3015	178.22	178.23	14920.0
2015-07-23 09:00:00	DIA	ETF	178.25	178.35	177.74	177.82	440954.0
2015-07-23 10:00:00	DIA	ETF	177.83	178.25	177.71	178.13	570903.0
2015-07-23 11:00:00	DIA	ETF	178.14	178.21	177.39	177.47	560424.0
2015-07-23 12:00:00	DIA	ETF	177.45	177.47	177.17	177.3	725999.0
2015-07-23 13:00:00	DIA	ETF	177.294	177.57	177.13	177.51	566393.0

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

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