PREVIEW / etf_1hour / 2015-02-25

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-02-25.parquet
  size:    236 KB
  rows:    7,512

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-25 04:00:00	SPY	ETF	211.77	211.77	211.59	211.61	5800.0
2015-02-25 05:00:00	SPY	ETF	211.6	211.74	211.6	211.69	4616.0
2015-02-25 06:00:00	SPY	ETF	211.69	211.69	211.55	211.56	3200.0
2015-02-25 07:00:00	SPY	ETF	211.55	211.71	211.51	211.68	94874.0
2015-02-25 08:00:00	SPY	ETF	211.68	211.71	211.62	211.66	235245.0
2015-02-25 09:00:00	SPY	ETF	211.66	211.78	211.37	211.52	6617139.0
2015-02-25 10:00:00	SPY	ETF	211.5	211.74	211.41	211.64	7584462.0
2015-02-25 11:00:00	SPY	ETF	211.64	211.92	211.495	211.78	6496213.0
2015-02-25 12:00:00	SPY	ETF	211.78	211.95	211.77	211.88	4473105.0
2015-02-25 13:00:00	SPY	ETF	211.88	212.24	211.81	212.14	6029979.0
2015-02-25 14:00:00	SPY	ETF	212.14	212.17	211.33	211.5641	11536245.0
2015-02-25 15:00:00	SPY	ETF	211.565	211.71	211.22	211.61	23266970.0
2015-02-25 16:00:00	SPY	ETF	211.62	211.8137	211.49	211.8137	4059589.0
2015-02-25 17:00:00	SPY	ETF	211.57	211.59	211.48	211.49	623916.0
2015-02-25 18:00:00	SPY	ETF	211.5	211.57	211.44	211.48	94554.0
2015-02-25 19:00:00	SPY	ETF	211.5	211.59	211.5	211.58	20035.0
2015-02-25 04:00:00	QQQ	ETF	108.45	108.45	108.45	108.45	200.0
2015-02-25 06:00:00	QQQ	ETF	108.42	108.45	108.4	108.42	11450.0
2015-02-25 07:00:00	QQQ	ETF	108.42	108.47	108.38	108.47	18143.0
2015-02-25 08:00:00	QQQ	ETF	108.46	108.48	108.39	108.41	96201.0
2015-02-25 09:00:00	QQQ	ETF	108.41	108.48	108.3051	108.46	1965152.0
2015-02-25 10:00:00	QQQ	ETF	108.45	108.64	108.41	108.6199	2221470.0
2015-02-25 11:00:00	QQQ	ETF	108.61	108.73	108.54	108.615	1654157.0
2015-02-25 12:00:00	QQQ	ETF	108.62	108.79	108.58	108.73	1447698.0
2015-02-25 13:00:00	QQQ	ETF	108.735	108.86	108.68	108.8	1561176.0
2015-02-25 14:00:00	QQQ	ETF	108.79	108.81	108.18	108.365	3173367.0
2015-02-25 15:00:00	QQQ	ETF	108.36	108.38	108.09	108.32	5958660.0
2015-02-25 16:00:00	QQQ	ETF	108.33	108.591	108.24	108.3	842259.0
2015-02-25 17:00:00	QQQ	ETF	108.29	108.34	108.28	108.3	11068.0
2015-02-25 18:00:00	QQQ	ETF	108.29	108.3	108.24	108.26	7030.0
2015-02-25 19:00:00	QQQ	ETF	108.3	108.305	108.3	108.3	2709.0
2015-02-25 04:00:00	IWM	ETF	122.37	122.37	122.37	122.37	106.0
2015-02-25 07:00:00	IWM	ETF	122.5	122.6	122.5	122.6	17806.0
2015-02-25 08:00:00	IWM	ETF	122.62	122.65	122.58	122.65	32589.0
2015-02-25 09:00:00	IWM	ETF	122.64	122.66	122.32	122.54	1685508.0
2015-02-25 10:00:00	IWM	ETF	122.51	122.89	122.46	122.745	1797837.0
2015-02-25 11:00:00	IWM	ETF	122.74	122.95	122.58	122.765	1168237.0
2015-02-25 12:00:00	IWM	ETF	122.77	122.95	122.76	122.85	982367.0
2015-02-25 13:00:00	IWM	ETF	122.85	123.04	122.8	122.96	1186640.0
2015-02-25 14:00:00	IWM	ETF	122.96	123.01	122.23	122.43	2633845.0
2015-02-25 15:00:00	IWM	ETF	122.42	122.85	122.3	122.77	3751412.0
2015-02-25 16:00:00	IWM	ETF	122.78	122.848	122.65	122.81	671696.0
2015-02-25 17:00:00	IWM	ETF	122.8	122.82	122.78	122.79	13222.0
2015-02-25 18:00:00	IWM	ETF	122.8	122.8	122.8	122.8	500000.0
2015-02-25 19:00:00	IWM	ETF	122.8	122.8	122.8	122.8	200.0
2015-02-25 06:00:00	DIA	ETF	181.77	181.77	181.75	181.75	2000.0
2015-02-25 07:00:00	DIA	ETF	181.73	181.86	181.73	181.86	1400.0
2015-02-25 08:00:00	DIA	ETF	181.78	181.83	181.78	181.78	6300.0
2015-02-25 09:00:00	DIA	ETF	181.83	181.9	181.56	181.61	439929.0
2015-02-25 10:00:00	DIA	ETF	181.58	181.905	181.56	181.79	318319.0

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

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