PREVIEW / etf_1hour / 2009-08-10

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-08-10.parquet
  size:    140 KB
  rows:    4,258

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-08-10 04:00:00	SPY	ETF	101.01	101.01	101.01	101.01	2000.0
2009-08-10 05:00:00	SPY	ETF	101.02	101.04	100.98	100.98	600.0
2009-08-10 06:00:00	SPY	ETF	100.93	100.97	100.88	100.88	6200.0
2009-08-10 07:00:00	SPY	ETF	100.9	100.9	100.65	100.85	524162.0
2009-08-10 08:00:00	SPY	ETF	100.86	101.0	100.52	100.68	2350244.0
2009-08-10 09:00:00	SPY	ETF	100.69	101.07	100.55	100.93	17402290.0
2009-08-10 10:00:00	SPY	ETF	100.92	101.22	100.75	101.1	18182787.0
2009-08-10 11:00:00	SPY	ETF	101.1	101.22	100.88	100.95	12310612.0
2009-08-10 12:00:00	SPY	ETF	100.96	101.06	100.68	100.72	9310519.0
2009-08-10 13:00:00	SPY	ETF	100.72	100.73	100.41	100.54	20900822.0
2009-08-10 14:00:00	SPY	ETF	100.54	100.61	100.27	100.6	12507296.0
2009-08-10 15:00:00	SPY	ETF	100.6	100.99	100.5	100.96	30242696.0
2009-08-10 16:00:00	SPY	ETF	100.96	101.23	100.91	101.1	6614434.0
2009-08-10 17:00:00	SPY	ETF	101.12	101.18	101.09	101.12	181212.0
2009-08-10 18:00:00	SPY	ETF	101.1	101.1	101.0	101.03	130565.0
2009-08-10 19:00:00	SPY	ETF	101.01	101.03	101.0	101.03	57987.0
2009-08-10 05:00:00	QQQ	ETF	39.77	39.78	39.77	39.78	3515.0
2009-08-10 06:00:00	QQQ	ETF	39.71	39.71	39.7	39.7	5200.0
2009-08-10 07:00:00	QQQ	ETF	39.66	39.78	39.61	39.78	931540.0
2009-08-10 08:00:00	QQQ	ETF	39.8	39.82	39.64	39.71	1911114.0
2009-08-10 09:00:00	QQQ	ETF	39.71	39.85	39.58	39.7799	12365675.0
2009-08-10 10:00:00	QQQ	ETF	39.77	39.82	39.65	39.7695	10004107.0
2009-08-10 11:00:00	QQQ	ETF	39.76	39.81	39.6	39.61	6770464.0
2009-08-10 12:00:00	QQQ	ETF	39.61	39.67	39.44	39.49	8482090.0
2009-08-10 13:00:00	QQQ	ETF	39.48	39.56	39.39	39.48	10762752.0
2009-08-10 14:00:00	QQQ	ETF	39.49	39.49	39.34	39.4701	7765439.0
2009-08-10 15:00:00	QQQ	ETF	39.48	39.62	39.48	39.6	15624300.0
2009-08-10 16:00:00	QQQ	ETF	39.6	39.7901	39.55	39.7	7093231.0
2009-08-10 17:00:00	QQQ	ETF	39.71	39.71	39.66	39.68	42979.0
2009-08-10 18:00:00	QQQ	ETF	39.69	39.69	39.62	39.62	60347.0
2009-08-10 19:00:00	QQQ	ETF	39.62	39.63	39.61	39.62	32004.0
2009-08-10 07:00:00	IWM	ETF	56.8	56.93	56.79	56.89	51326.0
2009-08-10 08:00:00	IWM	ETF	56.93	57.03	56.69	56.82	201838.0
2009-08-10 09:00:00	IWM	ETF	56.85	57.3	56.71	57.2	6406877.0
2009-08-10 10:00:00	IWM	ETF	57.2	57.469	57.0303	57.37	3825247.0
2009-08-10 11:00:00	IWM	ETF	57.38	57.55	57.28	57.3222	4718343.0
2009-08-10 12:00:00	IWM	ETF	57.33	57.44	57.06	57.1	4113613.0
2009-08-10 13:00:00	IWM	ETF	57.1	57.12	56.81	56.98	3294680.0
2009-08-10 14:00:00	IWM	ETF	56.97	57.03	56.75	57.0	2134957.0
2009-08-10 15:00:00	IWM	ETF	57.0	57.28	57.0	57.17	6861226.0
2009-08-10 16:00:00	IWM	ETF	57.18	57.36	57.18	57.29	6399989.0
2009-08-10 17:00:00	IWM	ETF	57.28	57.29	57.25	57.29	7641.0
2009-08-10 18:00:00	IWM	ETF	57.24	57.29	57.24	57.28	3739.0
2009-08-10 19:00:00	IWM	ETF	57.3	57.43	57.26	57.26	7600.0
2009-08-10 07:00:00	DIA	ETF	93.4	93.49	93.4	93.48	11700.0
2009-08-10 08:00:00	DIA	ETF	93.51	93.66	93.28	93.38	15315.0
2009-08-10 09:00:00	DIA	ETF	93.45	93.67	93.29	93.57	1175749.0
2009-08-10 10:00:00	DIA	ETF	93.5699	93.81	93.39	93.71	1229149.0
2009-08-10 11:00:00	DIA	ETF	93.74	93.81	93.49	93.53	466902.0
2009-08-10 12:00:00	DIA	ETF	93.53	93.59	93.32	93.34	630464.0

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

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