PREVIEW / etf_1hour / 2010-10-11

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-10-11.parquet
  size:    155 KB
  rows:    4,972

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
2010-10-11 04:00:00	SPY	ETF	116.61	116.81	116.61	116.81	5000.0
2010-10-11 05:00:00	SPY	ETF	116.77	116.86	116.77	116.86	5200.0
2010-10-11 06:00:00	SPY	ETF	116.81	116.84	116.7	116.73	15000.0
2010-10-11 07:00:00	SPY	ETF	116.76	116.82	116.68	116.78	88998.0
2010-10-11 08:00:00	SPY	ETF	116.85	116.85	115.65	116.67	829255.0
2010-10-11 09:00:00	SPY	ETF	116.69	116.84	116.51	116.59	14583785.0
2010-10-11 10:00:00	SPY	ETF	116.59	116.97	116.52	116.6	25970191.0
2010-10-11 11:00:00	SPY	ETF	116.59	116.85	116.49	116.74	11557985.0
2010-10-11 12:00:00	SPY	ETF	116.745	116.89	116.6802	116.78	7257822.0
2010-10-11 13:00:00	SPY	ETF	116.77	116.88	116.73	116.8599	5120960.0
2010-10-11 14:00:00	SPY	ETF	116.86	116.87	116.71	116.75	7475909.0
2010-10-11 15:00:00	SPY	ETF	116.75	116.8	116.25	116.65	22710413.0
2010-10-11 16:00:00	SPY	ETF	116.65	116.825	116.585	116.68	3152184.0
2010-10-11 17:00:00	SPY	ETF	116.68	116.73	116.66	116.7	89668.0
2010-10-11 18:00:00	SPY	ETF	116.68	116.73	116.65	116.72	45970.0
2010-10-11 19:00:00	SPY	ETF	116.71	116.71	116.59	116.71	132710.0
2010-10-11 06:00:00	QQQ	ETF	49.79	49.79	49.75	49.75	3200.0
2010-10-11 07:00:00	QQQ	ETF	49.76	49.81	49.75	49.78	45605.0
2010-10-11 08:00:00	QQQ	ETF	49.79	49.8	49.75	49.77	98237.0
2010-10-11 09:00:00	QQQ	ETF	49.77	49.93	49.72	49.8	6083370.0
2010-10-11 10:00:00	QQQ	ETF	49.81	50.02	49.79	49.8338	11335063.0
2010-10-11 11:00:00	QQQ	ETF	49.84	49.95	49.79	49.89	5667041.0
2010-10-11 12:00:00	QQQ	ETF	49.9	49.99	49.86	49.93	2781230.0
2010-10-11 13:00:00	QQQ	ETF	49.93	49.99	49.9	49.98	1479636.0
2010-10-11 14:00:00	QQQ	ETF	49.98	49.99	49.9	49.92	2505070.0
2010-10-11 15:00:00	QQQ	ETF	49.92	49.95	49.62	49.77	9123836.0
2010-10-11 16:00:00	QQQ	ETF	49.76	49.82	49.69	49.77	2456966.0
2010-10-11 17:00:00	QQQ	ETF	49.78	49.81	49.77	49.81	24494.0
2010-10-11 18:00:00	QQQ	ETF	49.78	49.8	49.78	49.78	11840.0
2010-10-11 19:00:00	QQQ	ETF	49.79	49.79	49.73	49.77	18575.0
2010-10-11 04:00:00	IWM	ETF	69.45	69.46	69.45	69.46	1000.0
2010-10-11 06:00:00	IWM	ETF	69.41	69.41	69.41	69.41	200.0
2010-10-11 07:00:00	IWM	ETF	69.44	69.48	69.43	69.45	34100.0
2010-10-11 08:00:00	IWM	ETF	69.33	69.45	69.32	69.34	96661.0
2010-10-11 09:00:00	IWM	ETF	69.35	69.51	69.18	69.3	2780876.0
2010-10-11 10:00:00	IWM	ETF	69.3	69.57	69.14	69.25	6803391.0
2010-10-11 11:00:00	IWM	ETF	69.24	69.61	69.14	69.52	4314619.0
2010-10-11 12:00:00	IWM	ETF	69.52	69.74	69.45	69.66	3492155.0
2010-10-11 13:00:00	IWM	ETF	69.66	69.86	69.63	69.83	2271299.0
2010-10-11 14:00:00	IWM	ETF	69.84	69.85	69.72	69.74	2894457.0
2010-10-11 15:00:00	IWM	ETF	69.75	69.805	69.32	69.39	8132909.0
2010-10-11 16:00:00	IWM	ETF	69.38	69.6022	69.31	69.35	1173148.0
2010-10-11 17:00:00	IWM	ETF	69.4	69.4	69.39	69.39	400.0
2010-10-11 19:00:00	IWM	ETF	69.38	69.38	69.38	69.38	200.0
2010-10-11 08:00:00	DIA	ETF	110.35	110.36	110.27	110.27	4475.0
2010-10-11 09:00:00	DIA	ETF	110.29	110.37	110.12	110.17	437312.0
2010-10-11 10:00:00	DIA	ETF	110.18	110.4	110.08	110.13	678253.0
2010-10-11 11:00:00	DIA	ETF	110.14	110.31	110.04	110.24	451770.0
2010-10-11 12:00:00	DIA	ETF	110.25	110.33	110.19	110.28	489391.0
2010-10-11 13:00:00	DIA	ETF	110.27	110.35	110.24	110.32	297312.0

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

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