PREVIEW / etf_1hour / 2015-06-30

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-06-30.parquet
  size:    251 KB
  rows:    8,097

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-06-30 04:00:00	SPY	ETF	206.1	206.29	205.95	206.28	21123.0
2015-06-30 05:00:00	SPY	ETF	206.2	207.39	206.2	206.99	230929.0
2015-06-30 06:00:00	SPY	ETF	206.99	207.29	206.48	206.72	271128.0
2015-06-30 07:00:00	SPY	ETF	206.68	206.97	206.52	206.86	762852.0
2015-06-30 08:00:00	SPY	ETF	206.85	207.27	206.18	207.14	2747936.0
2015-06-30 09:00:00	SPY	ETF	207.14	207.39	206.13	206.15	20737324.0
2015-06-30 10:00:00	SPY	ETF	206.15	206.44	205.65	206.15	20851743.0
2015-06-30 11:00:00	SPY	ETF	206.15	206.53	205.74	205.75	19324779.0
2015-06-30 12:00:00	SPY	ETF	205.75	206.07	205.28	205.78	16011493.0
2015-06-30 13:00:00	SPY	ETF	205.78	206.72	205.635	206.47	17433870.0
2015-06-30 14:00:00	SPY	ETF	206.46	207.16	206.21	206.23	20460189.0
2015-06-30 15:00:00	SPY	ETF	206.2355	206.54	205.87	205.89	33249297.0
2015-06-30 16:00:00	SPY	ETF	205.91	206.6015	205.4658	206.25	26160624.0
2015-06-30 17:00:00	SPY	ETF	206.25	206.35	205.85	206.24	1165206.0
2015-06-30 18:00:00	SPY	ETF	206.24	206.3	206.09	206.12	121276.0
2015-06-30 19:00:00	SPY	ETF	206.18	206.19	206.11	206.11	15986.0
2015-06-30 05:00:00	QQQ	ETF	107.06	107.44	107.06	107.44	12850.0
2015-06-30 06:00:00	QQQ	ETF	107.42	107.43	107.21	107.27	24400.0
2015-06-30 07:00:00	QQQ	ETF	107.27	107.4	107.22	107.35	27950.0
2015-06-30 08:00:00	QQQ	ETF	107.34	107.55	107.29	107.48	243142.0
2015-06-30 09:00:00	QQQ	ETF	107.48	107.58	107.05	107.061	5017160.0
2015-06-30 10:00:00	QQQ	ETF	107.06	107.2796	106.81	107.12	4337622.0
2015-06-30 11:00:00	QQQ	ETF	107.12	107.3799	106.991	107.0	3140616.0
2015-06-30 12:00:00	QQQ	ETF	107.0	107.17	106.74	106.96	2457091.0
2015-06-30 13:00:00	QQQ	ETF	106.96	107.52	106.84	107.405	3270220.0
2015-06-30 14:00:00	QQQ	ETF	107.4	107.72	107.24	107.24	4210959.0
2015-06-30 15:00:00	QQQ	ETF	107.25	107.42	107.07	107.11	5489942.0
2015-06-30 16:00:00	QQQ	ETF	107.12	107.28	106.98	107.28	1575724.0
2015-06-30 17:00:00	QQQ	ETF	107.273	107.28	107.07	107.18	75773.0
2015-06-30 18:00:00	QQQ	ETF	107.23	107.24	107.2	107.21	3249.0
2015-06-30 19:00:00	QQQ	ETF	107.23	107.23	107.2	107.2	4900.0
2015-06-30 05:00:00	IWM	ETF	125.12	125.12	125.12	125.12	200.0
2015-06-30 06:00:00	IWM	ETF	125.01	125.03	124.87	125.03	10200.0
2015-06-30 07:00:00	IWM	ETF	124.99	125.11	124.91	125.09	47463.0
2015-06-30 08:00:00	IWM	ETF	125.113	125.31	125.08	125.19	218684.0
2015-06-30 09:00:00	IWM	ETF	125.2	125.35	124.68	124.69	5080407.0
2015-06-30 10:00:00	IWM	ETF	124.68	124.88	124.36	124.64	4599140.0
2015-06-30 11:00:00	IWM	ETF	124.65	125.01	124.45	124.57	3224794.0
2015-06-30 12:00:00	IWM	ETF	124.575	124.84	124.29	124.64	4338878.0
2015-06-30 13:00:00	IWM	ETF	124.64	125.09	124.46	124.94	4147606.0
2015-06-30 14:00:00	IWM	ETF	124.93	125.32	124.81	124.81	3937837.0
2015-06-30 15:00:00	IWM	ETF	124.81	125.14	124.7	124.92	6303328.0
2015-06-30 16:00:00	IWM	ETF	124.91	124.99	124.4514	124.95	2328960.0
2015-06-30 17:00:00	IWM	ETF	125.06	125.06	124.86	125.06	245267.0
2015-06-30 18:00:00	IWM	ETF	124.89	125.0	124.89	124.9	2600.0
2015-06-30 07:00:00	DIA	ETF	176.64	176.75	176.64	176.75	1285.0
2015-06-30 08:00:00	DIA	ETF	176.73	177.05	176.69	176.9	9148.0
2015-06-30 09:00:00	DIA	ETF	176.9	177.11	176.16	176.16	907191.0
2015-06-30 10:00:00	DIA	ETF	176.18	176.455	175.84	176.24	815491.0
2015-06-30 11:00:00	DIA	ETF	176.24	176.5	175.79	175.8	677356.0

> showing 50 of 8,097 rows — these rows as CSV

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