PREVIEW / etf_1hour / 2009-09-11

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-09-11.parquet
  size:    140 KB
  rows:    4,323

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-09-11 04:00:00	SPY	ETF	104.6	104.69	104.57	104.69	3100.0
2009-09-11 05:00:00	SPY	ETF	104.75	104.86	104.75	104.81	4457.0
2009-09-11 06:00:00	SPY	ETF	104.73	104.88	104.73	104.87	23350.0
2009-09-11 07:00:00	SPY	ETF	104.86	104.88	104.76	104.82	128283.0
2009-09-11 08:00:00	SPY	ETF	104.81	104.87	104.73	104.82	1112498.0
2009-09-11 09:00:00	SPY	ETF	104.81	105.28	104.81	105.19	28983515.0
2009-09-11 10:00:00	SPY	ETF	105.2	105.3	104.76	105.07	30653260.0
2009-09-11 11:00:00	SPY	ETF	105.07	105.19	104.69	104.83	17569833.0
2009-09-11 12:00:00	SPY	ETF	104.84	105.05	104.28	104.56	16337982.0
2009-09-11 13:00:00	SPY	ETF	104.56	104.79	104.42	104.44	17034234.0
2009-09-11 14:00:00	SPY	ETF	104.43	104.84	104.43	104.67	12763406.0
2009-09-11 15:00:00	SPY	ETF	104.68	104.98	104.6	104.75	19449169.0
2009-09-11 16:00:00	SPY	ETF	104.76	105.11	104.39	104.71	7860473.0
2009-09-11 17:00:00	SPY	ETF	104.71	104.73	104.6	104.71	138766.0
2009-09-11 18:00:00	SPY	ETF	104.68	104.79	104.6	104.7	79524.0
2009-09-11 19:00:00	SPY	ETF	104.7	104.78	104.66	104.75	32122.0
2009-09-11 20:00:00	SPY	ETF	104.75	104.75	104.75	104.75	100.0
2009-09-11 04:00:00	QQQ	ETF	41.44	41.45	41.44	41.45	400.0
2009-09-11 05:00:00	QQQ	ETF	41.54	41.54	41.54	41.54	585.0
2009-09-11 06:00:00	QQQ	ETF	41.53	41.55	41.53	41.55	400.0
2009-09-11 07:00:00	QQQ	ETF	41.53	41.62	41.53	41.57	56350.0
2009-09-11 08:00:00	QQQ	ETF	41.59	41.59	41.52	41.58	2072643.0
2009-09-11 09:00:00	QQQ	ETF	41.56	41.65	41.41	41.53	11997938.0
2009-09-11 10:00:00	QQQ	ETF	41.53	41.61	41.38	41.54	16545433.0
2009-09-11 11:00:00	QQQ	ETF	41.54	41.62	41.37	41.43	13970200.0
2009-09-11 12:00:00	QQQ	ETF	41.43	41.445	41.22	41.36	10334251.0
2009-09-11 13:00:00	QQQ	ETF	41.37	41.46	41.23	41.33	9239735.0
2009-09-11 14:00:00	QQQ	ETF	41.32	41.51	41.32	41.45	7622010.0
2009-09-11 15:00:00	QQQ	ETF	41.45	41.56	41.42	41.51	10412430.0
2009-09-11 16:00:00	QQQ	ETF	41.52	41.5569	41.4804	41.52	4483632.0
2009-09-11 17:00:00	QQQ	ETF	41.52	41.53	41.5	41.52	40565.0
2009-09-11 18:00:00	QQQ	ETF	41.51	41.52	41.51	41.51	6267.0
2009-09-11 19:00:00	QQQ	ETF	41.51	41.52	41.51	41.52	20683.0
2009-09-11 07:00:00	IWM	ETF	59.59	59.65	59.59	59.64	53986.0
2009-09-11 08:00:00	IWM	ETF	59.6	59.65	59.53	59.57	41894.0
2009-09-11 09:00:00	IWM	ETF	59.56	59.93	59.41	59.84	6603874.0
2009-09-11 10:00:00	IWM	ETF	59.84	59.99	59.49	59.72	5354679.0
2009-09-11 11:00:00	IWM	ETF	59.71	59.795	59.42	59.61	3876573.0
2009-09-11 12:00:00	IWM	ETF	59.6	59.61	59.1	59.34	3699110.0
2009-09-11 13:00:00	IWM	ETF	59.34	59.44	59.19	59.21	1885343.0
2009-09-11 14:00:00	IWM	ETF	59.21	59.47	59.21	59.35	2117216.0
2009-09-11 15:00:00	IWM	ETF	59.35	59.59	59.32	59.4	4146030.0
2009-09-11 16:00:00	IWM	ETF	59.4	59.4672	59.34	59.41	650222.0
2009-09-11 17:00:00	IWM	ETF	59.43	59.43	59.37	59.41	5013.0
2009-09-11 18:00:00	IWM	ETF	59.37	59.37	59.37	59.37	700.0
2009-09-11 19:00:00	IWM	ETF	59.4	59.41	59.4	59.41	1035.0
2009-09-11 04:00:00	DIA	ETF	96.19	96.19	96.19	96.19	100.0
2009-09-11 07:00:00	DIA	ETF	96.31	96.31	96.31	96.31	600.0
2009-09-11 08:00:00	DIA	ETF	96.31	96.34	96.23	96.28	34490.0
2009-09-11 09:00:00	DIA	ETF	96.3	96.62	96.26	96.5301	1519993.0

> showing 50 of 4,323 rows — these rows as CSV

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