PREVIEW / etf_1hour / 2008-05-06

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-05-06.parquet
  size:    106 KB
  rows:    3,343

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-06 04:00:00	SPY	ETF	140.85	140.85	140.81	140.81	1600.0
2008-05-06 05:00:00	SPY	ETF	140.72	140.76	140.72	140.76	3100.0
2008-05-06 06:00:00	SPY	ETF	140.62	140.62	140.49	140.56	257200.0
2008-05-06 07:00:00	SPY	ETF	140.55	140.57	139.99	140.07	1503295.0
2008-05-06 08:00:00	SPY	ETF	140.06	141.21	139.89	139.91	4031719.0
2008-05-06 09:00:00	SPY	ETF	139.91	140.11	139.69	139.95	17669102.0
2008-05-06 10:00:00	SPY	ETF	139.95	140.62	139.85	140.6	25069372.0
2008-05-06 11:00:00	SPY	ETF	140.6	140.86	140.4	140.86	20688549.0
2008-05-06 12:00:00	SPY	ETF	140.85	141.71	140.83	141.62	29083782.0
2008-05-06 13:00:00	SPY	ETF	141.62	141.77	141.41	141.61	20977866.0
2008-05-06 14:00:00	SPY	ETF	141.608	141.87	141.22	141.81	20668474.0
2008-05-06 15:00:00	SPY	ETF	141.81	142.2	141.69	141.84	26047360.0
2008-05-06 16:00:00	SPY	ETF	141.8699	142.25	140.7543	142.15	6701508.0
2008-05-06 17:00:00	SPY	ETF	142.11	142.11	140.7543	141.97	2580446.0
2008-05-06 18:00:00	SPY	ETF	141.95	142.06	141.94	142.06	14532.0
2008-05-06 19:00:00	SPY	ETF	142.07	142.2	142.06	142.2	11606.0
2008-05-06 05:00:00	QQQ	ETF	48.59	48.59	48.59	48.59	100.0
2008-05-06 06:00:00	QQQ	ETF	48.55	48.55	48.53	48.53	2700.0
2008-05-06 07:00:00	QQQ	ETF	48.53	48.53	48.38	48.39	370648.0
2008-05-06 08:00:00	QQQ	ETF	48.4	48.47	48.36	48.42	1085855.0
2008-05-06 09:00:00	QQQ	ETF	48.42	48.51	48.14	48.23	17825517.0
2008-05-06 10:00:00	QQQ	ETF	48.24	48.57	48.15	48.55	18420286.0
2008-05-06 11:00:00	QQQ	ETF	48.55	48.62	48.3	48.61	14482377.0
2008-05-06 12:00:00	QQQ	ETF	48.62	48.92	48.61	48.86	13080103.0
2008-05-06 13:00:00	QQQ	ETF	48.87	48.95	48.5	48.89	10451935.0
2008-05-06 14:00:00	QQQ	ETF	48.889	49.05	48.5791	49.0	11916895.0
2008-05-06 15:00:00	QQQ	ETF	49.0	49.13	48.9	48.95	17663840.0
2008-05-06 16:00:00	QQQ	ETF	48.94	49.21	48.6024	49.15	12324805.0
2008-05-06 17:00:00	QQQ	ETF	48.93	49.15	48.92	49.06	6020405.0
2008-05-06 18:00:00	QQQ	ETF	49.05	49.08	49.04	49.08	69010.0
2008-05-06 19:00:00	QQQ	ETF	49.06	49.09	49.06	49.07	18815.0
2008-05-06 06:00:00	IWM	ETF	72.06	72.06	71.99	71.99	4200.0
2008-05-06 07:00:00	IWM	ETF	72.01	72.01	71.8	71.82	98300.0
2008-05-06 08:00:00	IWM	ETF	72.02	72.02	71.78	71.81	146109.0
2008-05-06 09:00:00	IWM	ETF	71.8	72.04	71.67	71.83	8450563.0
2008-05-06 10:00:00	IWM	ETF	71.82	72.31	71.76	72.3	8877719.0
2008-05-06 11:00:00	IWM	ETF	72.3	72.5	72.19	72.47	6457511.0
2008-05-06 12:00:00	IWM	ETF	72.48	72.9	72.46	72.81	8638579.0
2008-05-06 13:00:00	IWM	ETF	72.81	72.92	72.63	72.76	4222685.0
2008-05-06 14:00:00	IWM	ETF	72.75	72.87	72.41	72.82	5952054.0
2008-05-06 15:00:00	IWM	ETF	72.83	73.07	72.5	72.64	9716800.0
2008-05-06 16:00:00	IWM	ETF	72.65	72.95	72.47	72.88	2286597.0
2008-05-06 17:00:00	IWM	ETF	72.84	72.86	72.55	72.69	68593.0
2008-05-06 18:00:00	IWM	ETF	72.72	72.81	72.7	72.7	22920.0
2008-05-06 19:00:00	IWM	ETF	72.82	72.82	72.82	72.82	195.0
2008-05-06 07:00:00	DIA	ETF	129.42	129.42	129.07	129.1	4300.0
2008-05-06 08:00:00	DIA	ETF	129.15	129.31	129.05	129.05	43630.0
2008-05-06 09:00:00	DIA	ETF	129.06	129.7	128.58	128.76	1458962.0
2008-05-06 10:00:00	DIA	ETF	128.73	129.21	128.7	129.2	1205001.0
2008-05-06 11:00:00	DIA	ETF	129.2	129.34	129.0	129.33	1467275.0

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

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