PREVIEW / etf_1hour / 2010-07-08

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-07-08.parquet
  size:    157 KB
  rows:    4,870

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-07-08 04:00:00	SPY	ETF	106.2	106.2	106.04	106.11	5245.0
2010-07-08 05:00:00	SPY	ETF	106.09	106.34	106.08	106.19	11535.0
2010-07-08 06:00:00	SPY	ETF	106.2	106.34	106.15	106.34	13420.0
2010-07-08 07:00:00	SPY	ETF	106.33	106.43	106.16	106.31	388664.0
2010-07-08 08:00:00	SPY	ETF	106.32	107.05	106.0	106.89	7208789.0
2010-07-08 09:00:00	SPY	ETF	106.9	107.28	106.1075	106.77	33064295.0
2010-07-08 10:00:00	SPY	ETF	106.76	106.96	106.45	106.5	33279885.0
2010-07-08 11:00:00	SPY	ETF	106.5	106.61	106.04	106.18	26673793.0
2010-07-08 12:00:00	SPY	ETF	106.18	106.5	106.09	106.27	16487976.0
2010-07-08 13:00:00	SPY	ETF	106.2699	106.71	106.24	106.36	14161975.0
2010-07-08 14:00:00	SPY	ETF	106.35	106.56	105.91	106.5	20689135.0
2010-07-08 15:00:00	SPY	ETF	106.48	107.17	106.19	107.15	48157463.0
2010-07-08 16:00:00	SPY	ETF	107.14	107.37	106.19	107.13	9357534.0
2010-07-08 17:00:00	SPY	ETF	107.13	107.22	107.08	107.13	491097.0
2010-07-08 18:00:00	SPY	ETF	107.16	107.18	107.06	107.08	93129.0
2010-07-08 19:00:00	SPY	ETF	107.14	107.14	106.95	107.05	91382.0
2010-07-08 04:00:00	QQQ	ETF	43.9	43.9	43.9	43.9	200.0
2010-07-08 06:00:00	QQQ	ETF	43.93	43.97	43.92	43.97	643.0
2010-07-08 07:00:00	QQQ	ETF	44.0	44.0	43.91	43.96	8200.0
2010-07-08 08:00:00	QQQ	ETF	43.98	44.26	43.97	44.23	1374664.0
2010-07-08 09:00:00	QQQ	ETF	44.22	44.38	43.99	44.19	12613492.0
2010-07-08 10:00:00	QQQ	ETF	44.185	44.3201	44.08	44.14	9047979.0
2010-07-08 11:00:00	QQQ	ETF	44.14	44.15	43.72	43.8	10719494.0
2010-07-08 12:00:00	QQQ	ETF	43.81	43.98	43.76	43.8	5131363.0
2010-07-08 13:00:00	QQQ	ETF	43.8	44.03	43.79	43.88	4895356.0
2010-07-08 14:00:00	QQQ	ETF	43.8899	43.98	43.68	43.92	7366007.0
2010-07-08 15:00:00	QQQ	ETF	43.92	44.24	43.81	44.18	15170415.0
2010-07-08 16:00:00	QQQ	ETF	44.18	44.28	43.8013	43.9921	7677228.0
2010-07-08 17:00:00	QQQ	ETF	44.2	44.21	44.15	44.15	42430.0
2010-07-08 18:00:00	QQQ	ETF	44.17	44.18	44.15	44.15	3100.0
2010-07-08 19:00:00	QQQ	ETF	44.17	44.17	44.12	44.16	58256.0
2010-07-08 05:00:00	IWM	ETF	61.23	61.23	61.17	61.17	600.0
2010-07-08 06:00:00	IWM	ETF	61.21	61.28	61.21	61.28	900.0
2010-07-08 07:00:00	IWM	ETF	61.34	61.34	61.21	61.28	18431.0
2010-07-08 08:00:00	IWM	ETF	61.31	61.82	61.3	61.77	1142331.0
2010-07-08 09:00:00	IWM	ETF	61.75	62.11	61.1	61.725	9404075.0
2010-07-08 10:00:00	IWM	ETF	61.73	61.985	61.52	61.55	8905057.0
2010-07-08 11:00:00	IWM	ETF	61.57	61.68	61.04	61.2	7986332.0
2010-07-08 12:00:00	IWM	ETF	61.21	61.522	61.12	61.32	3356071.0
2010-07-08 13:00:00	IWM	ETF	61.32	61.62	61.3	61.41	3152134.0
2010-07-08 14:00:00	IWM	ETF	61.4	61.53	61.08	61.48	4010717.0
2010-07-08 15:00:00	IWM	ETF	61.49	62.03	61.25	61.97	11089821.0
2010-07-08 16:00:00	IWM	ETF	61.97	62.13	61.35	62.06	1175897.0
2010-07-08 17:00:00	IWM	ETF	62.03	62.08	62.02	62.02	27773.0
2010-07-08 18:00:00	IWM	ETF	62.02	62.08	62.02	62.02	12400.0
2010-07-08 19:00:00	IWM	ETF	62.02	62.03	61.98	61.98	11100.0
2010-07-08 04:00:00	DIA	ETF	100.19	100.31	99.5	100.31	7099.0
2010-07-08 05:00:00	DIA	ETF	100.22	100.22	100.22	100.22	100.0
2010-07-08 06:00:00	DIA	ETF	100.35	100.35	100.35	100.35	200.0
2010-07-08 07:00:00	DIA	ETF	100.43	100.43	100.4	100.4	2600.0

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

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