PREVIEW / etf_1hour / 2007-02-12

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-02-12.parquet
  size:    67 KB
  rows:    2,115

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-02-12 05:00:00	SPY	ETF	143.98	143.98	143.98	143.98	5900.0
2007-02-12 07:00:00	SPY	ETF	143.9	144.06	143.9	144.01	227596.0
2007-02-12 08:00:00	SPY	ETF	143.99	144.11	143.9	143.92	1134801.0
2007-02-12 09:00:00	SPY	ETF	143.93	144.04	143.64	143.65	6565420.0
2007-02-12 10:00:00	SPY	ETF	143.65	144.01	143.5	143.61	7084501.0
2007-02-12 11:00:00	SPY	ETF	143.6	143.72	143.45	143.62	8177231.0
2007-02-12 12:00:00	SPY	ETF	143.62	143.76	143.56	143.64	3593957.0
2007-02-12 13:00:00	SPY	ETF	143.63	143.68	143.26	143.34	10072775.0
2007-02-12 14:00:00	SPY	ETF	143.34	143.77	143.19	143.38	9942488.0
2007-02-12 15:00:00	SPY	ETF	143.38	143.69	143.31	143.42	6428854.0
2007-02-12 16:00:00	SPY	ETF	143.43	143.73	143.4	143.64	2140097.0
2007-02-12 17:00:00	SPY	ETF	143.63	143.72	143.33	143.44	8523040.0
2007-02-12 19:00:00	SPY	ETF	143.5	143.5	143.48	143.5	6150.0
2007-02-12 04:00:00	QQQ	ETF	43.87	43.87	43.87	43.87	300.0
2007-02-12 07:00:00	QQQ	ETF	43.81	43.89	43.8	43.87	140886.0
2007-02-12 08:00:00	QQQ	ETF	43.86	43.92	43.85	43.86	753090.0
2007-02-12 09:00:00	QQQ	ETF	43.86	43.89	43.67	43.71	32560303.0
2007-02-12 10:00:00	QQQ	ETF	43.72	43.79	43.63	43.72	26506600.0
2007-02-12 11:00:00	QQQ	ETF	43.72	43.81	43.65	43.71	14546300.0
2007-02-12 12:00:00	QQQ	ETF	43.7	43.81	43.69	43.75	7239000.0
2007-02-12 13:00:00	QQQ	ETF	43.75	43.76	43.61	43.66	11055800.0
2007-02-12 14:00:00	QQQ	ETF	43.65	43.72	43.59	43.69	13718900.0
2007-02-12 15:00:00	QQQ	ETF	43.68	43.77	43.65	43.71	16722700.0
2007-02-12 16:00:00	QQQ	ETF	43.71	43.71	43.67	43.69	1614125.0
2007-02-12 17:00:00	QQQ	ETF	43.7	43.7	43.68	43.69	34136.0
2007-02-12 18:00:00	QQQ	ETF	43.69	43.71	43.69	43.71	6630.0
2007-02-12 19:00:00	QQQ	ETF	43.7	43.71	43.7	43.7	21500.0
2007-02-12 07:00:00	IWM	ETF	80.22	80.22	80.22	80.22	6642.0
2007-02-12 08:00:00	IWM	ETF	80.22	80.31	80.22	80.26	49732.0
2007-02-12 09:00:00	IWM	ETF	80.26	80.3	79.79	79.79	5918619.0
2007-02-12 10:00:00	IWM	ETF	79.79	80.02	79.67	79.89	7157350.0
2007-02-12 11:00:00	IWM	ETF	79.89	79.98	79.75	79.87	4728019.0
2007-02-12 12:00:00	IWM	ETF	79.88	80.04	79.85	79.95	2743195.0
2007-02-12 13:00:00	IWM	ETF	79.95	79.96	79.6	79.66	3611507.0
2007-02-12 14:00:00	IWM	ETF	79.66	79.98	79.62	79.77	4306419.0
2007-02-12 15:00:00	IWM	ETF	79.77	79.99	79.73	79.98	4963083.0
2007-02-12 16:00:00	IWM	ETF	80.0	80.1105	79.69	79.91	3807951.0
2007-02-12 17:00:00	IWM	ETF	79.91	80.03	79.77	79.95	1264425.0
2007-02-12 18:00:00	IWM	ETF	80.0	80.0	80.0	80.0	350.0
2007-02-12 19:00:00	IWM	ETF	80.02	80.02	80.01	80.02	3100.0
2007-02-12 08:00:00	DIA	ETF	125.97	126.04	125.97	126.0	9300.0
2007-02-12 09:00:00	DIA	ETF	125.92	126.04	125.77	125.78	771200.0
2007-02-12 10:00:00	DIA	ETF	125.77	125.84	125.61	125.71	2096003.0
2007-02-12 11:00:00	DIA	ETF	125.69	125.8101	125.63	125.71	1011308.0
2007-02-12 12:00:00	DIA	ETF	125.72	125.87	125.67	125.73	633583.0
2007-02-12 13:00:00	DIA	ETF	125.74	125.88	125.46	125.52	1125138.0
2007-02-12 14:00:00	DIA	ETF	125.52	125.94	125.39	125.54	1226860.0
2007-02-12 15:00:00	DIA	ETF	125.56	125.81	125.46	125.59	731245.0
2007-02-12 16:00:00	DIA	ETF	125.5801	125.85	125.56	125.74	949903.0
2007-02-12 17:00:00	DIA	ETF	125.73	125.81	125.52	125.58	344885.0

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

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