PREVIEW / etf_1hour / 2007-10-09

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-10-09.parquet
  size:    84 KB
  rows:    2,838

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-09 06:00:00	SPY	ETF	155.32	155.34	155.32	155.34	95300.0
2007-10-09 07:00:00	SPY	ETF	155.36	155.44	155.36	155.43	231900.0
2007-10-09 08:00:00	SPY	ETF	155.42	155.65	155.39	155.55	1417100.0
2007-10-09 09:00:00	SPY	ETF	155.58	155.71	155.44	155.49	10652836.0
2007-10-09 10:00:00	SPY	ETF	155.48	155.55	155.18	155.54	15476200.0
2007-10-09 11:00:00	SPY	ETF	155.54	155.65	155.38	155.56	8626299.0
2007-10-09 12:00:00	SPY	ETF	155.56	155.59	155.25	155.3501	4494300.0
2007-10-09 13:00:00	SPY	ETF	155.35	155.41	155.03	155.31	8950389.0
2007-10-09 14:00:00	SPY	ETF	155.3	156.1	155.11	156.04	18416796.0
2007-10-09 15:00:00	SPY	ETF	156.05	156.44	155.89	156.41	19013189.0
2007-10-09 16:00:00	SPY	ETF	156.41	156.51	155.1357	156.35	4331100.0
2007-10-09 17:00:00	SPY	ETF	156.36	156.36	156.25	156.25	307800.0
2007-10-09 18:00:00	SPY	ETF	156.29	156.48	156.25	156.32	187000.0
2007-10-09 19:00:00	SPY	ETF	156.33	156.33	156.24	156.24	1800.0
2007-10-09 04:00:00	QQQ	ETF	53.14	53.15	53.14	53.15	6000.0
2007-10-09 05:00:00	QQQ	ETF	53.14	53.14	53.14	53.14	500.0
2007-10-09 06:00:00	QQQ	ETF	53.17	53.17	53.17	53.17	500.0
2007-10-09 07:00:00	QQQ	ETF	53.2	53.23	53.19	53.23	60138.0
2007-10-09 08:00:00	QQQ	ETF	53.22	53.3	53.21	53.27	330771.0
2007-10-09 09:00:00	QQQ	ETF	53.27	53.34	53.2	53.22	13658905.0
2007-10-09 10:00:00	QQQ	ETF	53.22	53.25	53.07	53.21	14746235.0
2007-10-09 11:00:00	QQQ	ETF	53.21	53.27	53.14	53.24	8464325.0
2007-10-09 12:00:00	QQQ	ETF	53.24	53.26	53.13	53.16	5539706.0
2007-10-09 13:00:00	QQQ	ETF	53.16	53.18	53.03	53.16	12460743.0
2007-10-09 14:00:00	QQQ	ETF	53.16	53.38	53.09	53.3685	17796464.0
2007-10-09 15:00:00	QQQ	ETF	53.36	53.45	53.28	53.38	13259718.0
2007-10-09 16:00:00	QQQ	ETF	53.38	53.45	53.1785	53.3801	7895068.0
2007-10-09 17:00:00	QQQ	ETF	53.42	53.42	53.38	53.39	51117.0
2007-10-09 18:00:00	QQQ	ETF	53.39	53.4	53.35	53.36	229800.0
2007-10-09 19:00:00	QQQ	ETF	53.38	53.4	53.35	53.39	12389.0
2007-10-09 07:00:00	IWM	ETF	83.74	83.81	83.74	83.81	3000.0
2007-10-09 08:00:00	IWM	ETF	83.79	83.9	83.78	83.83	65300.0
2007-10-09 09:00:00	IWM	ETF	83.83	83.95	83.67	83.74	6101088.0
2007-10-09 10:00:00	IWM	ETF	83.75	83.79	83.31	83.65	8477400.0
2007-10-09 11:00:00	IWM	ETF	83.66	83.76	83.55	83.73	2784900.0
2007-10-09 12:00:00	IWM	ETF	83.72	83.76	83.45	83.57	2268800.0
2007-10-09 13:00:00	IWM	ETF	83.57	83.6	83.3	83.5	7255000.0
2007-10-09 14:00:00	IWM	ETF	83.51	84.19	83.35	84.15	15285800.0
2007-10-09 15:00:00	IWM	ETF	84.14	84.33	84.02	84.19	9343500.0
2007-10-09 16:00:00	IWM	ETF	84.19	84.27	83.64	84.22	6498900.0
2007-10-09 17:00:00	IWM	ETF	84.21	84.3	84.14	84.3	133200.0
2007-10-09 18:00:00	IWM	ETF	84.2	84.2	84.2	84.2	1100.0
2007-10-09 19:00:00	IWM	ETF	84.2	84.2	84.2	84.2	4000.0
2007-10-09 08:00:00	DIA	ETF	140.6	140.68	140.59	140.65	27200.0
2007-10-09 09:00:00	DIA	ETF	140.68	140.78	140.63	140.65	769700.0
2007-10-09 10:00:00	DIA	ETF	140.65	140.72	140.44	140.72	1014900.0
2007-10-09 11:00:00	DIA	ETF	140.73	140.76	140.61	140.74	491700.0
2007-10-09 12:00:00	DIA	ETF	140.74	140.76	140.51	140.58	230700.0
2007-10-09 13:00:00	DIA	ETF	140.58	140.65	140.3	140.54	708600.0
2007-10-09 14:00:00	DIA	ETF	140.54	141.31	140.4	141.3	2374600.0

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

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