PREVIEW / etf_1hour / 2010-02-25

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-02-25.parquet
  size:    157 KB
  rows:    4,789

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-25 04:00:00	SPY	ETF	110.2	110.55	110.2	110.55	4900.0
2010-02-25 05:00:00	SPY	ETF	110.45	110.45	110.35	110.35	22300.0
2010-02-25 06:00:00	SPY	ETF	110.36	110.43	110.23	110.35	68600.0
2010-02-25 07:00:00	SPY	ETF	110.34	110.35	110.0	110.2	762917.0
2010-02-25 08:00:00	SPY	ETF	110.16	110.34	109.6	109.7	6772788.0
2010-02-25 09:00:00	SPY	ETF	109.72	109.73	108.94	109.2617	33630261.0
2010-02-25 10:00:00	SPY	ETF	109.26	109.5	109.06	109.33	35765280.0
2010-02-25 11:00:00	SPY	ETF	109.3383	109.43	109.05	109.14	24160902.0
2010-02-25 12:00:00	SPY	ETF	109.14	109.55	109.09	109.41	21947307.0
2010-02-25 13:00:00	SPY	ETF	109.41	110.1	109.31	110.09	25266627.0
2010-02-25 14:00:00	SPY	ETF	110.09	110.32	109.98	110.2	39248934.0
2010-02-25 15:00:00	SPY	ETF	110.19	110.75	110.11	110.71	56968670.0
2010-02-25 16:00:00	SPY	ETF	110.71	111.063	109.2	110.63	13045831.0
2010-02-25 17:00:00	SPY	ETF	110.62	110.74	110.58	110.66	251880.0
2010-02-25 18:00:00	SPY	ETF	110.66	110.81	110.62	110.8	151836.0
2010-02-25 19:00:00	SPY	ETF	110.8	111.0	110.77	110.98	459619.0
2010-02-25 04:00:00	QQQ	ETF	44.35	44.53	44.35	44.53	8900.0
2010-02-25 05:00:00	QQQ	ETF	44.5	44.5	44.47	44.47	1300.0
2010-02-25 06:00:00	QQQ	ETF	44.42	44.49	44.41	44.46	20633.0
2010-02-25 07:00:00	QQQ	ETF	44.44	44.44	44.35	44.4	74302.0
2010-02-25 08:00:00	QQQ	ETF	44.41	44.44	44.2	44.23	1682046.0
2010-02-25 09:00:00	QQQ	ETF	44.23	44.25	43.83	43.94	15256532.0
2010-02-25 10:00:00	QQQ	ETF	43.94	44.03	43.86	43.9499	13775729.0
2010-02-25 11:00:00	QQQ	ETF	43.94	44.04	43.87	43.91	9553777.0
2010-02-25 12:00:00	QQQ	ETF	43.9	44.04	43.88	44.005	6468506.0
2010-02-25 13:00:00	QQQ	ETF	44.01	44.38	43.97	44.38	10673401.0
2010-02-25 14:00:00	QQQ	ETF	44.39	44.47	44.31	44.41	13716677.0
2010-02-25 15:00:00	QQQ	ETF	44.41	44.7	44.385	44.63	19540319.0
2010-02-25 16:00:00	QQQ	ETF	44.62	44.66	44.5366	44.6	2702285.0
2010-02-25 17:00:00	QQQ	ETF	44.6	44.62	44.58	44.62	19005.0
2010-02-25 18:00:00	QQQ	ETF	44.59	44.63	44.59	44.62	21213.0
2010-02-25 19:00:00	QQQ	ETF	44.63	44.69	44.63	44.66	39477.0
2010-02-25 04:00:00	IWM	ETF	62.82	62.82	62.62	62.62	400.0
2010-02-25 07:00:00	IWM	ETF	62.66	62.66	62.49	62.52	60025.0
2010-02-25 08:00:00	IWM	ETF	62.53	62.61	62.3	62.42	1027818.0
2010-02-25 09:00:00	IWM	ETF	62.43	62.45	61.98	62.29	9284462.0
2010-02-25 10:00:00	IWM	ETF	62.29	62.43	62.15	62.32	6586415.0
2010-02-25 11:00:00	IWM	ETF	62.32	62.4	62.04	62.08	4483563.0
2010-02-25 12:00:00	IWM	ETF	62.09	62.34	62.05	62.27	3479531.0
2010-02-25 13:00:00	IWM	ETF	62.27	62.885	62.21	62.81	6818780.0
2010-02-25 14:00:00	IWM	ETF	62.83	62.91	62.65	62.722	5672371.0
2010-02-25 15:00:00	IWM	ETF	62.73	63.12	62.69	63.07	12166711.0
2010-02-25 16:00:00	IWM	ETF	63.08	63.1	62.3336	63.03	1600995.0
2010-02-25 17:00:00	IWM	ETF	63.01	63.13	63.0	63.07	89017.0
2010-02-25 18:00:00	IWM	ETF	63.07	63.13	63.04	63.05	5224.0
2010-02-25 19:00:00	IWM	ETF	63.15	63.2	63.04	63.17	4500.0
2010-02-25 07:00:00	DIA	ETF	103.32	103.34	103.13	103.13	2700.0
2010-02-25 08:00:00	DIA	ETF	103.2	103.2	102.77	102.82	44711.0
2010-02-25 09:00:00	DIA	ETF	102.83	102.83	101.99	102.24	1549014.0
2010-02-25 10:00:00	DIA	ETF	102.23	102.33	102.04	102.19	1238088.0

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

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