PREVIEW / etf_1hour / 2010-06-16

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-06-16.parquet
  size:    161 KB
  rows:    4,899

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-06-16 04:00:00	SPY	ETF	111.4	111.54	111.32	111.37	3100.0
2010-06-16 05:00:00	SPY	ETF	111.44	111.55	111.3	111.55	19550.0
2010-06-16 06:00:00	SPY	ETF	111.57	111.6	111.43	111.46	16200.0
2010-06-16 07:00:00	SPY	ETF	111.46	111.53	111.18	111.31	605152.0
2010-06-16 08:00:00	SPY	ETF	111.31	111.42	110.96	111.21	3338966.0
2010-06-16 09:00:00	SPY	ETF	111.2	111.75	111.15	111.74	30016449.0
2010-06-16 10:00:00	SPY	ETF	111.75	111.86	111.2	111.64	29466889.0
2010-06-16 11:00:00	SPY	ETF	111.65	112.039	111.5241	111.91	27396008.0
2010-06-16 12:00:00	SPY	ETF	111.91	112.3	111.82	111.94	21754026.0
2010-06-16 13:00:00	SPY	ETF	111.94	112.25	111.82	112.2499	11875965.0
2010-06-16 14:00:00	SPY	ETF	112.24	112.42	112.0	112.1617	21718691.0
2010-06-16 15:00:00	SPY	ETF	112.1631	112.17	111.51	111.94	47942685.0
2010-06-16 16:00:00	SPY	ETF	111.93	112.1133	110.8021	111.8	19054544.0
2010-06-16 17:00:00	SPY	ETF	111.8	111.81	111.67	111.77	2249840.0
2010-06-16 18:00:00	SPY	ETF	111.77	111.96	111.66	111.67	188530.0
2010-06-16 19:00:00	SPY	ETF	111.68	111.68	111.6	111.63	110107.0
2010-06-16 04:00:00	QQQ	ETF	46.43	46.49	46.43	46.48	14000.0
2010-06-16 05:00:00	QQQ	ETF	46.42	46.5	46.42	46.5	13850.0
2010-06-16 06:00:00	QQQ	ETF	46.52	46.52	46.52	46.52	200.0
2010-06-16 07:00:00	QQQ	ETF	46.53	46.54	46.41	46.49	474265.0
2010-06-16 08:00:00	QQQ	ETF	46.5	46.5	46.3	46.42	1728587.0
2010-06-16 09:00:00	QQQ	ETF	46.41	46.78	46.4	46.75	11269109.0
2010-06-16 10:00:00	QQQ	ETF	46.76	46.77	46.5	46.73	8233407.0
2010-06-16 11:00:00	QQQ	ETF	46.73	46.91	46.65	46.88	12689610.0
2010-06-16 12:00:00	QQQ	ETF	46.88	47.03	46.82	46.88	6159971.0
2010-06-16 13:00:00	QQQ	ETF	46.89	47.04	46.83	47.04	6221149.0
2010-06-16 14:00:00	QQQ	ETF	47.04	47.14	47.0	47.071	8341711.0
2010-06-16 15:00:00	QQQ	ETF	47.08	47.09	46.75	46.92	17048440.0
2010-06-16 16:00:00	QQQ	ETF	46.91	46.99	46.5806	46.89	2169509.0
2010-06-16 17:00:00	QQQ	ETF	46.88	46.92	46.85	46.9	47581.0
2010-06-16 18:00:00	QQQ	ETF	46.88	46.89	46.85	46.87	28599.0
2010-06-16 19:00:00	QQQ	ETF	46.86	46.88	46.83	46.85	33375.0
2010-06-16 04:00:00	IWM	ETF	66.51	66.51	66.51	66.51	100.0
2010-06-16 05:00:00	IWM	ETF	66.41	66.46	66.41	66.46	10300.0
2010-06-16 06:00:00	IWM	ETF	66.54	66.57	66.49	66.57	6300.0
2010-06-16 07:00:00	IWM	ETF	66.44	66.51	66.3	66.4	82029.0
2010-06-16 08:00:00	IWM	ETF	66.5	66.5	66.06	66.23	792550.0
2010-06-16 09:00:00	IWM	ETF	66.21	66.91	66.19	66.66	8188649.0
2010-06-16 10:00:00	IWM	ETF	66.66	66.76	66.29	66.66	8306352.0
2010-06-16 11:00:00	IWM	ETF	66.67	67.02	66.53	66.86	8405735.0
2010-06-16 12:00:00	IWM	ETF	66.88	67.15	66.81	66.87	3861847.0
2010-06-16 13:00:00	IWM	ETF	66.87	67.18	66.8	67.18	4557058.0
2010-06-16 14:00:00	IWM	ETF	67.18	67.38	67.07	67.12	7409340.0
2010-06-16 15:00:00	IWM	ETF	67.12	67.12	66.4	66.7	12381574.0
2010-06-16 16:00:00	IWM	ETF	66.69	67.1296	66.3977	66.7	5411735.0
2010-06-16 17:00:00	IWM	ETF	66.68	66.68	66.6	66.62	21158.0
2010-06-16 18:00:00	IWM	ETF	66.69	66.7	66.63	66.63	1075.0
2010-06-16 19:00:00	IWM	ETF	66.65	66.65	66.59	66.62	547.0
2010-06-16 04:00:00	DIA	ETF	103.77	103.77	103.77	103.77	500.0
2010-06-16 07:00:00	DIA	ETF	103.85	103.85	103.67	103.72	1961.0

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

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