PREVIEW / etf_1hour / 2009-11-04

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-11-04.parquet
  size:    147 KB
  rows:    4,527

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-11-04 04:00:00	SPY	ETF	105.22	105.33	105.21	105.33	1810.0
2009-11-04 05:00:00	SPY	ETF	105.32	105.37	105.31	105.33	2500.0
2009-11-04 06:00:00	SPY	ETF	105.27	105.36	105.27	105.36	5800.0
2009-11-04 07:00:00	SPY	ETF	105.34	105.38	105.12	105.2	337528.0
2009-11-04 08:00:00	SPY	ETF	105.19	105.62	104.53	105.47	2970015.0
2009-11-04 09:00:00	SPY	ETF	105.47	105.72	105.25	105.57	23564463.0
2009-11-04 10:00:00	SPY	ETF	105.58	106.26	105.34	106.24	47932132.0
2009-11-04 11:00:00	SPY	ETF	106.25	106.25	105.8	105.86	16953818.0
2009-11-04 12:00:00	SPY	ETF	105.87	105.94	105.65	105.77	14020184.0
2009-11-04 13:00:00	SPY	ETF	105.77	105.8	105.58	105.69	10644626.0
2009-11-04 14:00:00	SPY	ETF	105.68	106.33	105.11	106.09	55937693.0
2009-11-04 15:00:00	SPY	ETF	106.09	106.115	104.65	104.84	53438355.0
2009-11-04 16:00:00	SPY	ETF	104.84	106.29	104.81	105.15	17545600.0
2009-11-04 17:00:00	SPY	ETF	104.7236	105.24	104.7236	105.14	3684969.0
2009-11-04 18:00:00	SPY	ETF	105.16	105.2	104.97	104.98	186652.0
2009-11-04 19:00:00	SPY	ETF	104.98	105.06	104.88	104.91	370845.0
2009-11-04 04:00:00	QQQ	ETF	41.39	41.41	41.39	41.41	310.0
2009-11-04 05:00:00	QQQ	ETF	41.45	41.45	41.41	41.41	12700.0
2009-11-04 06:00:00	QQQ	ETF	41.44	41.44	41.44	41.44	100.0
2009-11-04 07:00:00	QQQ	ETF	41.43	41.43	41.35	41.39	66313.0
2009-11-04 08:00:00	QQQ	ETF	41.37	41.51	41.37	41.49	1053561.0
2009-11-04 09:00:00	QQQ	ETF	41.49	41.57	41.39	41.56	13524806.0
2009-11-04 10:00:00	QQQ	ETF	41.56	41.86	41.42	41.8501	20112569.0
2009-11-04 11:00:00	QQQ	ETF	41.86	41.87	41.69	41.7	7100301.0
2009-11-04 12:00:00	QQQ	ETF	41.7	41.75	41.64	41.68	5529192.0
2009-11-04 13:00:00	QQQ	ETF	41.672	41.7	41.58	41.62	3289559.0
2009-11-04 14:00:00	QQQ	ETF	41.62	41.86	41.44	41.7924	22643856.0
2009-11-04 15:00:00	QQQ	ETF	41.79	41.8	41.28	41.32	21194591.0
2009-11-04 16:00:00	QQQ	ETF	41.31	41.6866	41.31	41.51	9892235.0
2009-11-04 17:00:00	QQQ	ETF	41.51	41.6	41.48	41.51	462050.0
2009-11-04 18:00:00	QQQ	ETF	41.51	41.53	41.35	41.45	143928.0
2009-11-04 19:00:00	QQQ	ETF	41.45	41.49	41.42	41.42	71418.0
2009-11-04 06:00:00	IWM	ETF	57.36	57.36	57.36	57.36	100.0
2009-11-04 07:00:00	IWM	ETF	57.35	57.35	57.28	57.32	13201.0
2009-11-04 08:00:00	IWM	ETF	57.27	57.57	57.25	57.48	551911.0
2009-11-04 09:00:00	IWM	ETF	57.47	57.55	57.08	57.29	7709050.0
2009-11-04 10:00:00	IWM	ETF	57.3	57.68	57.13	57.55	12887058.0
2009-11-04 11:00:00	IWM	ETF	57.56	57.56	57.16	57.2	7772361.0
2009-11-04 12:00:00	IWM	ETF	57.19	57.24	56.92	57.02	5830185.0
2009-11-04 13:00:00	IWM	ETF	57.02	57.1	56.84	56.95	4216616.0
2009-11-04 14:00:00	IWM	ETF	56.95	57.42	56.58	57.189	17353467.0
2009-11-04 15:00:00	IWM	ETF	57.18	57.18	56.27	56.29	22508141.0
2009-11-04 16:00:00	IWM	ETF	56.3	57.1156	56.25	56.52	7024477.0
2009-11-04 17:00:00	IWM	ETF	56.56	57.5116	56.52	56.52	2035936.0
2009-11-04 18:00:00	IWM	ETF	56.54	56.57	56.54	56.54	2062.0
2009-11-04 19:00:00	IWM	ETF	56.52	56.52	56.5	56.5	1000.0
2009-11-04 07:00:00	DIA	ETF	98.15	98.3	98.15	98.3	2200.0
2009-11-04 08:00:00	DIA	ETF	98.3	98.47	98.23	98.37	40030.0
2009-11-04 09:00:00	DIA	ETF	98.37	98.58	98.26	98.5	1239239.0
2009-11-04 10:00:00	DIA	ETF	98.51	99.295	98.32	99.21	3550937.0

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

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