PREVIEW / etf_1hour / 2007-12-06

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-12-06.parquet
  size:    96 KB
  rows:    3,175

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-06 04:00:00	SPY	ETF	149.1	149.14	149.04	149.14	3100.0
2007-12-06 06:00:00	SPY	ETF	149.36	149.58	149.35	149.45	109600.0
2007-12-06 07:00:00	SPY	ETF	149.66	149.67	149.0	149.17	1416500.0
2007-12-06 08:00:00	SPY	ETF	149.17	149.35	148.42	148.43	1855800.0
2007-12-06 09:00:00	SPY	ETF	148.42	149.34	148.38	149.16	12159817.0
2007-12-06 10:00:00	SPY	ETF	149.16	149.44	148.91	149.32	20902911.0
2007-12-06 11:00:00	SPY	ETF	149.32	149.61	149.04	149.53	15598577.0
2007-12-06 12:00:00	SPY	ETF	149.54	149.87	149.46	149.79	9010424.0
2007-12-06 13:00:00	SPY	ETF	149.79	149.91	149.4	149.5	14742249.0
2007-12-06 14:00:00	SPY	ETF	149.5	150.57	149.43	150.4	25262305.0
2007-12-06 15:00:00	SPY	ETF	150.4	151.21	150.39	151.11	38377328.0
2007-12-06 16:00:00	SPY	ETF	151.071	151.15	149.54	150.88	4743600.0
2007-12-06 17:00:00	SPY	ETF	150.84	150.94	150.1646	150.88	6391100.0
2007-12-06 18:00:00	SPY	ETF	150.87	150.91	150.82	150.83	29000.0
2007-12-06 19:00:00	SPY	ETF	150.81	150.85	150.79	150.83	16600.0
2007-12-06 04:00:00	QQQ	ETF	51.75	51.75	51.75	51.75	1500.0
2007-12-06 05:00:00	QQQ	ETF	51.86	51.89	51.85	51.89	32262.0
2007-12-06 06:00:00	QQQ	ETF	51.9	51.97	51.9	51.97	40800.0
2007-12-06 07:00:00	QQQ	ETF	51.95	51.97	51.77	51.8	231947.0
2007-12-06 08:00:00	QQQ	ETF	51.83	51.85	51.63	51.63	1070863.0
2007-12-06 09:00:00	QQQ	ETF	51.63	51.95	51.54	51.85	12376587.0
2007-12-06 10:00:00	QQQ	ETF	51.84	51.99	51.65	51.77	16177420.0
2007-12-06 11:00:00	QQQ	ETF	51.7701	51.85	51.65	51.82	9209218.0
2007-12-06 12:00:00	QQQ	ETF	51.82	51.92	51.78	51.91	6780876.0
2007-12-06 13:00:00	QQQ	ETF	51.91	51.94	51.72	51.76	10194174.0
2007-12-06 14:00:00	QQQ	ETF	51.76	52.16	51.75	52.08	13145901.0
2007-12-06 15:00:00	QQQ	ETF	52.0801	52.37	52.07	52.3299	24269941.0
2007-12-06 16:00:00	QQQ	ETF	52.32	52.3567	52.16	52.18	6018611.0
2007-12-06 17:00:00	QQQ	ETF	52.18	52.21	52.17	52.2	174372.0
2007-12-06 18:00:00	QQQ	ETF	52.21	52.22	52.19	52.21	14184.0
2007-12-06 19:00:00	QQQ	ETF	52.21	52.21	52.16	52.18	25343.0
2007-12-06 06:00:00	IWM	ETF	76.91	76.91	76.91	76.91	5000.0
2007-12-06 07:00:00	IWM	ETF	76.9	76.99	76.66	76.68	23500.0
2007-12-06 08:00:00	IWM	ETF	76.73	76.73	76.18	76.18	610100.0
2007-12-06 09:00:00	IWM	ETF	76.12	77.26	76.1	77.15	9921493.0
2007-12-06 10:00:00	IWM	ETF	77.15	77.45	76.96	77.34	11289210.0
2007-12-06 11:00:00	IWM	ETF	77.35	77.5	77.15	77.43	8504343.0
2007-12-06 12:00:00	IWM	ETF	77.43	77.71	77.43	77.68	5413057.0
2007-12-06 13:00:00	IWM	ETF	77.68	77.76	77.45	77.55	8332829.0
2007-12-06 14:00:00	IWM	ETF	77.54	78.22	77.53	78.12	14414767.0
2007-12-06 15:00:00	IWM	ETF	78.13	78.42	78.01	78.41	14593358.0
2007-12-06 16:00:00	IWM	ETF	78.41	78.44	76.35	78.23	20036150.0
2007-12-06 17:00:00	IWM	ETF	78.21	78.33	78.21	78.28	75200.0
2007-12-06 18:00:00	IWM	ETF	78.34	78.34	78.28	78.28	1800.0
2007-12-06 19:00:00	IWM	ETF	78.25	78.25	78.19	78.19	1900.0
2007-12-06 07:00:00	DIA	ETF	134.93	134.93	134.57	134.68	4600.0
2007-12-06 08:00:00	DIA	ETF	134.75	134.75	134.15	134.15	28300.0
2007-12-06 09:00:00	DIA	ETF	134.2	134.9	134.18	134.76	1128547.0
2007-12-06 10:00:00	DIA	ETF	134.77	134.97	134.62	134.9	1582098.0
2007-12-06 11:00:00	DIA	ETF	134.89	135.16	134.66	135.07	1507110.0

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

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