PREVIEW / etf_1hour / 2013-10-30

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-10-30.parquet
  size:    210 KB
  rows:    6,651

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-30 04:00:00	SPY	ETF	177.22	177.63	177.22	177.61	274450.0
2013-10-30 05:00:00	SPY	ETF	177.62	177.76	177.61	177.75	219310.0
2013-10-30 06:00:00	SPY	ETF	177.7	177.7	177.64	177.66	30200.0
2013-10-30 07:00:00	SPY	ETF	177.7	177.7	177.56	177.62	99388.0
2013-10-30 08:00:00	SPY	ETF	177.61	177.75	177.39	177.44	905820.0
2013-10-30 09:00:00	SPY	ETF	177.44	177.51	177.13	177.27	10583455.0
2013-10-30 10:00:00	SPY	ETF	177.265	177.34	177.02	177.25	15141536.0
2013-10-30 11:00:00	SPY	ETF	177.25	177.31	176.65	176.7303	13236752.0
2013-10-30 12:00:00	SPY	ETF	176.73	176.99	176.69	176.9625	7132448.0
2013-10-30 13:00:00	SPY	ETF	176.96	176.99	176.52	176.63	9214870.0
2013-10-30 14:00:00	SPY	ETF	176.64	177.07	175.66	176.2686	41151652.0
2013-10-30 15:00:00	SPY	ETF	176.26	176.59	176.14	176.345	25197914.0
2013-10-30 16:00:00	SPY	ETF	176.345	177.1	176.23	176.44	9805873.0
2013-10-30 17:00:00	SPY	ETF	176.44	176.45	176.27	176.27	5272365.0
2013-10-30 18:00:00	SPY	ETF	176.27	176.29	175.84	175.87	191277.0
2013-10-30 19:00:00	SPY	ETF	175.87	175.99	175.82	175.96	154864.0
2013-10-30 04:00:00	QQQ	ETF	83.23	83.35	83.22	83.35	38600.0
2013-10-30 05:00:00	QQQ	ETF	83.36	83.43	83.36	83.41	11800.0
2013-10-30 06:00:00	QQQ	ETF	83.4	83.42	83.37	83.39	6375.0
2013-10-30 07:00:00	QQQ	ETF	83.4	83.44	83.4	83.43	45500.0
2013-10-30 08:00:00	QQQ	ETF	83.43	83.44	83.31	83.34	201326.0
2013-10-30 09:00:00	QQQ	ETF	83.33	83.485	83.06	83.37	3981739.0
2013-10-30 10:00:00	QQQ	ETF	83.375	83.39	83.081	83.3	4630294.0
2013-10-30 11:00:00	QQQ	ETF	83.31	83.375	82.94	83.03	3887640.0
2013-10-30 12:00:00	QQQ	ETF	83.03	83.17	82.96	83.17	1821225.0
2013-10-30 13:00:00	QQQ	ETF	83.17	83.19	82.93	83.01	1632350.0
2013-10-30 14:00:00	QQQ	ETF	83.01	83.25	82.58	82.81	8100320.0
2013-10-30 15:00:00	QQQ	ETF	82.81	83.03	82.75	82.96	4781132.0
2013-10-30 16:00:00	QQQ	ETF	82.96	83.366	82.86	83.16	2377198.0
2013-10-30 17:00:00	QQQ	ETF	83.16	83.17	82.92	82.92	27390.0
2013-10-30 18:00:00	QQQ	ETF	82.92	82.94	82.75	82.76	106482.0
2013-10-30 19:00:00	QQQ	ETF	82.75	82.8	82.7	82.79	10900.0
2013-10-30 07:00:00	IWM	ETF	111.67	111.67	111.59	111.6	3569.0
2013-10-30 08:00:00	IWM	ETF	111.59	111.61	111.4	111.42	149987.0
2013-10-30 09:00:00	IWM	ETF	111.43	111.48	111.05	111.08	3423448.0
2013-10-30 10:00:00	IWM	ETF	111.09	111.12	110.74	110.84	4198997.0
2013-10-30 11:00:00	IWM	ETF	110.845	110.915	110.19	110.285	5362693.0
2013-10-30 12:00:00	IWM	ETF	110.28	110.41	110.13	110.39	3237671.0
2013-10-30 13:00:00	IWM	ETF	110.39	110.44	110.07	110.2	2524678.0
2013-10-30 14:00:00	IWM	ETF	110.2	110.69	109.52	109.76	12163773.0
2013-10-30 15:00:00	IWM	ETF	109.76	110.11	109.68	109.85	10431450.0
2013-10-30 16:00:00	IWM	ETF	109.84	110.13	109.79	110.05	1631731.0
2013-10-30 17:00:00	IWM	ETF	110.02	110.04	109.83	109.83	4600.0
2013-10-30 18:00:00	IWM	ETF	109.81	109.83	109.7	109.7	8070.0
2013-10-30 19:00:00	IWM	ETF	109.7	109.76	109.6	109.7	9504.0
2013-10-30 04:00:00	DIA	ETF	156.8	156.82	156.8	156.82	1700.0
2013-10-30 05:00:00	DIA	ETF	156.92	156.97	156.92	156.97	1400.0
2013-10-30 07:00:00	DIA	ETF	156.95	156.95	156.85	156.87	900.0
2013-10-30 08:00:00	DIA	ETF	156.83	156.89	156.74	156.74	3695.0
2013-10-30 09:00:00	DIA	ETF	156.76	156.87	156.44	156.55	841735.0

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

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