PREVIEW / etf_1hour / 2008-04-25

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-04-25.parquet
  size:    103 KB
  rows:    3,319

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-25 04:00:00	SPY	ETF	139.0	139.04	139.0	139.04	151200.0
2008-04-25 05:00:00	SPY	ETF	139.0	139.0	138.95	138.95	101400.0
2008-04-25 06:00:00	SPY	ETF	139.0	139.16	138.99	138.99	416900.0
2008-04-25 07:00:00	SPY	ETF	138.99	139.4	138.82	139.35	714485.0
2008-04-25 08:00:00	SPY	ETF	139.35	139.43	139.13	139.26	3055689.0
2008-04-25 09:00:00	SPY	ETF	139.25	139.6	138.88	138.89	18598649.0
2008-04-25 10:00:00	SPY	ETF	138.89	139.21	138.58	138.92	40697656.0
2008-04-25 11:00:00	SPY	ETF	138.91	139.0	137.91	138.61	33660348.0
2008-04-25 12:00:00	SPY	ETF	138.62	138.8345	138.4	138.54	12174519.0
2008-04-25 13:00:00	SPY	ETF	138.54	138.93	138.29	138.91	11765171.0
2008-04-25 14:00:00	SPY	ETF	138.912	139.18	138.82	139.14	20116522.0
2008-04-25 15:00:00	SPY	ETF	139.14	139.89	138.31	139.76	42653514.0
2008-04-25 16:00:00	SPY	ETF	139.75	139.78	138.7453	139.6	2683199.0
2008-04-25 17:00:00	SPY	ETF	139.57	139.6	138.86	139.5	2045034.0
2008-04-25 18:00:00	SPY	ETF	139.53	139.53	139.42	139.45	10228.0
2008-04-25 19:00:00	SPY	ETF	139.53	139.6	139.53	139.6	13291.0
2008-04-25 04:00:00	QQQ	ETF	47.28	47.28	47.28	47.28	200.0
2008-04-25 05:00:00	QQQ	ETF	47.29	47.29	47.27	47.27	200.0
2008-04-25 06:00:00	QQQ	ETF	47.31	47.33	47.27	47.33	104800.0
2008-04-25 07:00:00	QQQ	ETF	47.29	47.4	47.18	47.36	377552.0
2008-04-25 08:00:00	QQQ	ETF	47.38	47.39	47.29	47.33	2178286.0
2008-04-25 09:00:00	QQQ	ETF	47.33	47.39	46.78	46.8699	24895646.0
2008-04-25 10:00:00	QQQ	ETF	46.87	47.08	46.77	46.92	21163662.0
2008-04-25 11:00:00	QQQ	ETF	46.92	46.96	46.58	46.82	18416708.0
2008-04-25 12:00:00	QQQ	ETF	46.82	46.87	46.65	46.71	9747754.0
2008-04-25 13:00:00	QQQ	ETF	46.7195	46.84	46.57	46.83	8511442.0
2008-04-25 14:00:00	QQQ	ETF	46.829	47.02	46.8	47.0	9718204.0
2008-04-25 15:00:00	QQQ	ETF	47.0	47.3	46.97	47.2	21836593.0
2008-04-25 16:00:00	QQQ	ETF	47.19	47.22	46.85	47.21	2811078.0
2008-04-25 17:00:00	QQQ	ETF	47.19	47.25	46.855	47.19	45503.0
2008-04-25 18:00:00	QQQ	ETF	47.2	47.2	47.18	47.2	13190.0
2008-04-25 19:00:00	QQQ	ETF	47.2	47.26	47.2	47.25	19410.0
2008-04-25 06:00:00	IWM	ETF	71.41	71.41	71.41	71.41	100.0
2008-04-25 07:00:00	IWM	ETF	71.36	71.65	71.34	71.65	28708.0
2008-04-25 08:00:00	IWM	ETF	71.66	71.69	71.39	71.69	1540476.0
2008-04-25 09:00:00	IWM	ETF	71.68	71.95	71.18	71.19	8191951.0
2008-04-25 10:00:00	IWM	ETF	71.2	71.47	70.96	71.32	7897974.0
2008-04-25 11:00:00	IWM	ETF	71.32	71.4	70.81	71.18	5636566.0
2008-04-25 12:00:00	IWM	ETF	71.17	71.37	71.07	71.21	3338321.0
2008-04-25 13:00:00	IWM	ETF	71.2	71.45	71.07	71.44	3947514.0
2008-04-25 14:00:00	IWM	ETF	71.44	71.74	71.37	71.73	5333055.0
2008-04-25 15:00:00	IWM	ETF	71.73	72.27	71.71	71.91	14037216.0
2008-04-25 16:00:00	IWM	ETF	71.91	72.0	71.51	71.95	5299188.0
2008-04-25 17:00:00	IWM	ETF	71.95	71.95	71.42	71.9	5323.0
2008-04-25 18:00:00	IWM	ETF	71.92	71.98	71.92	71.98	600.0
2008-04-25 19:00:00	IWM	ETF	71.88	71.88	71.88	71.88	350.0
2008-04-25 07:00:00	DIA	ETF	128.65	128.95	128.65	128.95	800.0
2008-04-25 08:00:00	DIA	ETF	128.99	128.99	128.37	128.86	153771.0
2008-04-25 09:00:00	DIA	ETF	128.85	129.05	128.24	128.24	1377535.0
2008-04-25 10:00:00	DIA	ETF	128.25	128.49	127.91	128.14	2608389.0

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

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