PREVIEW / etf_1hour / 2010-02-04

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-02-04.parquet
  size:    164 KB
  rows:    4,988

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
2010-02-04 04:00:00	SPY	ETF	109.61	109.61	109.29	109.45	8022.0
2010-02-04 05:00:00	SPY	ETF	109.43	109.44	109.21	109.26	89069.0
2010-02-04 06:00:00	SPY	ETF	109.39	109.47	109.36	109.36	56000.0
2010-02-04 07:00:00	SPY	ETF	109.42	109.64	109.31	109.5	589778.0
2010-02-04 08:00:00	SPY	ETF	109.51	109.55	108.95	109.06	7877367.0
2010-02-04 09:00:00	SPY	ETF	109.06	109.08	107.84	107.95	43580427.0
2010-02-04 10:00:00	SPY	ETF	107.96	108.18	107.46	107.5	55373227.0
2010-02-04 11:00:00	SPY	ETF	107.5	107.82	107.05	107.45	43290693.0
2010-02-04 12:00:00	SPY	ETF	107.45	107.51	106.95	107.26	33324006.0
2010-02-04 13:00:00	SPY	ETF	107.26	107.37	106.94	107.02	27820078.0
2010-02-04 14:00:00	SPY	ETF	107.02	107.44	106.87	107.26	33884550.0
2010-02-04 15:00:00	SPY	ETF	107.26	107.417	106.42	106.47	70971595.0
2010-02-04 16:00:00	SPY	ETF	106.47	108.93	106.44	106.62	21675846.0
2010-02-04 17:00:00	SPY	ETF	106.62	109.8803	106.56	106.69	3658954.0
2010-02-04 18:00:00	SPY	ETF	106.7	106.85	106.7	106.8	430750.0
2010-02-04 19:00:00	SPY	ETF	106.81	106.84	106.66	106.73	80589.0
2010-02-04 04:00:00	QQQ	ETF	43.83	43.84	43.76	43.82	2900.0
2010-02-04 05:00:00	QQQ	ETF	43.77	43.77	43.71	43.73	3200.0
2010-02-04 06:00:00	QQQ	ETF	43.72	43.77	43.71	43.73	12700.0
2010-02-04 07:00:00	QQQ	ETF	43.73	43.83	43.71	43.8	628884.0
2010-02-04 08:00:00	QQQ	ETF	43.81	43.86	43.61	43.62	3476878.0
2010-02-04 09:00:00	QQQ	ETF	43.62	43.66	43.13	43.1599	21745683.0
2010-02-04 10:00:00	QQQ	ETF	43.15	43.26	43.0	43.03	26410979.0
2010-02-04 11:00:00	QQQ	ETF	43.0201	43.1	42.79	42.92	15926980.0
2010-02-04 12:00:00	QQQ	ETF	42.9199	42.98	42.76	42.865	11816680.0
2010-02-04 13:00:00	QQQ	ETF	42.87	42.93	42.78	42.8	13305144.0
2010-02-04 14:00:00	QQQ	ETF	42.8	42.96	42.76	42.88	18194712.0
2010-02-04 15:00:00	QQQ	ETF	42.89	42.91	42.62	42.65	27895433.0
2010-02-04 16:00:00	QQQ	ETF	42.64	43.8872	42.62	42.66	7456736.0
2010-02-04 17:00:00	QQQ	ETF	42.67	43.8871	42.65	42.72	2089944.0
2010-02-04 18:00:00	QQQ	ETF	42.72	42.74	42.72	42.74	20700.0
2010-02-04 19:00:00	QQQ	ETF	42.74	42.75	42.7	42.7	71929.0
2010-02-04 04:00:00	IWM	ETF	61.13	61.13	61.02	61.02	6200.0
2010-02-04 05:00:00	IWM	ETF	61.0	61.0	61.0	61.0	300.0
2010-02-04 06:00:00	IWM	ETF	60.89	60.9	60.89	60.89	300.0
2010-02-04 07:00:00	IWM	ETF	60.86	60.99	60.82	60.93	11900.0
2010-02-04 08:00:00	IWM	ETF	60.92	60.98	60.61	60.66	367258.0
2010-02-04 09:00:00	IWM	ETF	60.68	60.7	59.79	59.87	11396820.0
2010-02-04 10:00:00	IWM	ETF	59.87	60.12	59.53	59.57	16622615.0
2010-02-04 11:00:00	IWM	ETF	59.568	59.9	59.49	59.71	10242538.0
2010-02-04 12:00:00	IWM	ETF	59.71	59.79	59.33	59.46	7781223.0
2010-02-04 13:00:00	IWM	ETF	59.46	59.56	59.3	59.3506	7106952.0
2010-02-04 14:00:00	IWM	ETF	59.36	59.56	59.21	59.47	8756031.0
2010-02-04 15:00:00	IWM	ETF	59.48	59.503	58.99	59.03	18001261.0
2010-02-04 16:00:00	IWM	ETF	59.04	61.0703	59.0	59.09	6418119.0
2010-02-04 17:00:00	IWM	ETF	59.1	61.0703	59.1	59.1	1526891.0
2010-02-04 18:00:00	IWM	ETF	59.1	59.2	59.1	59.1	9600.0
2010-02-04 19:00:00	IWM	ETF	59.17	59.18	59.1	59.1	3300.0
2010-02-04 07:00:00	DIA	ETF	102.39	102.41	102.31	102.38	3050.0
2010-02-04 08:00:00	DIA	ETF	102.37	102.45	101.6	102.02	102807.0

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

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