PREVIEW / etf_1hour / 2010-06-17

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-06-17.parquet
  size:    157 KB
  rows:    4,804

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-17 04:00:00	SPY	ETF	111.7	112.02	111.7	111.85	12100.0
2010-06-17 05:00:00	SPY	ETF	111.88	112.34	111.87	112.31	6600.0
2010-06-17 06:00:00	SPY	ETF	112.31	112.32	112.19	112.3	18680.0
2010-06-17 07:00:00	SPY	ETF	112.31	112.49	112.3	112.4	457442.0
2010-06-17 08:00:00	SPY	ETF	112.39	112.72	111.99	112.24	5491141.0
2010-06-17 09:00:00	SPY	ETF	112.23	112.43	111.8	112.099	24971651.0
2010-06-17 10:00:00	SPY	ETF	112.09	112.2	111.1	111.3	50129504.0
2010-06-17 11:00:00	SPY	ETF	111.3	111.78	111.05	111.7	39838834.0
2010-06-17 12:00:00	SPY	ETF	111.69	111.8	111.32	111.54	15762079.0
2010-06-17 13:00:00	SPY	ETF	111.54	111.96	111.38	111.93	17154695.0
2010-06-17 14:00:00	SPY	ETF	111.93	112.02	111.46	111.62	23341091.0
2010-06-17 15:00:00	SPY	ETF	111.62	112.22	111.2	112.12	59520340.0
2010-06-17 16:00:00	SPY	ETF	112.13	112.24	111.22	112.13	24812607.0
2010-06-17 17:00:00	SPY	ETF	112.11	112.18	112.03	112.14	632419.0
2010-06-17 18:00:00	SPY	ETF	112.14	112.16	112.0	112.01	118179.0
2010-06-17 19:00:00	SPY	ETF	112.06	112.1	112.04	112.06	24944.0
2010-06-17 04:00:00	QQQ	ETF	46.85	46.95	46.84	46.95	35390.0
2010-06-17 05:00:00	QQQ	ETF	47.07	47.14	47.07	47.14	17000.0
2010-06-17 06:00:00	QQQ	ETF	47.14	47.14	47.07	47.12	67622.0
2010-06-17 07:00:00	QQQ	ETF	47.12	47.23	47.12	47.2	315994.0
2010-06-17 08:00:00	QQQ	ETF	47.18	47.25	47.02	47.14	3383416.0
2010-06-17 09:00:00	QQQ	ETF	47.14	47.22	46.91	47.1325	10184669.0
2010-06-17 10:00:00	QQQ	ETF	47.14	47.14	46.64	46.79	17432521.0
2010-06-17 11:00:00	QQQ	ETF	46.79	47.04	46.66	47.01	7913019.0
2010-06-17 12:00:00	QQQ	ETF	47.01	47.02	46.812	46.89	3598770.0
2010-06-17 13:00:00	QQQ	ETF	46.8899	47.0881	46.83	47.08	4927542.0
2010-06-17 14:00:00	QQQ	ETF	47.08	47.14	46.8302	46.9	6877085.0
2010-06-17 15:00:00	QQQ	ETF	46.91	47.08	46.71	47.05	15137745.0
2010-06-17 16:00:00	QQQ	ETF	47.05	47.1	46.71	47.05	4479441.0
2010-06-17 17:00:00	QQQ	ETF	47.03	47.12	47.02	47.06	82995.0
2010-06-17 18:00:00	QQQ	ETF	47.08	47.08	47.03	47.03	18995.0
2010-06-17 19:00:00	QQQ	ETF	47.02	47.04	47.02	47.04	8550.0
2010-06-17 04:00:00	IWM	ETF	66.85	66.85	66.85	66.85	600.0
2010-06-17 05:00:00	IWM	ETF	67.0	67.12	67.0	67.12	1199.0
2010-06-17 06:00:00	IWM	ETF	67.14	67.14	67.08	67.08	1000.0
2010-06-17 07:00:00	IWM	ETF	67.16	67.3	67.13	67.22	39300.0
2010-06-17 08:00:00	IWM	ETF	67.2	67.27	66.89	67.08	1227512.0
2010-06-17 09:00:00	IWM	ETF	67.08	67.2	66.7	67.06	5674304.0
2010-06-17 10:00:00	IWM	ETF	67.06	67.06	65.97	66.14	12524258.0
2010-06-17 11:00:00	IWM	ETF	66.13	66.71	65.98	66.59	7547802.0
2010-06-17 12:00:00	IWM	ETF	66.59	66.62	66.26	66.38	4293834.0
2010-06-17 13:00:00	IWM	ETF	66.38	66.9	66.32	66.89	5642755.0
2010-06-17 14:00:00	IWM	ETF	66.8889	67.06	66.46	66.59	7168849.0
2010-06-17 15:00:00	IWM	ETF	66.6	66.82	66.31	66.75	15358469.0
2010-06-17 16:00:00	IWM	ETF	66.74	66.88	66.1	66.83	4198730.0
2010-06-17 17:00:00	IWM	ETF	66.81	66.9	66.7472	66.9	501890.0
2010-06-17 18:00:00	IWM	ETF	66.82	66.82	66.75	66.75	1366.0
2010-06-17 19:00:00	IWM	ETF	66.82	66.82	66.82	66.82	400.0
2010-06-17 07:00:00	DIA	ETF	104.56	104.67	104.56	104.67	2140.0
2010-06-17 08:00:00	DIA	ETF	104.64	104.71	104.3	104.46	54471.0

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

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