PREVIEW / etf_1hour / 2015-01-06

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-01-06.parquet
  size:    249 KB
  rows:    7,929

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-06 04:00:00	SPY	ETF	201.65	201.81	201.55	201.68	13615.0
2015-01-06 05:00:00	SPY	ETF	201.68	201.73	201.54	201.69	33814.0
2015-01-06 06:00:00	SPY	ETF	201.69	202.6	201.69	202.58	265998.0
2015-01-06 07:00:00	SPY	ETF	202.51	202.55	202.07	202.25	792041.0
2015-01-06 08:00:00	SPY	ETF	201.52	202.51	201.52	201.87	3372598.0
2015-01-06 09:00:00	SPY	ETF	201.87	202.395	201.72	202.0392	15483788.0
2015-01-06 10:00:00	SPY	ETF	202.0	202.72	201.275	201.29	28569824.0
2015-01-06 11:00:00	SPY	ETF	201.29	201.3	199.8	199.98	30756756.0
2015-01-06 12:00:00	SPY	ETF	199.98	200.19	199.18	200.11	26443483.0
2015-01-06 13:00:00	SPY	ETF	200.11	200.12	198.855	199.859	25195758.0
2015-01-06 14:00:00	SPY	ETF	199.85	200.985	199.28	200.618	28737490.0
2015-01-06 15:00:00	SPY	ETF	200.61	201.355	199.82	199.82	35526741.0
2015-01-06 16:00:00	SPY	ETF	199.79	200.19	199.5882	199.87	10259685.0
2015-01-06 17:00:00	SPY	ETF	199.87	199.99	199.84	199.98	138249.0
2015-01-06 18:00:00	SPY	ETF	199.99	200.16	199.92	200.01	173420.0
2015-01-06 19:00:00	SPY	ETF	200.05	200.17	200.05	200.16	32453.0
2015-01-06 06:00:00	QQQ	ETF	101.36	101.59	101.36	101.59	5500.0
2015-01-06 07:00:00	QQQ	ETF	101.7	101.72	101.58	101.63	81071.0
2015-01-06 08:00:00	QQQ	ETF	101.6	101.72	101.3	101.49	213478.0
2015-01-06 09:00:00	QQQ	ETF	101.49	101.75	101.2899	101.33	4706621.0
2015-01-06 10:00:00	QQQ	ETF	101.31	101.74	100.96	100.98	6090700.0
2015-01-06 11:00:00	QQQ	ETF	100.981	101.0	100.21	100.341	6264280.0
2015-01-06 12:00:00	QQQ	ETF	100.3499	100.5	99.75	100.46	6054672.0
2015-01-06 13:00:00	QQQ	ETF	100.46	100.4663	99.62	100.34	5376222.0
2015-01-06 14:00:00	QQQ	ETF	100.33	100.98	99.955	100.76	6970316.0
2015-01-06 15:00:00	QQQ	ETF	100.76	101.13	100.06	100.1	21915818.0
2015-01-06 16:00:00	QQQ	ETF	100.1	101.3696	99.97	100.03	2036258.0
2015-01-06 17:00:00	QQQ	ETF	100.02	100.08	100.0	100.08	8990.0
2015-01-06 18:00:00	QQQ	ETF	100.11	100.23	100.11	100.18	11384.0
2015-01-06 19:00:00	QQQ	ETF	100.22	100.23	100.2	100.23	5574.0
2015-01-06 06:00:00	IWM	ETF	117.45	117.74	117.45	117.74	500.0
2015-01-06 07:00:00	IWM	ETF	117.65	117.73	117.48	117.69	52200.0
2015-01-06 08:00:00	IWM	ETF	117.65	117.74	117.36	117.5	125350.0
2015-01-06 09:00:00	IWM	ETF	117.45	117.77	116.94	117.0	3592940.0
2015-01-06 10:00:00	IWM	ETF	116.99	117.205	116.3468	116.38	6058020.0
2015-01-06 11:00:00	IWM	ETF	116.379	116.51	114.985	115.0	9352022.0
2015-01-06 12:00:00	IWM	ETF	114.995	115.5	114.36	115.44	10489651.0
2015-01-06 13:00:00	IWM	ETF	115.45	115.465	114.59	115.13	3908923.0
2015-01-06 14:00:00	IWM	ETF	115.11	116.0	114.69	115.6501	6068662.0
2015-01-06 15:00:00	IWM	ETF	115.65	115.99	115.16	115.32	8661377.0
2015-01-06 16:00:00	IWM	ETF	115.3	115.34	115.12	115.34	1351732.0
2015-01-06 17:00:00	IWM	ETF	115.29	115.31	115.21	115.22	54300.0
2015-01-06 18:00:00	IWM	ETF	115.35	115.35	115.23	115.33	2708.0
2015-01-06 19:00:00	IWM	ETF	115.31	115.55	115.28	115.55	11332.0
2015-01-06 06:00:00	DIA	ETF	175.18	175.25	175.18	175.22	11800.0
2015-01-06 07:00:00	DIA	ETF	175.25	175.37	175.1	175.22	13851.0
2015-01-06 08:00:00	DIA	ETF	175.29	175.29	174.77	175.08	10958.0
2015-01-06 09:00:00	DIA	ETF	175.1	175.291	174.76	175.0046	683082.0
2015-01-06 10:00:00	DIA	ETF	175.0	175.54	174.37	174.37	1062820.0
2015-01-06 11:00:00	DIA	ETF	174.38	174.4	173.14	173.24	1303122.0

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

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