PREVIEW / etf_1hour / 2015-04-07

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-04-07.parquet
  size:    239 KB
  rows:    7,536

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-07 04:00:00	SPY	ETF	207.91	207.91	207.83	207.83	1300.0
2015-04-07 05:00:00	SPY	ETF	207.75	207.75	207.64	207.68	7883.0
2015-04-07 06:00:00	SPY	ETF	207.65	207.92	207.65	207.91	36520.0
2015-04-07 07:00:00	SPY	ETF	207.9	208.38	207.89	208.15	354170.0
2015-04-07 08:00:00	SPY	ETF	208.1	208.21	207.87	207.93	462551.0
2015-04-07 09:00:00	SPY	ETF	207.91	208.64	207.76	208.08	11232766.0
2015-04-07 10:00:00	SPY	ETF	208.08	208.76	207.73	208.48	11216117.0
2015-04-07 11:00:00	SPY	ETF	208.48	208.54	208.2	208.51	10641619.0
2015-04-07 12:00:00	SPY	ETF	208.51	208.65	208.31	208.41	5483469.0
2015-04-07 13:00:00	SPY	ETF	208.4133	208.55	208.14	208.25	5447689.0
2015-04-07 14:00:00	SPY	ETF	208.25	208.47	208.22	208.235	5315834.0
2015-04-07 15:00:00	SPY	ETF	208.24	208.28	207.24	207.26	17029290.0
2015-04-07 16:00:00	SPY	ETF	207.25	207.4682	207.11	207.3	5384519.0
2015-04-07 17:00:00	SPY	ETF	207.28	207.3705	207.25	207.31	7300118.0
2015-04-07 18:00:00	SPY	ETF	207.31	207.41	207.11	207.18	101943.0
2015-04-07 19:00:00	SPY	ETF	207.18	207.28	207.14	207.28	51709.0
2015-04-07 07:00:00	QQQ	ETF	106.13	106.33	106.13	106.17	164560.0
2015-04-07 08:00:00	QQQ	ETF	106.16	106.22	106.03	106.051	99221.0
2015-04-07 09:00:00	QQQ	ETF	106.03	106.48	105.9	106.196	3294655.0
2015-04-07 10:00:00	QQQ	ETF	106.2	106.7	106.02	106.55	2885230.0
2015-04-07 11:00:00	QQQ	ETF	106.55	106.59	106.39	106.52	2102355.0
2015-04-07 12:00:00	QQQ	ETF	106.5299	106.64	106.41	106.49	1651984.0
2015-04-07 13:00:00	QQQ	ETF	106.4987	106.57	106.34	106.4	1054052.0
2015-04-07 14:00:00	QQQ	ETF	106.4	106.5	106.34	106.358	1079368.0
2015-04-07 15:00:00	QQQ	ETF	106.36	106.39	105.8	105.8	4578541.0
2015-04-07 16:00:00	QQQ	ETF	105.8	105.86	105.56	105.76	526859.0
2015-04-07 17:00:00	QQQ	ETF	105.75	105.79	105.72	105.78	16664.0
2015-04-07 18:00:00	QQQ	ETF	105.79	105.81	105.68	105.74	19387.0
2015-04-07 19:00:00	QQQ	ETF	105.72	105.79	105.72	105.77	11000.0
2015-04-07 05:00:00	IWM	ETF	124.94	124.94	124.94	124.94	100.0
2015-04-07 07:00:00	IWM	ETF	125.31	125.44	125.12	125.12	74000.0
2015-04-07 08:00:00	IWM	ETF	125.12	125.16	125.02	125.07	75650.0
2015-04-07 09:00:00	IWM	ETF	125.03	125.36	124.84	125.21	2069324.0
2015-04-07 10:00:00	IWM	ETF	125.22	125.46	124.92	125.34	2011135.0
2015-04-07 11:00:00	IWM	ETF	125.33	125.37	125.21	125.37	1024055.0
2015-04-07 12:00:00	IWM	ETF	125.37	125.5	125.32	125.39	951274.0
2015-04-07 13:00:00	IWM	ETF	125.38	125.43	124.96	125.01	1520814.0
2015-04-07 14:00:00	IWM	ETF	125.01	125.2	124.96	124.97	870100.0
2015-04-07 15:00:00	IWM	ETF	124.97	124.99	124.37	124.37	5515991.0
2015-04-07 16:00:00	IWM	ETF	124.38	125.27	124.15	124.29	1568003.0
2015-04-07 17:00:00	IWM	ETF	124.25	124.25	124.23	124.23	399.0
2015-04-07 18:00:00	IWM	ETF	124.28	124.28	124.24	124.28	3128.0
2015-04-07 19:00:00	IWM	ETF	124.28	124.34	124.23	124.23	4084.0
2015-04-07 08:00:00	DIA	ETF	179.0	179.0	178.77	178.92	2450.0
2015-04-07 09:00:00	DIA	ETF	178.75	179.46	178.6	178.96	1578327.0
2015-04-07 10:00:00	DIA	ETF	178.96	179.58	178.7	179.39	1440842.0
2015-04-07 11:00:00	DIA	ETF	179.38	179.48	179.165	179.43	319587.0
2015-04-07 12:00:00	DIA	ETF	179.44	179.55	179.25	179.35	291796.0
2015-04-07 13:00:00	DIA	ETF	179.35	179.54	179.2301	179.32	236102.0
2015-04-07 14:00:00	DIA	ETF	179.31	179.5	179.25	179.27	197538.0

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

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