PREVIEW / etf_1hour / 2010-06-01

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-06-01.parquet
  size:    165 KB
  rows:    5,040

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-01 04:00:00	SPY	ETF	108.04	108.22	107.55	107.67	48269.0
2010-06-01 05:00:00	SPY	ETF	107.74	107.88	107.49	107.88	12900.0
2010-06-01 06:00:00	SPY	ETF	107.78	107.95	107.75	107.89	68400.0
2010-06-01 07:00:00	SPY	ETF	107.95	108.13	107.75	107.9	715151.0
2010-06-01 08:00:00	SPY	ETF	107.9	110.15	107.76	107.92	3251170.0
2010-06-01 09:00:00	SPY	ETF	107.93	109.369	107.93	108.55	37451143.0
2010-06-01 10:00:00	SPY	ETF	108.55	109.95	108.55	109.54	50151056.0
2010-06-01 11:00:00	SPY	ETF	109.54	109.58	108.79	108.88	30787907.0
2010-06-01 12:00:00	SPY	ETF	108.87	109.36	108.79	108.9599	17279908.0
2010-06-01 13:00:00	SPY	ETF	108.975	109.75	108.94	109.29	21123679.0
2010-06-01 14:00:00	SPY	ETF	109.25	109.6	108.7	109.07	32786908.0
2010-06-01 15:00:00	SPY	ETF	109.08	109.3621	107.37	107.52	65326697.0
2010-06-01 16:00:00	SPY	ETF	107.51	109.6872	107.27	107.54	17634024.0
2010-06-01 17:00:00	SPY	ETF	107.54	107.54	107.16	107.25	321992.0
2010-06-01 18:00:00	SPY	ETF	107.25	107.52	107.23	107.45	395583.0
2010-06-01 19:00:00	SPY	ETF	107.46	107.69	107.44	107.66	161945.0
2010-06-01 04:00:00	QQQ	ETF	45.29	45.29	44.99	44.99	6493.0
2010-06-01 05:00:00	QQQ	ETF	45.0	45.11	45.0	45.1	25700.0
2010-06-01 06:00:00	QQQ	ETF	45.08	45.08	45.08	45.08	100.0
2010-06-01 07:00:00	QQQ	ETF	45.15	45.24	45.1	45.21	312957.0
2010-06-01 08:00:00	QQQ	ETF	45.2	45.62	45.2	45.34	561046.0
2010-06-01 09:00:00	QQQ	ETF	45.34	45.73	45.33	45.55	12486947.0
2010-06-01 10:00:00	QQQ	ETF	45.55	46.25	45.55	46.0	19489631.0
2010-06-01 11:00:00	QQQ	ETF	46.0	46.02	45.64	45.66	11414890.0
2010-06-01 12:00:00	QQQ	ETF	45.66	45.93	45.62	45.78	6607301.0
2010-06-01 13:00:00	QQQ	ETF	45.78	46.14	45.77	45.867	10188097.0
2010-06-01 14:00:00	QQQ	ETF	45.865	45.975	45.68	45.86	11597987.0
2010-06-01 15:00:00	QQQ	ETF	45.86	45.89	45.13	45.18	24452750.0
2010-06-01 16:00:00	QQQ	ETF	45.18	45.6059	45.04	45.19	5282745.0
2010-06-01 17:00:00	QQQ	ETF	45.17	45.18	45.13	45.16	204451.0
2010-06-01 18:00:00	QQQ	ETF	45.14	45.19	45.13	45.19	15350.0
2010-06-01 19:00:00	QQQ	ETF	45.2	45.29	45.18	45.26	39700.0
2010-06-01 04:00:00	IWM	ETF	65.51	65.54	65.29	65.29	5690.0
2010-06-01 05:00:00	IWM	ETF	65.26	65.35	65.26	65.35	500.0
2010-06-01 06:00:00	IWM	ETF	65.25	65.25	65.25	65.25	300.0
2010-06-01 07:00:00	IWM	ETF	65.35	65.49	65.24	65.36	56235.0
2010-06-01 08:00:00	IWM	ETF	65.37	66.25	65.32	65.43	575869.0
2010-06-01 09:00:00	IWM	ETF	65.42	66.25	65.21	65.34	8931244.0
2010-06-01 10:00:00	IWM	ETF	65.3499	66.47	65.3499	65.915	14657876.0
2010-06-01 11:00:00	IWM	ETF	65.92	65.9714	65.06	65.11	10351002.0
2010-06-01 12:00:00	IWM	ETF	65.1	65.59	65.03	65.21	5509158.0
2010-06-01 13:00:00	IWM	ETF	65.1999	65.92	65.1875	65.35	8700335.0
2010-06-01 14:00:00	IWM	ETF	65.35	65.7	65.16	65.5	9015518.0
2010-06-01 15:00:00	IWM	ETF	65.5	65.56	64.19	64.23	20959380.0
2010-06-01 16:00:00	IWM	ETF	64.22	65.9867	64.04	64.18	2785107.0
2010-06-01 17:00:00	IWM	ETF	64.24	64.24	64.04	64.1	9429.0
2010-06-01 18:00:00	IWM	ETF	64.11	64.31	64.06	64.19	2000.0
2010-06-01 19:00:00	IWM	ETF	64.21	64.31	64.19	64.19	3200.0
2010-06-01 04:00:00	DIA	ETF	101.1	101.1	101.1	101.1	200.0
2010-06-01 07:00:00	DIA	ETF	100.42	100.47	100.23	100.24	2615.0

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

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