PREVIEW / etf_1hour / 2008-11-11

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-11-11.parquet
  size:    110 KB
  rows:    3,603

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-11 04:00:00	SPY	ETF	92.04	92.13	91.6	91.6	20600.0
2008-11-11 05:00:00	SPY	ETF	91.73	91.8	91.3	91.8	6200.0
2008-11-11 06:00:00	SPY	ETF	91.71	91.71	91.24	91.26	27740.0
2008-11-11 07:00:00	SPY	ETF	91.34	91.39	90.48	90.94	1079633.0
2008-11-11 08:00:00	SPY	ETF	90.94	92.63	90.55	90.87	2326613.0
2008-11-11 09:00:00	SPY	ETF	90.89	91.08	89.25	89.53	47205134.0
2008-11-11 10:00:00	SPY	ETF	89.54	90.13	89.1	89.18	53680083.0
2008-11-11 11:00:00	SPY	ETF	89.19	92.1377	88.85	89.29	35069446.0
2008-11-11 12:00:00	SPY	ETF	89.29	89.39	88.65	89.32	23773850.0
2008-11-11 13:00:00	SPY	ETF	89.33	90.51	88.9	90.3501	35862411.0
2008-11-11 14:00:00	SPY	ETF	90.35	92.04	89.89	89.98	105633482.0
2008-11-11 15:00:00	SPY	ETF	89.98	90.97	89.03	90.1	94668500.0
2008-11-11 16:00:00	SPY	ETF	90.11	92.138	89.0316	89.72	14906344.0
2008-11-11 17:00:00	SPY	ETF	89.72	89.78	89.64	89.74	209713.0
2008-11-11 18:00:00	SPY	ETF	89.67	89.93	89.67	89.82	155685.0
2008-11-11 19:00:00	SPY	ETF	89.85	90.28	89.83	90.17	80873.0
2008-11-11 04:00:00	QQQ	ETF	30.7	30.7	30.7	30.7	100.0
2008-11-11 06:00:00	QQQ	ETF	30.58	30.58	30.46	30.53	13740.0
2008-11-11 07:00:00	QQQ	ETF	30.5	30.5	30.26	30.43	318182.0
2008-11-11 08:00:00	QQQ	ETF	30.7	30.7	30.37	30.46	927153.0
2008-11-11 09:00:00	QQQ	ETF	30.46	30.51	29.87	29.9595	20301255.0
2008-11-11 10:00:00	QQQ	ETF	29.95	30.07	29.83	29.8699	21418914.0
2008-11-11 11:00:00	QQQ	ETF	29.86	30.0101	29.75	29.88	13317906.0
2008-11-11 12:00:00	QQQ	ETF	29.89	29.93	29.72	29.93	7856439.0
2008-11-11 13:00:00	QQQ	ETF	29.93	30.22	29.7799	30.18	15310454.0
2008-11-11 14:00:00	QQQ	ETF	30.18	30.76	30.03	30.12	38511931.0
2008-11-11 15:00:00	QQQ	ETF	30.13	30.49	29.85	30.13	40110513.0
2008-11-11 16:00:00	QQQ	ETF	30.13	40.08	30.02	30.04	3628350.0
2008-11-11 17:00:00	QQQ	ETF	30.03	30.08	30.03	30.06	29364.0
2008-11-11 18:00:00	QQQ	ETF	30.06	30.11	30.06	30.1	30840.0
2008-11-11 19:00:00	QQQ	ETF	30.1	30.25	30.1	30.21	44558.0
2008-11-11 04:00:00	IWM	ETF	49.73	49.73	49.67	49.67	200.0
2008-11-11 05:00:00	IWM	ETF	49.5	49.5	49.5	49.5	2000.0
2008-11-11 06:00:00	IWM	ETF	49.4	49.4	49.4	49.4	3000.0
2008-11-11 07:00:00	IWM	ETF	49.25	49.25	48.82	49.13	39400.0
2008-11-11 08:00:00	IWM	ETF	49.09	49.32	48.72	49.32	603479.0
2008-11-11 09:00:00	IWM	ETF	48.97	49.14	48.14	48.19	7956202.0
2008-11-11 10:00:00	IWM	ETF	48.19	48.76	48.05	48.39	9874378.0
2008-11-11 11:00:00	IWM	ETF	48.38	48.71	48.1	48.52	5181847.0
2008-11-11 12:00:00	IWM	ETF	48.51	48.6	48.01	48.44	4164306.0
2008-11-11 13:00:00	IWM	ETF	48.44	49.09	48.3	49.06	6587138.0
2008-11-11 14:00:00	IWM	ETF	49.07	49.9	48.63	48.84	18499761.0
2008-11-11 15:00:00	IWM	ETF	48.84	49.24	48.22	48.38	15846514.0
2008-11-11 16:00:00	IWM	ETF	48.39	48.51	48.12	48.18	1886077.0
2008-11-11 17:00:00	IWM	ETF	48.13	48.23	48.13	48.2	1744.0
2008-11-11 18:00:00	IWM	ETF	48.1	48.1	48.1	48.1	356.0
2008-11-11 19:00:00	IWM	ETF	48.19	48.19	48.04	48.04	700.0
2008-11-11 06:00:00	DIA	ETF	88.0	88.0	88.0	88.0	500.0
2008-11-11 07:00:00	DIA	ETF	87.83	87.83	87.36	87.64	7893.0
2008-11-11 08:00:00	DIA	ETF	87.75	87.9	87.57	87.69	59084.0

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

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