PREVIEW / etf_1hour / 2006-05-23

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-05-23.parquet
  size:    46 KB
  rows:    1,421

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
2006-05-23 04:00:00	SPY	ETF	126.81	126.81	126.81	126.81	100.0
2006-05-23 05:00:00	SPY	ETF	126.77	126.8	126.77	126.8	2300.0
2006-05-23 06:00:00	SPY	ETF	126.6	126.7	126.6	126.67	25500.0
2006-05-23 07:00:00	SPY	ETF	126.65	126.89	126.61	126.81	389300.0
2006-05-23 08:00:00	SPY	ETF	126.81	127.06	126.6	127.0	2679000.0
2006-05-23 09:00:00	SPY	ETF	126.99	127.45	126.97	127.23	12334200.0
2006-05-23 10:00:00	SPY	ETF	127.23	127.63	126.93	127.3876	12088700.0
2006-05-23 11:00:00	SPY	ETF	127.39	127.51	127.1	127.16	8232800.0
2006-05-23 12:00:00	SPY	ETF	127.16	127.25	126.97	127.05	6566900.0
2006-05-23 13:00:00	SPY	ETF	127.06	127.46	127.04	127.21	5791000.0
2006-05-23 14:00:00	SPY	ETF	127.21	127.29	126.72	126.82	10413200.0
2006-05-23 15:00:00	SPY	ETF	126.82	127.06	125.81	125.86	18826700.0
2006-05-23 16:00:00	SPY	ETF	125.85	125.88	124.69	124.8	6350500.0
2006-05-23 17:00:00	SPY	ETF	124.79	125.2	124.67	124.69	1639800.0
2006-05-23 18:00:00	SPY	ETF	124.7	125.0	124.68	124.8	47100.0
2006-05-23 19:00:00	SPY	ETF	124.78	124.8	124.74	124.79	13700.0
2006-05-23 09:00:00	QQQ	ETF	39.27	39.36	39.2	39.25	15300900.0
2006-05-23 10:00:00	QQQ	ETF	39.26	39.38	39.18	39.35	15201000.0
2006-05-23 11:00:00	QQQ	ETF	39.35	39.37	39.17	39.27	13180800.0
2006-05-23 12:00:00	QQQ	ETF	39.26	39.32	39.2	39.2	7409500.0
2006-05-23 13:00:00	QQQ	ETF	39.21	39.35	39.2	39.23	9055100.0
2006-05-23 14:00:00	QQQ	ETF	39.23	39.27	38.98	39.01	21442100.0
2006-05-23 15:00:00	QQQ	ETF	39.01	39.2	38.57	38.57	36990700.0
2006-05-23 08:00:00	IWM	ETF	71.61	71.78	71.59	71.78	292500.0
2006-05-23 09:00:00	IWM	ETF	71.77	72.29	71.77	72.0	18732200.0
2006-05-23 10:00:00	IWM	ETF	72.0	72.39	71.92	72.09	12379400.0
2006-05-23 11:00:00	IWM	ETF	72.09	72.14	71.79	71.8	3569700.0
2006-05-23 12:00:00	IWM	ETF	71.81	71.91	71.65	71.68	2456500.0
2006-05-23 13:00:00	IWM	ETF	71.68	72.03	71.097	71.82	5817200.0
2006-05-23 14:00:00	IWM	ETF	71.81	71.86	71.32	71.39	6383400.0
2006-05-23 15:00:00	IWM	ETF	71.37	71.51	70.57	70.61	18293300.0
2006-05-23 16:00:00	IWM	ETF	70.61	70.71	69.71	69.81	2358200.0
2006-05-23 17:00:00	IWM	ETF	69.81	70.18	69.7	69.83	1592100.0
2006-05-23 18:00:00	IWM	ETF	69.8	69.83	69.77	69.83	3100.0
2006-05-23 19:00:00	IWM	ETF	69.8	69.8	69.8	69.8	100.0
2006-05-23 07:00:00	DIA	ETF	111.46	111.46	111.42	111.42	30200.0
2006-05-23 08:00:00	DIA	ETF	111.45	111.6	111.37	111.42	55800.0
2006-05-23 09:00:00	DIA	ETF	111.49	111.85	111.48	111.59	1659400.0
2006-05-23 10:00:00	DIA	ETF	111.6	111.94	111.51	111.78	1696100.0
2006-05-23 11:00:00	DIA	ETF	111.79	111.81	111.51	111.62	1063100.0
2006-05-23 12:00:00	DIA	ETF	111.62	111.74	111.49	111.59	843600.0
2006-05-23 13:00:00	DIA	ETF	111.59	111.88	111.59	111.73	582100.0
2006-05-23 14:00:00	DIA	ETF	111.72	111.84	111.44	111.49	967700.0
2006-05-23 15:00:00	DIA	ETF	111.51	111.75	110.87	110.9	2147000.0
2006-05-23 16:00:00	DIA	ETF	110.9	110.9	110.03	110.05	290300.0
2006-05-23 17:00:00	DIA	ETF	110.1	110.13	109.98	110.0	15800.0
2006-05-23 18:00:00	DIA	ETF	109.98	111.1565	109.95	109.95	206500.0
2006-05-23 19:00:00	DIA	ETF	109.95	109.95	109.91	109.91	900.0
2006-05-23 07:00:00	GLD	ETF	65.8	65.81	65.43	65.47	3600.0
2006-05-23 08:00:00	GLD	ETF	65.45	65.95	65.45	65.88	106100.0

> showing 50 of 1,421 rows — these rows as CSV

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