PREVIEW / etf_1hour / 2015-07-13

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-07-13.parquet
  size:    247 KB
  rows:    7,975

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-07-13 04:00:00	SPY	ETF	208.04	208.39	208.04	208.39	167667.0
2015-07-13 05:00:00	SPY	ETF	208.36	209.25	208.36	208.98	124012.0
2015-07-13 06:00:00	SPY	ETF	209.0	209.0	208.75	208.8	84846.0
2015-07-13 07:00:00	SPY	ETF	208.8	209.0	208.69	208.84	643084.0
2015-07-13 08:00:00	SPY	ETF	208.84	209.0	208.58	208.75	1181748.0
2015-07-13 09:00:00	SPY	ETF	208.76	209.56	208.75	209.32	16649175.0
2015-07-13 10:00:00	SPY	ETF	209.32	209.6399	209.23	209.385	15786091.0
2015-07-13 11:00:00	SPY	ETF	209.38	209.58	209.17	209.43	9933705.0
2015-07-13 12:00:00	SPY	ETF	209.43	209.46	209.13	209.18	9198327.0
2015-07-13 13:00:00	SPY	ETF	209.17	209.3999	209.17	209.275	6907950.0
2015-07-13 14:00:00	SPY	ETF	209.28	209.72	209.275	209.65	11357370.0
2015-07-13 15:00:00	SPY	ETF	209.66	209.9	209.6	209.76	25337573.0
2015-07-13 16:00:00	SPY	ETF	209.79	210.0	209.4799	209.88	7584537.0
2015-07-13 17:00:00	SPY	ETF	209.9	209.97	207.4944	209.89	339311.0
2015-07-13 18:00:00	SPY	ETF	209.91	209.92	209.83	209.86	234697.0
2015-07-13 19:00:00	SPY	ETF	209.84	209.91	209.8	209.91	74480.0
2015-07-13 04:00:00	QQQ	ETF	108.1	108.28	108.1	108.24	7100.0
2015-07-13 05:00:00	QQQ	ETF	108.5	108.75	108.37	108.74	14700.0
2015-07-13 06:00:00	QQQ	ETF	108.54	108.55	108.5	108.51	57010.0
2015-07-13 07:00:00	QQQ	ETF	108.48	108.55	108.43	108.51	171416.0
2015-07-13 08:00:00	QQQ	ETF	108.48	108.54	108.37	108.5	136434.0
2015-07-13 09:00:00	QQQ	ETF	108.48	109.19	108.48	109.05	4445544.0
2015-07-13 10:00:00	QQQ	ETF	109.05	109.29	109.04	109.17	3621836.0
2015-07-13 11:00:00	QQQ	ETF	109.18	109.34	109.05	109.3168	3102740.0
2015-07-13 12:00:00	QQQ	ETF	109.32	109.36	109.17	109.23	1811538.0
2015-07-13 13:00:00	QQQ	ETF	109.235	109.36	109.18	109.2516	1406431.0
2015-07-13 14:00:00	QQQ	ETF	109.26	109.53	109.26	109.48	2071827.0
2015-07-13 15:00:00	QQQ	ETF	109.48	109.63	109.44	109.51	4759674.0
2015-07-13 16:00:00	QQQ	ETF	109.51	109.57	109.5	109.53	518505.0
2015-07-13 17:00:00	QQQ	ETF	109.51	109.55	109.5	109.51	23003.0
2015-07-13 18:00:00	QQQ	ETF	109.51	109.51	109.48	109.51	13943.0
2015-07-13 19:00:00	QQQ	ETF	109.5	109.54	109.49	109.54	8560.0
2015-07-13 04:00:00	IWM	ETF	124.17	124.47	124.17	124.47	1200.0
2015-07-13 05:00:00	IWM	ETF	124.84	124.9	124.84	124.9	200.0
2015-07-13 06:00:00	IWM	ETF	124.98	124.98	124.98	124.98	400.0
2015-07-13 07:00:00	IWM	ETF	124.89	124.9	124.7	124.78	79772.0
2015-07-13 08:00:00	IWM	ETF	124.79	124.8	124.63	124.73	97667.0
2015-07-13 09:00:00	IWM	ETF	124.66	125.51	124.66	125.32	4003780.0
2015-07-13 10:00:00	IWM	ETF	125.33	125.64	125.22	125.44	3661678.0
2015-07-13 11:00:00	IWM	ETF	125.45	125.625	125.21	125.465	2009477.0
2015-07-13 12:00:00	IWM	ETF	125.47	125.515	125.2264	125.29	1416043.0
2015-07-13 13:00:00	IWM	ETF	125.28	125.49	125.25	125.265	1006094.0
2015-07-13 14:00:00	IWM	ETF	125.28	125.52	125.28	125.47	1091865.0
2015-07-13 15:00:00	IWM	ETF	125.47	125.64	125.395	125.5	3853020.0
2015-07-13 16:00:00	IWM	ETF	125.495	125.65	125.48	125.58	1133034.0
2015-07-13 17:00:00	IWM	ETF	125.58	125.6	125.56	125.6	33100.0
2015-07-13 18:00:00	IWM	ETF	125.5	125.51	125.5	125.5	1100.0
2015-07-13 19:00:00	IWM	ETF	125.47	125.47	125.46	125.46	1500.0
2015-07-13 04:00:00	DIA	ETF	178.0	178.0	178.0	178.0	1000.0
2015-07-13 07:00:00	DIA	ETF	178.6	178.65	178.6	178.65	14689.0

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

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