PREVIEW / etf_1hour / 2011-02-03

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-02-03.parquet
  size:    175 KB
  rows:    5,341

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-02-03 04:00:00	SPY	ETF	130.37	130.44	130.28	130.44	1300.0
2011-02-03 05:00:00	SPY	ETF	130.51	130.51	130.45	130.45	15200.0
2011-02-03 06:00:00	SPY	ETF	130.36	130.36	130.2	130.24	9500.0
2011-02-03 07:00:00	SPY	ETF	130.24	130.32	130.18	130.21	520474.0
2011-02-03 08:00:00	SPY	ETF	130.21	130.21	130.0	130.08	2632497.0
2011-02-03 09:00:00	SPY	ETF	130.07	130.53	130.07	130.4	16551535.0
2011-02-03 10:00:00	SPY	ETF	130.39	130.51	129.57	130.05	28194808.0
2011-02-03 11:00:00	SPY	ETF	130.05	130.44	129.8	130.38	15040546.0
2011-02-03 12:00:00	SPY	ETF	130.38	130.47	130.21	130.4	10777901.0
2011-02-03 13:00:00	SPY	ETF	130.4	130.44	130.22	130.36	11430660.0
2011-02-03 14:00:00	SPY	ETF	130.3582	130.73	130.28	130.66	15414602.0
2011-02-03 15:00:00	SPY	ETF	130.65	130.98	130.65	130.78	31411865.0
2011-02-03 16:00:00	SPY	ETF	130.78	130.945	129.665	130.76	13173434.0
2011-02-03 17:00:00	SPY	ETF	130.75	130.78	130.63	130.69	373672.0
2011-02-03 18:00:00	SPY	ETF	130.71	130.77	130.67	130.77	103771.0
2011-02-03 19:00:00	SPY	ETF	130.76	130.8	130.63	130.76	91358.0
2011-02-03 05:00:00	QQQ	ETF	56.98	56.98	56.98	56.98	13000.0
2011-02-03 06:00:00	QQQ	ETF	56.85	56.85	56.85	56.85	100.0
2011-02-03 07:00:00	QQQ	ETF	56.89	56.9	56.84	56.84	45976.0
2011-02-03 08:00:00	QQQ	ETF	56.84	56.86	56.73	56.81	451838.0
2011-02-03 09:00:00	QQQ	ETF	56.82	56.98	56.82	56.93	4372306.0
2011-02-03 10:00:00	QQQ	ETF	56.93	56.98	56.4	56.71	11311903.0
2011-02-03 11:00:00	QQQ	ETF	56.7	56.99	56.58	56.9675	4635718.0
2011-02-03 12:00:00	QQQ	ETF	56.96	57.03	56.84	56.95	3519881.0
2011-02-03 13:00:00	QQQ	ETF	56.9401	56.97	56.84	56.915	2595366.0
2011-02-03 14:00:00	QQQ	ETF	56.91	57.05	56.875	56.9962	3528173.0
2011-02-03 15:00:00	QQQ	ETF	57.0	57.14	56.995	57.03	6536265.0
2011-02-03 16:00:00	QQQ	ETF	57.03	57.1255	56.93	57.07	2402819.0
2011-02-03 17:00:00	QQQ	ETF	57.07	57.08	57.03	57.04	25746.0
2011-02-03 18:00:00	QQQ	ETF	57.04	57.05	57.02	57.05	13700.0
2011-02-03 19:00:00	QQQ	ETF	57.05	57.06	57.01	57.01	18808.0
2011-02-03 06:00:00	IWM	ETF	79.37	79.39	79.34	79.34	5400.0
2011-02-03 07:00:00	IWM	ETF	79.38	79.43	79.36	79.36	18640.0
2011-02-03 08:00:00	IWM	ETF	79.28	79.38	79.19	79.29	160282.0
2011-02-03 09:00:00	IWM	ETF	79.26	79.6	79.2499	79.44	3973945.0
2011-02-03 10:00:00	IWM	ETF	79.47	79.57	78.5	79.33	11689420.0
2011-02-03 11:00:00	IWM	ETF	79.33	79.82	79.06	79.75	5104005.0
2011-02-03 12:00:00	IWM	ETF	79.75	79.85	79.42	79.58	4222866.0
2011-02-03 13:00:00	IWM	ETF	79.58	79.64	79.34	79.5299	2153714.0
2011-02-03 14:00:00	IWM	ETF	79.52	79.7001	79.35	79.61	2467546.0
2011-02-03 15:00:00	IWM	ETF	79.61	79.84	79.61	79.74	6770820.0
2011-02-03 16:00:00	IWM	ETF	79.74	79.761	79.5628	79.65	2534191.0
2011-02-03 17:00:00	IWM	ETF	79.64	79.69	79.63	79.63	22550.0
2011-02-03 18:00:00	IWM	ETF	79.66	79.66	79.65	79.65	1821.0
2011-02-03 19:00:00	IWM	ETF	79.66	79.68	79.65	79.66	4100.0
2011-02-03 08:00:00	DIA	ETF	119.96	119.96	119.82	119.93	11900.0
2011-02-03 09:00:00	DIA	ETF	119.96	120.16	119.93	120.07	648242.0
2011-02-03 10:00:00	DIA	ETF	120.08	120.14	119.56	120.01	1513909.0
2011-02-03 11:00:00	DIA	ETF	120.02	120.22	119.81	120.16	674191.0
2011-02-03 12:00:00	DIA	ETF	120.16	120.21	119.99	120.14	552777.0

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

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