PREVIEW / etf_1hour / 2009-12-24

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-12-24.parquet
  size:    93 KB
  rows:    2,711

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
2009-12-24 04:00:00	SPY	ETF	112.15	112.25	112.15	112.25	1597.0
2009-12-24 05:00:00	SPY	ETF	112.27	112.33	112.26	112.29	3800.0
2009-12-24 06:00:00	SPY	ETF	112.34	112.34	112.27	112.27	54000.0
2009-12-24 07:00:00	SPY	ETF	112.29	112.33	112.16	112.2	103660.0
2009-12-24 08:00:00	SPY	ETF	112.18	112.3	112.05	112.19	2706689.0
2009-12-24 09:00:00	SPY	ETF	112.19	112.42	111.9939	112.3801	7733130.0
2009-12-24 10:00:00	SPY	ETF	112.38	112.6	112.34	112.44	8531750.0
2009-12-24 11:00:00	SPY	ETF	112.4401	112.5	112.38	112.48	3306207.0
2009-12-24 12:00:00	SPY	ETF	112.4795	112.59	111.9948	112.57	12682569.0
2009-12-24 13:00:00	SPY	ETF	112.6	112.63	111.9948	112.52	4227736.0
2009-12-24 14:00:00	SPY	ETF	112.59	112.62	112.55	112.55	6500.0
2009-12-24 15:00:00	SPY	ETF	112.57	112.59	112.55	112.59	994.0
2009-12-24 16:00:00	SPY	ETF	112.58	112.65	112.57	112.6	4600.0
2009-12-24 06:00:00	QQQ	ETF	45.68	45.68	45.68	45.68	400.0
2009-12-24 07:00:00	QQQ	ETF	45.66	45.68	45.64	45.68	12169.0
2009-12-24 08:00:00	QQQ	ETF	45.67	45.69	45.6	45.65	1710811.0
2009-12-24 09:00:00	QQQ	ETF	45.66	45.8	44.249	45.7898	6820767.0
2009-12-24 10:00:00	QQQ	ETF	45.79	45.88	45.78	45.843	6470398.0
2009-12-24 11:00:00	QQQ	ETF	45.84	45.94	45.81	45.93	5655474.0
2009-12-24 12:00:00	QQQ	ETF	45.93	45.98	45.89	45.97	7122440.0
2009-12-24 13:00:00	QQQ	ETF	45.98	46.01	45.6706	45.93	2583507.0
2009-12-24 14:00:00	QQQ	ETF	45.93	45.95	45.9	45.9	1800.0
2009-12-24 15:00:00	QQQ	ETF	45.97	45.97	45.95	45.97	2845.0
2009-12-24 16:00:00	QQQ	ETF	45.95	45.97	45.91	45.97	600.0
2009-12-24 04:00:00	IWM	ETF	63.29	63.29	63.29	63.29	100.0
2009-12-24 07:00:00	IWM	ETF	63.35	63.35	63.33	63.33	5200.0
2009-12-24 08:00:00	IWM	ETF	63.35	63.4	63.24	63.35	394075.0
2009-12-24 09:00:00	IWM	ETF	63.36	63.39	63.13	63.2	4300083.0
2009-12-24 10:00:00	IWM	ETF	63.21	63.29	63.14	63.23	2855343.0
2009-12-24 11:00:00	IWM	ETF	63.23	63.3929	63.15	63.28	3101840.0
2009-12-24 12:00:00	IWM	ETF	63.28	63.3929	63.26	63.35	2288318.0
2009-12-24 13:00:00	IWM	ETF	63.35	63.48	63.32	63.32	1435973.0
2009-12-24 14:00:00	IWM	ETF	63.39	63.39	63.32	63.32	5336.0
2009-12-24 07:00:00	DIA	ETF	104.59	104.59	104.59	104.59	789.0
2009-12-24 08:00:00	DIA	ETF	104.65	104.79	104.56	104.65	3641.0
2009-12-24 09:00:00	DIA	ETF	104.65	104.78	104.55	104.76	547147.0
2009-12-24 10:00:00	DIA	ETF	104.7698	105.0	104.7695	104.93	1001620.0
2009-12-24 11:00:00	DIA	ETF	104.94	104.99	104.87	104.94	685907.0
2009-12-24 12:00:00	DIA	ETF	104.94	105.04	104.89	105.01	1190152.0
2009-12-24 13:00:00	DIA	ETF	104.99	105.11	104.94	105.06	135208.0
2009-12-24 15:00:00	DIA	ETF	105.0	105.02	105.0	105.02	300.0
2009-12-24 16:00:00	DIA	ETF	105.05	105.05	105.05	105.05	103.0
2009-12-24 04:00:00	GLD	ETF	108.23	108.3	108.21	108.29	9600.0
2009-12-24 05:00:00	GLD	ETF	108.3	108.35	108.16	108.16	2800.0
2009-12-24 06:00:00	GLD	ETF	108.05	108.2	108.05	108.17	15550.0
2009-12-24 07:00:00	GLD	ETF	108.08	108.15	107.88	107.89	135015.0
2009-12-24 08:00:00	GLD	ETF	107.88	107.93	107.55	107.75	459343.0
2009-12-24 09:00:00	GLD	ETF	107.7	108.11	107.7	107.98	1813397.0
2009-12-24 10:00:00	GLD	ETF	107.98	108.26	107.84	107.89	2416806.0
2009-12-24 11:00:00	GLD	ETF	107.89	108.25	107.82	108.2301	1026064.0

> showing 50 of 2,711 rows — these rows as CSV

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