PREVIEW / etf_1hour / 2008-01-07

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-01-07.parquet
  size:    100 KB
  rows:    3,345

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-01-07 04:00:00	SPY	ETF	141.74	141.96	141.74	141.96	20500.0
2008-01-07 05:00:00	SPY	ETF	142.14	142.14	142.14	142.14	2000.0
2008-01-07 06:00:00	SPY	ETF	142.16	142.22	142.09	142.22	108900.0
2008-01-07 07:00:00	SPY	ETF	142.16	142.29	141.82	141.9	788700.0
2008-01-07 08:00:00	SPY	ETF	141.93	142.28	141.83	141.99	1753900.0
2008-01-07 09:00:00	SPY	ETF	141.99	142.05	141.34	141.69	19905099.0
2008-01-07 10:00:00	SPY	ETF	141.69	141.7	140.1	140.65	40403908.0
2008-01-07 11:00:00	SPY	ETF	140.66	141.9	140.65	141.6	34713295.0
2008-01-07 12:00:00	SPY	ETF	141.6	142.23	141.04	142.06	27894381.0
2008-01-07 13:00:00	SPY	ETF	142.05	142.196	141.12	141.35	21877881.0
2008-01-07 14:00:00	SPY	ETF	141.35	142.16	140.4	140.89	41925743.0
2008-01-07 15:00:00	SPY	ETF	140.89	141.71	140.2	141.46	33592019.0
2008-01-07 16:00:00	SPY	ETF	141.5	141.68	141.055	141.21	5813700.0
2008-01-07 17:00:00	SPY	ETF	141.25	141.28	141.09	141.21	91000.0
2008-01-07 18:00:00	SPY	ETF	141.14	141.28	141.14	141.28	416300.0
2008-01-07 19:00:00	SPY	ETF	141.28	141.35	141.22	141.32	16300.0
2008-01-07 04:00:00	QQQ	ETF	48.62	48.62	48.62	48.62	100.0
2008-01-07 06:00:00	QQQ	ETF	48.63	48.63	48.58	48.62	56700.0
2008-01-07 07:00:00	QQQ	ETF	48.6	48.68	48.46	48.53	682856.0
2008-01-07 08:00:00	QQQ	ETF	48.52	48.61	48.47	48.52	1346785.0
2008-01-07 09:00:00	QQQ	ETF	48.51	48.56	48.2	48.45	23658421.0
2008-01-07 10:00:00	QQQ	ETF	48.4505	48.68	47.43	47.77	47630100.0
2008-01-07 11:00:00	QQQ	ETF	47.77	48.55	47.77	48.3701	35202576.0
2008-01-07 12:00:00	QQQ	ETF	48.37	48.6	48.05	48.53	30834889.0
2008-01-07 13:00:00	QQQ	ETF	48.53	48.6	48.04	48.14	17576514.0
2008-01-07 14:00:00	QQQ	ETF	48.14	48.19	47.71	47.9272	24797465.0
2008-01-07 15:00:00	QQQ	ETF	47.92	48.3	47.47	48.17	41385899.0
2008-01-07 16:00:00	QQQ	ETF	48.18	48.53	48.1111	48.17	12288815.0
2008-01-07 17:00:00	QQQ	ETF	48.18	48.19	48.13	48.16	160862.0
2008-01-07 18:00:00	QQQ	ETF	48.15	48.17	48.12	48.17	33212.0
2008-01-07 19:00:00	QQQ	ETF	48.16	48.17	48.13	48.17	55700.0
2008-01-07 05:00:00	IWM	ETF	72.41	72.45	72.41	72.45	4000.0
2008-01-07 07:00:00	IWM	ETF	72.49	72.54	72.25	72.39	94300.0
2008-01-07 08:00:00	IWM	ETF	72.32	72.5	70.48	72.44	387600.0
2008-01-07 09:00:00	IWM	ETF	72.46	72.53	71.89	72.27	9967031.0
2008-01-07 10:00:00	IWM	ETF	72.27	72.28	71.07	71.45	26485068.0
2008-01-07 11:00:00	IWM	ETF	71.46	72.65	71.45	72.4	27201465.0
2008-01-07 12:00:00	IWM	ETF	72.4	72.85	71.89	72.65	17306636.0
2008-01-07 13:00:00	IWM	ETF	72.65	72.81	72.13	72.36	9905849.0
2008-01-07 14:00:00	IWM	ETF	72.37	72.48	71.51	71.85	17925585.0
2008-01-07 15:00:00	IWM	ETF	71.86	72.29	71.42	72.1	15598357.0
2008-01-07 16:00:00	IWM	ETF	72.1	72.33	71.83	71.83	15498700.0
2008-01-07 17:00:00	IWM	ETF	72.09	72.45	72.06	72.1	5800.0
2008-01-07 18:00:00	IWM	ETF	72.09	72.1	72.06	72.1	4200.0
2008-01-07 19:00:00	IWM	ETF	72.14	72.15	72.1	72.1	1200.0
2008-01-07 07:00:00	DIA	ETF	128.94	128.94	128.7	128.7	3700.0
2008-01-07 08:00:00	DIA	ETF	128.7	128.82	128.61	128.61	19000.0
2008-01-07 09:00:00	DIA	ETF	128.63	128.74	128.2	128.42	1374440.0
2008-01-07 10:00:00	DIA	ETF	128.44	128.44	127.26	127.58	3394491.0
2008-01-07 11:00:00	DIA	ETF	127.58	128.47	127.58	128.2	2179653.0

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

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