PREVIEW / etf_1hour / 2009-09-03

all etf 1-hour files

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

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-03 04:00:00	SPY	ETF	100.3	100.45	100.3	100.45	3850.0
2009-09-03 05:00:00	SPY	ETF	100.4	100.4	100.31	100.31	5200.0
2009-09-03 06:00:00	SPY	ETF	100.35	100.41	100.29	100.41	3100.0
2009-09-03 07:00:00	SPY	ETF	100.44	100.87	100.4	100.66	830827.0
2009-09-03 08:00:00	SPY	ETF	100.65	100.82	100.35	100.46	5363247.0
2009-09-03 09:00:00	SPY	ETF	100.45	100.62	100.09	100.35	20299671.0
2009-09-03 10:00:00	SPY	ETF	100.35	100.77	99.59	100.01	37366027.0
2009-09-03 11:00:00	SPY	ETF	100.01	100.33	100.0	100.17	14743789.0
2009-09-03 12:00:00	SPY	ETF	100.17	100.29	100.09	100.15	12832242.0
2009-09-03 13:00:00	SPY	ETF	100.1507	100.38	100.15	100.19	7841528.0
2009-09-03 14:00:00	SPY	ETF	100.1999	100.27	99.92	100.08	7014739.0
2009-09-03 15:00:00	SPY	ETF	100.07	100.77	100.06	100.66	26969540.0
2009-09-03 16:00:00	SPY	ETF	100.66	100.79	99.8906	100.68	9684059.0
2009-09-03 17:00:00	SPY	ETF	100.68	100.71	100.2021	100.67	118113.0
2009-09-03 18:00:00	SPY	ETF	100.69	100.72	100.65	100.66	176340.0
2009-09-03 19:00:00	SPY	ETF	100.66	100.77	100.66	100.76	41998.0
2009-09-03 04:00:00	QQQ	ETF	39.38	39.38	39.38	39.38	100.0
2009-09-03 05:00:00	QQQ	ETF	39.41	39.41	39.39	39.39	7500.0
2009-09-03 06:00:00	QQQ	ETF	39.42	39.42	39.42	39.42	2000.0
2009-09-03 07:00:00	QQQ	ETF	39.41	39.61	39.41	39.52	180034.0
2009-09-03 08:00:00	QQQ	ETF	39.52	39.56	39.39	39.47	668933.0
2009-09-03 09:00:00	QQQ	ETF	39.45	39.5	39.16	39.28	13961325.0
2009-09-03 10:00:00	QQQ	ETF	39.27	39.38	39.02	39.2501	21002648.0
2009-09-03 11:00:00	QQQ	ETF	39.26	39.38	39.25	39.3601	8432407.0
2009-09-03 12:00:00	QQQ	ETF	39.3501	39.428	39.3301	39.36	3738303.0
2009-09-03 13:00:00	QQQ	ETF	39.37	39.49	39.35	39.4107	4115287.0
2009-09-03 14:00:00	QQQ	ETF	39.412	39.43	39.26	39.3505	5070863.0
2009-09-03 15:00:00	QQQ	ETF	39.36	39.5702	39.34	39.53	11090072.0
2009-09-03 16:00:00	QQQ	ETF	39.52	39.56	39.14	39.54	5747420.0
2009-09-03 17:00:00	QQQ	ETF	39.54	39.56	39.53	39.55	14547.0
2009-09-03 18:00:00	QQQ	ETF	39.54	39.56	39.53	39.54	37248.0
2009-09-03 19:00:00	QQQ	ETF	39.55	39.57	39.54	39.57	12400.0
2009-09-03 07:00:00	IWM	ETF	55.95	56.22	55.94	56.1	93764.0
2009-09-03 08:00:00	IWM	ETF	56.1	56.21	55.86	56.03	937763.0
2009-09-03 09:00:00	IWM	ETF	56.03	56.12	55.53	55.73	7065964.0
2009-09-03 10:00:00	IWM	ETF	55.73	55.96	55.21	55.6	11072787.0
2009-09-03 11:00:00	IWM	ETF	55.61	55.87	55.6	55.75	3902603.0
2009-09-03 12:00:00	IWM	ETF	55.74	55.9	55.73	55.79	1890945.0
2009-09-03 13:00:00	IWM	ETF	55.8	55.93	55.79	55.82	1814645.0
2009-09-03 14:00:00	IWM	ETF	55.83	55.91	55.67	55.81	2304463.0
2009-09-03 15:00:00	IWM	ETF	55.81	56.31	55.795	56.26	6419095.0
2009-09-03 16:00:00	IWM	ETF	56.26	56.3192	56.15	56.29	961567.0
2009-09-03 17:00:00	IWM	ETF	56.22	56.24	56.18	56.2	1600.0
2009-09-03 18:00:00	IWM	ETF	56.21	56.21	56.18	56.2	1132.0
2009-09-03 19:00:00	IWM	ETF	56.21	56.21	56.2	56.21	2400.0
2009-09-03 04:00:00	DIA	ETF	93.16	93.16	93.16	93.16	100.0
2009-09-03 07:00:00	DIA	ETF	93.31	93.63	93.3	93.55	10500.0
2009-09-03 08:00:00	DIA	ETF	93.56	93.62	93.28	93.31	60372.0
2009-09-03 09:00:00	DIA	ETF	93.37	93.48	93.04	93.23	1353678.0
2009-09-03 10:00:00	DIA	ETF	93.3	93.41	92.63	92.98	2167448.0

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

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