PREVIEW / etf_1hour / 2011-01-07

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-01-07.parquet
  size:    176 KB
  rows:    5,306

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-01-07 04:00:00	SPY	ETF	127.15	127.22	127.11	127.2	800.0
2011-01-07 05:00:00	SPY	ETF	127.18	127.2	127.01	127.2	2660.0
2011-01-07 06:00:00	SPY	ETF	127.19	127.44	127.15	127.44	12050.0
2011-01-07 07:00:00	SPY	ETF	127.45	127.45	127.3	127.35	218642.0
2011-01-07 08:00:00	SPY	ETF	127.38	127.9	126.67	127.4	11636429.0
2011-01-07 09:00:00	SPY	ETF	127.4	127.77	127.16	127.25	17544295.0
2011-01-07 10:00:00	SPY	ETF	127.255	127.65	127.06	127.19	24676021.0
2011-01-07 11:00:00	SPY	ETF	127.18	127.19	126.57	126.87	23555433.0
2011-01-07 12:00:00	SPY	ETF	126.86	126.88	126.15	126.5	17478832.0
2011-01-07 13:00:00	SPY	ETF	126.4962	126.8	126.43	126.615	14604414.0
2011-01-07 14:00:00	SPY	ETF	126.62	127.01	126.58	126.88	11814202.0
2011-01-07 15:00:00	SPY	ETF	126.88	127.23	126.8175	127.12	25787308.0
2011-01-07 16:00:00	SPY	ETF	127.13	127.605	126.515	127.17	7321973.0
2011-01-07 17:00:00	SPY	ETF	127.17	127.25	127.15	127.2	44320.0
2011-01-07 18:00:00	SPY	ETF	127.21	127.25	127.13	127.22	50209.0
2011-01-07 19:00:00	SPY	ETF	127.22	127.26	127.21	127.24	23900.0
2011-01-07 04:00:00	QQQ	ETF	55.85	55.86	55.85	55.86	2600.0
2011-01-07 06:00:00	QQQ	ETF	55.85	55.91	55.85	55.91	270.0
2011-01-07 07:00:00	QQQ	ETF	55.92	55.96	55.92	55.95	87894.0
2011-01-07 08:00:00	QQQ	ETF	55.94	56.05	55.69	55.94	1998272.0
2011-01-07 09:00:00	QQQ	ETF	55.95	56.05	55.73	55.83	13597059.0
2011-01-07 10:00:00	QQQ	ETF	55.825	56.02	55.8	55.85	12969244.0
2011-01-07 11:00:00	QQQ	ETF	55.845	55.87	55.66	55.8	8197762.0
2011-01-07 12:00:00	QQQ	ETF	55.805	55.805	55.32	55.55	13221071.0
2011-01-07 13:00:00	QQQ	ETF	55.55	55.74	55.5	55.64	6201307.0
2011-01-07 14:00:00	QQQ	ETF	55.64	55.81	55.625	55.74	2959507.0
2011-01-07 15:00:00	QQQ	ETF	55.74	55.92	55.74	55.87	8059725.0
2011-01-07 16:00:00	QQQ	ETF	55.87	55.92	55.83	55.91	1722247.0
2011-01-07 17:00:00	QQQ	ETF	55.88	55.93	55.86	55.9	30100.0
2011-01-07 18:00:00	QQQ	ETF	55.92	55.95	55.91	55.91	15300.0
2011-01-07 19:00:00	QQQ	ETF	55.92	55.95	55.9	55.9	38450.0
2011-01-07 04:00:00	IWM	ETF	78.9	78.9	78.9	78.9	150.0
2011-01-07 06:00:00	IWM	ETF	79.2	79.2	79.2	79.2	100.0
2011-01-07 07:00:00	IWM	ETF	79.2	79.2	79.13	79.17	10300.0
2011-01-07 08:00:00	IWM	ETF	79.17	79.48	78.74	79.1	1418867.0
2011-01-07 09:00:00	IWM	ETF	79.1	79.44	78.79	78.92	6096242.0
2011-01-07 10:00:00	IWM	ETF	78.91	79.32	78.84	79.03	6091809.0
2011-01-07 11:00:00	IWM	ETF	79.03	79.04	78.28	78.41	6881446.0
2011-01-07 12:00:00	IWM	ETF	78.41	78.445	77.44	77.84	8455781.0
2011-01-07 13:00:00	IWM	ETF	77.85	78.15	77.67	77.93	6109427.0
2011-01-07 14:00:00	IWM	ETF	77.93	78.32	77.908	78.17	3432988.0
2011-01-07 15:00:00	IWM	ETF	78.17	78.65	78.17	78.51	9081467.0
2011-01-07 16:00:00	IWM	ETF	78.51	78.9922	77.9	78.52	4060117.0
2011-01-07 17:00:00	IWM	ETF	78.52	78.52	78.48	78.51	1000.0
2011-01-07 18:00:00	IWM	ETF	78.55	78.55	78.52	78.55	9400.0
2011-01-07 19:00:00	IWM	ETF	78.56	78.56	78.56	78.56	600.0
2011-01-07 06:00:00	DIA	ETF	116.88	116.88	116.88	116.88	100.0
2011-01-07 07:00:00	DIA	ETF	116.84	116.84	116.84	116.84	300.0
2011-01-07 08:00:00	DIA	ETF	116.92	117.07	116.5	116.74	19200.0
2011-01-07 09:00:00	DIA	ETF	116.85	117.1	116.66	116.73	742698.0

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

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