PREVIEW / etf_1hour / 2008-12-18

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-12-18.parquet
  size:    122 KB
  rows:    3,959

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-12-18 04:00:00	SPY	ETF	91.39	91.44	91.33	91.4	5775.0
2008-12-18 05:00:00	SPY	ETF	91.49	91.52	91.05	91.05	500.0
2008-12-18 06:00:00	SPY	ETF	91.25	91.42	91.25	91.4	118110.0
2008-12-18 07:00:00	SPY	ETF	91.36	91.49	90.93	91.4	1100112.0
2008-12-18 08:00:00	SPY	ETF	91.41	91.81	91.25	91.6	3481595.0
2008-12-18 09:00:00	SPY	ETF	91.59	91.71	90.5	90.68	29767917.0
2008-12-18 10:00:00	SPY	ETF	90.69	91.58	90.67	91.43	46679826.0
2008-12-18 11:00:00	SPY	ETF	91.44	91.67	90.85	91.35	32480521.0
2008-12-18 12:00:00	SPY	ETF	91.35	91.42	90.82	91.1192	31138289.0
2008-12-18 13:00:00	SPY	ETF	91.12	91.27	90.29	90.35	39281093.0
2008-12-18 14:00:00	SPY	ETF	90.35	91.2	89.37	89.93	52520371.0
2008-12-18 15:00:00	SPY	ETF	89.93	90.7	88.21	89.15	93165788.0
2008-12-18 16:00:00	SPY	ETF	89.18	90.9624	88.9	89.62	20595719.0
2008-12-18 17:00:00	SPY	ETF	89.64	89.79	89.56	89.74	18190021.0
2008-12-18 18:00:00	SPY	ETF	89.74	90.04	89.67	89.91	230338.0
2008-12-18 19:00:00	SPY	ETF	89.91	90.08	89.82	89.98	103572.0
2008-12-18 06:00:00	QQQ	ETF	30.36	30.36	30.36	30.36	500.0
2008-12-18 07:00:00	QQQ	ETF	30.3	30.3	30.15	30.24	160810.0
2008-12-18 08:00:00	QQQ	ETF	30.24	30.33	30.16	30.23	2194056.0
2008-12-18 09:00:00	QQQ	ETF	30.21	30.36	29.99	30.11	13766508.0
2008-12-18 10:00:00	QQQ	ETF	30.11	30.4	30.11	30.3	21121143.0
2008-12-18 11:00:00	QQQ	ETF	30.2901	30.35	30.12	30.32	11926989.0
2008-12-18 12:00:00	QQQ	ETF	30.32	30.35	30.17	30.23	7413430.0
2008-12-18 13:00:00	QQQ	ETF	30.23	30.28	29.96	29.97	10564809.0
2008-12-18 14:00:00	QQQ	ETF	29.97	30.06	29.76	29.89	21294655.0
2008-12-18 15:00:00	QQQ	ETF	29.89	29.89	29.36	29.69	39776906.0
2008-12-18 16:00:00	QQQ	ETF	29.69	30.13	29.5913	29.9	9386100.0
2008-12-18 17:00:00	QQQ	ETF	29.9	30.0	29.88	29.99	183682.0
2008-12-18 18:00:00	QQQ	ETF	29.98	30.03	29.97	30.0	158721.0
2008-12-18 19:00:00	QQQ	ETF	30.01	30.07	30.0	30.03	111183.0
2008-12-18 07:00:00	IWM	ETF	48.49	48.65	48.37	48.65	160825.0
2008-12-18 08:00:00	IWM	ETF	48.65	48.96	48.61	48.81	353423.0
2008-12-18 09:00:00	IWM	ETF	48.81	49.01	48.1	48.42	6019186.0
2008-12-18 10:00:00	IWM	ETF	48.43	49.66	48.43	49.49	16242447.0
2008-12-18 11:00:00	IWM	ETF	49.5	49.63	48.97	49.28	8168818.0
2008-12-18 12:00:00	IWM	ETF	49.28	49.34	48.73	48.85	4798982.0
2008-12-18 13:00:00	IWM	ETF	48.84	48.97	48.62	48.68	8250025.0
2008-12-18 14:00:00	IWM	ETF	48.67	48.8	47.98	48.36	9938922.0
2008-12-18 15:00:00	IWM	ETF	48.37	48.38	47.32	48.21	19344627.0
2008-12-18 16:00:00	IWM	ETF	48.24	49.12	48.21	48.7	2840050.0
2008-12-18 17:00:00	IWM	ETF	48.75	48.81	48.69	48.75	12951.0
2008-12-18 18:00:00	IWM	ETF	48.75	48.85	48.75	48.85	2300.0
2008-12-18 19:00:00	IWM	ETF	48.76	49.06	48.75	48.94	1630.0
2008-12-18 07:00:00	DIA	ETF	88.53	88.76	88.38	88.76	1654.0
2008-12-18 08:00:00	DIA	ETF	88.85	89.15	88.65	89.07	85209.0
2008-12-18 09:00:00	DIA	ETF	89.04	89.04	88.0	88.18	2508836.0
2008-12-18 10:00:00	DIA	ETF	88.2	88.77	88.17	88.56	4079656.0
2008-12-18 11:00:00	DIA	ETF	88.58	88.8	87.99	88.39	2631275.0
2008-12-18 12:00:00	DIA	ETF	88.37	88.44	87.77	88.0	2059752.0
2008-12-18 13:00:00	DIA	ETF	88.0	88.17	87.32	87.38	2319541.0

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

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