PREVIEW / etf_1hour / 2010-03-12

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-03-12.parquet
  size:    151 KB
  rows:    4,740

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-03-12 04:00:00	SPY	ETF	115.5	115.57	115.5	115.57	2100.0
2010-03-12 05:00:00	SPY	ETF	115.75	115.86	115.75	115.84	9300.0
2010-03-12 06:00:00	SPY	ETF	115.78	115.83	115.7	115.72	5300.0
2010-03-12 07:00:00	SPY	ETF	115.72	115.84	115.72	115.75	610690.0
2010-03-12 08:00:00	SPY	ETF	115.75	116.16	115.66	116.04	4443348.0
2010-03-12 09:00:00	SPY	ETF	116.03	116.04	115.45	115.7	28954874.0
2010-03-12 10:00:00	SPY	ETF	115.69	115.71	115.14	115.34	35577916.0
2010-03-12 11:00:00	SPY	ETF	115.34	115.61	115.26	115.39	17705663.0
2010-03-12 12:00:00	SPY	ETF	115.39	115.52	115.26	115.4	14088736.0
2010-03-12 13:00:00	SPY	ETF	115.3901	115.54	115.39	115.53	8599359.0
2010-03-12 14:00:00	SPY	ETF	115.53	115.6	115.33	115.42	14125604.0
2010-03-12 15:00:00	SPY	ETF	115.42	115.5	115.18	115.45	26242809.0
2010-03-12 16:00:00	SPY	ETF	115.45	115.88	115.25	115.493	11425173.0
2010-03-12 17:00:00	SPY	ETF	115.52	115.57	115.51	115.54	87195.0
2010-03-12 18:00:00	SPY	ETF	115.53	115.56	115.46	115.54	79318.0
2010-03-12 19:00:00	SPY	ETF	115.54	115.6	115.5	115.5	70189.0
2010-03-12 04:00:00	QQQ	ETF	47.42	47.42	47.42	47.42	5000.0
2010-03-12 05:00:00	QQQ	ETF	47.4	47.4	47.4	47.4	4000.0
2010-03-12 06:00:00	QQQ	ETF	47.42	47.42	47.4	47.4	404.0
2010-03-12 07:00:00	QQQ	ETF	47.43	47.44	47.42	47.43	47783.0
2010-03-12 08:00:00	QQQ	ETF	47.42	47.56	47.4	47.51	788128.0
2010-03-12 09:00:00	QQQ	ETF	47.52	47.53	47.33	47.43	11060996.0
2010-03-12 10:00:00	QQQ	ETF	47.44	47.53	47.1	47.28	14659498.0
2010-03-12 11:00:00	QQQ	ETF	47.28	47.43	47.249	47.35	5755818.0
2010-03-12 12:00:00	QQQ	ETF	47.3501	47.4	47.27	47.35	4599572.0
2010-03-12 13:00:00	QQQ	ETF	47.359	47.4	47.33	47.4	5059532.0
2010-03-12 14:00:00	QQQ	ETF	47.4	47.43	47.36	47.3999	5444930.0
2010-03-12 15:00:00	QQQ	ETF	47.39	47.41	47.2754	47.36	8677402.0
2010-03-12 16:00:00	QQQ	ETF	47.36	47.53	47.27	47.32	3629709.0
2010-03-12 17:00:00	QQQ	ETF	47.33	47.37	47.32	47.36	17283.0
2010-03-12 18:00:00	QQQ	ETF	47.36	47.37	47.33	47.34	7952.0
2010-03-12 19:00:00	QQQ	ETF	47.34	47.37	47.31	47.32	11100.0
2010-03-12 07:00:00	IWM	ETF	67.95	68.0	67.95	68.0	17600.0
2010-03-12 08:00:00	IWM	ETF	67.95	68.14	67.92	68.1	821651.0
2010-03-12 09:00:00	IWM	ETF	68.1	68.13	67.68	67.74	10846895.0
2010-03-12 10:00:00	IWM	ETF	67.75	67.75	67.26	67.53	13093726.0
2010-03-12 11:00:00	IWM	ETF	67.53	67.83	67.45	67.6195	6636187.0
2010-03-12 12:00:00	IWM	ETF	67.6193	67.73	67.47	67.6507	5435043.0
2010-03-12 13:00:00	IWM	ETF	67.66	67.77	67.61	67.75	2807270.0
2010-03-12 14:00:00	IWM	ETF	67.75	67.8	67.61	67.65	4668507.0
2010-03-12 15:00:00	IWM	ETF	67.65	67.75	67.43	67.71	8595809.0
2010-03-12 16:00:00	IWM	ETF	67.71	69.7544	67.4298	67.79	6534507.0
2010-03-12 17:00:00	IWM	ETF	67.77	67.77	67.73	67.76	422.0
2010-03-12 18:00:00	IWM	ETF	67.73	67.73	67.73	67.73	300.0
2010-03-12 19:00:00	IWM	ETF	67.71	67.71	67.71	67.71	600.0
2010-03-12 07:00:00	DIA	ETF	106.6	106.6	106.6	106.6	1000.0
2010-03-12 08:00:00	DIA	ETF	106.48	106.75	106.46	106.68	56171.0
2010-03-12 09:00:00	DIA	ETF	106.68	106.68	106.39	106.51	1198635.0
2010-03-12 10:00:00	DIA	ETF	106.52	106.525	106.13	106.27	2225181.0
2010-03-12 11:00:00	DIA	ETF	106.27	106.51	106.22	106.3	1005613.0

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

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