PREVIEW / etf_1hour / 2008-10-14

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-10-14.parquet
  size:    117 KB
  rows:    3,810

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
2008-10-14 04:00:00	SPY	ETF	102.78	103.29	102.09	102.11	12500.0
2008-10-14 05:00:00	SPY	ETF	102.2	102.81	102.1	102.8	14500.0
2008-10-14 06:00:00	SPY	ETF	102.8	104.38	102.77	104.1	299148.0
2008-10-14 07:00:00	SPY	ETF	104.06	104.47	103.87	104.03	1161616.0
2008-10-14 08:00:00	SPY	ETF	103.579	106.18	101.35	104.96	17185612.0
2008-10-14 09:00:00	SPY	ETF	105.01	105.53	101.35	101.36	89304556.0
2008-10-14 10:00:00	SPY	ETF	101.37	102.92	99.12	100.62	95554164.0
2008-10-14 11:00:00	SPY	ETF	100.62	101.65	99.2	100.95	53635551.0
2008-10-14 12:00:00	SPY	ETF	100.91	101.87	100.08	100.98	33879649.0
2008-10-14 13:00:00	SPY	ETF	100.98	101.26	99.67	99.95	35501438.0
2008-10-14 14:00:00	SPY	ETF	99.95	101.6	97.11	97.61	98111249.0
2008-10-14 15:00:00	SPY	ETF	97.61	101.8	97.33	99.93	94459890.0
2008-10-14 16:00:00	SPY	ETF	99.93	102.2647	98.1	100.42	13385119.0
2008-10-14 17:00:00	SPY	ETF	100.47	104.19	99.81	99.87	12448111.0
2008-10-14 18:00:00	SPY	ETF	99.92	100.24	99.8	99.89	133722.0
2008-10-14 19:00:00	SPY	ETF	99.9	99.92	97.57	98.68	234430.0
2008-10-14 04:00:00	QQQ	ETF	36.12	36.12	35.95	35.95	5000.0
2008-10-14 05:00:00	QQQ	ETF	35.98	36.08	35.98	36.01	5200.0
2008-10-14 06:00:00	QQQ	ETF	36.02	36.49	36.02	36.36	77064.0
2008-10-14 07:00:00	QQQ	ETF	36.47	36.6	36.32	36.46	781077.0
2008-10-14 08:00:00	QQQ	ETF	36.46	36.7	36.27	36.36	6148125.0
2008-10-14 09:00:00	QQQ	ETF	36.37	36.37	34.5	34.5	55901185.0
2008-10-14 10:00:00	QQQ	ETF	34.51	35.05	33.96	34.47	70422515.0
2008-10-14 11:00:00	QQQ	ETF	34.47	34.83	33.87	34.56	36721542.0
2008-10-14 12:00:00	QQQ	ETF	34.56	34.93	34.26	34.53	20288542.0
2008-10-14 13:00:00	QQQ	ETF	34.54	34.67	34.01	34.1405	18644895.0
2008-10-14 14:00:00	QQQ	ETF	34.14	34.22	33.19	33.42	55671689.0
2008-10-14 15:00:00	QQQ	ETF	33.42	34.26	33.3	33.58	57007084.0
2008-10-14 16:00:00	QQQ	ETF	33.58	35.1461	33.33	34.12	10436219.0
2008-10-14 17:00:00	QQQ	ETF	34.1	34.16	33.87	33.96	841326.0
2008-10-14 18:00:00	QQQ	ETF	33.96	34.07	33.93	34.0	260420.0
2008-10-14 19:00:00	QQQ	ETF	34.0	34.0	33.44	33.56	423802.0
2008-10-14 06:00:00	IWM	ETF	58.64	58.64	58.64	58.64	2000.0
2008-10-14 07:00:00	IWM	ETF	58.75	58.78	58.56	58.68	27300.0
2008-10-14 08:00:00	IWM	ETF	58.7	59.96	58.55	59.42	636499.0
2008-10-14 09:00:00	IWM	ETF	59.43	59.45	56.59	56.65	18182089.0
2008-10-14 10:00:00	IWM	ETF	56.66	57.6	55.3	56.25	22841343.0
2008-10-14 11:00:00	IWM	ETF	56.25	57.26	55.81	56.44	15119228.0
2008-10-14 12:00:00	IWM	ETF	56.44	56.9	56.15	56.35	7946485.0
2008-10-14 13:00:00	IWM	ETF	56.36	56.52	55.67	55.9	8703437.0
2008-10-14 14:00:00	IWM	ETF	55.89	56.13	53.86	54.04	25746695.0
2008-10-14 15:00:00	IWM	ETF	54.03	56.8	53.93	55.38	28591604.0
2008-10-14 16:00:00	IWM	ETF	55.35	56.06	55.17	56.05	1133992.0
2008-10-14 17:00:00	IWM	ETF	56.14	56.14	55.38	55.38	429664.0
2008-10-14 18:00:00	IWM	ETF	55.4	55.4	55.25	55.25	1500.0
2008-10-14 19:00:00	IWM	ETF	55.26	55.26	55.0	55.25	1200.0
2008-10-14 06:00:00	DIA	ETF	95.95	95.95	95.95	95.95	200.0
2008-10-14 07:00:00	DIA	ETF	97.09	97.6	96.74	96.89	33720.0
2008-10-14 08:00:00	DIA	ETF	96.97	98.97	96.85	98.05	337380.0
2008-10-14 09:00:00	DIA	ETF	98.07	98.8	94.95	94.98	7804387.0

> showing 50 of 3,810 rows — these rows as CSV

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