PREVIEW / etf_1hour / 2013-06-05

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-06-05.parquet
  size:    212 KB
  rows:    6,639

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-06-05 04:00:00	SPY	ETF	163.42	163.57	163.27	163.4	6800.0
2013-06-05 05:00:00	SPY	ETF	163.37	163.47	163.11	163.19	24300.0
2013-06-05 06:00:00	SPY	ETF	163.22	163.22	162.75	162.93	112093.0
2013-06-05 07:00:00	SPY	ETF	162.91	163.08	162.8	162.93	317727.0
2013-06-05 08:00:00	SPY	ETF	162.93	163.32	162.75	163.21	2912161.0
2013-06-05 09:00:00	SPY	ETF	163.19	163.37	162.84	162.99	14445785.0
2013-06-05 10:00:00	SPY	ETF	162.99	163.42	162.31	162.4	32890875.0
2013-06-05 11:00:00	SPY	ETF	162.4	162.43	161.82	161.93	24912377.0
2013-06-05 12:00:00	SPY	ETF	161.94	162.0199	161.35	161.48	21582274.0
2013-06-05 13:00:00	SPY	ETF	161.49	162.19	161.35	161.77	25606144.0
2013-06-05 14:00:00	SPY	ETF	161.76	161.91	161.13	161.64	26709514.0
2013-06-05 15:00:00	SPY	ETF	161.64	161.98	161.25	161.26	39136129.0
2013-06-05 16:00:00	SPY	ETF	161.26	163.5885	161.16	161.35	17833115.0
2013-06-05 17:00:00	SPY	ETF	161.35	161.45	161.32	161.38	257931.0
2013-06-05 18:00:00	SPY	ETF	161.38	161.49	161.29	161.43	263598.0
2013-06-05 19:00:00	SPY	ETF	161.44	161.58	161.41	161.55	267246.0
2013-06-05 04:00:00	QQQ	ETF	72.96	73.01	72.92	72.95	4600.0
2013-06-05 05:00:00	QQQ	ETF	72.92	72.98	72.86	72.86	3900.0
2013-06-05 06:00:00	QQQ	ETF	72.83	72.83	72.71	72.78	5684.0
2013-06-05 07:00:00	QQQ	ETF	72.8	72.83	72.7	72.75	128880.0
2013-06-05 08:00:00	QQQ	ETF	72.8	72.87	72.71	72.85	801627.0
2013-06-05 09:00:00	QQQ	ETF	72.86	73.04	72.62	72.88	5794791.0
2013-06-05 10:00:00	QQQ	ETF	72.89	73.03	72.46	72.54	7394464.0
2013-06-05 11:00:00	QQQ	ETF	72.54	72.54	72.3	72.34	5330518.0
2013-06-05 12:00:00	QQQ	ETF	72.35	72.39	72.04	72.09	3178356.0
2013-06-05 13:00:00	QQQ	ETF	72.09	72.43	72.04	72.24	4425668.0
2013-06-05 14:00:00	QQQ	ETF	72.23	72.299	71.99	72.18	3585511.0
2013-06-05 15:00:00	QQQ	ETF	72.1835	72.33	72.02	72.0999	8165088.0
2013-06-05 16:00:00	QQQ	ETF	72.08	72.9951	72.03	72.15	5670721.0
2013-06-05 17:00:00	QQQ	ETF	72.11	72.19	72.11	72.13	6836.0
2013-06-05 18:00:00	QQQ	ETF	72.19	72.25	72.11	72.18	13100.0
2013-06-05 19:00:00	QQQ	ETF	72.2	72.22	72.18	72.2	15353.0
2013-06-05 06:00:00	IWM	ETF	97.27	97.3	97.27	97.3	4900.0
2013-06-05 07:00:00	IWM	ETF	97.32	97.53	97.3	97.41	188660.0
2013-06-05 08:00:00	IWM	ETF	97.35	97.7	97.33	97.62	197165.0
2013-06-05 09:00:00	IWM	ETF	97.62	97.71	97.15	97.18	4325288.0
2013-06-05 10:00:00	IWM	ETF	97.2	97.645	96.69	96.91	11086761.0
2013-06-05 11:00:00	IWM	ETF	96.9	96.92	96.51	96.59	6403569.0
2013-06-05 12:00:00	IWM	ETF	96.58	96.62	96.25	96.3901	5857135.0
2013-06-05 13:00:00	IWM	ETF	96.39	96.98	96.28	96.69	6210295.0
2013-06-05 14:00:00	IWM	ETF	96.69	96.81	96.15	96.58	5915828.0
2013-06-05 15:00:00	IWM	ETF	96.57	96.7102	96.25	96.42	9864664.0
2013-06-05 16:00:00	IWM	ETF	96.41	97.3696	96.34	96.41	3147929.0
2013-06-05 17:00:00	IWM	ETF	96.41	96.43	96.39	96.43	4971.0
2013-06-05 18:00:00	IWM	ETF	96.43	96.43	96.41	96.42	5200.0
2013-06-05 19:00:00	IWM	ETF	96.42	96.49	96.4	96.4	1913.0
2013-06-05 06:00:00	DIA	ETF	151.21	151.21	151.21	151.21	500.0
2013-06-05 07:00:00	DIA	ETF	151.06	151.22	151.06	151.22	4500.0
2013-06-05 08:00:00	DIA	ETF	151.19	151.27	151.15	151.24	3807.0
2013-06-05 09:00:00	DIA	ETF	151.23	151.3	150.92	151.06	579184.0

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

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