PREVIEW / etf_1hour / 2007-03-16

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-03-16.parquet
  size:    68 KB
  rows:    2,149

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-03-16 04:00:00	SPY	ETF	138.71	138.71	138.65	138.65	700.0
2007-03-16 06:00:00	SPY	ETF	138.81	138.81	138.65	138.81	32400.0
2007-03-16 07:00:00	SPY	ETF	138.79	138.82	138.58	138.64	506200.0
2007-03-16 08:00:00	SPY	ETF	138.68	139.13	138.35	138.95	8718400.0
2007-03-16 09:00:00	SPY	ETF	138.95	139.53	138.87	139.43	18770515.0
2007-03-16 10:00:00	SPY	ETF	139.43	139.63	139.08	139.09	17444687.0
2007-03-16 11:00:00	SPY	ETF	139.09	139.16	138.53	138.7	20626500.0
2007-03-16 12:00:00	SPY	ETF	138.7	138.85	138.64	138.74	5099852.0
2007-03-16 13:00:00	SPY	ETF	138.73	139.0	138.59	138.71	7636154.0
2007-03-16 14:00:00	SPY	ETF	138.72	138.72	138.12	138.45	14655950.0
2007-03-16 15:00:00	SPY	ETF	138.45	138.7	138.3	138.48	19547550.0
2007-03-16 16:00:00	SPY	ETF	138.49	138.61	138.39	138.4	5161200.0
2007-03-16 17:00:00	SPY	ETF	138.4	138.45	137.95	138.05	1063700.0
2007-03-16 18:00:00	SPY	ETF	138.05	138.54	138.0	138.19	533200.0
2007-03-16 19:00:00	SPY	ETF	138.15	138.23	138.15	138.2	25400.0
2007-03-16 04:00:00	QQQ	ETF	42.77	42.77	42.77	42.77	2500.0
2007-03-16 07:00:00	QQQ	ETF	42.77	42.78	42.69	42.72	49356.0
2007-03-16 08:00:00	QQQ	ETF	42.73	42.9	42.68	42.82	2706436.0
2007-03-16 09:00:00	QQQ	ETF	42.83	43.0	42.78	42.92	13298315.0
2007-03-16 10:00:00	QQQ	ETF	42.92	43.04	42.83	42.84	17478800.0
2007-03-16 11:00:00	QQQ	ETF	42.84	42.86	42.61	42.7	19767600.0
2007-03-16 12:00:00	QQQ	ETF	42.7	42.82	42.7	42.79	7499600.0
2007-03-16 13:00:00	QQQ	ETF	42.79	42.91	42.75	42.86	9071400.0
2007-03-16 14:00:00	QQQ	ETF	42.87	42.87	42.67	42.77	11734600.0
2007-03-16 15:00:00	QQQ	ETF	42.76	42.87	42.74	42.83	19379100.0
2007-03-16 16:00:00	QQQ	ETF	42.83	42.87	42.82	42.84	2651756.0
2007-03-16 17:00:00	QQQ	ETF	42.83	42.86	42.77	42.8	345115.0
2007-03-16 18:00:00	QQQ	ETF	42.81	42.82	42.8	42.81	36900.0
2007-03-16 19:00:00	QQQ	ETF	42.81	42.81	42.78	42.78	34100.0
2007-03-16 07:00:00	IWM	ETF	77.43	77.48	77.43	77.48	25500.0
2007-03-16 08:00:00	IWM	ETF	77.48	77.86	77.45	77.6	1579700.0
2007-03-16 09:00:00	IWM	ETF	77.64	77.93	77.34	77.87	10262500.0
2007-03-16 10:00:00	IWM	ETF	77.87	78.06	77.48	77.53	9867455.0
2007-03-16 11:00:00	IWM	ETF	77.53	77.8	77.11	77.35	14028400.0
2007-03-16 12:00:00	IWM	ETF	77.34	77.53	77.33	77.49	4535115.0
2007-03-16 13:00:00	IWM	ETF	77.49	77.62	77.35	77.49	4116800.0
2007-03-16 14:00:00	IWM	ETF	77.5	77.5	77.17	77.31	13362809.0
2007-03-16 15:00:00	IWM	ETF	77.31	77.45	76.54	77.34	16200767.0
2007-03-16 16:00:00	IWM	ETF	77.34	77.41	77.25	77.3	914500.0
2007-03-16 17:00:00	IWM	ETF	77.25	77.25	77.13	77.13	700.0
2007-03-16 18:00:00	IWM	ETF	77.87	77.87	77.87	77.87	90000.0
2007-03-16 05:00:00	DIA	ETF	122.81	122.81	122.81	122.81	100.0
2007-03-16 07:00:00	DIA	ETF	121.33	121.35	121.19	121.26	2400.0
2007-03-16 08:00:00	DIA	ETF	121.27	121.75	121.05	121.4	104300.0
2007-03-16 09:00:00	DIA	ETF	121.4	121.77	121.22	121.6	1396600.0
2007-03-16 10:00:00	DIA	ETF	121.6	121.78	121.33	121.37	996300.0
2007-03-16 11:00:00	DIA	ETF	121.37	121.43	120.93	121.09	1108708.0
2007-03-16 12:00:00	DIA	ETF	121.09	121.21	121.03	121.121	703700.0
2007-03-16 13:00:00	DIA	ETF	121.13	121.31	120.99	121.1	942900.0
2007-03-16 14:00:00	DIA	ETF	121.1	121.13	120.73	120.91	1085800.0

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

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