PREVIEW / etf_1hour / 2011-10-26

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-10-26.parquet
  size:    185 KB
  rows:    5,677

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-10-26 04:00:00	SPY	ETF	123.56	123.95	123.56	123.56	19971.0
2011-10-26 05:00:00	SPY	ETF	123.47	123.74	123.47	123.72	8000.0
2011-10-26 06:00:00	SPY	ETF	123.7	123.9	123.45	123.67	264490.0
2011-10-26 07:00:00	SPY	ETF	123.69	123.93	123.5	123.62	355343.0
2011-10-26 08:00:00	SPY	ETF	123.64	124.4	123.6	124.08	3627512.0
2011-10-26 09:00:00	SPY	ETF	124.08	124.53	123.89	124.05	35682461.0
2011-10-26 10:00:00	SPY	ETF	124.06	124.12	122.21	122.48	48784503.0
2011-10-26 11:00:00	SPY	ETF	122.48	123.36	122.45	123.14	30437258.0
2011-10-26 12:00:00	SPY	ETF	123.14	123.33	122.88	122.95	13552350.0
2011-10-26 13:00:00	SPY	ETF	122.95	124.0	122.62	123.79	41870383.0
2011-10-26 14:00:00	SPY	ETF	123.8	124.44	123.69	123.97	38484391.0
2011-10-26 15:00:00	SPY	ETF	123.97	124.77	123.88	124.31	57681267.0
2011-10-26 16:00:00	SPY	ETF	124.31	124.85	123.0195	124.76	13799129.0
2011-10-26 17:00:00	SPY	ETF	124.74	124.96	124.58	124.64	480384.0
2011-10-26 18:00:00	SPY	ETF	124.7	124.75	124.33	124.41	1386769.0
2011-10-26 19:00:00	SPY	ETF	124.47	124.61	124.35	124.57	109496.0
2011-10-26 05:00:00	QQQ	ETF	57.43	57.43	57.34	57.34	866.0
2011-10-26 06:00:00	QQQ	ETF	57.34	57.44	57.3	57.42	33937.0
2011-10-26 07:00:00	QQQ	ETF	57.39	57.45	57.32	57.32	127314.0
2011-10-26 08:00:00	QQQ	ETF	57.34	57.63	57.31	57.51	611590.0
2011-10-26 09:00:00	QQQ	ETF	57.51	57.78	57.44	57.5174	7825671.0
2011-10-26 10:00:00	QQQ	ETF	57.52	57.54	56.2126	56.3	19624831.0
2011-10-26 11:00:00	QQQ	ETF	56.3	56.9785	56.29	56.79	12845634.0
2011-10-26 12:00:00	QQQ	ETF	56.8	56.89	56.63	56.65	2739375.0
2011-10-26 13:00:00	QQQ	ETF	56.65	57.24	56.48	57.16	10932751.0
2011-10-26 14:00:00	QQQ	ETF	57.16	57.45	57.075	57.15	10100794.0
2011-10-26 15:00:00	QQQ	ETF	57.16	57.5	57.12	57.3	10450555.0
2011-10-26 16:00:00	QQQ	ETF	57.31	57.5	57.21	57.44	1501298.0
2011-10-26 17:00:00	QQQ	ETF	57.44	57.55	57.42	57.43	78158.0
2011-10-26 18:00:00	QQQ	ETF	57.45	57.45	57.32	57.32	21985.0
2011-10-26 19:00:00	QQQ	ETF	57.31	57.4	57.3	57.3	24300.0
2011-10-26 04:00:00	IWM	ETF	72.1	72.15	71.94	71.94	2015.0
2011-10-26 06:00:00	IWM	ETF	71.73	71.77	71.73	71.77	500.0
2011-10-26 07:00:00	IWM	ETF	71.89	72.2	71.89	71.96	166000.0
2011-10-26 08:00:00	IWM	ETF	71.94	72.29	71.94	72.23	746078.0
2011-10-26 09:00:00	IWM	ETF	72.25	72.67	71.965	71.98	9898506.0
2011-10-26 10:00:00	IWM	ETF	71.985	72.06	70.54	70.81	11830724.0
2011-10-26 11:00:00	IWM	ETF	70.81	71.89	70.75	71.718	6426572.0
2011-10-26 12:00:00	IWM	ETF	71.719	71.89	71.53	71.59	3249263.0
2011-10-26 13:00:00	IWM	ETF	71.59	72.41	71.17	72.2	9780945.0
2011-10-26 14:00:00	IWM	ETF	72.22	72.64	72.1248	72.25	8137762.0
2011-10-26 15:00:00	IWM	ETF	72.27	73.04	72.22	72.55	15375394.0
2011-10-26 16:00:00	IWM	ETF	72.56	72.905	72.355	72.75	7377176.0
2011-10-26 17:00:00	IWM	ETF	72.74	72.88	72.7	72.7	36696.0
2011-10-26 18:00:00	IWM	ETF	72.73	72.73	72.59	72.59	6667.0
2011-10-26 19:00:00	IWM	ETF	72.57	72.74	72.57	72.66	7787.0
2011-10-26 06:00:00	DIA	ETF	117.43	117.43	117.42	117.42	3000.0
2011-10-26 07:00:00	DIA	ETF	117.53	117.79	117.53	117.6	800.0
2011-10-26 08:00:00	DIA	ETF	117.59	117.94	117.59	117.91	27448.0
2011-10-26 09:00:00	DIA	ETF	118.0	118.5	117.96	118.21	1072535.0

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

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