PREVIEW / etf_1hour / 2013-05-01

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-05-01.parquet
  size:    202 KB
  rows:    6,307

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
2013-05-01 04:00:00	SPY	ETF	159.87	159.9	159.87	159.9	200.0
2013-05-01 05:00:00	SPY	ETF	159.97	159.98	159.86	159.89	8700.0
2013-05-01 06:00:00	SPY	ETF	159.86	159.93	159.82	159.92	33176.0
2013-05-01 07:00:00	SPY	ETF	159.93	160.0	159.82	159.83	108675.0
2013-05-01 08:00:00	SPY	ETF	159.85	160.08	159.42	159.48	1721502.0
2013-05-01 09:00:00	SPY	ETF	159.5	159.68	159.08	159.17	14052892.0
2013-05-01 10:00:00	SPY	ETF	159.17	159.4	158.77	159.25	22328648.0
2013-05-01 11:00:00	SPY	ETF	159.25	159.32	158.98	159.23	9281452.0
2013-05-01 12:00:00	SPY	ETF	159.2202	159.25	158.83	158.851	6609854.0
2013-05-01 13:00:00	SPY	ETF	158.855	158.885	158.45	158.648	15554055.0
2013-05-01 14:00:00	SPY	ETF	158.64	159.11	158.6	158.88	18546540.0
2013-05-01 15:00:00	SPY	ETF	158.87	158.9	158.1	158.2725	27018927.0
2013-05-01 16:00:00	SPY	ETF	158.31	159.7496	158.15	158.34	20375652.0
2013-05-01 17:00:00	SPY	ETF	158.34	158.41	158.34	158.41	182170.0
2013-05-01 18:00:00	SPY	ETF	158.42	158.55	158.4	158.55	63855.0
2013-05-01 19:00:00	SPY	ETF	158.5	158.52	158.38	158.42	37644.0
2013-05-01 04:00:00	QQQ	ETF	70.77	70.77	70.77	70.77	200.0
2013-05-01 07:00:00	QQQ	ETF	70.73	70.8	70.73	70.77	20200.0
2013-05-01 08:00:00	QQQ	ETF	70.73	70.81	70.69	70.69	94341.0
2013-05-01 09:00:00	QQQ	ETF	70.7	70.85	70.61	70.662	3809497.0
2013-05-01 10:00:00	QQQ	ETF	70.67	70.75	70.39	70.64	4539126.0
2013-05-01 11:00:00	QQQ	ETF	70.64	70.71	70.53	70.67	1964819.0
2013-05-01 12:00:00	QQQ	ETF	70.662	70.69	70.49	70.498	1332491.0
2013-05-01 13:00:00	QQQ	ETF	70.49	70.505	70.33	70.44	2628217.0
2013-05-01 14:00:00	QQQ	ETF	70.44	70.65	70.42	70.5999	2785454.0
2013-05-01 15:00:00	QQQ	ETF	70.59	70.63	70.25	70.41	4830186.0
2013-05-01 16:00:00	QQQ	ETF	70.41	70.7178	70.3	70.36	6173173.0
2013-05-01 17:00:00	QQQ	ETF	70.37	70.39	70.34	70.34	19098.0
2013-05-01 18:00:00	QQQ	ETF	70.38	70.43	70.38	70.43	6195.0
2013-05-01 19:00:00	QQQ	ETF	70.44	70.44	70.4	70.4	1100.0
2013-05-01 05:00:00	IWM	ETF	94.12	94.12	94.12	94.12	100.0
2013-05-01 07:00:00	IWM	ETF	94.16	94.16	94.06	94.06	27600.0
2013-05-01 08:00:00	IWM	ETF	94.07	94.13	93.88	93.88	126134.0
2013-05-01 09:00:00	IWM	ETF	93.88	94.1	93.1	93.18	8565303.0
2013-05-01 10:00:00	IWM	ETF	93.18	93.27	92.58	92.8	15926775.0
2013-05-01 11:00:00	IWM	ETF	92.8	92.855	92.35	92.61	10559801.0
2013-05-01 12:00:00	IWM	ETF	92.61	92.651	92.26	92.3	7849112.0
2013-05-01 13:00:00	IWM	ETF	92.3	92.37	91.89	92.14	13104747.0
2013-05-01 14:00:00	IWM	ETF	92.14	92.61	92.11	92.19	11467494.0
2013-05-01 15:00:00	IWM	ETF	92.19	92.28	91.76	91.84	19664904.0
2013-05-01 16:00:00	IWM	ETF	91.84	94.12	91.7	91.85	8049844.0
2013-05-01 17:00:00	IWM	ETF	91.87	91.87	91.84	91.85	4875.0
2013-05-01 19:00:00	IWM	ETF	91.92	91.94	91.92	91.94	1500.0
2013-05-01 04:00:00	DIA	ETF	148.17	148.17	148.17	148.17	4300.0
2013-05-01 07:00:00	DIA	ETF	148.15	148.21	148.11	148.19	2200.0
2013-05-01 08:00:00	DIA	ETF	148.02	148.02	147.78	147.78	7895.0
2013-05-01 09:00:00	DIA	ETF	147.77	147.77	147.46	147.61	498059.0
2013-05-01 10:00:00	DIA	ETF	147.64	147.81	147.31	147.62	735214.0
2013-05-01 11:00:00	DIA	ETF	147.63	147.67	147.41	147.56	382947.0
2013-05-01 12:00:00	DIA	ETF	147.55	147.57	147.25	147.271	271904.0

> showing 50 of 6,307 rows — these rows as CSV

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