PREVIEW / etf_1hour / 2007-12-24

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-12-24.parquet
  size:    61 KB
  rows:    1,938

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
2007-12-24 06:00:00	SPY	ETF	148.35	148.35	148.35	148.35	2200.0
2007-12-24 07:00:00	SPY	ETF	148.41	148.65	148.22	148.51	223600.0
2007-12-24 08:00:00	SPY	ETF	148.5	148.83	148.46	148.79	858600.0
2007-12-24 09:00:00	SPY	ETF	148.8	149.27	148.48	149.1	10248604.0
2007-12-24 10:00:00	SPY	ETF	149.1	149.27	148.89	149.0	8626732.0
2007-12-24 11:00:00	SPY	ETF	149.0	149.11	148.99	148.99	3973016.0
2007-12-24 12:00:00	SPY	ETF	148.99	149.48	148.98	149.45	18276315.0
2007-12-24 13:00:00	SPY	ETF	149.45	149.46	149.2	149.37	1543300.0
2007-12-24 14:00:00	SPY	ETF	149.3	149.38	149.25	149.38	5200.0
2007-12-24 15:00:00	SPY	ETF	149.31	149.31	149.2	149.2	5600.0
2007-12-24 16:00:00	SPY	ETF	149.32	149.33	149.26	149.26	800.0
2007-12-24 07:00:00	QQQ	ETF	51.93	52.01	51.91	51.99	233200.0
2007-12-24 08:00:00	QQQ	ETF	51.99	52.03	51.99	52.02	548801.0
2007-12-24 09:00:00	QQQ	ETF	52.02	52.27	51.9501	52.17	10097292.0
2007-12-24 10:00:00	QQQ	ETF	52.18	52.27	52.14	52.24	7150153.0
2007-12-24 11:00:00	QQQ	ETF	52.25	52.25	52.19	52.21	4207419.0
2007-12-24 12:00:00	QQQ	ETF	52.21	52.4	52.2	52.3	11044221.0
2007-12-24 13:00:00	QQQ	ETF	52.3	52.32	52.21	52.23	1203617.0
2007-12-24 14:00:00	QQQ	ETF	52.23	52.25	52.22	52.25	11140.0
2007-12-24 15:00:00	QQQ	ETF	52.24	52.25	52.23	52.23	3350.0
2007-12-24 16:00:00	QQQ	ETF	52.24	52.25	52.23	52.23	700.0
2007-12-24 08:00:00	IWM	ETF	78.65	78.75	78.61	78.71	97700.0
2007-12-24 09:00:00	IWM	ETF	78.72	79.17	78.59	78.92	6018985.0
2007-12-24 10:00:00	IWM	ETF	78.91	79.01	78.8	78.93	6328954.0
2007-12-24 11:00:00	IWM	ETF	78.93	79.11	78.92	79.02	4462121.0
2007-12-24 12:00:00	IWM	ETF	79.02	79.33	79.0	79.17	8252165.0
2007-12-24 13:00:00	IWM	ETF	79.18	79.4	78.38	78.38	4706100.0
2007-12-24 16:00:00	IWM	ETF	79.35	79.35	79.35	79.35	1000.0
2007-12-24 07:00:00	DIA	ETF	134.5	134.5	134.5	134.5	1400.0
2007-12-24 08:00:00	DIA	ETF	134.72	134.78	134.64	134.75	36800.0
2007-12-24 09:00:00	DIA	ETF	134.82	135.4	134.74	135.25	949488.0
2007-12-24 10:00:00	DIA	ETF	135.25	135.36	135.0	135.13	1065097.0
2007-12-24 11:00:00	DIA	ETF	135.14	135.26	135.11	135.15	612200.0
2007-12-24 12:00:00	DIA	ETF	135.15	135.48	135.14	135.45	865700.0
2007-12-24 13:00:00	DIA	ETF	135.46	135.47	134.9	135.34	125200.0
2007-12-24 07:00:00	GLD	ETF	80.3	80.36	80.3	80.36	5100.0
2007-12-24 08:00:00	GLD	ETF	80.35	80.38	79.99	80.07	82000.0
2007-12-24 09:00:00	GLD	ETF	80.07	80.54	80.07	80.51	1123000.0
2007-12-24 10:00:00	GLD	ETF	80.51	80.63	80.17	80.27	930500.0
2007-12-24 11:00:00	GLD	ETF	80.27	80.39	80.24	80.29	316100.0
2007-12-24 12:00:00	GLD	ETF	80.29	80.4	80.24	80.35	392000.0
2007-12-24 13:00:00	GLD	ETF	80.36	80.36	80.14	80.24	14500.0
2007-12-24 14:00:00	GLD	ETF	80.17	80.17	80.16	80.16	300.0
2007-12-24 08:00:00	TLT	ETF	91.55	91.67	91.55	91.67	12100.0
2007-12-24 09:00:00	TLT	ETF	91.13	91.36	91.08	91.28	141700.0
2007-12-24 10:00:00	TLT	ETF	91.27	91.47	91.25	91.3	284500.0
2007-12-24 11:00:00	TLT	ETF	91.29	91.29	91.19	91.26	36100.0
2007-12-24 12:00:00	TLT	ETF	91.28	91.28	91.19	91.22	67657.0
2007-12-24 13:00:00	TLT	ETF	91.17	91.24	91.17	91.24	8200.0

> showing 49 of 1,938 rows — these rows as CSV

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