PREVIEW / etf_1hour / 2008-04-03

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-04-03.parquet
  size:    101 KB
  rows:    3,396

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-04-03 05:00:00	SPY	ETF	136.72	136.72	136.72	136.72	10000.0
2008-04-03 06:00:00	SPY	ETF	136.65	136.65	136.28	136.4	55700.0
2008-04-03 07:00:00	SPY	ETF	136.35	136.65	136.2	136.55	865300.0
2008-04-03 08:00:00	SPY	ETF	136.51	136.7	135.72	135.79	8555538.0
2008-04-03 09:00:00	SPY	ETF	135.78	136.27	135.65	136.24	20534279.0
2008-04-03 10:00:00	SPY	ETF	136.24	136.74	135.862	135.902	32053371.0
2008-04-03 11:00:00	SPY	ETF	135.9	136.71	135.81	136.57	16348365.0
2008-04-03 12:00:00	SPY	ETF	136.58	137.21	136.36	137.01	18229725.0
2008-04-03 13:00:00	SPY	ETF	137.01	137.44	136.86	136.86	21149663.0
2008-04-03 14:00:00	SPY	ETF	136.865	137.25	136.68	137.23	20317007.0
2008-04-03 15:00:00	SPY	ETF	137.23	137.23	136.39	136.79	27569852.0
2008-04-03 16:00:00	SPY	ETF	136.72	137.13	136.72	137.0	4149300.0
2008-04-03 17:00:00	SPY	ETF	137.02	137.09	136.99	137.01	511300.0
2008-04-03 18:00:00	SPY	ETF	137.05	137.05	136.98	137.0	14600.0
2008-04-03 19:00:00	SPY	ETF	136.98	137.0	136.96	137.0	18500.0
2008-04-03 06:00:00	QQQ	ETF	45.45	45.45	45.45	45.45	2400.0
2008-04-03 07:00:00	QQQ	ETF	45.46	45.6	45.39	45.52	698028.0
2008-04-03 08:00:00	QQQ	ETF	45.53	45.54	45.17	45.23	6225281.0
2008-04-03 09:00:00	QQQ	ETF	45.23	45.42	45.16	45.408	14032136.0
2008-04-03 10:00:00	QQQ	ETF	45.4	45.572	45.14	45.19	30002174.0
2008-04-03 11:00:00	QQQ	ETF	45.19	45.55	45.15	45.5	14802219.0
2008-04-03 12:00:00	QQQ	ETF	45.51	45.87	45.47	45.78	13789450.0
2008-04-03 13:00:00	QQQ	ETF	45.78	45.91	45.63	45.64	16129972.0
2008-04-03 14:00:00	QQQ	ETF	45.64	45.83	45.56	45.81	12720843.0
2008-04-03 15:00:00	QQQ	ETF	45.82	45.82	45.5	45.59	16133385.0
2008-04-03 16:00:00	QQQ	ETF	45.59	45.84	45.58	45.76	3607980.0
2008-04-03 17:00:00	QQQ	ETF	45.76	45.8	45.59	45.77	1346094.0
2008-04-03 18:00:00	QQQ	ETF	45.77	45.8	45.76	45.78	188173.0
2008-04-03 19:00:00	QQQ	ETF	45.77	45.8	45.77	45.8	18621.0
2008-04-03 06:00:00	IWM	ETF	70.84	70.84	70.84	70.84	200.0
2008-04-03 07:00:00	IWM	ETF	70.8	70.86	70.79	70.86	2000.0
2008-04-03 08:00:00	IWM	ETF	70.85	70.86	70.39	70.43	648786.0
2008-04-03 09:00:00	IWM	ETF	70.45	70.8	70.33	70.79	5116078.0
2008-04-03 10:00:00	IWM	ETF	70.78	71.08	70.35	70.41	12614051.0
2008-04-03 11:00:00	IWM	ETF	70.4	70.96	70.36	70.87	3710082.0
2008-04-03 12:00:00	IWM	ETF	70.86	71.29	70.75	71.15	5664079.0
2008-04-03 13:00:00	IWM	ETF	71.16	71.47	71.11	71.15	7450486.0
2008-04-03 14:00:00	IWM	ETF	71.16	71.32	70.96	71.31	6869614.0
2008-04-03 15:00:00	IWM	ETF	71.31	71.31	70.81	71.14	8236854.0
2008-04-03 16:00:00	IWM	ETF	71.14	71.45	71.08	71.13	3041500.0
2008-04-03 17:00:00	IWM	ETF	71.32	71.35	71.14	71.32	503400.0
2008-04-03 18:00:00	IWM	ETF	71.32	71.32	71.32	71.32	1300.0
2008-04-03 19:00:00	IWM	ETF	71.35	71.37	71.35	71.37	300.0
2008-04-03 07:00:00	DIA	ETF	126.0	126.0	126.0	126.0	4300.0
2008-04-03 08:00:00	DIA	ETF	126.0	126.02	125.39	125.41	248500.0
2008-04-03 09:00:00	DIA	ETF	125.41	125.67	125.22	125.66	1800488.0
2008-04-03 10:00:00	DIA	ETF	125.66	126.04	125.35	125.35	2407524.0
2008-04-03 11:00:00	DIA	ETF	125.35	125.94	125.29	125.83	1015231.0
2008-04-03 12:00:00	DIA	ETF	125.82	126.45	125.68	126.33	1182962.0
2008-04-03 13:00:00	DIA	ETF	126.35	126.64	126.23	126.23	1628923.0

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

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