PREVIEW / etf_1hour / 2010-03-15

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-03-15.parquet
  size:    153 KB
  rows:    4,723

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-15 04:00:00	SPY	ETF	115.3	115.3	115.15	115.15	200.0
2010-03-15 05:00:00	SPY	ETF	115.12	115.12	115.09	115.09	1800.0
2010-03-15 06:00:00	SPY	ETF	115.16	115.16	115.13	115.13	27100.0
2010-03-15 07:00:00	SPY	ETF	115.15	115.3	115.15	115.3	155170.0
2010-03-15 08:00:00	SPY	ETF	115.18	115.4	114.88	115.33	1168659.0
2010-03-15 09:00:00	SPY	ETF	115.33	115.4825	115.11	115.138	14927848.0
2010-03-15 10:00:00	SPY	ETF	115.13	115.35	115.02	115.12	20594251.0
2010-03-15 11:00:00	SPY	ETF	115.11	115.18	114.6	114.79	25849987.0
2010-03-15 12:00:00	SPY	ETF	114.788	114.94	114.65	114.88	13251963.0
2010-03-15 13:00:00	SPY	ETF	114.88	115.02	114.84	114.98	12051543.0
2010-03-15 14:00:00	SPY	ETF	114.98	115.15	114.77	115.075	16266103.0
2010-03-15 15:00:00	SPY	ETF	115.06	115.575	114.8	115.5	28155184.0
2010-03-15 16:00:00	SPY	ETF	115.51	115.65	115.06	115.54	12087384.0
2010-03-15 17:00:00	SPY	ETF	115.56	115.63	115.55	115.59	161187.0
2010-03-15 18:00:00	SPY	ETF	115.62	115.66	115.5	115.55	111339.0
2010-03-15 19:00:00	SPY	ETF	115.58	115.61	115.54	115.58	173586.0
2010-03-15 06:00:00	QQQ	ETF	47.27	47.27	47.26	47.26	17000.0
2010-03-15 07:00:00	QQQ	ETF	47.25	47.32	47.25	47.3	30326.0
2010-03-15 08:00:00	QQQ	ETF	47.31	47.33	47.28	47.28	215799.0
2010-03-15 09:00:00	QQQ	ETF	47.28	47.38	47.165	47.18	8885433.0
2010-03-15 10:00:00	QQQ	ETF	47.17	47.28	47.08	47.1	10415551.0
2010-03-15 11:00:00	QQQ	ETF	47.1	47.15	46.91	46.98	9082534.0
2010-03-15 12:00:00	QQQ	ETF	46.98	47.367	46.93	47.0	5049784.0
2010-03-15 13:00:00	QQQ	ETF	47.0	47.0301	46.96	47.01	2954392.0
2010-03-15 14:00:00	QQQ	ETF	47.0	47.11	46.92	47.06	3857270.0
2010-03-15 15:00:00	QQQ	ETF	47.064	47.29	47.06	47.25	12729367.0
2010-03-15 16:00:00	QQQ	ETF	47.25	47.367	46.96	47.24	3334269.0
2010-03-15 17:00:00	QQQ	ETF	47.24	47.27	47.24	47.26	2500.0
2010-03-15 18:00:00	QQQ	ETF	47.26	47.3	47.25	47.26	64150.0
2010-03-15 19:00:00	QQQ	ETF	47.26	47.27	47.25	47.25	27000.0
2010-03-15 06:00:00	IWM	ETF	67.61	67.61	67.57	67.57	3000.0
2010-03-15 07:00:00	IWM	ETF	67.67	67.67	67.62	67.62	66716.0
2010-03-15 08:00:00	IWM	ETF	67.68	67.68	67.45	67.56	470449.0
2010-03-15 09:00:00	IWM	ETF	67.57	67.81	67.42	67.43	6705899.0
2010-03-15 10:00:00	IWM	ETF	67.43	67.6	67.33	67.44	7565777.0
2010-03-15 11:00:00	IWM	ETF	67.44	67.5	67.03	67.08	7045705.0
2010-03-15 12:00:00	IWM	ETF	67.07	67.28	67.0	67.24	3885181.0
2010-03-15 13:00:00	IWM	ETF	67.24	67.33	67.19	67.24	2845334.0
2010-03-15 14:00:00	IWM	ETF	67.24	67.37	67.07	67.28	2816047.0
2010-03-15 15:00:00	IWM	ETF	67.28	67.64	67.25	67.52	8201336.0
2010-03-15 16:00:00	IWM	ETF	67.51	67.7539	67.134	67.53	8323139.0
2010-03-15 17:00:00	IWM	ETF	67.51	67.57	67.49	67.57	60346.0
2010-03-15 18:00:00	IWM	ETF	67.59	67.6	67.46	67.48	9564.0
2010-03-15 19:00:00	IWM	ETF	67.45	67.47	67.42	67.47	4700.0
2010-03-15 05:00:00	DIA	ETF	106.22	106.22	106.22	106.22	1250.0
2010-03-15 06:00:00	DIA	ETF	106.22	106.22	106.22	106.22	250.0
2010-03-15 07:00:00	DIA	ETF	106.3	106.3	106.28	106.28	615.0
2010-03-15 08:00:00	DIA	ETF	106.34	106.4	106.32	106.34	2500.0
2010-03-15 09:00:00	DIA	ETF	106.33	106.56	106.26	106.28	807258.0
2010-03-15 10:00:00	DIA	ETF	106.27	106.46	106.21	106.3	1259182.0

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

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