PREVIEW / etf_1hour / 2013-10-10

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-10-10.parquet
  size:    215 KB
  rows:    6,673

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-10-10 04:00:00	SPY	ETF	166.43	166.8	166.43	166.66	80783.0
2013-10-10 05:00:00	SPY	ETF	166.65	166.86	166.65	166.79	54483.0
2013-10-10 06:00:00	SPY	ETF	166.77	167.08	166.77	167.0	234517.0
2013-10-10 07:00:00	SPY	ETF	167.0	167.12	166.83	166.84	688430.0
2013-10-10 08:00:00	SPY	ETF	166.84	167.08	165.57	167.07	3077569.0
2013-10-10 09:00:00	SPY	ETF	167.07	167.9	167.07	167.815	25176428.0
2013-10-10 10:00:00	SPY	ETF	167.815	168.18	167.62	167.89	25573297.0
2013-10-10 11:00:00	SPY	ETF	167.88	168.52	167.59	168.385	25288310.0
2013-10-10 12:00:00	SPY	ETF	168.3801	168.51	168.3	168.41	11010370.0
2013-10-10 13:00:00	SPY	ETF	168.39	168.46	168.19	168.43	14267305.0
2013-10-10 14:00:00	SPY	ETF	168.425	168.43	168.12	168.37	10664747.0
2013-10-10 15:00:00	SPY	ETF	168.37	169.26	168.37	169.16	49603837.0
2013-10-10 16:00:00	SPY	ETF	169.16	169.24	165.586	168.78	19789359.0
2013-10-10 17:00:00	SPY	ETF	168.78	168.85	168.67	168.8	3765734.0
2013-10-10 18:00:00	SPY	ETF	168.8	168.86	167.86	168.6	1657989.0
2013-10-10 19:00:00	SPY	ETF	168.61	168.9	168.54	168.75	275576.0
2013-10-10 04:00:00	QQQ	ETF	77.37	77.48	77.35	77.46	40300.0
2013-10-10 05:00:00	QQQ	ETF	77.47	77.53	77.47	77.51	11800.0
2013-10-10 06:00:00	QQQ	ETF	77.52	77.64	77.52	77.59	17900.0
2013-10-10 07:00:00	QQQ	ETF	77.6	77.67	77.59	77.59	103960.0
2013-10-10 08:00:00	QQQ	ETF	77.6	77.7	76.98	77.7	206568.0
2013-10-10 09:00:00	QQQ	ETF	77.71	78.25	77.71	78.21	9304949.0
2013-10-10 10:00:00	QQQ	ETF	78.21	78.331	78.01	78.14	7288837.0
2013-10-10 11:00:00	QQQ	ETF	78.14	78.49	78.03	78.4399	6659890.0
2013-10-10 12:00:00	QQQ	ETF	78.44	78.55	78.39	78.48	2417761.0
2013-10-10 13:00:00	QQQ	ETF	78.47	78.48	78.361	78.43	2339216.0
2013-10-10 14:00:00	QQQ	ETF	78.43	78.45	78.24	78.45	2253584.0
2013-10-10 15:00:00	QQQ	ETF	78.45	78.79	78.44	78.61	9350940.0
2013-10-10 16:00:00	QQQ	ETF	78.61	78.67	78.0	78.38	4069836.0
2013-10-10 17:00:00	QQQ	ETF	78.37	78.43	78.36	78.38	15050.0
2013-10-10 18:00:00	QQQ	ETF	78.42	78.42	78.0	78.27	224423.0
2013-10-10 19:00:00	QQQ	ETF	78.26	78.42	78.26	78.36	25788.0
2013-10-10 04:00:00	IWM	ETF	104.4	104.4	104.4	104.4	100.0
2013-10-10 06:00:00	IWM	ETF	104.62	104.62	104.62	104.62	100.0
2013-10-10 07:00:00	IWM	ETF	104.72	104.75	104.64	104.66	159864.0
2013-10-10 08:00:00	IWM	ETF	104.65	104.75	104.48	104.75	315176.0
2013-10-10 09:00:00	IWM	ETF	104.75	105.51	104.75	105.44	8957608.0
2013-10-10 10:00:00	IWM	ETF	105.45	105.72	105.175	105.5	8476227.0
2013-10-10 11:00:00	IWM	ETF	105.4975	105.91	105.28	105.85	6752134.0
2013-10-10 12:00:00	IWM	ETF	105.85	106.06	105.8	105.99	3150674.0
2013-10-10 13:00:00	IWM	ETF	105.98	106.02	105.83	105.97	2713291.0
2013-10-10 14:00:00	IWM	ETF	105.98	105.98	105.79	105.9055	2656640.0
2013-10-10 15:00:00	IWM	ETF	105.91	106.31	105.895	106.13	12246181.0
2013-10-10 16:00:00	IWM	ETF	106.13	106.1796	103.5964	105.96	3659942.0
2013-10-10 17:00:00	IWM	ETF	105.98	106.09	105.96	106.09	4256.0
2013-10-10 18:00:00	IWM	ETF	105.99	106.0	105.51	105.7	49668.0
2013-10-10 19:00:00	IWM	ETF	105.93	105.96	105.87	105.96	7502.0
2013-10-10 05:00:00	DIA	ETF	148.88	148.88	148.88	148.88	200.0
2013-10-10 06:00:00	DIA	ETF	148.85	149.03	148.85	149.03	7100.0
2013-10-10 07:00:00	DIA	ETF	149.05	149.05	148.9	148.97	38150.0

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

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