PREVIEW / etf_1hour / 2010-06-18

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-06-18.parquet
  size:    151 KB
  rows:    4,748

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-18 04:00:00	SPY	ETF	111.72	111.72	111.66	111.66	500.0
2010-06-18 05:00:00	SPY	ETF	111.69	111.82	111.65	111.65	27600.0
2010-06-18 06:00:00	SPY	ETF	111.67	111.67	111.32	111.45	84242.0
2010-06-18 07:00:00	SPY	ETF	111.41	111.64	111.41	111.53	230805.0
2010-06-18 08:00:00	SPY	ETF	111.54	111.75	111.41	111.5	2471166.0
2010-06-18 09:00:00	SPY	ETF	111.5	111.85	111.37	111.39	29195582.0
2010-06-18 10:00:00	SPY	ETF	111.4	112.13	111.381	112.05	30997470.0
2010-06-18 11:00:00	SPY	ETF	112.05	112.13	111.64	111.74	16714427.0
2010-06-18 12:00:00	SPY	ETF	111.75	112.08	111.47	111.6	15809963.0
2010-06-18 13:00:00	SPY	ETF	111.6	111.82	111.51	111.65	16251403.0
2010-06-18 14:00:00	SPY	ETF	111.66	111.88	111.61	111.76	15010684.0
2010-06-18 15:00:00	SPY	ETF	111.77	111.79	111.48	111.71	28893873.0
2010-06-18 16:00:00	SPY	ETF	111.71	112.11	111.44	111.5	11413229.0
2010-06-18 17:00:00	SPY	ETF	111.5	111.729	111.36	111.53	377898.0
2010-06-18 18:00:00	SPY	ETF	111.52	111.66	111.49	111.64	158715.0
2010-06-18 19:00:00	SPY	ETF	111.63	111.7	111.59	111.7	26064.0
2010-06-18 05:00:00	QQQ	ETF	47.08	47.08	47.08	47.08	8315.0
2010-06-18 06:00:00	QQQ	ETF	47.08	47.08	47.08	47.08	4666.0
2010-06-18 07:00:00	QQQ	ETF	47.04	47.04	46.9	46.91	139086.0
2010-06-18 08:00:00	QQQ	ETF	47.0	47.02	46.84	46.91	2260861.0
2010-06-18 09:00:00	QQQ	ETF	46.93	47.0825	46.89	46.9	12712769.0
2010-06-18 10:00:00	QQQ	ETF	46.91	47.33	46.91	47.31	14873006.0
2010-06-18 11:00:00	QQQ	ETF	47.3065	47.34	47.02	47.09	7506225.0
2010-06-18 12:00:00	QQQ	ETF	47.09	47.16	46.86	46.95	9956642.0
2010-06-18 13:00:00	QQQ	ETF	46.94	47.07	46.92	46.975	6211167.0
2010-06-18 14:00:00	QQQ	ETF	46.975	47.09	46.96	47.04	7387375.0
2010-06-18 15:00:00	QQQ	ETF	47.045	47.05	46.89	47.02	10453923.0
2010-06-18 16:00:00	QQQ	ETF	47.01	47.04	46.91	46.99	3120400.0
2010-06-18 17:00:00	QQQ	ETF	46.99	47.0	46.97	46.97	65868.0
2010-06-18 18:00:00	QQQ	ETF	47.0	47.01	47.0	47.0	4150.0
2010-06-18 19:00:00	QQQ	ETF	47.0	47.01	46.98	47.0	14700.0
2010-06-18 07:00:00	IWM	ETF	66.85	66.9	66.83	66.84	35114.0
2010-06-18 08:00:00	IWM	ETF	66.84	66.95	66.6	66.6	665301.0
2010-06-18 09:00:00	IWM	ETF	66.62	67.02	66.45	66.46	8203010.0
2010-06-18 10:00:00	IWM	ETF	66.46	67.5333	66.45	67.31	7346573.0
2010-06-18 11:00:00	IWM	ETF	67.3	67.32	66.9	66.98	4999119.0
2010-06-18 12:00:00	IWM	ETF	66.9786	67.13	66.48	66.63	7104128.0
2010-06-18 13:00:00	IWM	ETF	66.63	66.81	66.56	66.69	4302775.0
2010-06-18 14:00:00	IWM	ETF	66.69	66.92	66.6	66.76	3363903.0
2010-06-18 15:00:00	IWM	ETF	66.7585	66.9	66.57	66.8	7140634.0
2010-06-18 16:00:00	IWM	ETF	66.8	67.2	66.61	66.71	5473674.0
2010-06-18 17:00:00	IWM	ETF	66.67	66.73	66.66	66.7	505200.0
2010-06-18 18:00:00	IWM	ETF	66.68	66.79	66.68	66.79	800.0
2010-06-18 19:00:00	IWM	ETF	66.78	66.82	66.74	66.82	4000.0
2010-06-18 06:00:00	DIA	ETF	104.25	104.25	104.12	104.12	300.0
2010-06-18 07:00:00	DIA	ETF	104.2	104.2	104.2	104.2	300.0
2010-06-18 08:00:00	DIA	ETF	104.19	104.65	104.15	104.2	14763.0
2010-06-18 09:00:00	DIA	ETF	104.18	104.56	104.14	104.24	1023104.0
2010-06-18 10:00:00	DIA	ETF	104.26	104.84	104.2401	104.82	1638242.0
2010-06-18 11:00:00	DIA	ETF	104.8018	104.82	104.45	104.49	1078772.0

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

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