PREVIEW / etf_1hour / 2006-05-24

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-05-24.parquet
  size:    45 KB
  rows:    1,372

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-24 04:00:00	SPY	ETF	125.82	125.87	125.8	125.8	9200.0
2006-05-24 05:00:00	SPY	ETF	125.8	125.8	125.57	125.67	13700.0
2006-05-24 06:00:00	SPY	ETF	125.65	125.65	125.14	125.26	6300.0
2006-05-24 07:00:00	SPY	ETF	125.29	125.54	125.17	125.54	297800.0
2006-05-24 08:00:00	SPY	ETF	125.52	125.88	124.82	125.77	6007700.0
2006-05-24 09:00:00	SPY	ETF	125.77	126.31	125.38	126.21	17098600.0
2006-05-24 10:00:00	SPY	ETF	126.22	126.89	126.08	126.29	17544500.0
2006-05-24 11:00:00	SPY	ETF	126.3	126.32	125.55	126.08	23286500.0
2006-05-24 12:00:00	SPY	ETF	126.06	126.34	125.21	125.38	17454100.0
2006-05-24 13:00:00	SPY	ETF	125.39	125.73	124.76	125.54	30225300.0
2006-05-24 14:00:00	SPY	ETF	125.54	126.2	125.11	125.97	27521900.0
2006-05-24 15:00:00	SPY	ETF	125.99	126.55	125.51	126.09	23062100.0
2006-05-24 16:00:00	SPY	ETF	126.07	126.3	125.96	126.18	1776000.0
2006-05-24 17:00:00	SPY	ETF	126.23	126.33	126.21	126.31	347500.0
2006-05-24 18:00:00	SPY	ETF	126.3	126.3	126.24	126.27	12800.0
2006-05-24 19:00:00	SPY	ETF	126.29	126.35	126.29	126.35	8500.0
2006-05-24 09:00:00	QQQ	ETF	38.52	38.89	38.34	38.88	28876000.0
2006-05-24 10:00:00	QQQ	ETF	38.88	39.04	38.76	38.78	30872600.0
2006-05-24 11:00:00	QQQ	ETF	38.78	38.83	38.56	38.77	27194700.0
2006-05-24 12:00:00	QQQ	ETF	38.77	38.84	38.4	38.44	22809600.0
2006-05-24 13:00:00	QQQ	ETF	38.45	38.65	38.23	38.57	30522500.0
2006-05-24 14:00:00	QQQ	ETF	38.57	38.82	38.35	38.78	38977000.0
2006-05-24 15:00:00	QQQ	ETF	38.78	38.99	38.55	38.84	39284300.0
2006-05-24 07:00:00	IWM	ETF	70.5	70.5	70.08	70.08	500.0
2006-05-24 08:00:00	IWM	ETF	70.18	70.71	69.94	70.51	1480400.0
2006-05-24 09:00:00	IWM	ETF	70.48	71.12	70.02	70.98	11150500.0
2006-05-24 10:00:00	IWM	ETF	70.98	71.37	70.85	70.9501	11230700.0
2006-05-24 11:00:00	IWM	ETF	70.96	70.96	70.27	70.68	16661200.0
2006-05-24 12:00:00	IWM	ETF	70.67	70.9	69.72	69.87	14143300.0
2006-05-24 13:00:00	IWM	ETF	69.87	70.13	69.11	70.02	17038000.0
2006-05-24 14:00:00	IWM	ETF	70.01	70.89	69.31	70.48	28882400.0
2006-05-24 15:00:00	IWM	ETF	70.49	71.01	70.06	70.67	14726800.0
2006-05-24 16:00:00	IWM	ETF	70.67	71.0	70.62	70.79	1227700.0
2006-05-24 17:00:00	IWM	ETF	70.72	70.72	70.72	70.72	5046100.0
2006-05-24 19:00:00	IWM	ETF	70.81	70.81	70.79	70.79	500.0
2006-05-24 07:00:00	DIA	ETF	110.46	110.74	110.46	110.74	43200.0
2006-05-24 08:00:00	DIA	ETF	110.73	111.04	110.45	110.88	108700.0
2006-05-24 09:00:00	DIA	ETF	110.88	111.27	110.55	111.21	1870700.0
2006-05-24 10:00:00	DIA	ETF	111.21	111.57	111.09	111.29	2511000.0
2006-05-24 11:00:00	DIA	ETF	111.31	111.31	110.7	111.14	2311000.0
2006-05-24 12:00:00	DIA	ETF	111.12	111.3	110.51	110.62	1656200.0
2006-05-24 13:00:00	DIA	ETF	110.63	110.95	110.19	110.78	2001500.0
2006-05-24 14:00:00	DIA	ETF	110.78	111.23	110.42	111.01	2524700.0
2006-05-24 15:00:00	DIA	ETF	111.02	111.48	110.67	111.093	2076100.0
2006-05-24 16:00:00	DIA	ETF	111.09	111.23	110.97	111.15	224000.0
2006-05-24 17:00:00	DIA	ETF	111.14	111.14	111.1	111.1	3300.0
2006-05-24 18:00:00	DIA	ETF	111.14	111.14	111.14	111.14	20000.0
2006-05-24 07:00:00	GLD	ETF	66.08	66.08	65.84	65.88	3100.0
2006-05-24 08:00:00	GLD	ETF	66.09	66.09	64.74	65.24	386400.0
2006-05-24 09:00:00	GLD	ETF	65.2	65.21	64.58	65.0	1491300.0

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

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