PREVIEW / etf_1hour / 2007-10-30

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-10-30.parquet
  size:    86 KB
  rows:    2,933

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-10-30 06:00:00	SPY	ETF	153.77	153.77	153.56	153.65	137700.0
2007-10-30 07:00:00	SPY	ETF	153.69	153.74	153.45	153.45	317100.0
2007-10-30 08:00:00	SPY	ETF	153.47	153.73	153.35	153.41	3687600.0
2007-10-30 09:00:00	SPY	ETF	153.4	153.7	153.31	153.52	12085868.0
2007-10-30 10:00:00	SPY	ETF	153.51	153.57	153.0	153.48	26643980.0
2007-10-30 11:00:00	SPY	ETF	153.48	153.49	152.96	153.23	21131092.0
2007-10-30 12:00:00	SPY	ETF	153.23	153.439	153.14	153.3599	9995932.0
2007-10-30 13:00:00	SPY	ETF	153.36	153.75	153.3	153.66	12615001.0
2007-10-30 14:00:00	SPY	ETF	153.65	153.75	153.44	153.55	14732410.0
2007-10-30 15:00:00	SPY	ETF	153.55	153.7	152.87	153.06	25317827.0
2007-10-30 16:00:00	SPY	ETF	153.05	153.11	152.86	152.92	2413900.0
2007-10-30 17:00:00	SPY	ETF	152.89	152.99	152.86	152.98	42100.0
2007-10-30 18:00:00	SPY	ETF	152.99	152.99	152.87	152.87	30100.0
2007-10-30 19:00:00	SPY	ETF	152.87	152.94	152.87	152.94	6000.0
2007-10-30 05:00:00	QQQ	ETF	54.05	54.05	54.05	54.05	300.0
2007-10-30 07:00:00	QQQ	ETF	53.95	53.96	53.9	53.91	182119.0
2007-10-30 08:00:00	QQQ	ETF	53.91	54.04	53.89	53.89	1446114.0
2007-10-30 09:00:00	QQQ	ETF	53.9	54.15	53.86	54.08	14678098.0
2007-10-30 10:00:00	QQQ	ETF	54.07	54.25	53.9	54.22	15652445.0
2007-10-30 11:00:00	QQQ	ETF	54.22	54.22	54.04	54.128	11137099.0
2007-10-30 12:00:00	QQQ	ETF	54.12	54.24	54.08	54.21	7806297.0
2007-10-30 13:00:00	QQQ	ETF	54.21	54.45	54.17	54.36	12114182.0
2007-10-30 14:00:00	QQQ	ETF	54.37	54.47	54.33	54.4	7723995.0
2007-10-30 15:00:00	QQQ	ETF	54.4	54.56	54.21	54.26	35174743.0
2007-10-30 16:00:00	QQQ	ETF	54.26	54.36	54.15	54.26	8644081.0
2007-10-30 17:00:00	QQQ	ETF	54.19	54.26	54.18	54.23	57840.0
2007-10-30 18:00:00	QQQ	ETF	54.22	54.23	54.17	54.19	15221.0
2007-10-30 19:00:00	QQQ	ETF	54.19	54.2	54.18	54.18	14064.0
2007-10-30 06:00:00	IWM	ETF	81.73	81.73	81.62	81.62	20200.0
2007-10-30 07:00:00	IWM	ETF	81.64	81.7	81.57	81.57	68600.0
2007-10-30 08:00:00	IWM	ETF	81.58	81.7	81.44	81.47	158400.0
2007-10-30 09:00:00	IWM	ETF	81.46	81.96	81.44	81.8	9689822.0
2007-10-30 10:00:00	IWM	ETF	81.8	81.84	81.25	81.76	12991700.0
2007-10-30 11:00:00	IWM	ETF	81.77	81.77	81.21	81.34	10716400.0
2007-10-30 12:00:00	IWM	ETF	81.34	81.6	81.3	81.53	3961600.0
2007-10-30 13:00:00	IWM	ETF	81.53	81.73	81.45	81.6	4057900.0
2007-10-30 14:00:00	IWM	ETF	81.6	81.7	81.46	81.53	4042200.0
2007-10-30 15:00:00	IWM	ETF	81.52	81.65	80.97	80.98	11354000.0
2007-10-30 16:00:00	IWM	ETF	80.98	81.48	80.96	81.24	2852100.0
2007-10-30 17:00:00	IWM	ETF	81.25	81.25	81.24	81.25	52700.0
2007-10-30 18:00:00	IWM	ETF	81.27	81.27	81.27	81.27	1000.0
2007-10-30 07:00:00	DIA	ETF	138.37	138.37	138.19	138.2	8100.0
2007-10-30 08:00:00	DIA	ETF	138.18	138.32	138.07	138.12	24100.0
2007-10-30 09:00:00	DIA	ETF	138.11	138.36	138.07	138.23	624734.0
2007-10-30 10:00:00	DIA	ETF	138.22	138.26	137.79	138.25	1834600.0
2007-10-30 11:00:00	DIA	ETF	138.24	138.27	137.85	138.06	1153800.0
2007-10-30 12:00:00	DIA	ETF	138.03	138.55	137.98	138.16	1047100.0
2007-10-30 13:00:00	DIA	ETF	138.15	138.39	138.08	138.3	1517200.0
2007-10-30 14:00:00	DIA	ETF	138.3	138.38	138.17	138.3	595400.0
2007-10-30 15:00:00	DIA	ETF	138.3	138.35	137.66	137.83	1509400.0

> showing 50 of 2,933 rows — these rows as CSV

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