PREVIEW / etf_1hour / 2011-01-04

all etf 1-hour files

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

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-04 04:00:00	SPY	ETF	126.93	127.09	126.93	127.09	3766.0
2011-01-04 05:00:00	SPY	ETF	127.15	127.21	127.07	127.21	2562.0
2011-01-04 06:00:00	SPY	ETF	127.2	127.31	127.2	127.29	5900.0
2011-01-04 07:00:00	SPY	ETF	127.29	127.34	127.22	127.25	171125.0
2011-01-04 08:00:00	SPY	ETF	127.23	127.28	127.07	127.12	1119450.0
2011-01-04 09:00:00	SPY	ETF	127.13	127.37	126.86	126.88	17614776.0
2011-01-04 10:00:00	SPY	ETF	126.88	126.99	126.68	126.72	19782827.0
2011-01-04 11:00:00	SPY	ETF	126.72	126.8	126.53	126.5726	17256837.0
2011-01-04 12:00:00	SPY	ETF	126.58	126.62	126.19	126.32	14623747.0
2011-01-04 13:00:00	SPY	ETF	126.32	126.63	126.31	126.5725	13800922.0
2011-01-04 14:00:00	SPY	ETF	126.575	126.88	126.51	126.745	18895670.0
2011-01-04 15:00:00	SPY	ETF	126.7495	126.99	126.66	126.93	22526071.0
2011-01-04 16:00:00	SPY	ETF	126.93	127.1214	126.6	126.9	10057313.0
2011-01-04 17:00:00	SPY	ETF	126.9	126.96	126.7086	126.91	318538.0
2011-01-04 18:00:00	SPY	ETF	126.9	126.93	126.82	126.82	81115.0
2011-01-04 19:00:00	SPY	ETF	126.86	126.88	126.82	126.82	33939.0
2011-01-04 04:00:00	QQQ	ETF	55.28	55.28	55.28	55.28	144.0
2011-01-04 05:00:00	QQQ	ETF	55.35	55.35	55.35	55.35	2000.0
2011-01-04 06:00:00	QQQ	ETF	55.4	55.44	55.4	55.44	500.0
2011-01-04 07:00:00	QQQ	ETF	55.43	55.46	55.43	55.43	13372.0
2011-01-04 08:00:00	QQQ	ETF	55.45	55.48	55.39	55.41	740973.0
2011-01-04 09:00:00	QQQ	ETF	55.41	55.56	55.34	55.39	6421154.0
2011-01-04 10:00:00	QQQ	ETF	55.4	55.43	55.22	55.23	6689063.0
2011-01-04 11:00:00	QQQ	ETF	55.2325	55.27	55.05	55.0504	5658420.0
2011-01-04 12:00:00	QQQ	ETF	55.05	55.09	54.92	55.06	6538795.0
2011-01-04 13:00:00	QQQ	ETF	55.0585	55.135	55.04	55.11	3236535.0
2011-01-04 14:00:00	QQQ	ETF	55.1165	55.3	55.09	55.245	4054885.0
2011-01-04 15:00:00	QQQ	ETF	55.24	55.315	55.16	55.26	6899383.0
2011-01-04 16:00:00	QQQ	ETF	55.26	55.28	55.14	55.17	1439604.0
2011-01-04 17:00:00	QQQ	ETF	55.18	55.18	55.15	55.18	13593.0
2011-01-04 18:00:00	QQQ	ETF	55.16	55.17	55.16	55.16	6900.0
2011-01-04 19:00:00	QQQ	ETF	55.16	55.21	55.15	55.21	18671.0
2011-01-04 05:00:00	IWM	ETF	79.74	79.74	79.74	79.74	2000.0
2011-01-04 06:00:00	IWM	ETF	79.84	79.84	79.77	79.77	350.0
2011-01-04 07:00:00	IWM	ETF	79.75	79.82	79.75	79.81	5661.0
2011-01-04 08:00:00	IWM	ETF	79.82	79.86	79.67	79.7	403758.0
2011-01-04 09:00:00	IWM	ETF	79.7	79.9	79.36	79.43	6281107.0
2011-01-04 10:00:00	IWM	ETF	79.43	79.55	79.14	79.18	10089535.0
2011-01-04 11:00:00	IWM	ETF	79.17	79.18	78.23	78.24	9645813.0
2011-01-04 12:00:00	IWM	ETF	78.25	78.35	77.57	77.89	11420517.0
2011-01-04 13:00:00	IWM	ETF	77.89	78.25	77.85	78.17	6144755.0
2011-01-04 14:00:00	IWM	ETF	78.16	78.67	78.08	78.4	7753738.0
2011-01-04 15:00:00	IWM	ETF	78.3901	78.64	78.27	78.43	8002339.0
2011-01-04 16:00:00	IWM	ETF	78.42	79.6953	78.225	78.41	4394729.0
2011-01-04 17:00:00	IWM	ETF	78.36	78.38	78.31	78.31	12250.0
2011-01-04 18:00:00	IWM	ETF	78.33	78.37	78.33	78.35	1190.0
2011-01-04 19:00:00	IWM	ETF	78.33	78.33	78.32	78.33	890.0
2011-01-04 05:00:00	DIA	ETF	116.55	116.55	116.55	116.55	500.0
2011-01-04 06:00:00	DIA	ETF	116.57	116.65	116.57	116.65	3500.0
2011-01-04 07:00:00	DIA	ETF	116.63	116.63	116.6	116.6	2300.0

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

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