PREVIEW / etf_1hour / 2008-06-11

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-06-11.parquet
  size:    109 KB
  rows:    3,504

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
2008-06-11 04:00:00	SPY	ETF	136.33	136.66	136.33	136.66	200.0
2008-06-11 05:00:00	SPY	ETF	136.34	136.34	136.34	136.34	300.0
2008-06-11 06:00:00	SPY	ETF	136.42	136.54	136.31	136.38	90900.0
2008-06-11 07:00:00	SPY	ETF	136.49	136.62	136.42	136.54	419331.0
2008-06-11 08:00:00	SPY	ETF	136.54	136.57	136.19	136.28	1338309.0
2008-06-11 09:00:00	SPY	ETF	136.27	136.28	135.51	135.53	17547189.0
2008-06-11 10:00:00	SPY	ETF	135.53	135.54	134.44	135.19	71090879.0
2008-06-11 11:00:00	SPY	ETF	135.19	136.2592	134.45	134.98	39257347.0
2008-06-11 12:00:00	SPY	ETF	134.98	136.2591	134.31	134.67	33167435.0
2008-06-11 13:00:00	SPY	ETF	134.65	136.2592	134.45	134.74	26939790.0
2008-06-11 14:00:00	SPY	ETF	134.7395	135.15	134.48	134.56	29230171.0
2008-06-11 15:00:00	SPY	ETF	134.56	134.9	133.93	133.96	44141883.0
2008-06-11 16:00:00	SPY	ETF	134.01	136.26	133.87	133.94	13877111.0
2008-06-11 17:00:00	SPY	ETF	133.94	134.12	133.91	133.93	2407093.0
2008-06-11 18:00:00	SPY	ETF	133.9	134.09	133.85	134.09	42150.0
2008-06-11 19:00:00	SPY	ETF	134.09	134.18	134.07	134.15	20989.0
2008-06-11 06:00:00	QQQ	ETF	48.66	48.66	48.66	48.66	500.0
2008-06-11 07:00:00	QQQ	ETF	48.67	48.77	48.67	48.74	88300.0
2008-06-11 08:00:00	QQQ	ETF	48.74	48.75	48.55	48.61	546607.0
2008-06-11 09:00:00	QQQ	ETF	48.61	48.62	48.19	48.2	11444781.0
2008-06-11 10:00:00	QQQ	ETF	48.19	48.2	47.71	48.13	41110879.0
2008-06-11 11:00:00	QQQ	ETF	48.12	48.14	47.73	47.94	24493079.0
2008-06-11 12:00:00	QQQ	ETF	47.94	47.96	47.6	47.65	15485220.0
2008-06-11 13:00:00	QQQ	ETF	47.65	47.78	47.6	47.68	13600169.0
2008-06-11 14:00:00	QQQ	ETF	47.68	47.9	47.59	47.66	17226313.0
2008-06-11 15:00:00	QQQ	ETF	47.66	48.1058	47.35	47.37	28755512.0
2008-06-11 16:00:00	QQQ	ETF	47.37	48.547	47.3335	47.38	7951079.0
2008-06-11 17:00:00	QQQ	ETF	47.39	47.4	47.31	47.34	575012.0
2008-06-11 18:00:00	QQQ	ETF	47.32	47.38	47.32	47.38	54094.0
2008-06-11 19:00:00	QQQ	ETF	47.37	47.39	47.36	47.38	59530.0
2008-06-11 06:00:00	IWM	ETF	73.22	73.28	73.22	73.28	20000.0
2008-06-11 07:00:00	IWM	ETF	73.22	73.32	73.2	73.25	36500.0
2008-06-11 08:00:00	IWM	ETF	73.29	73.29	73.04	73.04	167793.0
2008-06-11 09:00:00	IWM	ETF	73.07	73.22	72.56	72.57	9707703.0
2008-06-11 10:00:00	IWM	ETF	72.57	72.81	72.1	72.73	22069218.0
2008-06-11 11:00:00	IWM	ETF	72.73	72.77	72.28	72.59	10953461.0
2008-06-11 12:00:00	IWM	ETF	72.6	72.6	72.1	72.2	7002388.0
2008-06-11 13:00:00	IWM	ETF	72.21	72.4	72.1	72.28	6349702.0
2008-06-11 14:00:00	IWM	ETF	72.28	72.6	72.17	72.25	10249490.0
2008-06-11 15:00:00	IWM	ETF	72.25	72.4	71.77	71.78	15412229.0
2008-06-11 16:00:00	IWM	ETF	71.78	73.2	71.35	71.8	7483563.0
2008-06-11 17:00:00	IWM	ETF	73.2	73.2	71.77	71.77	4091512.0
2008-06-11 18:00:00	IWM	ETF	71.81	71.89	71.79	71.82	9475.0
2008-06-11 07:00:00	DIA	ETF	123.19	123.31	123.19	123.31	3600.0
2008-06-11 08:00:00	DIA	ETF	123.28	123.29	122.9	122.97	32871.0
2008-06-11 09:00:00	DIA	ETF	122.95	122.95	122.06	122.07	2717260.0
2008-06-11 10:00:00	DIA	ETF	122.07	122.15	121.22	121.88	5041624.0
2008-06-11 11:00:00	DIA	ETF	121.86	121.89	121.23	121.69	2697397.0
2008-06-11 12:00:00	DIA	ETF	121.7	121.81	121.17	121.46	1555232.0
2008-06-11 13:00:00	DIA	ETF	121.45	121.65	121.26	121.48	1371436.0

> showing 50 of 3,504 rows — these rows as CSV

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