PREVIEW / etf_1hour / 2011-01-03

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-01-03.parquet
  size:    179 KB
  rows:    5,556

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-03 04:00:00	SPY	ETF	126.35	126.45	126.3	126.4	3397.0
2011-01-03 05:00:00	SPY	ETF	126.44	126.5	126.44	126.48	3600.0
2011-01-03 06:00:00	SPY	ETF	126.49	126.51	126.44	126.45	7075.0
2011-01-03 07:00:00	SPY	ETF	126.45	126.81	126.35	126.73	576572.0
2011-01-03 08:00:00	SPY	ETF	126.71	126.78	125.05	126.66	1241688.0
2011-01-03 09:00:00	SPY	ETF	126.66	127.15	125.75	127.13	19649149.0
2011-01-03 10:00:00	SPY	ETF	127.14	127.43	126.97	127.4	19128421.0
2011-01-03 11:00:00	SPY	ETF	127.4	127.6	127.32	127.475	13900914.0
2011-01-03 12:00:00	SPY	ETF	127.47	127.55	127.35	127.42	10034218.0
2011-01-03 13:00:00	SPY	ETF	127.42	127.46	127.35	127.447	8085674.0
2011-01-03 14:00:00	SPY	ETF	127.45	127.48	127.2	127.29	13342509.0
2011-01-03 15:00:00	SPY	ETF	127.29	127.3	127.02	127.05	34442061.0
2011-01-03 16:00:00	SPY	ETF	127.04	127.525	125.6986	126.92	12277737.0
2011-01-03 17:00:00	SPY	ETF	126.91	126.94	126.89	126.91	53570.0
2011-01-03 18:00:00	SPY	ETF	126.91	127.01	126.88	126.95	113750.0
2011-01-03 19:00:00	SPY	ETF	126.94	126.94	126.87	126.9	117628.0
2011-01-03 04:00:00	QQQ	ETF	54.76	54.78	54.75	54.78	700.0
2011-01-03 05:00:00	QQQ	ETF	54.8	54.84	54.8	54.84	400.0
2011-01-03 06:00:00	QQQ	ETF	54.85	54.86	54.85	54.85	3700.0
2011-01-03 07:00:00	QQQ	ETF	54.85	55.03	54.81	54.99	113452.0
2011-01-03 08:00:00	QQQ	ETF	54.98	55.02	54.94	54.96	964677.0
2011-01-03 09:00:00	QQQ	ETF	54.96	55.37	54.95	55.34	14043938.0
2011-01-03 10:00:00	QQQ	ETF	55.33	55.64	55.29	55.6101	17028204.0
2011-01-03 11:00:00	QQQ	ETF	55.61	55.69	55.53	55.579	6420203.0
2011-01-03 12:00:00	QQQ	ETF	55.58	55.61	55.425	55.4498	7406789.0
2011-01-03 13:00:00	QQQ	ETF	55.45	55.47	55.39	55.4495	3815589.0
2011-01-03 14:00:00	QQQ	ETF	55.44	55.49	55.3	55.347	5939631.0
2011-01-03 15:00:00	QQQ	ETF	55.35	55.38	55.24	55.3055	11080269.0
2011-01-03 16:00:00	QQQ	ETF	55.31	55.375	55.21	55.28	1414301.0
2011-01-03 17:00:00	QQQ	ETF	55.27	55.29	55.27	55.29	8027.0
2011-01-03 18:00:00	QQQ	ETF	55.29	55.3	55.29	55.29	9440.0
2011-01-03 19:00:00	QQQ	ETF	55.29	55.29	55.25	55.28	11868.0
2011-01-03 04:00:00	IWM	ETF	78.77	78.77	78.77	78.77	219.0
2011-01-03 05:00:00	IWM	ETF	78.9	78.92	78.87	78.92	2300.0
2011-01-03 06:00:00	IWM	ETF	78.91	78.91	78.83	78.83	1300.0
2011-01-03 07:00:00	IWM	ETF	78.85	79.1	78.8	79.07	196500.0
2011-01-03 08:00:00	IWM	ETF	79.02	79.07	78.24	78.95	470802.0
2011-01-03 09:00:00	IWM	ETF	78.94	79.16	78.24	79.14	6341085.0
2011-01-03 10:00:00	IWM	ETF	79.15	80.02	79.09	79.951	10073676.0
2011-01-03 11:00:00	IWM	ETF	79.96	80.01	79.85	79.93	4580954.0
2011-01-03 12:00:00	IWM	ETF	79.93	79.99	79.61	79.73	2613170.0
2011-01-03 13:00:00	IWM	ETF	79.73	79.81	79.64	79.74	2539928.0
2011-01-03 14:00:00	IWM	ETF	79.74	79.82	79.51	79.81	4892405.0
2011-01-03 15:00:00	IWM	ETF	79.82	79.95	79.61	79.62	10026002.0
2011-01-03 16:00:00	IWM	ETF	79.62	79.7247	78.2084	79.54	2805929.0
2011-01-03 17:00:00	IWM	ETF	79.54	79.54	79.46	79.46	30515.0
2011-01-03 18:00:00	IWM	ETF	79.54	79.54	79.53	79.54	4866.0
2011-01-03 19:00:00	IWM	ETF	79.54	79.54	79.45	79.5	6825.0
2011-01-03 04:00:00	DIA	ETF	116.08	116.08	116.08	116.08	100.0
2011-01-03 05:00:00	DIA	ETF	116.18	116.32	116.18	116.32	1200.0

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

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