PREVIEW / etf_1hour / 2012-05-16

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-05-16.parquet
  size:    192 KB
  rows:    5,932

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-05-16 04:00:00	SPY	ETF	133.25	133.3	133.11	133.2	55059.0
2012-05-16 05:00:00	SPY	ETF	133.27	133.5	133.15	133.23	49970.0
2012-05-16 06:00:00	SPY	ETF	133.19	133.56	133.05	133.39	101544.0
2012-05-16 07:00:00	SPY	ETF	133.4	133.85	133.31	133.85	449738.0
2012-05-16 08:00:00	SPY	ETF	133.81	134.25	133.78	133.94	2205368.0
2012-05-16 09:00:00	SPY	ETF	133.93	134.47	133.74	134.36	21008283.0
2012-05-16 10:00:00	SPY	ETF	134.35	134.55	133.97	134.02	27949490.0
2012-05-16 11:00:00	SPY	ETF	134.03	134.3259	133.47	133.885	37649964.0
2012-05-16 12:00:00	SPY	ETF	133.89	133.9	133.49	133.56	16365204.0
2012-05-16 13:00:00	SPY	ETF	133.55	133.66	133.08	133.42	18713414.0
2012-05-16 14:00:00	SPY	ETF	133.42	133.72	132.91	133.389	32370515.0
2012-05-16 15:00:00	SPY	ETF	133.38	133.43	132.8	132.85	36380666.0
2012-05-16 16:00:00	SPY	ETF	132.85	133.5623	132.76	132.91	9581942.0
2012-05-16 17:00:00	SPY	ETF	132.89	132.94	132.74	132.75	633136.0
2012-05-16 18:00:00	SPY	ETF	132.73	132.93	132.66	132.9	119618.0
2012-05-16 19:00:00	SPY	ETF	132.92	133.15	132.88	133.13	178150.0
2012-05-16 06:00:00	QQQ	ETF	63.41	63.41	63.35	63.4	4458.0
2012-05-16 07:00:00	QQQ	ETF	63.4	63.58	63.36	63.58	64250.0
2012-05-16 08:00:00	QQQ	ETF	63.56	63.78	63.55	63.58	493854.0
2012-05-16 09:00:00	QQQ	ETF	63.57	63.78	63.37	63.69	5967785.0
2012-05-16 10:00:00	QQQ	ETF	63.69	63.76	63.47	63.59	8420461.0
2012-05-16 11:00:00	QQQ	ETF	63.595	63.63	63.21	63.42	10453709.0
2012-05-16 12:00:00	QQQ	ETF	63.42	63.43	63.27	63.295	3816407.0
2012-05-16 13:00:00	QQQ	ETF	63.29	63.36	62.86	63.045	5399825.0
2012-05-16 14:00:00	QQQ	ETF	63.05	63.19	62.81	63.1	7936125.0
2012-05-16 15:00:00	QQQ	ETF	63.1	63.12	62.82	62.92	8375057.0
2012-05-16 16:00:00	QQQ	ETF	62.93	62.96	62.84	62.9	786699.0
2012-05-16 17:00:00	QQQ	ETF	62.91	62.92	62.8	62.84	104542.0
2012-05-16 18:00:00	QQQ	ETF	62.83	62.9	62.79	62.87	71536.0
2012-05-16 19:00:00	QQQ	ETF	62.87	62.99	62.87	62.99	16050.0
2012-05-16 04:00:00	IWM	ETF	77.4	77.4	77.39	77.39	405.0
2012-05-16 05:00:00	IWM	ETF	77.59	77.59	77.59	77.59	300.0
2012-05-16 07:00:00	IWM	ETF	77.54	78.02	77.54	77.9	143438.0
2012-05-16 08:00:00	IWM	ETF	77.9	78.3	77.88	77.9	449897.0
2012-05-16 09:00:00	IWM	ETF	77.9	78.325	77.76	78.22	4933440.0
2012-05-16 10:00:00	IWM	ETF	78.23	78.39	78.0	78.148	6243405.0
2012-05-16 11:00:00	IWM	ETF	78.16	78.21	77.82	78.13	9048559.0
2012-05-16 12:00:00	IWM	ETF	78.13	78.15	77.63	77.65	4851246.0
2012-05-16 13:00:00	IWM	ETF	77.64	77.77	77.34	77.59	5598245.0
2012-05-16 14:00:00	IWM	ETF	77.595	77.82	77.31	77.4599	7802716.0
2012-05-16 15:00:00	IWM	ETF	77.45	77.49	77.1	77.2	8343085.0
2012-05-16 16:00:00	IWM	ETF	77.21	78.2066	77.02	77.12	1463343.0
2012-05-16 17:00:00	IWM	ETF	77.12	77.12	76.97	76.97	23184.0
2012-05-16 18:00:00	IWM	ETF	77.02	77.16	77.02	77.16	2600.0
2012-05-16 19:00:00	IWM	ETF	77.17	77.18	77.17	77.18	1800.0
2012-05-16 04:00:00	DIA	ETF	125.78	125.78	125.78	125.78	200.0
2012-05-16 07:00:00	DIA	ETF	126.44	126.8	126.44	126.53	15500.0
2012-05-16 08:00:00	DIA	ETF	126.71	127.02	126.71	126.75	9799.0
2012-05-16 09:00:00	DIA	ETF	126.85	127.31	126.68	127.23	606990.0
2012-05-16 10:00:00	DIA	ETF	127.22	127.37	126.86	126.92	706647.0

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

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