PREVIEW / etf_1hour / 2015-01-07

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-01-07.parquet
  size:    242 KB
  rows:    7,715

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-01-07 04:00:00	SPY	ETF	200.29	200.68	200.15	200.6	28745.0
2015-01-07 05:00:00	SPY	ETF	200.63	201.23	200.57	201.17	352525.0
2015-01-07 06:00:00	SPY	ETF	201.1	201.21	200.92	201.01	103479.0
2015-01-07 07:00:00	SPY	ETF	201.01	201.45	200.98	201.45	388099.0
2015-01-07 08:00:00	SPY	ETF	201.26	201.77	201.03	201.39	1472527.0
2015-01-07 09:00:00	SPY	ETF	201.37	202.01	201.15	201.99	18310512.0
2015-01-07 10:00:00	SPY	ETF	201.99	202.21	200.985	201.615	18812845.0
2015-01-07 11:00:00	SPY	ETF	201.63	202.3	200.88	202.22	17116914.0
2015-01-07 12:00:00	SPY	ETF	202.22	202.72	202.05	202.15	13749385.0
2015-01-07 13:00:00	SPY	ETF	202.155	202.37	201.72	202.23	7813804.0
2015-01-07 14:00:00	SPY	ETF	202.22	202.54	201.76	201.86	18405265.0
2015-01-07 15:00:00	SPY	ETF	201.87	202.34	201.76	202.34	17953672.0
2015-01-07 16:00:00	SPY	ETF	202.34	202.51	201.5	202.42	7242635.0
2015-01-07 17:00:00	SPY	ETF	202.42	202.47	202.4	202.42	1357495.0
2015-01-07 18:00:00	SPY	ETF	202.46	202.53	202.44	202.48	216598.0
2015-01-07 19:00:00	SPY	ETF	202.5	202.52	202.4	202.52	53964.0
2015-01-07 04:00:00	QQQ	ETF	100.44	100.53	100.44	100.52	2400.0
2015-01-07 05:00:00	QQQ	ETF	100.58	100.66	100.58	100.66	15100.0
2015-01-07 06:00:00	QQQ	ETF	100.65	100.74	100.65	100.74	4400.0
2015-01-07 07:00:00	QQQ	ETF	100.58	100.8	100.58	100.8	73628.0
2015-01-07 08:00:00	QQQ	ETF	100.81	100.97	100.54	100.69	219646.0
2015-01-07 09:00:00	QQQ	ETF	100.71	101.15	100.485	101.14	5518925.0
2015-01-07 10:00:00	QQQ	ETF	101.13	101.339	100.71	101.05	5474725.0
2015-01-07 11:00:00	QQQ	ETF	101.06	101.42	100.58	101.4	5450227.0
2015-01-07 12:00:00	QQQ	ETF	101.39	101.6	101.28	101.37	2576275.0
2015-01-07 13:00:00	QQQ	ETF	101.37	101.5	101.05	101.37	2615379.0
2015-01-07 14:00:00	QQQ	ETF	101.3765	101.49	101.06	101.11	4115575.0
2015-01-07 15:00:00	QQQ	ETF	101.12	101.37	101.06	101.36	4381954.0
2015-01-07 16:00:00	QQQ	ETF	101.35	101.39	101.0083	101.37	1243640.0
2015-01-07 17:00:00	QQQ	ETF	101.35	101.4	101.31	101.4	8172.0
2015-01-07 18:00:00	QQQ	ETF	101.37	101.44	101.36	101.44	23748.0
2015-01-07 19:00:00	QQQ	ETF	101.4	101.44	101.38	101.4	4584.0
2015-01-07 04:00:00	IWM	ETF	115.65	115.65	115.65	115.65	600.0
2015-01-07 06:00:00	IWM	ETF	115.98	115.98	115.75	115.75	1000.0
2015-01-07 07:00:00	IWM	ETF	116.06	116.08	115.87	116.08	112478.0
2015-01-07 08:00:00	IWM	ETF	116.08	116.25	115.85	116.13	390885.0
2015-01-07 09:00:00	IWM	ETF	116.16	116.46	115.88	116.13	4503453.0
2015-01-07 10:00:00	IWM	ETF	116.12	116.32	115.56	115.97	4503472.0
2015-01-07 11:00:00	IWM	ETF	115.975	116.3	115.48	116.22	4670864.0
2015-01-07 12:00:00	IWM	ETF	116.21	116.39	116.05	116.13	2717752.0
2015-01-07 13:00:00	IWM	ETF	116.14	116.35	115.94	116.2	1795015.0
2015-01-07 14:00:00	IWM	ETF	116.21	116.62	116.02	116.24	4146690.0
2015-01-07 15:00:00	IWM	ETF	116.25	116.76	116.1401	116.75	4144271.0
2015-01-07 16:00:00	IWM	ETF	116.75	116.78	116.56	116.75	1046754.0
2015-01-07 17:00:00	IWM	ETF	116.75	116.84	116.72	116.72	50085.0
2015-01-07 18:00:00	IWM	ETF	116.78	116.8	116.78	116.8	500.0
2015-01-07 19:00:00	IWM	ETF	116.74	116.76	116.74	116.76	900.0
2015-01-07 05:00:00	DIA	ETF	174.09	174.41	174.09	174.41	60000.0
2015-01-07 06:00:00	DIA	ETF	174.43	174.43	174.43	174.43	3000.0
2015-01-07 07:00:00	DIA	ETF	174.44	174.49	174.44	174.49	18000.0

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

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