PREVIEW / etf_1hour / 2007-05-01

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-05-01.parquet
  size:    72 KB
  rows:    2,273

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-05-01 06:00:00	SPY	ETF	148.52	148.52	148.49	148.49	100000.0
2007-05-01 07:00:00	SPY	ETF	148.51	148.6	148.5	148.59	487200.0
2007-05-01 08:00:00	SPY	ETF	148.53	148.59	148.29	148.49	491800.0
2007-05-01 09:00:00	SPY	ETF	148.49	148.68	148.2	148.2601	15062176.0
2007-05-01 10:00:00	SPY	ETF	148.25	149.47	147.67	148.23	43259486.0
2007-05-01 11:00:00	SPY	ETF	148.23	148.43	148.03	148.07	18825263.0
2007-05-01 12:00:00	SPY	ETF	148.068	148.23	148.02	148.04	7327392.0
2007-05-01 13:00:00	SPY	ETF	148.03	148.37	147.76	148.261	14552779.0
2007-05-01 14:00:00	SPY	ETF	148.27	148.73	148.13	148.6028	16666336.0
2007-05-01 15:00:00	SPY	ETF	148.61	148.7	148.38	148.61	12585702.0
2007-05-01 16:00:00	SPY	ETF	148.61	148.72	148.57	148.62	2493500.0
2007-05-01 17:00:00	SPY	ETF	148.64	148.77	148.64	148.76	428000.0
2007-05-01 18:00:00	SPY	ETF	148.74	148.76	148.68	148.74	82400.0
2007-05-01 19:00:00	SPY	ETF	148.75	148.78	148.7	148.78	12400.0
2007-05-01 07:00:00	QQQ	ETF	46.0	46.05	46.0	46.05	271388.0
2007-05-01 08:00:00	QQQ	ETF	46.05	46.05	45.96	45.99	689585.0
2007-05-01 09:00:00	QQQ	ETF	45.98	46.08	45.87	45.93	16808770.0
2007-05-01 10:00:00	QQQ	ETF	45.93	46.0	45.67	45.92	47015848.0
2007-05-01 11:00:00	QQQ	ETF	45.92	45.97	45.81	45.82	12527944.0
2007-05-01 12:00:00	QQQ	ETF	45.83	45.86	45.76	45.8	7113751.0
2007-05-01 13:00:00	QQQ	ETF	45.78	45.93	45.66	45.88	14008977.0
2007-05-01 14:00:00	QQQ	ETF	45.88	46.14	45.84	46.05	21657505.0
2007-05-01 15:00:00	QQQ	ETF	46.05	46.1	45.95	46.07	11796452.0
2007-05-01 16:00:00	QQQ	ETF	46.07	46.13	46.06	46.09	904728.0
2007-05-01 17:00:00	QQQ	ETF	46.09	46.09	46.06	46.09	22200.0
2007-05-01 18:00:00	QQQ	ETF	46.09	46.11	46.07	46.07	42916.0
2007-05-01 19:00:00	QQQ	ETF	46.09	46.09	46.09	46.09	2000.0
2007-05-01 07:00:00	IWM	ETF	80.95	80.96	80.75	80.96	9400.0
2007-05-01 08:00:00	IWM	ETF	80.74	80.96	80.74	80.92	802400.0
2007-05-01 09:00:00	IWM	ETF	80.92	81.04	80.34	80.49	16120479.0
2007-05-01 10:00:00	IWM	ETF	80.48	80.65	80.13	80.63	19987443.0
2007-05-01 11:00:00	IWM	ETF	80.64	80.73	80.45	80.49	9531111.0
2007-05-01 12:00:00	IWM	ETF	80.49	80.68	80.45	80.55	3121528.0
2007-05-01 13:00:00	IWM	ETF	80.55	80.77	80.27	80.67	6700177.0
2007-05-01 14:00:00	IWM	ETF	80.67	81.15	80.55	81.08	8493942.0
2007-05-01 15:00:00	IWM	ETF	81.08	81.16	80.87	81.06	8326495.0
2007-05-01 16:00:00	IWM	ETF	81.08	81.15	80.95	80.97	1880500.0
2007-05-01 17:00:00	IWM	ETF	80.3	81.14	80.3	81.14	1939600.0
2007-05-01 18:00:00	IWM	ETF	81.14	81.14	81.07	81.07	1001600.0
2007-05-01 07:00:00	DIA	ETF	130.87	130.89	130.87	130.89	1000.0
2007-05-01 08:00:00	DIA	ETF	130.87	130.9	130.8	130.85	16400.0
2007-05-01 09:00:00	DIA	ETF	130.78	130.93	130.71	130.74	1391800.0
2007-05-01 10:00:00	DIA	ETF	130.74	131.02	130.39	130.88	4865666.0
2007-05-01 11:00:00	DIA	ETF	130.87	131.04	130.68	130.7	2231340.0
2007-05-01 12:00:00	DIA	ETF	130.7	130.75	130.53	130.57	1286367.0
2007-05-01 13:00:00	DIA	ETF	130.56	130.9	130.31	130.82	1723550.0
2007-05-01 14:00:00	DIA	ETF	130.83	131.3	130.74	131.2	2633289.0
2007-05-01 15:00:00	DIA	ETF	131.21	131.28	131.02	131.26	1890050.0
2007-05-01 16:00:00	DIA	ETF	131.28	131.33	131.26	131.33	37700.0
2007-05-01 17:00:00	DIA	ETF	130.5341	131.35	130.5341	131.35	1618700.0

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

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