PREVIEW / etf_1hour / 2008-06-30

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-06-30.parquet
  size:    112 KB
  rows:    3,562

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-30 04:00:00	SPY	ETF	127.93	127.93	127.33	127.33	3400.0
2008-06-30 05:00:00	SPY	ETF	127.47	127.66	127.47	127.66	2500.0
2008-06-30 06:00:00	SPY	ETF	127.87	127.87	127.48	127.62	66800.0
2008-06-30 07:00:00	SPY	ETF	127.73	127.85	127.37	127.37	949726.0
2008-06-30 08:00:00	SPY	ETF	127.38	127.96	127.38	127.94	3821676.0
2008-06-30 09:00:00	SPY	ETF	127.94	128.33	127.56	127.58	26364556.0
2008-06-30 10:00:00	SPY	ETF	127.59	128.57	127.3	128.54	46025738.0
2008-06-30 11:00:00	SPY	ETF	128.55	128.87	128.27	128.6	38917049.0
2008-06-30 12:00:00	SPY	ETF	128.61	128.91	128.45	128.5801	20986455.0
2008-06-30 13:00:00	SPY	ETF	128.5801	128.69	127.88	128.13	36466955.0
2008-06-30 14:00:00	SPY	ETF	128.12	128.47	128.0	128.23	27834094.0
2008-06-30 15:00:00	SPY	ETF	128.23	128.63	127.68	127.84	42703142.0
2008-06-30 16:00:00	SPY	ETF	127.74	128.6616	127.68	128.22	5262883.0
2008-06-30 17:00:00	SPY	ETF	128.2	128.23	128.03	128.1	482760.0
2008-06-30 18:00:00	SPY	ETF	128.1	128.15	127.99	128.06	90150.0
2008-06-30 19:00:00	SPY	ETF	128.06	128.25	128.06	128.25	25800.0
2008-06-30 04:00:00	QQQ	ETF	45.52	45.52	45.52	45.52	200.0
2008-06-30 05:00:00	QQQ	ETF	45.45	45.45	45.45	45.45	2000.0
2008-06-30 06:00:00	QQQ	ETF	45.56	45.61	45.45	45.5	34400.0
2008-06-30 07:00:00	QQQ	ETF	45.53	45.6	45.35	45.37	719281.0
2008-06-30 08:00:00	QQQ	ETF	45.38	45.65	45.36	45.64	3311343.0
2008-06-30 09:00:00	QQQ	ETF	45.64	45.76	45.37	45.38	7250284.0
2008-06-30 10:00:00	QQQ	ETF	45.39	45.67	45.24	45.66	19815818.0
2008-06-30 11:00:00	QQQ	ETF	45.66	45.83	45.55	45.65	15032432.0
2008-06-30 12:00:00	QQQ	ETF	45.65	45.74	45.48	45.53	12926558.0
2008-06-30 13:00:00	QQQ	ETF	45.52	45.61	45.19	45.26	14706535.0
2008-06-30 14:00:00	QQQ	ETF	45.25	45.5	45.24	45.38	11899033.0
2008-06-30 15:00:00	QQQ	ETF	45.39	45.61	45.15	45.15	19250500.0
2008-06-30 16:00:00	QQQ	ETF	45.15	45.6921	45.14	45.3	5496232.0
2008-06-30 17:00:00	QQQ	ETF	45.32	45.34	45.3	45.32	91373.0
2008-06-30 18:00:00	QQQ	ETF	45.32	45.32	45.28	45.32	31073.0
2008-06-30 19:00:00	QQQ	ETF	45.29	45.35	45.29	45.35	8018.0
2008-06-30 07:00:00	IWM	ETF	69.88	69.93	69.6	69.62	405814.0
2008-06-30 08:00:00	IWM	ETF	69.63	69.98	69.63	69.93	984060.0
2008-06-30 09:00:00	IWM	ETF	69.94	70.17	69.64	69.66	10082417.0
2008-06-30 10:00:00	IWM	ETF	69.66	69.96	69.46	69.84	11860647.0
2008-06-30 11:00:00	IWM	ETF	69.84	70.21	69.8	70.0	13168245.0
2008-06-30 12:00:00	IWM	ETF	70.01	70.06	69.81	69.9	10089912.0
2008-06-30 13:00:00	IWM	ETF	69.89	69.97	69.35	69.5	9571046.0
2008-06-30 14:00:00	IWM	ETF	69.5	69.71	69.41	69.43	12960590.0
2008-06-30 15:00:00	IWM	ETF	69.44	69.63	68.92	69.05	25696545.0
2008-06-30 16:00:00	IWM	ETF	69.06	69.85	68.93	69.09	8260019.0
2008-06-30 17:00:00	IWM	ETF	69.05	69.84	69.01	69.03	9392391.0
2008-06-30 18:00:00	IWM	ETF	69.08	69.08	69.03	69.03	18109.0
2008-06-30 19:00:00	IWM	ETF	69.04	69.08	69.04	69.08	2178.0
2008-06-30 07:00:00	DIA	ETF	113.41	113.41	113.08	113.1	13308.0
2008-06-30 08:00:00	DIA	ETF	113.13	113.56	113.1	113.51	116101.0
2008-06-30 09:00:00	DIA	ETF	113.51	113.75	113.05	113.05	2818495.0
2008-06-30 10:00:00	DIA	ETF	113.05	113.91	112.75	113.9	4155579.0
2008-06-30 11:00:00	DIA	ETF	113.9	114.27	113.65	114.02	3415486.0

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

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