PREVIEW / etf_1hour / 2011-12-16

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-12-16.parquet
  size:    179 KB
  rows:    5,605

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
2011-12-16 04:00:00	SPY	ETF	122.76	122.76	122.26	122.26	73197.0
2011-12-16 05:00:00	SPY	ETF	122.27	122.64	122.18	122.41	123522.0
2011-12-16 06:00:00	SPY	ETF	122.42	122.43	122.2	122.39	79450.0
2011-12-16 07:00:00	SPY	ETF	122.38	122.65	122.22	122.51	526790.0
2011-12-16 08:00:00	SPY	ETF	122.54	122.68	122.35	122.47	5565102.0
2011-12-16 09:00:00	SPY	ETF	122.49	122.58	122.07	122.41	32838114.0
2011-12-16 10:00:00	SPY	ETF	122.42	122.95	122.31	122.68	27483880.0
2011-12-16 11:00:00	SPY	ETF	122.69	122.77	121.89	121.91	21082973.0
2011-12-16 12:00:00	SPY	ETF	121.91	121.97	121.3	121.61	30815492.0
2011-12-16 13:00:00	SPY	ETF	121.61	121.9	121.51	121.59	22561091.0
2011-12-16 14:00:00	SPY	ETF	121.591	121.83	121.4	121.67	14593825.0
2011-12-16 15:00:00	SPY	ETF	121.675	121.88	121.52	121.67	38648596.0
2011-12-16 16:00:00	SPY	ETF	121.66	122.75	121.31	121.4	19714509.0
2011-12-16 17:00:00	SPY	ETF	121.4	121.62	121.35	121.5	348599.0
2011-12-16 18:00:00	SPY	ETF	121.5	121.57	121.45	121.53	847375.0
2011-12-16 19:00:00	SPY	ETF	121.51	121.58	121.49	121.58	41241.0
2011-12-16 04:00:00	QQQ	ETF	54.85	54.92	54.85	54.87	23654.0
2011-12-16 05:00:00	QQQ	ETF	54.83	55.01	54.83	54.92	56900.0
2011-12-16 06:00:00	QQQ	ETF	54.92	54.93	54.85	54.93	55400.0
2011-12-16 07:00:00	QQQ	ETF	54.92	55.03	54.89	55.02	106184.0
2011-12-16 08:00:00	QQQ	ETF	54.97	55.13	54.97	55.06	2926372.0
2011-12-16 09:00:00	QQQ	ETF	55.06	55.29	54.85	55.27	10735117.0
2011-12-16 10:00:00	QQQ	ETF	55.27	55.61	55.205	55.52	9258410.0
2011-12-16 11:00:00	QQQ	ETF	55.52	55.55	55.03	55.04	6237775.0
2011-12-16 12:00:00	QQQ	ETF	55.035	55.06	54.77	54.906	7066761.0
2011-12-16 13:00:00	QQQ	ETF	54.9	55.05	54.88	54.905	5264663.0
2011-12-16 14:00:00	QQQ	ETF	54.91	55.01	54.83	54.91	2726801.0
2011-12-16 15:00:00	QQQ	ETF	54.91	54.99	54.8	54.86	9540553.0
2011-12-16 16:00:00	QQQ	ETF	54.86	55.03	54.81	54.81	2009807.0
2011-12-16 17:00:00	QQQ	ETF	54.86	54.97	54.86	54.94	106606.0
2011-12-16 18:00:00	QQQ	ETF	54.93	55.12	54.89	54.93	17163.0
2011-12-16 19:00:00	QQQ	ETF	54.96	54.97	54.91	54.97	21407.0
2011-12-16 05:00:00	IWM	ETF	72.39	72.39	72.39	72.39	200.0
2011-12-16 06:00:00	IWM	ETF	72.13	72.15	72.1	72.15	4000.0
2011-12-16 07:00:00	IWM	ETF	72.29	72.53	72.2	72.49	30430.0
2011-12-16 08:00:00	IWM	ETF	72.41	72.61	72.4	72.43	462422.0
2011-12-16 09:00:00	IWM	ETF	72.45	72.9	72.18	72.74	11657846.0
2011-12-16 10:00:00	IWM	ETF	72.75	73.28	72.68	72.96	12147183.0
2011-12-16 11:00:00	IWM	ETF	72.97	73.1	72.29	72.3	4538573.0
2011-12-16 12:00:00	IWM	ETF	72.3	72.42	71.73	72.08	7499831.0
2011-12-16 13:00:00	IWM	ETF	72.09	72.34	71.98	72.13	4681618.0
2011-12-16 14:00:00	IWM	ETF	72.13	72.2001	71.83	72.05	4133706.0
2011-12-16 15:00:00	IWM	ETF	72.065	72.34	72.01	72.28	12274813.0
2011-12-16 16:00:00	IWM	ETF	72.28	72.57	72.11	72.26	2782795.0
2011-12-16 17:00:00	IWM	ETF	72.23	72.34	72.22	72.34	2150.0
2011-12-16 18:00:00	IWM	ETF	72.22	72.22	72.22	72.22	1500.0
2011-12-16 19:00:00	IWM	ETF	72.23	72.4	72.23	72.4	4100.0
2011-12-16 08:00:00	DIA	ETF	119.26	119.61	118.98	119.31	35750.0
2011-12-16 09:00:00	DIA	ETF	119.32	119.369	118.85	119.02	1260174.0
2011-12-16 10:00:00	DIA	ETF	119.04	119.4	118.93	119.2487	1726099.0

> showing 50 of 5,605 rows — these rows as CSV

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