PREVIEW / etf_1hour / 2007-11-01

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-11-01.parquet
  size:    95 KB
  rows:    3,204

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-11-01 04:00:00	SPY	ETF	154.5	154.5	154.29	154.29	600.0
2007-11-01 05:00:00	SPY	ETF	154.4	154.4	154.23	154.32	16100.0
2007-11-01 06:00:00	SPY	ETF	154.27	154.45	154.22	154.4	23600.0
2007-11-01 07:00:00	SPY	ETF	154.43	154.43	154.04	154.12	1218800.0
2007-11-01 08:00:00	SPY	ETF	154.1	154.65	152.9	153.05	14168000.0
2007-11-01 09:00:00	SPY	ETF	153.04	154.48	152.05	152.67	38876834.0
2007-11-01 10:00:00	SPY	ETF	152.67	152.99	151.75	152.87	67692357.0
2007-11-01 11:00:00	SPY	ETF	152.88	152.89	152.13	152.64	34829146.0
2007-11-01 12:00:00	SPY	ETF	152.65	153.11	152.39	152.71	27409428.0
2007-11-01 13:00:00	SPY	ETF	152.73	152.94	151.78	151.86	30058533.0
2007-11-01 14:00:00	SPY	ETF	151.86	152.55	151.19	152.38	36395625.0
2007-11-01 15:00:00	SPY	ETF	152.38	152.51	150.59	150.78	64076313.0
2007-11-01 16:00:00	SPY	ETF	150.78	154.3	150.76	150.89	14141500.0
2007-11-01 17:00:00	SPY	ETF	150.88	150.91	150.7	150.78	173000.0
2007-11-01 18:00:00	SPY	ETF	150.74	151.04	150.74	151.04	81300.0
2007-11-01 19:00:00	SPY	ETF	151.0	151.15	150.94	151.03	69900.0
2007-11-01 05:00:00	QQQ	ETF	54.89	54.95	54.89	54.94	90100.0
2007-11-01 06:00:00	QQQ	ETF	54.95	55.0	54.94	54.99	141000.0
2007-11-01 07:00:00	QQQ	ETF	55.01	55.01	54.86	54.91	246626.0
2007-11-01 08:00:00	QQQ	ETF	54.89	54.94	54.55	54.61	2695502.0
2007-11-01 09:00:00	QQQ	ETF	54.64	54.77	54.41	54.62	28549817.0
2007-11-01 10:00:00	QQQ	ETF	54.61	54.68	54.24	54.642	30299410.0
2007-11-01 11:00:00	QQQ	ETF	54.64	54.68	54.43	54.59	14830968.0
2007-11-01 12:00:00	QQQ	ETF	54.59	54.68	54.5	54.61	13319458.0
2007-11-01 13:00:00	QQQ	ETF	54.61	54.75	54.28	54.33	17752266.0
2007-11-01 14:00:00	QQQ	ETF	54.32	54.61	54.31	54.56	17071134.0
2007-11-01 15:00:00	QQQ	ETF	54.57	54.65	53.97	54.0	52175296.0
2007-11-01 16:00:00	QQQ	ETF	54.018	54.68	54.0	54.1	6718946.0
2007-11-01 17:00:00	QQQ	ETF	54.1	54.11	54.0	54.08	132684.0
2007-11-01 18:00:00	QQQ	ETF	54.08	54.13	54.07	54.11	21922.0
2007-11-01 19:00:00	QQQ	ETF	54.12	54.17	54.12	54.13	33956.0
2007-11-01 04:00:00	IWM	ETF	82.23	82.23	82.22	82.22	500.0
2007-11-01 07:00:00	IWM	ETF	82.2	82.2	81.95	82.01	58000.0
2007-11-01 08:00:00	IWM	ETF	82.03	82.32	81.29	81.42	1067700.0
2007-11-01 09:00:00	IWM	ETF	81.32	82.47	79.98	80.5	24851082.0
2007-11-01 10:00:00	IWM	ETF	80.5	80.91	79.7	80.73	37509209.0
2007-11-01 11:00:00	IWM	ETF	80.72	80.72	80.0	80.39	14990149.0
2007-11-01 12:00:00	IWM	ETF	80.39	80.52	79.99	80.18	12661988.0
2007-11-01 13:00:00	IWM	ETF	80.18	80.44	79.66	79.82	16499151.0
2007-11-01 14:00:00	IWM	ETF	79.82	80.17	79.75	80.0	23760458.0
2007-11-01 15:00:00	IWM	ETF	80.0	80.1	79.0	79.33	34440037.0
2007-11-01 16:00:00	IWM	ETF	79.32	79.94	79.01	79.03	5042600.0
2007-11-01 17:00:00	IWM	ETF	79.03	79.08	79.01	79.03	35600.0
2007-11-01 18:00:00	IWM	ETF	79.05	79.16	78.96	79.16	40800.0
2007-11-01 19:00:00	IWM	ETF	79.12	79.15	79.1	79.15	2600.0
2007-11-01 07:00:00	DIA	ETF	138.53	138.53	138.42	138.47	6100.0
2007-11-01 08:00:00	DIA	ETF	138.46	138.46	137.54	137.67	256800.0
2007-11-01 09:00:00	DIA	ETF	137.66	137.9	136.87	137.27	2726134.0
2007-11-01 10:00:00	DIA	ETF	137.27	137.38	136.58	137.36	4266017.0
2007-11-01 11:00:00	DIA	ETF	137.37	137.38	136.84	137.13	2633294.0

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

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