PREVIEW / etf_1hour / 2007-11-23

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-11-23.parquet
  size:    59 KB
  rows:    1,819

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-23 04:00:00	SPY	ETF	142.71	142.88	142.68	142.88	26000.0
2007-11-23 05:00:00	SPY	ETF	142.98	143.0	142.83	142.83	6500.0
2007-11-23 06:00:00	SPY	ETF	142.72	142.72	142.66	142.68	16000.0
2007-11-23 07:00:00	SPY	ETF	142.71	143.04	142.56	142.96	383400.0
2007-11-23 08:00:00	SPY	ETF	142.99	143.15	142.1	143.12	1933300.0
2007-11-23 09:00:00	SPY	ETF	143.12	143.26	142.7	143.0	15764021.0
2007-11-23 10:00:00	SPY	ETF	143.0	143.51	142.94	143.5	13869142.0
2007-11-23 11:00:00	SPY	ETF	143.5	144.0	143.3	143.9	16764895.0
2007-11-23 12:00:00	SPY	ETF	143.89	144.34	143.67	144.18	23744814.0
2007-11-23 13:00:00	SPY	ETF	144.17	144.25	142.57	143.81	2395100.0
2007-11-23 14:00:00	SPY	ETF	143.82	143.94	143.6	143.9	14100.0
2007-11-23 15:00:00	SPY	ETF	143.86	143.95	143.8	143.93	6300.0
2007-11-23 16:00:00	SPY	ETF	144.13	144.13	143.95	143.95	3500.0
2007-11-23 04:00:00	QQQ	ETF	49.52	49.52	49.52	49.52	17000.0
2007-11-23 05:00:00	QQQ	ETF	49.62	49.62	49.62	49.62	10000.0
2007-11-23 06:00:00	QQQ	ETF	49.54	49.57	49.52	49.52	40600.0
2007-11-23 07:00:00	QQQ	ETF	49.53	49.6	49.49	49.6	134148.0
2007-11-23 08:00:00	QQQ	ETF	49.61	49.72	49.35	49.68	914911.0
2007-11-23 09:00:00	QQQ	ETF	49.68	49.69	49.3724	49.49	10147085.0
2007-11-23 10:00:00	QQQ	ETF	49.5	49.6	49.45	49.54	7687522.0
2007-11-23 11:00:00	QQQ	ETF	49.54	49.76	49.44	49.6801	11493167.0
2007-11-23 12:00:00	QQQ	ETF	49.69	49.97	49.65	49.89	14971659.0
2007-11-23 13:00:00	QQQ	ETF	49.88	49.88	49.47	49.84	998391.0
2007-11-23 14:00:00	QQQ	ETF	49.83	49.84	49.77	49.8	38900.0
2007-11-23 15:00:00	QQQ	ETF	49.82	49.82	49.8	49.81	13360.0
2007-11-23 16:00:00	QQQ	ETF	49.83	49.83	49.82	49.83	5790.0
2007-11-23 07:00:00	IWM	ETF	74.15	74.28	74.14	74.23	31700.0
2007-11-23 08:00:00	IWM	ETF	74.26	74.43	74.2	74.43	83300.0
2007-11-23 09:00:00	IWM	ETF	74.42	74.6	74.11	74.33	6121060.0
2007-11-23 10:00:00	IWM	ETF	74.34	74.9	74.31	74.89	5873733.0
2007-11-23 11:00:00	IWM	ETF	74.89	75.11	74.85	75.05	8894050.0
2007-11-23 12:00:00	IWM	ETF	75.06	76.0	74.98	75.2	24604961.0
2007-11-23 13:00:00	IWM	ETF	75.2	75.26	74.9	74.9	5240300.0
2007-11-23 14:00:00	IWM	ETF	74.85	74.85	74.85	74.85	100.0
2007-11-23 15:00:00	IWM	ETF	74.91	74.91	74.91	74.91	100.0
2007-11-23 07:00:00	DIA	ETF	128.54	128.75	128.54	128.75	3200.0
2007-11-23 08:00:00	DIA	ETF	128.74	128.84	128.63	128.83	23100.0
2007-11-23 09:00:00	DIA	ETF	128.82	129.0	128.61	128.83	1464378.0
2007-11-23 10:00:00	DIA	ETF	128.84	129.04	128.75	129.04	978706.0
2007-11-23 11:00:00	DIA	ETF	129.05	129.32	128.89	129.19	1488108.0
2007-11-23 12:00:00	DIA	ETF	129.2	129.68	129.11	129.67	2803347.0
2007-11-23 13:00:00	DIA	ETF	129.67	129.67	127.96	129.23	498500.0
2007-11-23 14:00:00	DIA	ETF	129.4	129.4	129.15	129.15	1600.0
2007-11-23 15:00:00	DIA	ETF	129.4	129.4	129.4	129.4	1600.0
2007-11-23 04:00:00	GLD	ETF	80.05	80.05	80.05	80.05	100.0
2007-11-23 07:00:00	GLD	ETF	80.05	80.11	80.03	80.06	40800.0
2007-11-23 08:00:00	GLD	ETF	80.06	80.49	79.98	80.34	523600.0
2007-11-23 09:00:00	GLD	ETF	80.33	80.85	80.11	80.47	1216500.0
2007-11-23 10:00:00	GLD	ETF	80.45	80.67	80.43	80.65	917700.0
2007-11-23 11:00:00	GLD	ETF	80.66	81.49	80.54	81.28	1498600.0

> showing 50 of 1,819 rows — these rows as CSV

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