PREVIEW / etf_1hour / 2010-05-11

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-05-11.parquet
  size:    172 KB
  rows:    5,221

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-11 04:00:00	SPY	ETF	115.28	115.31	114.68	114.71	16736.0
2010-05-11 05:00:00	SPY	ETF	114.76	114.98	114.71	114.95	54300.0
2010-05-11 06:00:00	SPY	ETF	114.92	115.1	114.7	114.76	132500.0
2010-05-11 07:00:00	SPY	ETF	114.72	115.17	114.53	114.94	1390579.0
2010-05-11 08:00:00	SPY	ETF	114.97	116.14	114.6	114.76	2417750.0
2010-05-11 09:00:00	SPY	ETF	114.77	115.79	114.71	115.57	41781381.0
2010-05-11 10:00:00	SPY	ETF	115.57	115.93	115.38	115.671	35563154.0
2010-05-11 11:00:00	SPY	ETF	115.67	116.62	115.5	116.42	35906261.0
2010-05-11 12:00:00	SPY	ETF	116.43	117.09	116.2	116.99	30244340.0
2010-05-11 13:00:00	SPY	ETF	117.0	117.36	116.71	117.03	28096186.0
2010-05-11 14:00:00	SPY	ETF	117.04	117.1	116.0	116.19	49350055.0
2010-05-11 15:00:00	SPY	ETF	116.195	116.32	115.58	115.83	61245093.0
2010-05-11 16:00:00	SPY	ETF	115.82	117.0	115.5	115.52	24532813.0
2010-05-11 17:00:00	SPY	ETF	115.51	115.83	115.5	115.53	2175903.0
2010-05-11 18:00:00	SPY	ETF	115.53	115.83	114.76	115.12	3349563.0
2010-05-11 19:00:00	SPY	ETF	115.12	115.3	115.06	115.3	294199.0
2010-05-11 04:00:00	QQQ	ETF	47.47	47.47	47.25	47.25	2090.0
2010-05-11 05:00:00	QQQ	ETF	47.25	47.33	47.25	47.33	40600.0
2010-05-11 06:00:00	QQQ	ETF	47.36	47.38	47.25	47.28	29057.0
2010-05-11 07:00:00	QQQ	ETF	47.27	47.43	47.17	47.34	491856.0
2010-05-11 08:00:00	QQQ	ETF	47.32	47.79	47.23	47.27	973163.0
2010-05-11 09:00:00	QQQ	ETF	47.27	47.68	47.2	47.5	16397968.0
2010-05-11 10:00:00	QQQ	ETF	47.5	47.75	47.42	47.63	13392734.0
2010-05-11 11:00:00	QQQ	ETF	47.63	48.12	47.61	48.04	12845446.0
2010-05-11 12:00:00	QQQ	ETF	48.04	48.3	48.0172	48.24	11764551.0
2010-05-11 13:00:00	QQQ	ETF	48.25	48.39	48.17	48.29	11410268.0
2010-05-11 14:00:00	QQQ	ETF	48.29	48.34	47.84	47.895	20857434.0
2010-05-11 15:00:00	QQQ	ETF	47.8934	47.97	47.66	47.71	18807125.0
2010-05-11 16:00:00	QQQ	ETF	47.72	47.9108	47.55	47.56	1359703.0
2010-05-11 17:00:00	QQQ	ETF	47.58	47.6	47.53	47.54	45555.0
2010-05-11 18:00:00	QQQ	ETF	47.56	47.56	47.27	47.43	200685.0
2010-05-11 19:00:00	QQQ	ETF	47.43	47.49	47.37	47.49	34689.0
2010-05-11 04:00:00	IWM	ETF	68.38	68.38	68.13	68.13	2684.0
2010-05-11 05:00:00	IWM	ETF	68.05	68.05	68.05	68.05	1500.0
2010-05-11 06:00:00	IWM	ETF	68.15	68.19	67.95	68.05	18280.0
2010-05-11 07:00:00	IWM	ETF	67.98	68.22	67.87	68.1	164619.0
2010-05-11 08:00:00	IWM	ETF	68.1	68.8	67.86	67.88	525304.0
2010-05-11 09:00:00	IWM	ETF	67.9	68.9	67.87	68.71	10029950.0
2010-05-11 10:00:00	IWM	ETF	68.71	68.93	68.48	68.67	9513913.0
2010-05-11 11:00:00	IWM	ETF	68.67	69.59	68.64	69.51	9990953.0
2010-05-11 12:00:00	IWM	ETF	69.52	69.98	69.4	69.918	9073410.0
2010-05-11 13:00:00	IWM	ETF	69.93	70.47	69.79	70.36	11594097.0
2010-05-11 14:00:00	IWM	ETF	70.35	70.52	69.7	69.97	18526555.0
2010-05-11 15:00:00	IWM	ETF	69.97	69.97	69.37	69.5	18348547.0
2010-05-11 16:00:00	IWM	ETF	69.5	70.0324	68.63	69.16	8948913.0
2010-05-11 17:00:00	IWM	ETF	69.2	69.27	69.19	69.19	18100.0
2010-05-11 18:00:00	IWM	ETF	69.22	69.22	68.93	68.93	18983.0
2010-05-11 19:00:00	IWM	ETF	69.01	69.03	68.97	69.03	2800.0
2010-05-11 06:00:00	DIA	ETF	107.09	107.09	106.93	106.93	900.0
2010-05-11 07:00:00	DIA	ETF	106.92	107.21	106.81	107.17	8550.0

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

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