PREVIEW / etf_1hour / 2011-12-01

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-12-01.parquet
  size:    183 KB
  rows:    5,668

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-12-01 04:00:00	SPY	ETF	124.68	124.79	124.33	124.79	14850.0
2011-12-01 05:00:00	SPY	ETF	124.83	124.95	124.68	124.93	22480.0
2011-12-01 06:00:00	SPY	ETF	124.93	124.93	124.51	124.86	114700.0
2011-12-01 07:00:00	SPY	ETF	124.78	125.15	124.77	125.07	629622.0
2011-12-01 08:00:00	SPY	ETF	125.05	125.29	124.35	124.95	3053473.0
2011-12-01 09:00:00	SPY	ETF	124.95	125.4	124.7099	125.34	25710631.0
2011-12-01 10:00:00	SPY	ETF	125.34	125.64	124.86	124.92	33634822.0
2011-12-01 11:00:00	SPY	ETF	124.91	125.12	124.43	124.88	28954433.0
2011-12-01 12:00:00	SPY	ETF	124.89	124.99	124.47	124.48	14267485.0
2011-12-01 13:00:00	SPY	ETF	124.48	125.34	124.47	125.33	14634919.0
2011-12-01 14:00:00	SPY	ETF	125.3292	125.34	124.96	125.0798	13571516.0
2011-12-01 15:00:00	SPY	ETF	125.07	125.27	124.7	124.97	29328986.0
2011-12-01 16:00:00	SPY	ETF	124.96	125.0	124.73	124.89	10092251.0
2011-12-01 17:00:00	SPY	ETF	124.89	124.98	124.86	124.9	125406.0
2011-12-01 18:00:00	SPY	ETF	124.9	124.98	124.8	124.94	217391.0
2011-12-01 19:00:00	SPY	ETF	124.97	125.29	124.93	125.22	243901.0
2011-12-01 04:00:00	QQQ	ETF	56.2	56.31	56.2	56.31	4085.0
2011-12-01 05:00:00	QQQ	ETF	56.43	56.43	56.43	56.43	500.0
2011-12-01 06:00:00	QQQ	ETF	56.41	56.44	56.32	56.43	12300.0
2011-12-01 07:00:00	QQQ	ETF	56.43	56.53	56.42	56.49	13150.0
2011-12-01 08:00:00	QQQ	ETF	56.49	56.59	56.36	56.42	163095.0
2011-12-01 09:00:00	QQQ	ETF	56.42	56.81	56.35	56.76	5844241.0
2011-12-01 10:00:00	QQQ	ETF	56.76	56.88	56.44	56.48	8203132.0
2011-12-01 11:00:00	QQQ	ETF	56.49	56.64	56.35	56.62	6192837.0
2011-12-01 12:00:00	QQQ	ETF	56.62	56.72	56.49	56.51	3358316.0
2011-12-01 13:00:00	QQQ	ETF	56.51	56.85	56.5	56.845	2945791.0
2011-12-01 14:00:00	QQQ	ETF	56.85	56.86	56.68	56.788	2719324.0
2011-12-01 15:00:00	QQQ	ETF	56.77	56.925	56.69	56.76	8101018.0
2011-12-01 16:00:00	QQQ	ETF	56.77	56.85	56.7083	56.77	2098216.0
2011-12-01 17:00:00	QQQ	ETF	56.77	56.82	56.77	56.82	14695.0
2011-12-01 18:00:00	QQQ	ETF	56.79	56.82	56.77	56.81	23650.0
2011-12-01 19:00:00	QQQ	ETF	56.82	56.9	56.81	56.9	21230.0
2011-12-01 04:00:00	IWM	ETF	73.12	73.45	73.12	73.42	1264.0
2011-12-01 06:00:00	IWM	ETF	73.73	73.8	73.66	73.8	800.0
2011-12-01 07:00:00	IWM	ETF	73.92	74.04	73.92	74.04	3900.0
2011-12-01 08:00:00	IWM	ETF	73.92	74.13	73.56	73.73	819927.0
2011-12-01 09:00:00	IWM	ETF	73.7	74.08	73.11	73.91	9754405.0
2011-12-01 10:00:00	IWM	ETF	73.9	74.145	73.2	73.29	11053556.0
2011-12-01 11:00:00	IWM	ETF	73.3	73.55	73.0605	73.49	5308526.0
2011-12-01 12:00:00	IWM	ETF	73.49	73.67	73.255	73.27	3188572.0
2011-12-01 13:00:00	IWM	ETF	73.27	73.86	73.26	73.84	2862448.0
2011-12-01 14:00:00	IWM	ETF	73.85	73.88	73.58	73.76	4770085.0
2011-12-01 15:00:00	IWM	ETF	73.75	73.84	73.11	73.19	8550797.0
2011-12-01 16:00:00	IWM	ETF	73.18	73.6	73.1296	73.2	4764770.0
2011-12-01 17:00:00	IWM	ETF	73.2	73.2	73.13	73.14	12752.0
2011-12-01 18:00:00	IWM	ETF	73.18	73.24	73.063	73.23	1228063.0
2011-12-01 19:00:00	IWM	ETF	73.21	73.35	73.21	73.35	3700.0
2011-12-01 04:00:00	DIA	ETF	119.95	119.95	119.89	119.89	7000.0
2011-12-01 07:00:00	DIA	ETF	120.22	120.4	120.22	120.4	3600.0
2011-12-01 08:00:00	DIA	ETF	120.21	120.51	120.05	120.23	17650.0

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

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