PREVIEW / etf_1hour / 2008-11-24

all etf 1-hour files

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

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-24 04:00:00	SPY	ETF	79.88	80.93	79.88	80.88	23200.0
2008-11-24 05:00:00	SPY	ETF	80.88	81.2	80.75	80.75	42543.0
2008-11-24 06:00:00	SPY	ETF	80.82	82.01	80.82	81.9	267800.0
2008-11-24 07:00:00	SPY	ETF	81.88	82.15	81.72	81.76	2470321.0
2008-11-24 08:00:00	SPY	ETF	81.76	81.83	79.35	81.76	5120045.0
2008-11-24 09:00:00	SPY	ETF	81.78	82.25	81.17	81.98	38833587.0
2008-11-24 10:00:00	SPY	ETF	81.96	84.02	81.94	83.93	80487632.0
2008-11-24 11:00:00	SPY	ETF	83.94	84.66	83.41	84.25	59298290.0
2008-11-24 12:00:00	SPY	ETF	84.25	84.51	82.94	83.85	55465491.0
2008-11-24 13:00:00	SPY	ETF	83.86	84.57	83.41	84.57	43464026.0
2008-11-24 14:00:00	SPY	ETF	84.57	84.94	83.25	84.56	52078900.0
2008-11-24 15:00:00	SPY	ETF	84.56	86.985	84.1	84.94	144118702.0
2008-11-24 16:00:00	SPY	ETF	84.9	85.71	80.3614	84.95	28197985.0
2008-11-24 17:00:00	SPY	ETF	85.0	85.25	80.3614	85.16	1349811.0
2008-11-24 18:00:00	SPY	ETF	85.16	85.46	84.92	85.28	3375955.0
2008-11-24 19:00:00	SPY	ETF	85.31	85.45	85.28	85.35	39795.0
2008-11-24 04:00:00	QQQ	ETF	27.1	27.11	27.1	27.11	900.0
2008-11-24 05:00:00	QQQ	ETF	27.09	27.22	27.04	27.08	2169.0
2008-11-24 06:00:00	QQQ	ETF	27.2	27.4	27.2	27.35	28095.0
2008-11-24 07:00:00	QQQ	ETF	27.35	27.47	27.28	27.32	495519.0
2008-11-24 08:00:00	QQQ	ETF	27.32	27.46	26.65	27.46	2385383.0
2008-11-24 09:00:00	QQQ	ETF	27.46	27.48	26.98	27.28	29967689.0
2008-11-24 10:00:00	QQQ	ETF	27.29	27.97	27.29	27.89	38307925.0
2008-11-24 11:00:00	QQQ	ETF	27.89	28.04	27.68	27.96	22509083.0
2008-11-24 12:00:00	QQQ	ETF	27.9599	28.05	27.5	27.75	30166215.0
2008-11-24 13:00:00	QQQ	ETF	27.75	27.96	27.58	27.96	13654121.0
2008-11-24 14:00:00	QQQ	ETF	27.95	28.1	27.71	27.99	22337953.0
2008-11-24 15:00:00	QQQ	ETF	27.99	28.64	27.9	28.3	53090733.0
2008-11-24 16:00:00	QQQ	ETF	28.29	28.3912	27.7	28.11	6494880.0
2008-11-24 17:00:00	QQQ	ETF	28.13	28.26	27.21	28.25	249021.0
2008-11-24 18:00:00	QQQ	ETF	28.21	28.27	28.16	28.23	98636.0
2008-11-24 19:00:00	QQQ	ETF	28.24	28.29	28.21	28.29	117218.0
2008-11-24 05:00:00	IWM	ETF	40.76	40.76	40.76	40.76	100.0
2008-11-24 06:00:00	IWM	ETF	41.24	41.26	41.24	41.26	4486.0
2008-11-24 07:00:00	IWM	ETF	41.24	41.4	41.15	41.38	61298.0
2008-11-24 08:00:00	IWM	ETF	39.95	41.41	39.95	41.4	410716.0
2008-11-24 09:00:00	IWM	ETF	41.39	41.46	40.64	41.38	8112993.0
2008-11-24 10:00:00	IWM	ETF	41.37	43.03	41.37	42.8	23047773.0
2008-11-24 11:00:00	IWM	ETF	42.81	42.93	42.42	42.83	10496497.0
2008-11-24 12:00:00	IWM	ETF	42.84	43.0	42.17	42.66	11792264.0
2008-11-24 13:00:00	IWM	ETF	42.67	42.94	42.39	42.92	5062900.0
2008-11-24 14:00:00	IWM	ETF	42.93	43.19	42.5	42.99	8912260.0
2008-11-24 15:00:00	IWM	ETF	42.99	44.04	42.75	43.55	24488448.0
2008-11-24 16:00:00	IWM	ETF	43.55	43.92	42.89	43.2	4557029.0
2008-11-24 17:00:00	IWM	ETF	43.34	43.41	43.32	43.41	3000.0
2008-11-24 18:00:00	IWM	ETF	43.29	43.5	43.28	43.5	1600.0
2008-11-24 04:00:00	DIA	ETF	80.7	80.7	80.7	80.7	100.0
2008-11-24 06:00:00	DIA	ETF	81.21	82.02	81.21	82.02	1920.0
2008-11-24 07:00:00	DIA	ETF	82.02	82.11	81.75	81.85	14269.0
2008-11-24 08:00:00	DIA	ETF	81.81	81.86	81.47	81.74	79374.0

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

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