PREVIEW / etf_1hour / 2010-05-12

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-05-12.parquet
  size:    164 KB
  rows:    5,013

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-05-12 04:00:00	SPY	ETF	116.12	116.12	115.87	115.87	3818.0
2010-05-12 05:00:00	SPY	ETF	115.84	115.84	115.49	115.64	10200.0
2010-05-12 06:00:00	SPY	ETF	115.77	116.14	115.77	116.1	159400.0
2010-05-12 07:00:00	SPY	ETF	116.05	116.45	115.96	116.42	890987.0
2010-05-12 08:00:00	SPY	ETF	116.4	116.49	115.5	116.38	3134216.0
2010-05-12 09:00:00	SPY	ETF	116.36	116.83	116.09	116.82	29764882.0
2010-05-12 10:00:00	SPY	ETF	116.82	117.04	116.56	116.84	31702616.0
2010-05-12 11:00:00	SPY	ETF	116.8475	117.18	116.4	116.83	36599143.0
2010-05-12 12:00:00	SPY	ETF	116.83	117.15	116.79	117.12	16602570.0
2010-05-12 13:00:00	SPY	ETF	117.12	117.42	116.93	116.94	26552050.0
2010-05-12 14:00:00	SPY	ETF	116.93	117.45	116.89	117.36	23485760.0
2010-05-12 15:00:00	SPY	ETF	117.36	117.62	117.12	117.45	38532808.0
2010-05-12 16:00:00	SPY	ETF	117.45	117.54	115.861	117.28	25775198.0
2010-05-12 17:00:00	SPY	ETF	117.28	117.48	115.861	117.4	1223766.0
2010-05-12 18:00:00	SPY	ETF	117.4	117.47	117.24	117.24	235649.0
2010-05-12 19:00:00	SPY	ETF	117.25	117.36	117.25	117.36	74175.0
2010-05-12 20:00:00	SPY	ETF	117.32	117.32	117.32	117.32	200.0
2010-05-12 04:00:00	QQQ	ETF	47.77	47.77	47.77	47.77	440.0
2010-05-12 06:00:00	QQQ	ETF	47.74	47.79	47.68	47.79	3913.0
2010-05-12 07:00:00	QQQ	ETF	47.78	47.96	47.73	47.94	291928.0
2010-05-12 08:00:00	QQQ	ETF	47.94	47.99	47.85	47.97	1470447.0
2010-05-12 09:00:00	QQQ	ETF	47.97	48.26	47.89	48.2465	12737364.0
2010-05-12 10:00:00	QQQ	ETF	48.2478	48.43	48.2	48.36	14163105.0
2010-05-12 11:00:00	QQQ	ETF	48.36	48.48	48.18	48.35	9610356.0
2010-05-12 12:00:00	QQQ	ETF	48.35	48.45	48.32	48.44	5756673.0
2010-05-12 13:00:00	QQQ	ETF	48.4399	48.56	48.37	48.3999	10178770.0
2010-05-12 14:00:00	QQQ	ETF	48.3925	48.61	48.37	48.57	6802331.0
2010-05-12 15:00:00	QQQ	ETF	48.5701	48.66	48.47	48.61	13515289.0
2010-05-12 16:00:00	QQQ	ETF	48.62	48.67	48.2152	48.44	5360281.0
2010-05-12 17:00:00	QQQ	ETF	48.45	48.53	48.4	48.47	837717.0
2010-05-12 18:00:00	QQQ	ETF	48.48	48.49	48.4	48.44	150190.0
2010-05-12 19:00:00	QQQ	ETF	48.44	48.5	48.44	48.49	52794.0
2010-05-12 06:00:00	IWM	ETF	69.51	69.62	69.47	69.56	23800.0
2010-05-12 07:00:00	IWM	ETF	69.57	69.99	69.53	69.93	460778.0
2010-05-12 08:00:00	IWM	ETF	69.94	69.98	69.6	69.9	904100.0
2010-05-12 09:00:00	IWM	ETF	69.89	70.41	69.78	70.4	9728386.0
2010-05-12 10:00:00	IWM	ETF	70.4	70.95	69.9	70.78	14756931.0
2010-05-12 11:00:00	IWM	ETF	70.78	70.99	70.36	70.83	10486579.0
2010-05-12 12:00:00	IWM	ETF	70.83	71.06	70.78	71.03	9017026.0
2010-05-12 13:00:00	IWM	ETF	71.03	71.3	70.96	71.17	10102421.0
2010-05-12 14:00:00	IWM	ETF	71.18	71.68	71.14	71.55	11145322.0
2010-05-12 15:00:00	IWM	ETF	71.55	71.7	71.42	71.62	14003375.0
2010-05-12 16:00:00	IWM	ETF	71.63	71.63	69.5943	71.34	1843982.0
2010-05-12 17:00:00	IWM	ETF	71.35	71.46	71.3	71.4	29309.0
2010-05-12 18:00:00	IWM	ETF	71.38	71.47	71.28	71.47	15184.0
2010-05-12 19:00:00	IWM	ETF	71.41	71.47	71.4	71.47	1055.0
2010-05-12 06:00:00	DIA	ETF	107.79	107.79	107.79	107.79	500.0
2010-05-12 07:00:00	DIA	ETF	107.9	108.15	107.9	108.15	1600.0
2010-05-12 08:00:00	DIA	ETF	108.03	108.1	107.91	108.1	8327.0
2010-05-12 09:00:00	DIA	ETF	108.01	108.55	107.95	108.5405	1801897.0

> showing 50 of 5,013 rows — these rows as CSV

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