PREVIEW / etf_1hour / 2011-03-30

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-03-30.parquet
  size:    178 KB
  rows:    5,459

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-03-30 04:00:00	SPY	ETF	132.45	132.61	132.39	132.48	7344.0
2011-03-30 05:00:00	SPY	ETF	132.59	132.6	132.45	132.45	17700.0
2011-03-30 06:00:00	SPY	ETF	132.51	132.85	132.51	132.67	77064.0
2011-03-30 07:00:00	SPY	ETF	132.69	132.83	132.66	132.75	415518.0
2011-03-30 08:00:00	SPY	ETF	132.75	132.81	131.86	132.62	1601255.0
2011-03-30 09:00:00	SPY	ETF	132.62	132.74	132.46	132.7	18365950.0
2011-03-30 10:00:00	SPY	ETF	132.7	132.74	132.36	132.73	20079354.0
2011-03-30 11:00:00	SPY	ETF	132.72	132.8	132.57	132.72	12659683.0
2011-03-30 12:00:00	SPY	ETF	132.72	133.06	132.7081	132.98	16270121.0
2011-03-30 13:00:00	SPY	ETF	132.98	133.16	132.9	132.96	12281449.0
2011-03-30 14:00:00	SPY	ETF	132.965	133.08	132.89	132.93	10824043.0
2011-03-30 15:00:00	SPY	ETF	132.93	133.01	132.69	132.76	24046297.0
2011-03-30 16:00:00	SPY	ETF	132.75	133.0	132.55	132.79	15741172.0
2011-03-30 17:00:00	SPY	ETF	132.81	132.83	132.78	132.8	182370.0
2011-03-30 18:00:00	SPY	ETF	132.79	132.82	132.7	132.75	148876.0
2011-03-30 19:00:00	SPY	ETF	132.74	132.8	132.7	132.74	97738.0
2011-03-30 04:00:00	QQQ	ETF	57.23	57.4	57.23	57.4	4420.0
2011-03-30 05:00:00	QQQ	ETF	57.38	57.38	57.31	57.33	20400.0
2011-03-30 06:00:00	QQQ	ETF	57.39	57.4	57.39	57.4	4165.0
2011-03-30 07:00:00	QQQ	ETF	57.39	57.54	57.39	57.49	60132.0
2011-03-30 08:00:00	QQQ	ETF	57.47	57.5	57.4	57.4	347899.0
2011-03-30 09:00:00	QQQ	ETF	57.4	57.42	57.16	57.3	6215200.0
2011-03-30 10:00:00	QQQ	ETF	57.3	57.31	57.08	57.2806	7343734.0
2011-03-30 11:00:00	QQQ	ETF	57.2825	57.285	57.19	57.2338	5198837.0
2011-03-30 12:00:00	QQQ	ETF	57.24	57.41	57.23	57.365	4874293.0
2011-03-30 13:00:00	QQQ	ETF	57.368	57.43	57.32	57.34	3432250.0
2011-03-30 14:00:00	QQQ	ETF	57.34	57.41	57.33	57.355	2382740.0
2011-03-30 15:00:00	QQQ	ETF	57.35	57.43	57.26	57.34	9093893.0
2011-03-30 16:00:00	QQQ	ETF	57.35	57.39	57.31	57.34	1289847.0
2011-03-30 17:00:00	QQQ	ETF	57.34	57.38	57.34	57.37	19450.0
2011-03-30 18:00:00	QQQ	ETF	57.36	57.36	57.25	57.29	102647.0
2011-03-30 19:00:00	QQQ	ETF	57.27	57.31	57.25	57.26	20674.0
2011-03-30 04:00:00	IWM	ETF	83.21	83.21	83.21	83.21	376.0
2011-03-30 05:00:00	IWM	ETF	83.19	83.19	83.13	83.13	400.0
2011-03-30 06:00:00	IWM	ETF	83.23	83.35	83.23	83.31	10400.0
2011-03-30 07:00:00	IWM	ETF	83.31	83.34	83.28	83.29	108527.0
2011-03-30 08:00:00	IWM	ETF	83.28	83.31	83.18	83.19	299684.0
2011-03-30 09:00:00	IWM	ETF	83.18	83.4	82.81	83.37	4196988.0
2011-03-30 10:00:00	IWM	ETF	83.38	83.51	83.08	83.45	5848107.0
2011-03-30 11:00:00	IWM	ETF	83.45	83.68	83.34	83.6201	4353651.0
2011-03-30 12:00:00	IWM	ETF	83.63	83.78	83.62	83.69	3175397.0
2011-03-30 13:00:00	IWM	ETF	83.691	83.78	83.65	83.7	2260141.0
2011-03-30 14:00:00	IWM	ETF	83.71	83.879	83.7	83.74	2323684.0
2011-03-30 15:00:00	IWM	ETF	83.74	83.99	83.72	83.88	10938879.0
2011-03-30 16:00:00	IWM	ETF	83.88	83.98	83.71	83.92	2532172.0
2011-03-30 17:00:00	IWM	ETF	83.94	83.99	83.9	83.91	24837.0
2011-03-30 18:00:00	IWM	ETF	83.91	83.94	83.91	83.94	300.0
2011-03-30 19:00:00	IWM	ETF	83.98	83.98	83.85	83.95	9300.0
2011-03-30 05:00:00	DIA	ETF	122.95	122.95	122.95	122.95	100.0
2011-03-30 06:00:00	DIA	ETF	123.15	123.2	123.15	123.2	5000.0

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

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