PREVIEW / etf_1hour / 2008-12-10

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-12-10.parquet
  size:    118 KB
  rows:    3,824

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-12-10 04:00:00	SPY	ETF	90.6	90.78	90.51	90.66	14210.0
2008-12-10 05:00:00	SPY	ETF	90.56	90.66	90.13	90.18	7100.0
2008-12-10 06:00:00	SPY	ETF	90.12	90.76	90.12	90.7	168388.0
2008-12-10 07:00:00	SPY	ETF	90.69	91.08	90.27	90.28	1976463.0
2008-12-10 08:00:00	SPY	ETF	90.29	90.82	90.08	90.34	4582151.0
2008-12-10 09:00:00	SPY	ETF	90.34	90.59	89.75	89.82	31769008.0
2008-12-10 10:00:00	SPY	ETF	89.82	90.98	89.75	90.09	47090442.0
2008-12-10 11:00:00	SPY	ETF	90.09	91.14	89.94	90.89	36084320.0
2008-12-10 12:00:00	SPY	ETF	90.89	91.36	90.05	90.1592	39849709.0
2008-12-10 13:00:00	SPY	ETF	90.15	90.86	89.2	89.4	49223767.0
2008-12-10 14:00:00	SPY	ETF	89.399	89.94	89.0	89.705	66524499.0
2008-12-10 15:00:00	SPY	ETF	89.7	90.7	89.47	90.35	71951613.0
2008-12-10 16:00:00	SPY	ETF	90.32	90.41	89.3523	90.05	30271126.0
2008-12-10 17:00:00	SPY	ETF	90.03	90.08	89.3524	89.98	1096559.0
2008-12-10 18:00:00	SPY	ETF	89.99	90.1	89.81	89.87	106923.0
2008-12-10 19:00:00	SPY	ETF	89.81	90.0	89.6	89.98	130723.0
2008-12-10 04:00:00	QQQ	ETF	30.4	30.43	30.39	30.39	1630.0
2008-12-10 06:00:00	QQQ	ETF	30.42	30.42	30.38	30.38	300.0
2008-12-10 07:00:00	QQQ	ETF	30.45	30.45	30.22	30.22	197260.0
2008-12-10 08:00:00	QQQ	ETF	30.22	30.29	30.16	30.2	1163552.0
2008-12-10 09:00:00	QQQ	ETF	30.2	30.25	29.75	29.94	17611737.0
2008-12-10 10:00:00	QQQ	ETF	29.95	30.27	29.92	30.01	19512378.0
2008-12-10 11:00:00	QQQ	ETF	30.01	30.381	29.96	30.28	15610808.0
2008-12-10 12:00:00	QQQ	ETF	30.28	30.46	30.05	30.09	16135035.0
2008-12-10 13:00:00	QQQ	ETF	30.08	30.29	29.76	29.8	13525984.0
2008-12-10 14:00:00	QQQ	ETF	29.8	30.04	29.62	29.88	30005288.0
2008-12-10 15:00:00	QQQ	ETF	29.88	30.2	29.83	29.92	31728246.0
2008-12-10 16:00:00	QQQ	ETF	29.93	30.146	29.8522	29.92	6430091.0
2008-12-10 17:00:00	QQQ	ETF	29.92	29.94	29.88	29.94	130306.0
2008-12-10 18:00:00	QQQ	ETF	29.92	29.94	29.88	29.88	4649.0
2008-12-10 19:00:00	QQQ	ETF	29.89	29.98	29.84	29.95	119367.0
2008-12-10 05:00:00	IWM	ETF	47.46	47.46	47.46	47.46	1000.0
2008-12-10 07:00:00	IWM	ETF	47.76	47.84	47.45	47.45	68373.0
2008-12-10 08:00:00	IWM	ETF	47.42	47.89	47.25	47.35	116142.0
2008-12-10 09:00:00	IWM	ETF	47.35	47.75	47.04	47.34	7852964.0
2008-12-10 10:00:00	IWM	ETF	47.37	48.35	47.34	47.82	12700836.0
2008-12-10 11:00:00	IWM	ETF	47.82	48.44	47.75	48.13	7468122.0
2008-12-10 12:00:00	IWM	ETF	48.15	48.34	47.56	47.68	7825255.0
2008-12-10 13:00:00	IWM	ETF	47.68	48.08	47.15	47.32	6498082.0
2008-12-10 14:00:00	IWM	ETF	47.31	47.45	46.76	47.04	10011088.0
2008-12-10 15:00:00	IWM	ETF	47.04	47.78	46.84	47.71	14230830.0
2008-12-10 16:00:00	IWM	ETF	47.7	47.94	46.69	47.72	3309890.0
2008-12-10 17:00:00	IWM	ETF	47.7	47.76	47.61	47.7	94170.0
2008-12-10 18:00:00	IWM	ETF	47.51	47.65	47.51	47.51	2030.0
2008-12-10 19:00:00	IWM	ETF	47.45	47.46	47.25	47.3	3000.0
2008-12-10 06:00:00	DIA	ETF	88.01	88.52	88.01	88.44	2100.0
2008-12-10 07:00:00	DIA	ETF	88.47	88.64	88.1	88.1	10440.0
2008-12-10 08:00:00	DIA	ETF	88.1	88.3	87.9	88.21	146970.0
2008-12-10 09:00:00	DIA	ETF	88.13	88.29	87.45	87.48	3931339.0
2008-12-10 10:00:00	DIA	ETF	87.5	88.58	87.43	87.82	5099353.0

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

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