PREVIEW / etf_1hour / 2012-01-25

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-01-25.parquet
  size:    189 KB
  rows:    5,789

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-25 04:00:00	SPY	ETF	131.89	131.89	131.32	131.37	25033.0
2012-01-25 05:00:00	SPY	ETF	131.33	131.37	131.16	131.17	16184.0
2012-01-25 06:00:00	SPY	ETF	131.09	131.24	131.09	131.19	49689.0
2012-01-25 07:00:00	SPY	ETF	131.2	131.27	130.99	131.17	402338.0
2012-01-25 08:00:00	SPY	ETF	131.17	131.79	131.13	131.22	727004.0
2012-01-25 09:00:00	SPY	ETF	131.22	131.33	130.78	130.86	15325729.0
2012-01-25 10:00:00	SPY	ETF	130.86	131.23	130.75	131.18	19119612.0
2012-01-25 11:00:00	SPY	ETF	131.19	131.42	131.18	131.3	12419907.0
2012-01-25 12:00:00	SPY	ETF	131.3	131.74	131.04	131.51	32464573.0
2012-01-25 13:00:00	SPY	ETF	131.5	132.5	131.47	132.46	25705948.0
2012-01-25 14:00:00	SPY	ETF	132.47	132.49	131.88	132.28	28865058.0
2012-01-25 15:00:00	SPY	ETF	132.275	132.87	132.16	132.57	36988748.0
2012-01-25 16:00:00	SPY	ETF	132.58	132.63	131.21	132.49	20006588.0
2012-01-25 17:00:00	SPY	ETF	132.57	132.57	131.4812	132.55	4261574.0
2012-01-25 18:00:00	SPY	ETF	132.52	132.53	132.31	132.31	240801.0
2012-01-25 19:00:00	SPY	ETF	132.31	132.41	132.28	132.38	172566.0
2012-01-25 04:00:00	QQQ	ETF	60.29	60.29	60.15	60.17	10800.0
2012-01-25 05:00:00	QQQ	ETF	60.21	60.21	60.08	60.08	10900.0
2012-01-25 06:00:00	QQQ	ETF	60.07	60.18	60.05	60.17	59500.0
2012-01-25 07:00:00	QQQ	ETF	60.16	60.26	60.15	60.24	92325.0
2012-01-25 08:00:00	QQQ	ETF	60.17	60.34	60.16	60.3	505313.0
2012-01-25 09:00:00	QQQ	ETF	60.3	60.37	59.91	59.96	7866137.0
2012-01-25 10:00:00	QQQ	ETF	59.965	60.06	59.8335	60.01	10264043.0
2012-01-25 11:00:00	QQQ	ETF	60.02	60.19	60.0	60.15	4163254.0
2012-01-25 12:00:00	QQQ	ETF	60.14	60.27	59.98	60.02	9206871.0
2012-01-25 13:00:00	QQQ	ETF	60.02	60.51	60.02	60.49	7442562.0
2012-01-25 14:00:00	QQQ	ETF	60.5	60.5	60.22	60.34	7204676.0
2012-01-25 15:00:00	QQQ	ETF	60.34	60.58	60.3	60.43	12124121.0
2012-01-25 16:00:00	QQQ	ETF	60.43	60.5091	60.35	60.39	1733012.0
2012-01-25 17:00:00	QQQ	ETF	60.38	60.4	60.37	60.4	9850.0
2012-01-25 18:00:00	QQQ	ETF	60.36	60.36	60.32	60.33	22690.0
2012-01-25 19:00:00	QQQ	ETF	60.36	60.38	60.35	60.37	8360.0
2012-01-25 04:00:00	IWM	ETF	79.1	79.1	78.72	78.72	200.0
2012-01-25 06:00:00	IWM	ETF	78.53	78.6	78.53	78.6	3067.0
2012-01-25 07:00:00	IWM	ETF	78.6	78.62	78.46	78.53	92894.0
2012-01-25 08:00:00	IWM	ETF	78.57	79.12	78.52	78.54	183624.0
2012-01-25 09:00:00	IWM	ETF	78.5	78.62	78.19	78.33	4713089.0
2012-01-25 10:00:00	IWM	ETF	78.32	78.66	78.24	78.61	9013828.0
2012-01-25 11:00:00	IWM	ETF	78.61	78.84	78.6	78.76	4289740.0
2012-01-25 12:00:00	IWM	ETF	78.76	79.01	78.51	78.8	8710299.0
2012-01-25 13:00:00	IWM	ETF	78.8	79.57	78.78	79.53	6726664.0
2012-01-25 14:00:00	IWM	ETF	79.52	79.535	78.945	79.1	6937869.0
2012-01-25 15:00:00	IWM	ETF	79.1	79.55	79.0	79.28	12210083.0
2012-01-25 16:00:00	IWM	ETF	79.28	79.39	79.25	79.35	2658704.0
2012-01-25 17:00:00	IWM	ETF	79.39	79.48	79.38	79.48	205837.0
2012-01-25 18:00:00	IWM	ETF	79.41	79.41	79.41	79.41	100.0
2012-01-25 07:00:00	DIA	ETF	126.0	126.0	126.0	126.0	500.0
2012-01-25 08:00:00	DIA	ETF	126.14	126.14	126.0	126.04	2450.0
2012-01-25 09:00:00	DIA	ETF	126.0	126.13	125.57	125.59	589725.0
2012-01-25 10:00:00	DIA	ETF	125.56	125.9	125.47	125.86	782012.0

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

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