PREVIEW / etf_1hour / 2015-10-15

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-10-15.parquet
  size:    244 KB
  rows:    7,738

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-10-15 04:00:00	SPY	ETF	200.29	200.59	200.2	200.58	34839.0
2015-10-15 05:00:00	SPY	ETF	200.61	200.69	200.4	200.61	40674.0
2015-10-15 06:00:00	SPY	ETF	200.51	200.6	200.37	200.49	191081.0
2015-10-15 07:00:00	SPY	ETF	200.44	200.55	200.17	200.29	337027.0
2015-10-15 08:00:00	SPY	ETF	200.29	200.6	199.91	200.24	1385094.0
2015-10-15 09:00:00	SPY	ETF	200.23	200.44	199.29	200.1498	12847786.0
2015-10-15 10:00:00	SPY	ETF	200.14	200.7327	199.86	200.58	14027889.0
2015-10-15 11:00:00	SPY	ETF	200.58	200.68	199.64	199.82	11354351.0
2015-10-15 12:00:00	SPY	ETF	199.82	200.61	199.76	200.58	12337537.0
2015-10-15 13:00:00	SPY	ETF	200.58	201.391	200.56	201.24	13948846.0
2015-10-15 14:00:00	SPY	ETF	201.24	201.97	201.23	201.84	16141595.0
2015-10-15 15:00:00	SPY	ETF	201.85	202.34	201.8	202.33	33480794.0
2015-10-15 16:00:00	SPY	ETF	202.33	202.6	201.46	202.52	12985665.0
2015-10-15 17:00:00	SPY	ETF	202.52	202.55	202.38	202.48	155424.0
2015-10-15 18:00:00	SPY	ETF	202.46	202.93	202.37	202.79	189308.0
2015-10-15 19:00:00	SPY	ETF	202.75	202.86	202.66	202.86	94759.0
2015-10-15 04:00:00	QQQ	ETF	106.45	106.58	106.4	106.48	9988.0
2015-10-15 05:00:00	QQQ	ETF	106.6	106.63	106.51	106.63	29650.0
2015-10-15 06:00:00	QQQ	ETF	106.6	106.6	106.46	106.46	4500.0
2015-10-15 07:00:00	QQQ	ETF	106.51	106.55	106.4	106.47	36154.0
2015-10-15 08:00:00	QQQ	ETF	106.52	106.57	106.23	106.39	110961.0
2015-10-15 09:00:00	QQQ	ETF	106.36	106.88	106.22	106.71	4677978.0
2015-10-15 10:00:00	QQQ	ETF	106.71	106.94	106.44	106.825	4745586.0
2015-10-15 11:00:00	QQQ	ETF	106.82	106.93	106.18	106.28	4091878.0
2015-10-15 12:00:00	QQQ	ETF	106.28	106.79	106.25	106.71	2430987.0
2015-10-15 13:00:00	QQQ	ETF	106.7	107.13	106.684	107.05	2944079.0
2015-10-15 14:00:00	QQQ	ETF	107.05	107.445	107.045	107.35	3752826.0
2015-10-15 15:00:00	QQQ	ETF	107.35	107.675	107.29	107.66	6114840.0
2015-10-15 16:00:00	QQQ	ETF	107.66	107.77	107.59	107.76	2360421.0
2015-10-15 17:00:00	QQQ	ETF	107.75	107.76	107.69	107.73	15080.0
2015-10-15 18:00:00	QQQ	ETF	107.7	107.99	107.7	107.91	192349.0
2015-10-15 19:00:00	QQQ	ETF	107.95	107.99	107.88	107.99	65946.0
2015-10-15 04:00:00	IWM	ETF	113.55	113.55	113.55	113.55	400.0
2015-10-15 06:00:00	IWM	ETF	113.55	113.59	113.55	113.55	11100.0
2015-10-15 07:00:00	IWM	ETF	113.55	113.6	113.42	113.44	68384.0
2015-10-15 08:00:00	IWM	ETF	113.49	113.67	113.28	113.32	120691.0
2015-10-15 09:00:00	IWM	ETF	113.3	113.63	113.17	113.36	2990458.0
2015-10-15 10:00:00	IWM	ETF	113.37	113.89	113.3	113.58	4297576.0
2015-10-15 11:00:00	IWM	ETF	113.58	113.76	112.66	112.74	4973617.0
2015-10-15 12:00:00	IWM	ETF	112.74	113.46	112.69	113.3	2866130.0
2015-10-15 13:00:00	IWM	ETF	113.29	114.08	113.29	114.04	3439802.0
2015-10-15 14:00:00	IWM	ETF	114.02	115.03	114.02	114.82	4942671.0
2015-10-15 15:00:00	IWM	ETF	114.82	115.55	114.8	115.53	9430381.0
2015-10-15 16:00:00	IWM	ETF	115.53	115.85	114.25	115.8	2274664.0
2015-10-15 17:00:00	IWM	ETF	115.83	115.83	115.75	115.75	326872.0
2015-10-15 18:00:00	IWM	ETF	115.75	115.8	115.63	115.69	56355.0
2015-10-15 19:00:00	IWM	ETF	115.66	115.73	115.57	115.66	17769.0
2015-10-15 04:00:00	DIA	ETF	169.88	169.88	169.88	169.88	100.0
2015-10-15 06:00:00	DIA	ETF	170.1	170.14	170.05	170.14	3000.0
2015-10-15 07:00:00	DIA	ETF	170.11	170.11	169.8	169.8	1000.0

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

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