PREVIEW / etf_1hour / 2010-08-31

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-08-31.parquet
  size:    164 KB
  rows:    5,099

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-08-31 04:00:00	SPY	ETF	105.0	105.0	104.62	104.72	4700.0
2010-08-31 05:00:00	SPY	ETF	104.67	104.94	104.67	104.94	14350.0
2010-08-31 06:00:00	SPY	ETF	104.86	104.86	104.66	104.7	34500.0
2010-08-31 07:00:00	SPY	ETF	104.68	104.76	104.5	104.74	263790.0
2010-08-31 08:00:00	SPY	ETF	104.76	104.77	104.46	104.63	1397352.0
2010-08-31 09:00:00	SPY	ETF	104.67	105.3	104.49	105.1	42375888.0
2010-08-31 10:00:00	SPY	ETF	105.1	105.85	104.7836	105.6775	45176559.0
2010-08-31 11:00:00	SPY	ETF	105.68	105.98	105.34	105.81	29424628.0
2010-08-31 12:00:00	SPY	ETF	105.81	105.9	105.4	105.4	12543285.0
2010-08-31 13:00:00	SPY	ETF	105.4	105.8	105.37	105.64	12050039.0
2010-08-31 14:00:00	SPY	ETF	105.63	105.86	104.83	104.98	40639020.0
2010-08-31 15:00:00	SPY	ETF	104.97	105.61	104.86	105.4	65777546.0
2010-08-31 16:00:00	SPY	ETF	105.4	105.915	104.595	105.85	21081891.0
2010-08-31 17:00:00	SPY	ETF	105.85	105.88	105.72	105.72	1463389.0
2010-08-31 18:00:00	SPY	ETF	105.76	105.88	105.75	105.83	198480.0
2010-08-31 19:00:00	SPY	ETF	105.86	105.86	105.71	105.78	129977.0
2010-08-31 04:00:00	QQQ	ETF	43.27	43.37	43.27	43.33	8058.0
2010-08-31 05:00:00	QQQ	ETF	43.36	43.36	43.35	43.35	300.0
2010-08-31 06:00:00	QQQ	ETF	43.36	43.36	43.3	43.3	2000.0
2010-08-31 07:00:00	QQQ	ETF	43.31	43.34	43.23	43.34	63978.0
2010-08-31 08:00:00	QQQ	ETF	43.35	43.36	43.24	43.29	170261.0
2010-08-31 09:00:00	QQQ	ETF	43.31	43.6	43.18	43.52	13030109.0
2010-08-31 10:00:00	QQQ	ETF	43.53	43.85	43.47	43.63	13215562.0
2010-08-31 11:00:00	QQQ	ETF	43.62	43.73	43.45	43.67	6261537.0
2010-08-31 12:00:00	QQQ	ETF	43.67	43.72	43.5	43.5	3866472.0
2010-08-31 13:00:00	QQQ	ETF	43.5	43.73	43.48	43.63	5313933.0
2010-08-31 14:00:00	QQQ	ETF	43.63	43.72	43.25	43.3375	9841918.0
2010-08-31 15:00:00	QQQ	ETF	43.33	43.56	43.26	43.51	14261912.0
2010-08-31 16:00:00	QQQ	ETF	43.52	43.71	43.3101	43.68	3343179.0
2010-08-31 17:00:00	QQQ	ETF	43.68	43.7	43.605	43.65	2082313.0
2010-08-31 18:00:00	QQQ	ETF	43.67	43.68	43.63	43.66	21900.0
2010-08-31 19:00:00	QQQ	ETF	43.69	43.69	43.63	43.67	27350.0
2010-08-31 20:00:00	QQQ	ETF	43.56	43.67	43.56	43.67	1357.0
2010-08-31 05:00:00	IWM	ETF	59.99	60.04	59.99	60.04	7500.0
2010-08-31 06:00:00	IWM	ETF	59.95	59.95	59.86	59.86	3700.0
2010-08-31 07:00:00	IWM	ETF	59.92	59.93	59.77	59.93	76120.0
2010-08-31 08:00:00	IWM	ETF	59.93	59.93	59.78	59.83	94990.0
2010-08-31 09:00:00	IWM	ETF	59.84	60.38	59.68	60.12	8171478.0
2010-08-31 10:00:00	IWM	ETF	60.13	60.83	60.05	60.54	9460024.0
2010-08-31 11:00:00	IWM	ETF	60.52	60.83	60.26	60.695	3689541.0
2010-08-31 12:00:00	IWM	ETF	60.7	60.79	60.41	60.42	2599318.0
2010-08-31 13:00:00	IWM	ETF	60.42	60.91	60.37	60.68	4375650.0
2010-08-31 14:00:00	IWM	ETF	60.67	60.85	59.88	59.98	10195096.0
2010-08-31 15:00:00	IWM	ETF	59.97	60.52	59.91	60.175	15077589.0
2010-08-31 16:00:00	IWM	ETF	60.25	60.6	60.17	60.58	4909952.0
2010-08-31 17:00:00	IWM	ETF	60.58	60.58	60.48	60.48	12007.0
2010-08-31 18:00:00	IWM	ETF	60.5	60.56	60.49	60.54	2400.0
2010-08-31 19:00:00	IWM	ETF	60.54	60.54	60.53	60.53	1000.0
2010-08-31 04:00:00	DIA	ETF	100.08	100.08	100.08	100.08	400.0
2010-08-31 05:00:00	DIA	ETF	99.64	99.7	99.64	99.7	470.0

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

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