PREVIEW / etf_1hour / 2008-10-09

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-10-09.parquet
  size:    116 KB
  rows:    3,782

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
2008-10-09 04:00:00	SPY	ETF	100.27	100.47	100.08	100.4	10300.0
2008-10-09 05:00:00	SPY	ETF	100.4	100.4	99.23	99.47	31800.0
2008-10-09 06:00:00	SPY	ETF	99.4	99.62	99.0	99.44	137500.0
2008-10-09 07:00:00	SPY	ETF	99.5	99.88	98.75	98.78	1206591.0
2008-10-09 08:00:00	SPY	ETF	98.76	100.39	97.75	99.54	6887282.0
2008-10-09 09:00:00	SPY	ETF	99.54	100.62	99.0	99.14	56982305.0
2008-10-09 10:00:00	SPY	ETF	99.15	99.61	97.01	97.22	74772526.0
2008-10-09 11:00:00	SPY	ETF	97.21	99.0	95.93	97.46	78154518.0
2008-10-09 12:00:00	SPY	ETF	97.45	98.5012	96.69	97.15	29170044.0
2008-10-09 13:00:00	SPY	ETF	97.15	98.35	96.91	97.3	42856338.0
2008-10-09 14:00:00	SPY	ETF	97.3	97.66	95.55	95.69	54443633.0
2008-10-09 15:00:00	SPY	ETF	95.69	96.35	90.9	91.75	155125234.0
2008-10-09 16:00:00	SPY	ETF	91.72	99.56	90.27	90.73	26665602.0
2008-10-09 17:00:00	SPY	ETF	90.68	99.58	90.68	91.22	3149796.0
2008-10-09 18:00:00	SPY	ETF	91.22	91.32	90.5	91.12	3834252.0
2008-10-09 19:00:00	SPY	ETF	91.01	91.25	90.8	90.85	162167.0
2008-10-09 04:00:00	QQQ	ETF	33.43	33.46	33.32	33.42	5600.0
2008-10-09 05:00:00	QQQ	ETF	33.35	33.37	33.24	33.24	10300.0
2008-10-09 06:00:00	QQQ	ETF	33.2	33.2	33.04	33.18	20000.0
2008-10-09 07:00:00	QQQ	ETF	33.09	33.21	32.84	32.88	738049.0
2008-10-09 08:00:00	QQQ	ETF	32.88	33.27	32.72	33.13	3100079.0
2008-10-09 09:00:00	QQQ	ETF	33.13	33.68	33.0	33.18	31410197.0
2008-10-09 10:00:00	QQQ	ETF	33.18	33.45	32.74	32.87	49459463.0
2008-10-09 11:00:00	QQQ	ETF	32.87	33.46	32.37	33.13	52246862.0
2008-10-09 12:00:00	QQQ	ETF	33.14	33.34	32.79	32.95	20271571.0
2008-10-09 13:00:00	QQQ	ETF	32.94	33.39	32.91	33.06	28608830.0
2008-10-09 14:00:00	QQQ	ETF	33.06	33.18	32.37	32.4	31185149.0
2008-10-09 15:00:00	QQQ	ETF	32.4	32.46	30.97	31.53	99961095.0
2008-10-09 16:00:00	QQQ	ETF	31.53	32.7155	30.98	31.08	18792381.0
2008-10-09 17:00:00	QQQ	ETF	31.1	31.52	31.09	31.26	370496.0
2008-10-09 18:00:00	QQQ	ETF	31.32	31.32	31.0	31.24	269058.0
2008-10-09 19:00:00	QQQ	ETF	31.19	31.27	31.04	31.15	150822.0
2008-10-09 07:00:00	IWM	ETF	55.66	55.92	55.45	55.49	102728.0
2008-10-09 08:00:00	IWM	ETF	55.46	56.98	55.23	55.63	486311.0
2008-10-09 09:00:00	IWM	ETF	55.6	55.93	54.75	54.77	8452120.0
2008-10-09 10:00:00	IWM	ETF	54.78	55.19	53.31	53.46	19662254.0
2008-10-09 11:00:00	IWM	ETF	53.45	54.48	52.8	53.68	15750002.0
2008-10-09 12:00:00	IWM	ETF	53.68	54.35	53.05	53.4	12338990.0
2008-10-09 13:00:00	IWM	ETF	53.4	54.01	53.2	53.42	9623237.0
2008-10-09 14:00:00	IWM	ETF	53.41	53.62	52.3	52.32	15462660.0
2008-10-09 15:00:00	IWM	ETF	52.38	53.2	49.88	49.98	43953203.0
2008-10-09 16:00:00	IWM	ETF	49.98	54.59	48.66	49.22	20560125.0
2008-10-09 17:00:00	IWM	ETF	49.34	54.59	49.3	50.1	518948.0
2008-10-09 18:00:00	IWM	ETF	49.75	50.0	49.6	49.95	4040.0
2008-10-09 19:00:00	IWM	ETF	49.95	49.95	49.6	49.75	4295.0
2008-10-09 04:00:00	DIA	ETF	93.0	93.0	93.0	93.0	200.0
2008-10-09 05:00:00	DIA	ETF	93.55	93.55	93.55	93.55	500.0
2008-10-09 07:00:00	DIA	ETF	93.11	93.64	93.0	93.06	10835.0
2008-10-09 08:00:00	DIA	ETF	93.08	93.97	92.89	93.8	212493.0
2008-10-09 09:00:00	DIA	ETF	93.76	94.51	93.31	93.4	3723463.0

> showing 50 of 3,782 rows — these rows as CSV

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