PREVIEW / etf_1hour / 2008-06-12

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-06-12.parquet
  size:    108 KB
  rows:    3,440

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-12 04:00:00	SPY	ETF	134.67	134.67	134.51	134.51	3100.0
2008-06-12 05:00:00	SPY	ETF	134.48	134.59	134.48	134.59	3100.0
2008-06-12 06:00:00	SPY	ETF	134.52	134.93	134.46	134.93	216400.0
2008-06-12 07:00:00	SPY	ETF	134.95	135.07	134.79	135.06	2553978.0
2008-06-12 08:00:00	SPY	ETF	135.04	135.37	134.45	135.02	11402905.0
2008-06-12 09:00:00	SPY	ETF	135.04	135.67	134.53	135.42	31691674.0
2008-06-12 10:00:00	SPY	ETF	135.43	135.77	135.0	135.38	34997700.0
2008-06-12 11:00:00	SPY	ETF	135.38	135.71	135.17	135.26	19425805.0
2008-06-12 12:00:00	SPY	ETF	135.26	135.53	135.12	135.17	15286266.0
2008-06-12 13:00:00	SPY	ETF	135.17	135.35	134.56	134.72	25240854.0
2008-06-12 14:00:00	SPY	ETF	134.72	134.86	134.13	134.52	35971553.0
2008-06-12 15:00:00	SPY	ETF	134.51	135.87	133.52	134.44	58682481.0
2008-06-12 16:00:00	SPY	ETF	134.44	134.67	134.1289	134.58	5743798.0
2008-06-12 17:00:00	SPY	ETF	134.58	134.75	134.4	134.45	220938.0
2008-06-12 18:00:00	SPY	ETF	134.52	134.68	134.51	134.68	73000.0
2008-06-12 19:00:00	SPY	ETF	134.67	134.71	134.53	134.58	12050.0
2008-06-12 04:00:00	QQQ	ETF	47.64	47.65	47.58	47.58	6100.0
2008-06-12 06:00:00	QQQ	ETF	47.59	47.72	47.59	47.72	204500.0
2008-06-12 07:00:00	QQQ	ETF	47.69	47.77	47.65	47.76	531150.0
2008-06-12 08:00:00	QQQ	ETF	47.76	47.86	47.6	47.73	4481940.0
2008-06-12 09:00:00	QQQ	ETF	47.73	48.11	47.63	47.99	26533889.0
2008-06-12 10:00:00	QQQ	ETF	48.0	48.09	47.57	47.88	26781779.0
2008-06-12 11:00:00	QQQ	ETF	47.87	48.04	47.71	47.77	13882871.0
2008-06-12 12:00:00	QQQ	ETF	47.77	47.94	47.66	47.67	12646942.0
2008-06-12 13:00:00	QQQ	ETF	47.67	47.74	47.44	47.54	16081896.0
2008-06-12 14:00:00	QQQ	ETF	47.54	47.61	47.09	47.34	27576534.0
2008-06-12 15:00:00	QQQ	ETF	47.34	47.45	47.0	47.42	42034695.0
2008-06-12 16:00:00	QQQ	ETF	47.41	47.5577	47.362	47.51	7844188.0
2008-06-12 17:00:00	QQQ	ETF	47.5	47.53	47.45	47.45	182187.0
2008-06-12 18:00:00	QQQ	ETF	47.45	47.51	47.45	47.48	359574.0
2008-06-12 19:00:00	QQQ	ETF	47.5	47.5	47.47	47.49	35909.0
2008-06-12 06:00:00	IWM	ETF	72.26	72.35	72.26	72.35	32000.0
2008-06-12 07:00:00	IWM	ETF	72.36	72.4	72.28	72.38	329012.0
2008-06-12 08:00:00	IWM	ETF	72.38	72.65	72.21	72.49	1359054.0
2008-06-12 09:00:00	IWM	ETF	72.51	73.1	72.26	72.92	10514867.0
2008-06-12 10:00:00	IWM	ETF	72.92	73.0	72.5	72.68	9732022.0
2008-06-12 11:00:00	IWM	ETF	72.68	73.05	72.65	72.79	9758001.0
2008-06-12 12:00:00	IWM	ETF	72.79	72.92	72.66	72.69	6482562.0
2008-06-12 13:00:00	IWM	ETF	72.69	72.81	72.35	72.46	5640651.0
2008-06-12 14:00:00	IWM	ETF	72.45	72.54	72.06	72.25	7865343.0
2008-06-12 15:00:00	IWM	ETF	72.26	72.26	71.63	71.91	20980271.0
2008-06-12 16:00:00	IWM	ETF	71.91	72.36	71.75	71.75	18819896.0
2008-06-12 17:00:00	IWM	ETF	72.1	72.1	71.96	71.96	3379.0
2008-06-12 18:00:00	IWM	ETF	71.99	71.99	71.99	71.99	2400.0
2008-06-12 07:00:00	DIA	ETF	121.87	121.96	121.76	121.95	148752.0
2008-06-12 08:00:00	DIA	ETF	121.94	122.38	121.5	122.0	203845.0
2008-06-12 09:00:00	DIA	ETF	122.02	122.59	121.5	122.39	2843287.0
2008-06-12 10:00:00	DIA	ETF	122.39	122.79	122.25	122.55	2360655.0
2008-06-12 11:00:00	DIA	ETF	122.56	122.85	122.39	122.47	2080083.0
2008-06-12 12:00:00	DIA	ETF	122.48	122.67	122.24	122.3	1382595.0

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

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