PREVIEW / etf_1hour / 2012-01-18

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-01-18.parquet
  size:    187 KB
  rows:    5,755

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
2012-01-18 04:00:00	SPY	ETF	129.47	129.64	129.32	129.52	9352.0
2012-01-18 05:00:00	SPY	ETF	129.83	130.2	129.83	130.0	27827.0
2012-01-18 06:00:00	SPY	ETF	129.75	129.85	129.75	129.82	8096.0
2012-01-18 07:00:00	SPY	ETF	129.89	129.89	129.48	129.65	309423.0
2012-01-18 08:00:00	SPY	ETF	129.63	130.07	129.25	129.29	1393647.0
2012-01-18 09:00:00	SPY	ETF	129.27	129.88	129.08	129.82	20328113.0
2012-01-18 10:00:00	SPY	ETF	129.82	130.28	129.791	130.1	23734327.0
2012-01-18 11:00:00	SPY	ETF	130.1	130.21	129.875	129.98	15917436.0
2012-01-18 12:00:00	SPY	ETF	129.99	130.5	129.98	130.4517	15044764.0
2012-01-18 13:00:00	SPY	ETF	130.45	130.56	130.26	130.2789	11389256.0
2012-01-18 14:00:00	SPY	ETF	130.27	130.63	130.27	130.54	16993635.0
2012-01-18 15:00:00	SPY	ETF	130.55	130.84	130.53	130.78	33037922.0
2012-01-18 16:00:00	SPY	ETF	130.77	130.811	129.3753	130.73	18339853.0
2012-01-18 17:00:00	SPY	ETF	130.73	130.77	130.65	130.73	120423.0
2012-01-18 18:00:00	SPY	ETF	130.73	130.8	130.7	130.71	312217.0
2012-01-18 19:00:00	SPY	ETF	130.74	130.77	130.62	130.69	181282.0
2012-01-18 05:00:00	QQQ	ETF	59.04	59.05	58.99	58.99	13300.0
2012-01-18 06:00:00	QQQ	ETF	58.95	58.97	58.93	58.97	6000.0
2012-01-18 07:00:00	QQQ	ETF	58.95	58.96	58.86	58.95	19800.0
2012-01-18 08:00:00	QQQ	ETF	58.9	58.96	58.8	58.8	220611.0
2012-01-18 09:00:00	QQQ	ETF	58.78	58.99	58.71	58.92	5388426.0
2012-01-18 10:00:00	QQQ	ETF	58.92	59.18	58.91	59.12	6957738.0
2012-01-18 11:00:00	QQQ	ETF	59.13	59.22	59.07	59.1	5082350.0
2012-01-18 12:00:00	QQQ	ETF	59.1	59.39	59.08	59.37	4834506.0
2012-01-18 13:00:00	QQQ	ETF	59.37	59.45	59.3	59.31	3733564.0
2012-01-18 14:00:00	QQQ	ETF	59.31	59.45	59.31	59.416	3622020.0
2012-01-18 15:00:00	QQQ	ETF	59.42	59.49	59.39	59.47	7123434.0
2012-01-18 16:00:00	QQQ	ETF	59.49	59.49	59.37	59.46	1591918.0
2012-01-18 17:00:00	QQQ	ETF	59.44	59.49	59.42	59.48	46877.0
2012-01-18 18:00:00	QQQ	ETF	59.47	59.47	59.42	59.43	85295.0
2012-01-18 19:00:00	QQQ	ETF	59.44	59.46	59.42	59.45	33880.0
2012-01-18 07:00:00	IWM	ETF	76.62	76.66	76.6	76.62	3200.0
2012-01-18 08:00:00	IWM	ETF	76.89	77.12	75.76	76.31	181044.0
2012-01-18 09:00:00	IWM	ETF	76.28	76.81	76.15	76.72	4608970.0
2012-01-18 10:00:00	IWM	ETF	76.73	77.2	76.72	77.06	7157286.0
2012-01-18 11:00:00	IWM	ETF	77.06	77.25	76.95	76.98	5684884.0
2012-01-18 12:00:00	IWM	ETF	76.985	77.37	76.98	77.3274	3873207.0
2012-01-18 13:00:00	IWM	ETF	77.32	77.49	77.24	77.3	3403859.0
2012-01-18 14:00:00	IWM	ETF	77.31	77.55	77.291	77.49	3720922.0
2012-01-18 15:00:00	IWM	ETF	77.49	77.73	77.475	77.72	9474806.0
2012-01-18 16:00:00	IWM	ETF	77.71	77.7333	76.3802	77.65	4008940.0
2012-01-18 17:00:00	IWM	ETF	77.65	77.71	77.63	77.68	18998.0
2012-01-18 18:00:00	IWM	ETF	77.68	77.7	77.64	77.66	2700.0
2012-01-18 19:00:00	IWM	ETF	77.66	77.71	77.64	77.71	9994.0
2012-01-18 08:00:00	DIA	ETF	124.81	124.93	124.56	124.56	8100.0
2012-01-18 09:00:00	DIA	ETF	124.5	125.13	124.41	125.09	672406.0
2012-01-18 10:00:00	DIA	ETF	125.07	125.5	125.07	125.3	1364867.0
2012-01-18 11:00:00	DIA	ETF	125.29	125.38	125.08	125.14	788328.0
2012-01-18 12:00:00	DIA	ETF	125.14	125.56	125.14	125.4966	771679.0
2012-01-18 13:00:00	DIA	ETF	125.5	125.57	125.27	125.29	561703.0

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

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