PREVIEW / etf_1hour / 2008-09-11

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-09-11.parquet
  size:    113 KB
  rows:    3,635

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-09-11 04:00:00	SPY	ETF	122.99	123.09	122.99	123.09	500.0
2008-09-11 05:00:00	SPY	ETF	122.57	122.57	122.47	122.54	600.0
2008-09-11 06:00:00	SPY	ETF	122.28	122.79	122.27	122.77	119700.0
2008-09-11 07:00:00	SPY	ETF	122.79	122.82	122.0	122.22	1956357.0
2008-09-11 08:00:00	SPY	ETF	122.25	122.77	121.65	121.9	7090500.0
2008-09-11 09:00:00	SPY	ETF	121.9	122.32	121.6	121.83	44341358.0
2008-09-11 10:00:00	SPY	ETF	121.83	123.23	121.8	123.06	58504043.0
2008-09-11 11:00:00	SPY	ETF	123.06	123.83	122.69	123.69	46911927.0
2008-09-11 12:00:00	SPY	ETF	123.69	124.2	123.14	123.38	41806419.0
2008-09-11 13:00:00	SPY	ETF	123.38	123.92	122.67	123.7	32636856.0
2008-09-11 14:00:00	SPY	ETF	123.69	124.62	123.55	124.15	35850321.0
2008-09-11 15:00:00	SPY	ETF	124.16	125.55	123.44	125.51	72735324.0
2008-09-11 16:00:00	SPY	ETF	125.57	125.79	123.45	125.76	16525960.0
2008-09-11 17:00:00	SPY	ETF	125.77	125.8	125.48	125.64	4513565.0
2008-09-11 18:00:00	SPY	ETF	125.64	125.75	125.37	125.45	411093.0
2008-09-11 19:00:00	SPY	ETF	125.45	125.58	125.36	125.36	49256.0
2008-09-11 04:00:00	QQQ	ETF	42.43	42.43	42.39	42.39	700.0
2008-09-11 05:00:00	QQQ	ETF	42.42	42.42	42.21	42.21	1700.0
2008-09-11 06:00:00	QQQ	ETF	42.31	42.33	42.28	42.31	3800.0
2008-09-11 07:00:00	QQQ	ETF	42.3	42.34	42.15	42.2	874767.0
2008-09-11 08:00:00	QQQ	ETF	42.2	42.37	41.99	42.09	3366739.0
2008-09-11 09:00:00	QQQ	ETF	42.09	42.4	42.08	42.319	25093059.0
2008-09-11 10:00:00	QQQ	ETF	42.32	42.92	42.31	42.88	36666073.0
2008-09-11 11:00:00	QQQ	ETF	42.8899	43.18	42.69	43.18	26187578.0
2008-09-11 12:00:00	QQQ	ETF	43.18	43.33	42.95	43.08	16763241.0
2008-09-11 13:00:00	QQQ	ETF	43.07	43.16	42.76	43.08	19597913.0
2008-09-11 14:00:00	QQQ	ETF	43.08	43.34	43.04	43.18	20259755.0
2008-09-11 15:00:00	QQQ	ETF	43.18	43.69	43.07	43.67	41212438.0
2008-09-11 16:00:00	QQQ	ETF	43.65	43.75	43.0025	43.73	9486958.0
2008-09-11 17:00:00	QQQ	ETF	43.73	43.75	42.7674	43.66	1230810.0
2008-09-11 18:00:00	QQQ	ETF	43.68	43.73	43.66	43.66	111038.0
2008-09-11 19:00:00	QQQ	ETF	43.66	43.7	43.66	43.66	22110.0
2008-09-11 05:00:00	IWM	ETF	70.92	70.92	70.8	70.8	48000.0
2008-09-11 06:00:00	IWM	ETF	70.84	70.93	70.84	70.93	2400.0
2008-09-11 07:00:00	IWM	ETF	70.92	70.93	70.4	70.56	336114.0
2008-09-11 08:00:00	IWM	ETF	70.58	70.94	70.31	70.46	1182891.0
2008-09-11 09:00:00	IWM	ETF	70.46	70.68	69.9	70.28	18132514.0
2008-09-11 10:00:00	IWM	ETF	70.28	71.18	70.26	71.15	26361623.0
2008-09-11 11:00:00	IWM	ETF	71.15	71.55	70.85	71.44	16250255.0
2008-09-11 12:00:00	IWM	ETF	71.45	71.85	71.05	71.15	14129013.0
2008-09-11 13:00:00	IWM	ETF	71.16	71.56	70.62	71.28	10997764.0
2008-09-11 14:00:00	IWM	ETF	71.27	71.82	71.12	71.43	13937380.0
2008-09-11 15:00:00	IWM	ETF	71.44	72.0	70.86	71.93	26954422.0
2008-09-11 16:00:00	IWM	ETF	71.92	72.36	71.17	72.3	9365002.0
2008-09-11 17:00:00	IWM	ETF	72.36	72.36	72.14	72.2	18483.0
2008-09-11 18:00:00	IWM	ETF	72.19	72.2	72.06	72.06	3367.0
2008-09-11 19:00:00	IWM	ETF	72.15	72.15	72.15	72.15	2000.0
2008-09-11 06:00:00	DIA	ETF	112.2	112.2	112.2	112.2	200.0
2008-09-11 07:00:00	DIA	ETF	112.29	112.29	111.63	111.84	44909.0
2008-09-11 08:00:00	DIA	ETF	111.78	111.92	111.5	111.71	192785.0

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

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