PREVIEW / etf_1hour / 2008-11-13

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-11-13.parquet
  size:    118 KB
  rows:    3,839

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-11-13 04:00:00	SPY	ETF	86.24	86.69	86.21	86.52	6900.0
2008-11-13 05:00:00	SPY	ETF	86.28	86.28	84.94	85.22	1900.0
2008-11-13 06:00:00	SPY	ETF	85.24	85.77	84.77	85.52	135200.0
2008-11-13 07:00:00	SPY	ETF	85.6	86.45	85.5	85.57	1863051.0
2008-11-13 08:00:00	SPY	ETF	85.58	86.37	84.759	85.38	6329046.0
2008-11-13 09:00:00	SPY	ETF	85.42	86.87	85.0	85.11	46966136.0
2008-11-13 10:00:00	SPY	ETF	85.12	87.08	85.02	85.9	76465328.0
2008-11-13 11:00:00	SPY	ETF	85.9	86.19	84.97	85.33	54634969.0
2008-11-13 12:00:00	SPY	ETF	85.34	85.58	82.15	82.17	70661783.0
2008-11-13 13:00:00	SPY	ETF	82.16	86.56	82.09	85.18	150261449.0
2008-11-13 14:00:00	SPY	ETF	85.2	88.57	84.87	87.6699	131197150.0
2008-11-13 15:00:00	SPY	ETF	87.66	91.73	85.92	91.5	170413465.0
2008-11-13 16:00:00	SPY	ETF	91.46	91.61	85.7	90.9	35499931.0
2008-11-13 17:00:00	SPY	ETF	90.9	91.24	90.89	91.17	6265871.0
2008-11-13 18:00:00	SPY	ETF	91.16	91.27	90.95	91.12	218599.0
2008-11-13 19:00:00	SPY	ETF	91.08	91.08	90.62	90.62	503294.0
2008-11-13 04:00:00	QQQ	ETF	28.62	28.64	28.62	28.64	1000.0
2008-11-13 05:00:00	QQQ	ETF	28.57	28.57	28.22	28.32	7000.0
2008-11-13 06:00:00	QQQ	ETF	28.28	28.42	28.15	28.32	5600.0
2008-11-13 07:00:00	QQQ	ETF	28.34	28.67	28.31	28.37	305061.0
2008-11-13 08:00:00	QQQ	ETF	28.39	28.45	28.24	28.38	1893365.0
2008-11-13 09:00:00	QQQ	ETF	28.39	28.93	28.24	28.28	28349570.0
2008-11-13 10:00:00	QQQ	ETF	28.28	28.97	28.25	28.6	30817878.0
2008-11-13 11:00:00	QQQ	ETF	28.59	28.68	28.26	28.3499	23181616.0
2008-11-13 12:00:00	QQQ	ETF	28.35	28.42	27.3	27.3	30587429.0
2008-11-13 13:00:00	QQQ	ETF	27.3	28.77	27.28	28.29	58730892.0
2008-11-13 14:00:00	QQQ	ETF	28.29	29.6201	28.15	29.33	63606611.0
2008-11-13 15:00:00	QQQ	ETF	29.33	30.53	28.8601	30.49	71766716.0
2008-11-13 16:00:00	QQQ	ETF	30.48	30.56	29.6406	30.37	7236286.0
2008-11-13 17:00:00	QQQ	ETF	30.34	30.39	30.33	30.39	135228.0
2008-11-13 18:00:00	QQQ	ETF	30.35	30.38	30.26	30.34	91091.0
2008-11-13 19:00:00	QQQ	ETF	30.34	30.35	30.23	30.28	243221.0
2008-11-13 07:00:00	IWM	ETF	45.09	45.72	45.09	45.55	263843.0
2008-11-13 08:00:00	IWM	ETF	45.53	45.72	45.27	45.33	1856440.0
2008-11-13 09:00:00	IWM	ETF	45.39	46.22	44.65	44.79	8921418.0
2008-11-13 10:00:00	IWM	ETF	44.78	46.08	44.71	45.56	11914561.0
2008-11-13 11:00:00	IWM	ETF	45.57	45.7	44.99	45.24	8048706.0
2008-11-13 12:00:00	IWM	ETF	45.24	45.43	43.28	43.29	12577920.0
2008-11-13 13:00:00	IWM	ETF	43.29	46.01	43.24	45.15	21100492.0
2008-11-13 14:00:00	IWM	ETF	45.14	47.55	45.07	47.02	29866402.0
2008-11-13 15:00:00	IWM	ETF	47.02	49.44	46.05	49.36	38549968.0
2008-11-13 16:00:00	IWM	ETF	49.35	49.53	43.7	48.94	7365127.0
2008-11-13 17:00:00	IWM	ETF	49.1	49.1	49.1	49.1	100.0
2008-11-13 19:00:00	IWM	ETF	49.0	49.0	48.94	48.94	1225.0
2008-11-13 07:00:00	DIA	ETF	83.07	83.77	83.02	83.27	23621.0
2008-11-13 08:00:00	DIA	ETF	83.1	83.85	82.52	83.0	138049.0
2008-11-13 09:00:00	DIA	ETF	83.06	84.2	82.4	82.49	3758113.0
2008-11-13 10:00:00	DIA	ETF	82.48	84.32	82.39	83.17	6772260.0
2008-11-13 11:00:00	DIA	ETF	83.18	83.38	82.26	82.65	4978017.0
2008-11-13 12:00:00	DIA	ETF	82.65	82.86	79.9	79.93	5983348.0

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

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