PREVIEW / etf_1hour / 2009-09-10

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-09-10.parquet
  size:    144 KB
  rows:    4,412

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-10 04:00:00	SPY	ETF	104.01	104.03	103.98	104.03	1700.0
2009-09-10 05:00:00	SPY	ETF	103.97	103.97	103.58	103.58	600.0
2009-09-10 06:00:00	SPY	ETF	103.63	103.63	103.39	103.44	5030.0
2009-09-10 07:00:00	SPY	ETF	103.42	103.76	103.42	103.69	157398.0
2009-09-10 08:00:00	SPY	ETF	103.69	104.01	103.33	103.82	3438443.0
2009-09-10 09:00:00	SPY	ETF	103.83	103.88	103.22	103.54	23006967.0
2009-09-10 10:00:00	SPY	ETF	103.54	104.13	103.51	104.09	24628304.0
2009-09-10 11:00:00	SPY	ETF	104.1	104.27	103.92	104.03	17742848.0
2009-09-10 12:00:00	SPY	ETF	104.02	104.19	103.94	104.17	8032653.0
2009-09-10 13:00:00	SPY	ETF	104.16	104.73	104.08	104.71	25172703.0
2009-09-10 14:00:00	SPY	ETF	104.71	104.82	104.59	104.66	15049064.0
2009-09-10 15:00:00	SPY	ETF	104.66	104.86	104.0563	104.79	31648640.0
2009-09-10 16:00:00	SPY	ETF	104.8	104.8374	103.57	104.61	11721139.0
2009-09-10 17:00:00	SPY	ETF	104.61	104.66	104.6	104.65	41933.0
2009-09-10 18:00:00	SPY	ETF	104.66	104.82	104.52	104.54	102955.0
2009-09-10 19:00:00	SPY	ETF	104.56	104.59	104.55	104.55	65276.0
2009-09-10 04:00:00	QQQ	ETF	41.13	41.13	41.13	41.13	200.0
2009-09-10 06:00:00	QQQ	ETF	40.99	40.99	40.99	40.99	300.0
2009-09-10 07:00:00	QQQ	ETF	40.93	41.08	40.92	41.05	135598.0
2009-09-10 08:00:00	QQQ	ETF	41.05	41.21	40.99	41.12	599197.0
2009-09-10 09:00:00	QQQ	ETF	41.11	41.27	41.04	41.1574	14579091.0
2009-09-10 10:00:00	QQQ	ETF	41.152	41.3	41.0	41.258	19283075.0
2009-09-10 11:00:00	QQQ	ETF	41.26	41.34	41.16	41.25	9397515.0
2009-09-10 12:00:00	QQQ	ETF	41.25	41.3	41.2	41.27	3568742.0
2009-09-10 13:00:00	QQQ	ETF	41.28	41.4779	41.17	41.468	13217913.0
2009-09-10 14:00:00	QQQ	ETF	41.47	41.52	41.34	41.44	9269098.0
2009-09-10 15:00:00	QQQ	ETF	41.44	41.53	41.3	41.47	15647098.0
2009-09-10 16:00:00	QQQ	ETF	41.47	41.53	41.2044	41.49	7404860.0
2009-09-10 17:00:00	QQQ	ETF	41.48	41.52	41.1049	41.52	1759799.0
2009-09-10 18:00:00	QQQ	ETF	41.52	41.52	41.48	41.48	72805.0
2009-09-10 19:00:00	QQQ	ETF	41.48	41.5	41.47	41.48	46488.0
2009-09-10 06:00:00	IWM	ETF	58.58	58.58	58.58	58.58	1400.0
2009-09-10 07:00:00	IWM	ETF	58.5	58.67	58.47	58.65	6466.0
2009-09-10 08:00:00	IWM	ETF	58.65	58.87	58.45	58.74	93979.0
2009-09-10 09:00:00	IWM	ETF	58.74	58.79	58.2	58.58	5645672.0
2009-09-10 10:00:00	IWM	ETF	58.58	58.9	58.49	58.88	4702344.0
2009-09-10 11:00:00	IWM	ETF	58.89	59.09	58.82	58.93	4465323.0
2009-09-10 12:00:00	IWM	ETF	58.93	59.06	58.82	59.02	1824850.0
2009-09-10 13:00:00	IWM	ETF	59.02	59.46	58.95	59.45	5538178.0
2009-09-10 14:00:00	IWM	ETF	59.46	59.51	59.26	59.32	4481741.0
2009-09-10 15:00:00	IWM	ETF	59.33	59.56	59.125	59.47	8255764.0
2009-09-10 16:00:00	IWM	ETF	59.47	59.47	59.33	59.44	1612081.0
2009-09-10 17:00:00	IWM	ETF	59.4	59.5	59.39	59.44	111313.0
2009-09-10 18:00:00	IWM	ETF	59.47	59.47	59.47	59.47	1999.0
2009-09-10 19:00:00	IWM	ETF	59.57	59.63	59.53	59.53	700.0
2009-09-10 07:00:00	DIA	ETF	95.39	95.48	95.39	95.48	1200.0
2009-09-10 08:00:00	DIA	ETF	95.43	95.73	95.37	95.62	76634.0
2009-09-10 09:00:00	DIA	ETF	95.61	95.71	95.19	95.48	1459704.0
2009-09-10 10:00:00	DIA	ETF	95.4794	95.85	95.42	95.83	1400041.0
2009-09-10 11:00:00	DIA	ETF	95.84	95.98	95.74	95.7813	985086.0

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

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