PREVIEW / etf_1hour / 2011-06-09

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-06-09.parquet
  size:    177 KB
  rows:    5,422

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-06-09 04:00:00	SPY	ETF	128.87	128.89	128.74	128.89	7938.0
2011-06-09 05:00:00	SPY	ETF	128.6	128.66	128.4	128.66	2100.0
2011-06-09 06:00:00	SPY	ETF	128.6	128.73	128.6	128.73	5950.0
2011-06-09 07:00:00	SPY	ETF	128.67	128.81	128.59	128.77	417400.0
2011-06-09 08:00:00	SPY	ETF	128.77	128.95	128.46	128.67	5109686.0
2011-06-09 09:00:00	SPY	ETF	128.68	129.06	128.46	129.035	22852352.0
2011-06-09 10:00:00	SPY	ETF	129.04	129.54	129.03	129.41	25049258.0
2011-06-09 11:00:00	SPY	ETF	129.39	129.72	129.2	129.6167	15682797.0
2011-06-09 12:00:00	SPY	ETF	129.61	129.81	129.51	129.62	12793449.0
2011-06-09 13:00:00	SPY	ETF	129.61	129.79	129.57	129.7	9686584.0
2011-06-09 14:00:00	SPY	ETF	129.695	129.93	129.63	129.91	9591465.0
2011-06-09 15:00:00	SPY	ETF	129.92	129.93	129.34	129.37	33680696.0
2011-06-09 16:00:00	SPY	ETF	129.37	129.5286	129.22	129.27	19283244.0
2011-06-09 17:00:00	SPY	ETF	129.28	129.35	129.25	129.32	71604.0
2011-06-09 18:00:00	SPY	ETF	129.3	129.41	129.26	129.36	217329.0
2011-06-09 19:00:00	SPY	ETF	129.36	129.37	129.25	129.29	72621.0
2011-06-09 04:00:00	QQQ	ETF	55.35	55.46	55.35	55.46	900.0
2011-06-09 05:00:00	QQQ	ETF	55.37	55.37	55.37	55.37	800.0
2011-06-09 06:00:00	QQQ	ETF	55.35	55.46	55.3	55.44	9440.0
2011-06-09 07:00:00	QQQ	ETF	55.38	55.46	55.38	55.45	12430.0
2011-06-09 08:00:00	QQQ	ETF	55.45	55.5	55.32	55.4	594194.0
2011-06-09 09:00:00	QQQ	ETF	55.41	55.46	55.23	55.42	5516635.0
2011-06-09 10:00:00	QQQ	ETF	55.41	55.57	55.38	55.52	9015433.0
2011-06-09 11:00:00	QQQ	ETF	55.52	55.575	55.41	55.53	4262176.0
2011-06-09 12:00:00	QQQ	ETF	55.53	55.66	55.51	55.61	2692938.0
2011-06-09 13:00:00	QQQ	ETF	55.605	55.66	55.57	55.6105	2299651.0
2011-06-09 14:00:00	QQQ	ETF	55.61	55.72	55.59	55.72	2384173.0
2011-06-09 15:00:00	QQQ	ETF	55.71	55.76	55.47	55.485	7688296.0
2011-06-09 16:00:00	QQQ	ETF	55.48	55.5765	55.38	55.39	4619415.0
2011-06-09 17:00:00	QQQ	ETF	55.39	55.45	55.39	55.43	33210.0
2011-06-09 18:00:00	QQQ	ETF	55.42	55.48	55.39	55.44	60892.0
2011-06-09 19:00:00	QQQ	ETF	55.43	55.43	55.4	55.41	48175.0
2011-06-09 06:00:00	IWM	ETF	78.99	78.99	78.99	78.99	200.0
2011-06-09 07:00:00	IWM	ETF	79.0	79.13	78.99	79.02	138485.0
2011-06-09 08:00:00	IWM	ETF	79.04	79.32	78.86	79.15	1829200.0
2011-06-09 09:00:00	IWM	ETF	79.16	79.27	78.73	79.14	8960040.0
2011-06-09 10:00:00	IWM	ETF	79.14	79.59	79.13	79.45	13654625.0
2011-06-09 11:00:00	IWM	ETF	79.45	79.54	79.13	79.41	5943061.0
2011-06-09 12:00:00	IWM	ETF	79.41	79.62	79.36	79.43	4983089.0
2011-06-09 13:00:00	IWM	ETF	79.42	79.69	79.39	79.59	2884745.0
2011-06-09 14:00:00	IWM	ETF	79.58	79.68	79.51	79.65	2524486.0
2011-06-09 15:00:00	IWM	ETF	79.65	79.71	79.22	79.26	10230663.0
2011-06-09 16:00:00	IWM	ETF	79.26	79.3571	78.8118	79.11	1840622.0
2011-06-09 17:00:00	IWM	ETF	79.1	79.19	79.1	79.16	19073.0
2011-06-09 18:00:00	IWM	ETF	79.27	79.27	79.22	79.24	34277.0
2011-06-09 19:00:00	IWM	ETF	79.15	79.19	79.15	79.18	2100.0
2011-06-09 07:00:00	DIA	ETF	120.48	120.65	120.48	120.65	2060.0
2011-06-09 08:00:00	DIA	ETF	120.61	120.74	120.38	120.56	23268.0
2011-06-09 09:00:00	DIA	ETF	120.7	120.84	120.425	120.83	586686.0
2011-06-09 10:00:00	DIA	ETF	120.829	121.38	120.8215	121.25	945452.0

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

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