PREVIEW / etf_1hour / 2009-07-08

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-07-08.parquet
  size:    140 KB
  rows:    4,261

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
2009-07-08 04:00:00	SPY	ETF	88.52	88.52	88.4	88.4	600.0
2009-07-08 05:00:00	SPY	ETF	88.46	88.67	88.46	88.64	6000.0
2009-07-08 06:00:00	SPY	ETF	88.63	88.69	88.38	88.41	44691.0
2009-07-08 07:00:00	SPY	ETF	88.5	88.7	88.44	88.46	268471.0
2009-07-08 08:00:00	SPY	ETF	88.42	88.68	88.11	88.34	2720367.0
2009-07-08 09:00:00	SPY	ETF	88.34	88.72	88.32	88.36	22092669.0
2009-07-08 10:00:00	SPY	ETF	88.36	88.8	88.15	88.15	30646669.0
2009-07-08 11:00:00	SPY	ETF	88.15	88.16	87.4	87.54	37929691.0
2009-07-08 12:00:00	SPY	ETF	87.55	87.59	87.08	87.2705	26207167.0
2009-07-08 13:00:00	SPY	ETF	87.27	87.86	87.26	87.6	25765391.0
2009-07-08 14:00:00	SPY	ETF	87.61	87.64	87.0	87.52	30229653.0
2009-07-08 15:00:00	SPY	ETF	87.51	88.34	87.34	88.01	56892027.0
2009-07-08 16:00:00	SPY	ETF	88.01	88.182	87.316	87.98	13688816.0
2009-07-08 17:00:00	SPY	ETF	87.98	88.08	87.61	88.04	424934.0
2009-07-08 18:00:00	SPY	ETF	88.06	88.12	88.0	88.1	65669.0
2009-07-08 19:00:00	SPY	ETF	88.08	88.08	88.01	88.08	75571.0
2009-07-08 05:00:00	QQQ	ETF	34.69	34.77	34.69	34.76	2580.0
2009-07-08 06:00:00	QQQ	ETF	34.77	34.77	34.71	34.71	1600.0
2009-07-08 07:00:00	QQQ	ETF	34.73	34.79	34.7	34.71	412858.0
2009-07-08 08:00:00	QQQ	ETF	34.71	34.74	34.64	34.73	1483476.0
2009-07-08 09:00:00	QQQ	ETF	34.74	34.84	34.58	34.62	19809967.0
2009-07-08 10:00:00	QQQ	ETF	34.62	34.84	34.56	34.5614	22433162.0
2009-07-08 11:00:00	QQQ	ETF	34.56	34.6477	34.33	34.44	23677906.0
2009-07-08 12:00:00	QQQ	ETF	34.43	34.47	34.3	34.4201	13221356.0
2009-07-08 13:00:00	QQQ	ETF	34.42	34.65	34.42	34.531	15915537.0
2009-07-08 14:00:00	QQQ	ETF	34.53	34.59	34.35	34.55	16930637.0
2009-07-08 15:00:00	QQQ	ETF	34.56	34.87	34.51	34.72	26968428.0
2009-07-08 16:00:00	QQQ	ETF	34.72	34.785	34.425	34.73	6132147.0
2009-07-08 17:00:00	QQQ	ETF	34.74	34.78	34.73	34.76	138201.0
2009-07-08 18:00:00	QQQ	ETF	34.74	34.76	34.72	34.76	28081.0
2009-07-08 19:00:00	QQQ	ETF	34.76	34.76	34.72	34.74	21550.0
2009-07-08 07:00:00	IWM	ETF	48.6	48.74	48.57	48.57	12262.0
2009-07-08 08:00:00	IWM	ETF	48.57	48.68	48.4	48.6	234111.0
2009-07-08 09:00:00	IWM	ETF	48.62	48.78	48.31	48.33	6866798.0
2009-07-08 10:00:00	IWM	ETF	48.33	48.63	48.14	48.14	7781574.0
2009-07-08 11:00:00	IWM	ETF	48.14	48.15	47.45	47.57	8796045.0
2009-07-08 12:00:00	IWM	ETF	47.56	47.61	47.27	47.3601	4354623.0
2009-07-08 13:00:00	IWM	ETF	47.36	47.9	47.36	47.62	4949040.0
2009-07-08 14:00:00	IWM	ETF	47.62	47.67	47.31	47.575	6193470.0
2009-07-08 15:00:00	IWM	ETF	47.57	48.19	47.5	48.06	13715724.0
2009-07-08 16:00:00	IWM	ETF	48.04	48.4159	47.65	47.88	6432459.0
2009-07-08 17:00:00	IWM	ETF	47.94	48.05	47.94	48.05	24955.0
2009-07-08 18:00:00	IWM	ETF	48.1	48.2	48.03	48.06	12000.0
2009-07-08 19:00:00	IWM	ETF	48.09	48.14	48.09	48.14	2200.0
2009-07-08 07:00:00	DIA	ETF	81.98	82.07	81.93	81.93	5220.0
2009-07-08 08:00:00	DIA	ETF	81.83	81.88	81.76	81.82	13878.0
2009-07-08 09:00:00	DIA	ETF	81.86	82.12	81.77	81.8491	1665689.0
2009-07-08 10:00:00	DIA	ETF	81.8402	82.28	81.82	81.82	2481345.0
2009-07-08 11:00:00	DIA	ETF	81.82	81.82	81.26	81.38	1823457.0
2009-07-08 12:00:00	DIA	ETF	81.39	81.46	81.08	81.23	1893493.0

> showing 50 of 4,261 rows — these rows as CSV

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