PREVIEW / etf_1hour / 2008-05-07

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-05-07.parquet
  size:    107 KB
  rows:    3,413

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-05-07 04:00:00	SPY	ETF	141.6	141.62	141.5	141.5	3100.0
2008-05-07 05:00:00	SPY	ETF	141.81	141.81	141.81	141.81	1000.0
2008-05-07 06:00:00	SPY	ETF	141.87	141.91	141.83	141.84	127800.0
2008-05-07 07:00:00	SPY	ETF	141.93	141.95	141.6	141.7	624871.0
2008-05-07 08:00:00	SPY	ETF	141.7	142.13	141.31	142.0	3216319.0
2008-05-07 09:00:00	SPY	ETF	141.99	142.02	141.57	141.68	13188103.0
2008-05-07 10:00:00	SPY	ETF	141.67	142.04	141.38	141.47	23691606.0
2008-05-07 11:00:00	SPY	ETF	141.48	141.58	141.02	141.14	18551193.0
2008-05-07 12:00:00	SPY	ETF	141.14	141.32	141.0	141.24	11791224.0
2008-05-07 13:00:00	SPY	ETF	141.24	141.26	140.63	140.759	17143845.0
2008-05-07 14:00:00	SPY	ETF	140.76	140.85	139.61	139.9	37962281.0
2008-05-07 15:00:00	SPY	ETF	139.88	141.8858	139.13	139.28	55019512.0
2008-05-07 16:00:00	SPY	ETF	139.3	141.8857	139.26	139.55	15433364.0
2008-05-07 17:00:00	SPY	ETF	139.53	139.59	139.48	139.57	37460.0
2008-05-07 18:00:00	SPY	ETF	139.56	139.66	139.46	139.55	55509.0
2008-05-07 19:00:00	SPY	ETF	139.51	139.67	139.51	139.65	8165.0
2008-05-07 05:00:00	QQQ	ETF	48.98	48.98	48.98	48.98	1000.0
2008-05-07 06:00:00	QQQ	ETF	48.95	49.05	48.93	48.93	151100.0
2008-05-07 07:00:00	QQQ	ETF	48.95	48.95	48.82	48.84	668399.0
2008-05-07 08:00:00	QQQ	ETF	48.84	49.06	48.82	48.98	2179575.0
2008-05-07 09:00:00	QQQ	ETF	48.98	49.04	48.78	48.93	12426220.0
2008-05-07 10:00:00	QQQ	ETF	48.93	49.23	48.83	48.9801	18787135.0
2008-05-07 11:00:00	QQQ	ETF	48.98	49.07	48.71	48.7695	12228009.0
2008-05-07 12:00:00	QQQ	ETF	48.77	48.85	48.64	48.76	11688024.0
2008-05-07 13:00:00	QQQ	ETF	48.77	48.775	48.3	48.38	14860306.0
2008-05-07 14:00:00	QQQ	ETF	48.39	48.46	48.01	48.13	28174311.0
2008-05-07 15:00:00	QQQ	ETF	48.12	48.16	47.872	48.07	30248693.0
2008-05-07 16:00:00	QQQ	ETF	48.06	48.4782	47.8987	48.14	7416231.0
2008-05-07 17:00:00	QQQ	ETF	48.14	48.15	48.1	48.14	37339.0
2008-05-07 18:00:00	QQQ	ETF	48.14	48.16	48.12	48.13	48939.0
2008-05-07 19:00:00	QQQ	ETF	48.13	48.16	48.13	48.15	103515.0
2008-05-07 04:00:00	IWM	ETF	72.67	72.67	72.67	72.67	100.0
2008-05-07 06:00:00	IWM	ETF	72.94	72.94	72.92	72.92	5200.0
2008-05-07 07:00:00	IWM	ETF	72.87	72.87	72.72	72.77	131000.0
2008-05-07 08:00:00	IWM	ETF	72.75	73.09	72.75	72.98	450983.0
2008-05-07 09:00:00	IWM	ETF	72.95	73.03	72.71	72.79	4253423.0
2008-05-07 10:00:00	IWM	ETF	72.8	73.22	72.67	72.99	9899264.0
2008-05-07 11:00:00	IWM	ETF	73.0	73.04	72.57	72.62	4957789.0
2008-05-07 12:00:00	IWM	ETF	72.62	72.77	72.56	72.75	2552178.0
2008-05-07 13:00:00	IWM	ETF	72.74	72.75	72.13	72.18	5515797.0
2008-05-07 14:00:00	IWM	ETF	72.17	72.25	71.65	71.79	10526236.0
2008-05-07 15:00:00	IWM	ETF	71.78	71.83	71.34	71.57	15942953.0
2008-05-07 16:00:00	IWM	ETF	71.57	72.2	71.54	71.58	1727497.0
2008-05-07 17:00:00	IWM	ETF	71.63	71.68	71.63	71.66	314718.0
2008-05-07 18:00:00	IWM	ETF	71.63	71.7	71.63	71.7	944.0
2008-05-07 19:00:00	IWM	ETF	71.61	71.7	71.61	71.7	2048.0
2008-05-07 08:00:00	DIA	ETF	130.03	130.43	130.03	130.36	18410.0
2008-05-07 09:00:00	DIA	ETF	130.35	130.36	129.86	130.11	929002.0
2008-05-07 10:00:00	DIA	ETF	130.11	130.37	129.88	129.94	1636968.0
2008-05-07 11:00:00	DIA	ETF	129.94	129.97	129.46	129.53	1739763.0

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

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