PREVIEW / etf_1hour / 2010-06-08

all etf 1-hour files

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

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-08 04:00:00	SPY	ETF	106.25	106.25	105.4	105.43	4066.0
2010-06-08 05:00:00	SPY	ETF	105.33	105.41	105.11	105.18	35400.0
2010-06-08 06:00:00	SPY	ETF	105.25	105.7	105.25	105.41	72340.0
2010-06-08 07:00:00	SPY	ETF	105.4	105.8	105.4	105.64	546422.0
2010-06-08 08:00:00	SPY	ETF	105.67	105.98	105.63	105.74	2445072.0
2010-06-08 09:00:00	SPY	ETF	105.75	106.13	105.16	105.359	35633828.0
2010-06-08 10:00:00	SPY	ETF	105.35	105.9	104.68	105.23	63374044.0
2010-06-08 11:00:00	SPY	ETF	105.225	106.32	104.65	106.06	63725002.0
2010-06-08 12:00:00	SPY	ETF	106.06	106.21	105.62	106.05	24771724.0
2010-06-08 13:00:00	SPY	ETF	106.04	106.14	104.83	105.22	35404984.0
2010-06-08 14:00:00	SPY	ETF	105.2228	106.16	104.98	105.601	44917547.0
2010-06-08 15:00:00	SPY	ETF	105.62	106.83	105.36	106.57	68363346.0
2010-06-08 16:00:00	SPY	ETF	106.57	106.66	104.96	106.54	15876887.0
2010-06-08 17:00:00	SPY	ETF	106.56	106.6	105.14	106.55	276812.0
2010-06-08 18:00:00	SPY	ETF	106.55	106.57	106.44	106.56	130922.0
2010-06-08 19:00:00	SPY	ETF	106.56	106.63	106.36	106.38	111808.0
2010-06-08 04:00:00	QQQ	ETF	44.45	44.45	44.36	44.36	400.0
2010-06-08 05:00:00	QQQ	ETF	44.27	44.27	44.15	44.26	22200.0
2010-06-08 06:00:00	QQQ	ETF	44.27	44.39	44.27	44.27	18681.0
2010-06-08 07:00:00	QQQ	ETF	44.27	44.4	44.27	44.32	74556.0
2010-06-08 08:00:00	QQQ	ETF	44.35	44.5	44.32	44.43	516680.0
2010-06-08 09:00:00	QQQ	ETF	44.44	44.49	43.93	44.01	11399267.0
2010-06-08 10:00:00	QQQ	ETF	44.01	44.22	43.65	43.89	19804513.0
2010-06-08 11:00:00	QQQ	ETF	43.9	44.36	43.63	44.23	24212197.0
2010-06-08 12:00:00	QQQ	ETF	44.2201	44.3	44.0	44.12	8390737.0
2010-06-08 13:00:00	QQQ	ETF	44.11	44.1704	43.59	43.74	12717644.0
2010-06-08 14:00:00	QQQ	ETF	43.75	44.12	43.61	43.84	16007136.0
2010-06-08 15:00:00	QQQ	ETF	43.84	44.29	43.68	44.2	25637058.0
2010-06-08 16:00:00	QQQ	ETF	44.19	44.2	44.07	44.19	3016497.0
2010-06-08 17:00:00	QQQ	ETF	44.18	44.21	44.16	44.17	66736.0
2010-06-08 18:00:00	QQQ	ETF	44.17	44.19	44.13	44.19	22400.0
2010-06-08 19:00:00	QQQ	ETF	44.17	44.22	44.13	44.13	37015.0
2010-06-08 04:00:00	IWM	ETF	62.38	62.42	62.07	62.08	1300.0
2010-06-08 05:00:00	IWM	ETF	61.83	61.83	61.72	61.72	1600.0
2010-06-08 06:00:00	IWM	ETF	61.94	62.09	61.91	61.91	6860.0
2010-06-08 07:00:00	IWM	ETF	61.93	62.21	61.93	62.11	132450.0
2010-06-08 08:00:00	IWM	ETF	62.14	62.43	62.14	62.23	556201.0
2010-06-08 09:00:00	IWM	ETF	62.24	62.6	61.37	61.5017	12672704.0
2010-06-08 10:00:00	IWM	ETF	61.5	61.96	60.98	61.28	16595700.0
2010-06-08 11:00:00	IWM	ETF	61.29	61.84	60.7	61.61	19435272.0
2010-06-08 12:00:00	IWM	ETF	61.61	61.75	61.18	61.68	10080637.0
2010-06-08 13:00:00	IWM	ETF	61.68	61.82	60.81	61.13	11316878.0
2010-06-08 14:00:00	IWM	ETF	61.13	61.78	60.84	61.27	16368012.0
2010-06-08 15:00:00	IWM	ETF	61.27	62.07	61.04	61.83	25105760.0
2010-06-08 16:00:00	IWM	ETF	61.84	61.9458	61.4	61.76	10863827.0
2010-06-08 17:00:00	IWM	ETF	61.76	61.79	61.72	61.76	34035.0
2010-06-08 18:00:00	IWM	ETF	61.74	62.19	61.7	61.85	8562.0
2010-06-08 19:00:00	IWM	ETF	61.91	62.0	61.87	61.9	11000.0
2010-06-08 07:00:00	DIA	ETF	98.42	98.5	98.37	98.4	1852.0
2010-06-08 08:00:00	DIA	ETF	98.41	98.66	98.41	98.51	15307.0

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

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