PREVIEW / etf_1hour / 2006-09-13

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-09-13.parquet
  size:    51 KB
  rows:    1,630

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-09-13 04:00:00	SPY	ETF	131.76	131.76	131.76	131.76	200.0
2006-09-13 05:00:00	SPY	ETF	131.73	131.73	131.69	131.69	300.0
2006-09-13 06:00:00	SPY	ETF	131.61	131.61	131.6	131.6	10000.0
2006-09-13 07:00:00	SPY	ETF	131.63	131.71	131.62	131.71	8300.0
2006-09-13 08:00:00	SPY	ETF	131.69	131.81	131.65	131.73	1341400.0
2006-09-13 09:00:00	SPY	ETF	131.73	131.91	131.52	131.83	7422400.0
2006-09-13 10:00:00	SPY	ETF	131.82	131.83	131.56	131.72	14048800.0
2006-09-13 11:00:00	SPY	ETF	131.71	132.04	131.69	132.01	7435400.0
2006-09-13 12:00:00	SPY	ETF	132.04	132.21	131.95	132.03	7259900.0
2006-09-13 13:00:00	SPY	ETF	132.03	132.23	131.96	132.17	4568100.0
2006-09-13 14:00:00	SPY	ETF	132.17	132.45	132.09	132.41	8937400.0
2006-09-13 15:00:00	SPY	ETF	132.41	132.41	132.07	132.25	9765900.0
2006-09-13 16:00:00	SPY	ETF	132.25	132.26	132.13	132.16	834800.0
2006-09-13 17:00:00	SPY	ETF	132.16	132.18	132.13	132.18	10400.0
2006-09-13 18:00:00	SPY	ETF	132.16	132.18	132.15	132.17	13700.0
2006-09-13 19:00:00	SPY	ETF	132.17	132.17	132.13	132.13	18600.0
2006-09-13 09:00:00	QQQ	ETF	39.73	39.93	39.63	39.86	20415800.0
2006-09-13 10:00:00	QQQ	ETF	39.86	39.89	39.65	39.76	26787200.0
2006-09-13 11:00:00	QQQ	ETF	39.75	39.95	39.74	39.94	16456800.0
2006-09-13 12:00:00	QQQ	ETF	39.94	39.98	39.81	39.82	9612200.0
2006-09-13 13:00:00	QQQ	ETF	39.82	39.9	39.77	39.85	7029600.0
2006-09-13 14:00:00	QQQ	ETF	39.85	39.98	39.85	39.97	10455200.0
2006-09-13 15:00:00	QQQ	ETF	39.96	39.98	39.79	39.95	16732000.0
2006-09-13 07:00:00	IWM	ETF	72.0	72.0	72.0	72.0	2000.0
2006-09-13 08:00:00	IWM	ETF	72.0	72.3	72.0	72.24	233600.0
2006-09-13 09:00:00	IWM	ETF	72.24	72.5	72.0	72.38	3599400.0
2006-09-13 10:00:00	IWM	ETF	72.37	72.48	72.03	72.22	4832600.0
2006-09-13 11:00:00	IWM	ETF	72.22	72.55	72.19	72.53	3395000.0
2006-09-13 12:00:00	IWM	ETF	72.54	72.75	72.41	72.58	5529200.0
2006-09-13 13:00:00	IWM	ETF	72.58	72.75	72.54	72.67	2766700.0
2006-09-13 14:00:00	IWM	ETF	72.66	72.88	72.6	72.84	5227300.0
2006-09-13 15:00:00	IWM	ETF	72.85	72.86	72.44	72.71	8658800.0
2006-09-13 16:00:00	IWM	ETF	72.7	72.76	72.66	72.67	307000.0
2006-09-13 17:00:00	IWM	ETF	72.69	72.69	72.67	72.69	800.0
2006-09-13 08:00:00	DIA	ETF	114.9	114.99	114.9	114.99	4300.0
2006-09-13 09:00:00	DIA	ETF	114.94	115.15	114.82	115.08	678000.0
2006-09-13 10:00:00	DIA	ETF	115.09	115.17	114.96	115.12	712600.0
2006-09-13 11:00:00	DIA	ETF	115.09	115.28	115.09	115.27	367200.0
2006-09-13 12:00:00	DIA	ETF	115.27	115.43	115.23	115.3	604900.0
2006-09-13 13:00:00	DIA	ETF	115.3	115.44	115.27	115.38	416100.0
2006-09-13 14:00:00	DIA	ETF	115.39	115.79	115.39	115.75	887000.0
2006-09-13 15:00:00	DIA	ETF	115.75	115.75	115.44	115.51	932600.0
2006-09-13 16:00:00	DIA	ETF	115.51	115.52	114.48	115.46	35200.0
2006-09-13 04:00:00	GLD	ETF	58.0	58.0	58.0	58.0	1400.0
2006-09-13 08:00:00	GLD	ETF	58.43	58.65	58.29	58.65	50900.0
2006-09-13 09:00:00	GLD	ETF	58.64	58.94	58.58	58.75	660100.0
2006-09-13 10:00:00	GLD	ETF	58.7401	58.7488	57.97	58.23	922000.0
2006-09-13 11:00:00	GLD	ETF	58.21	58.7	58.09	58.66	648000.0
2006-09-13 12:00:00	GLD	ETF	58.64	58.71	58.45	58.48	359600.0
2006-09-13 13:00:00	GLD	ETF	58.49	58.61	58.26	58.52	343700.0

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

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