PREVIEW / etf_1hour / 2012-01-12

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-01-12.parquet
  size:    185 KB
  rows:    5,695

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
2012-01-12 04:00:00	SPY	ETF	129.06	129.3	129.01	129.3	10805.0
2012-01-12 05:00:00	SPY	ETF	129.54	129.87	129.54	129.87	50225.0
2012-01-12 06:00:00	SPY	ETF	129.85	129.95	129.7	129.9	155547.0
2012-01-12 07:00:00	SPY	ETF	129.9	130.18	129.82	130.0	429261.0
2012-01-12 08:00:00	SPY	ETF	129.96	129.99	129.34	129.47	4096855.0
2012-01-12 09:00:00	SPY	ETF	129.48	129.7	129.1	129.31	20194238.0
2012-01-12 10:00:00	SPY	ETF	129.31	129.4	128.54	128.74	24734598.0
2012-01-12 11:00:00	SPY	ETF	128.741	129.08	128.72	129.025	11978008.0
2012-01-12 12:00:00	SPY	ETF	129.025	129.31	128.97	129.26	8707424.0
2012-01-12 13:00:00	SPY	ETF	129.26	129.43	129.11	129.28	10105112.0
2012-01-12 14:00:00	SPY	ETF	129.29	129.52	129.12	129.49	11864520.0
2012-01-12 15:00:00	SPY	ETF	129.49	129.67	129.36	129.53	19052445.0
2012-01-12 16:00:00	SPY	ETF	129.53	129.66	129.02	129.59	5389791.0
2012-01-12 17:00:00	SPY	ETF	129.6	129.63	129.538	129.59	1782884.0
2012-01-12 18:00:00	SPY	ETF	129.59	129.65	129.51	129.65	130369.0
2012-01-12 19:00:00	SPY	ETF	129.65	129.85	129.64	129.76	235120.0
2012-01-12 05:00:00	QQQ	ETF	58.34	58.39	58.34	58.39	2600.0
2012-01-12 06:00:00	QQQ	ETF	58.44	58.48	58.39	58.41	103682.0
2012-01-12 07:00:00	QQQ	ETF	58.4	58.52	58.4	58.42	92085.0
2012-01-12 08:00:00	QQQ	ETF	58.41	58.42	58.22	58.26	487997.0
2012-01-12 09:00:00	QQQ	ETF	58.26	58.36	58.06	58.18	4240275.0
2012-01-12 10:00:00	QQQ	ETF	58.17	58.22	57.86	57.99	6050741.0
2012-01-12 11:00:00	QQQ	ETF	57.99	58.25	57.98	58.2199	3306373.0
2012-01-12 12:00:00	QQQ	ETF	58.215	58.29	58.18	58.26	2050553.0
2012-01-12 13:00:00	QQQ	ETF	58.27	58.335	58.2	58.3	1770620.0
2012-01-12 14:00:00	QQQ	ETF	58.3	58.41	58.24	58.402	2205087.0
2012-01-12 15:00:00	QQQ	ETF	58.41	58.47	58.34	58.4	4153823.0
2012-01-12 16:00:00	QQQ	ETF	58.41	58.44	58.38	58.44	419543.0
2012-01-12 17:00:00	QQQ	ETF	58.44	58.5	58.42	58.48	92200.0
2012-01-12 18:00:00	QQQ	ETF	58.46	58.48	58.45	58.46	50491.0
2012-01-12 19:00:00	QQQ	ETF	58.47	58.54	58.47	58.53	17795.0
2012-01-12 06:00:00	IWM	ETF	77.0	77.0	77.0	77.0	52668.0
2012-01-12 07:00:00	IWM	ETF	77.0	77.18	77.0	77.06	90351.0
2012-01-12 08:00:00	IWM	ETF	77.05	77.19	76.69	76.72	558474.0
2012-01-12 09:00:00	IWM	ETF	76.73	76.89	76.28	76.5	4878174.0
2012-01-12 10:00:00	IWM	ETF	76.5	76.5693	75.94	76.15	6278549.0
2012-01-12 11:00:00	IWM	ETF	76.15	76.64	76.15	76.63	5106613.0
2012-01-12 12:00:00	IWM	ETF	76.63	76.77	76.55	76.72	2403824.0
2012-01-12 13:00:00	IWM	ETF	76.72	76.81	76.59	76.74	2277417.0
2012-01-12 14:00:00	IWM	ETF	76.735	76.83	76.6	76.81	3082436.0
2012-01-12 15:00:00	IWM	ETF	76.81	76.92	76.7	76.82	6033679.0
2012-01-12 16:00:00	IWM	ETF	76.83	76.9	76.8	76.86	1209530.0
2012-01-12 17:00:00	IWM	ETF	76.86	76.87	76.82	76.82	55700.0
2012-01-12 18:00:00	IWM	ETF	76.85	76.87	76.85	76.85	1800.0
2012-01-12 19:00:00	IWM	ETF	76.9	76.9	76.9	76.9	100.0
2012-01-12 05:00:00	DIA	ETF	124.8	124.8	124.8	124.8	200.0
2012-01-12 07:00:00	DIA	ETF	124.9	125.0	124.9	125.0	2600.0
2012-01-12 08:00:00	DIA	ETF	124.83	125.0	123.25	124.41	43805.0
2012-01-12 09:00:00	DIA	ETF	124.41	124.55	124.02	124.24	812306.0
2012-01-12 10:00:00	DIA	ETF	124.23	124.32	123.66	123.85	1441403.0

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

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