PREVIEW / etf_1hour / 2011-07-05

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-07-05.parquet
  size:    179 KB
  rows:    5,538

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
2011-07-05 04:00:00	SPY	ETF	133.85	133.97	133.8	133.87	1800.0
2011-07-05 05:00:00	SPY	ETF	133.82	134.05	133.8	134.05	5000.0
2011-07-05 06:00:00	SPY	ETF	134.1	134.2	134.0	134.0	33100.0
2011-07-05 07:00:00	SPY	ETF	134.0	134.09	133.7	133.7	701187.0
2011-07-05 08:00:00	SPY	ETF	133.71	133.76	133.57	133.76	1332494.0
2011-07-05 09:00:00	SPY	ETF	133.76	133.81	133.48	133.7	15004218.0
2011-07-05 10:00:00	SPY	ETF	133.71	133.98	133.455	133.53	19597504.0
2011-07-05 11:00:00	SPY	ETF	133.54	133.81	133.39	133.76	15029378.0
2011-07-05 12:00:00	SPY	ETF	133.77	133.93	133.73	133.85	6814094.0
2011-07-05 13:00:00	SPY	ETF	133.86	134.08	133.84	134.05	9158533.0
2011-07-05 14:00:00	SPY	ETF	134.06	134.08	133.4	133.74	32786063.0
2011-07-05 15:00:00	SPY	ETF	133.73	134.07	133.63	133.78	46863173.0
2011-07-05 16:00:00	SPY	ETF	133.77	134.17	133.67	134.0	11802390.0
2011-07-05 17:00:00	SPY	ETF	134.01	134.05	133.97	134.03	255182.0
2011-07-05 18:00:00	SPY	ETF	134.02	134.06	133.71	134.01	149664.0
2011-07-05 19:00:00	SPY	ETF	134.0	134.03	134.0	134.01	51650.0
2011-07-05 04:00:00	QQQ	ETF	57.92	58.04	57.92	58.04	200.0
2011-07-05 05:00:00	QQQ	ETF	58.0	58.14	58.0	58.14	1100.0
2011-07-05 06:00:00	QQQ	ETF	58.18	58.2	58.05	58.05	700.0
2011-07-05 07:00:00	QQQ	ETF	58.06	58.08	57.95	57.95	70700.0
2011-07-05 08:00:00	QQQ	ETF	57.95	57.99	57.9	57.95	323231.0
2011-07-05 09:00:00	QQQ	ETF	57.95	58.0	57.91	57.97	6091502.0
2011-07-05 10:00:00	QQQ	ETF	57.97	58.09	57.83	57.94	7847224.0
2011-07-05 11:00:00	QQQ	ETF	57.94	58.1699	57.9	58.095	6344279.0
2011-07-05 12:00:00	QQQ	ETF	58.0997	58.16	58.06	58.15	2822248.0
2011-07-05 13:00:00	QQQ	ETF	58.15	58.23	58.14	58.225	2712096.0
2011-07-05 14:00:00	QQQ	ETF	58.23	58.255	57.96	58.1071	8344600.0
2011-07-05 15:00:00	QQQ	ETF	58.1	58.26	58.05	58.19	6996335.0
2011-07-05 16:00:00	QQQ	ETF	58.19	58.28	58.09	58.22	710526.0
2011-07-05 17:00:00	QQQ	ETF	58.23	58.25	58.1112	58.22	26542.0
2011-07-05 18:00:00	QQQ	ETF	58.24	58.25	58.18	58.24	70364.0
2011-07-05 19:00:00	QQQ	ETF	58.25	58.26	58.22	58.24	23492.0
2011-07-05 05:00:00	IWM	ETF	83.86	83.92	83.86	83.92	300.0
2011-07-05 06:00:00	IWM	ETF	84.05	84.06	83.93	84.02	5900.0
2011-07-05 07:00:00	IWM	ETF	84.02	84.02	83.81	83.81	49213.0
2011-07-05 08:00:00	IWM	ETF	83.79	83.9	83.75	83.88	363195.0
2011-07-05 09:00:00	IWM	ETF	83.86	83.97	83.62	83.85	6395715.0
2011-07-05 10:00:00	IWM	ETF	83.86	84.04	83.55	83.63	10214318.0
2011-07-05 11:00:00	IWM	ETF	83.6299	83.85	83.53	83.8157	5930763.0
2011-07-05 12:00:00	IWM	ETF	83.8185	83.98	83.78	83.94	2753405.0
2011-07-05 13:00:00	IWM	ETF	83.94	84.14	83.92	84.11	3034773.0
2011-07-05 14:00:00	IWM	ETF	84.12	84.14	83.73	83.9	5576470.0
2011-07-05 15:00:00	IWM	ETF	83.8991	84.11	83.835	84.03	6015716.0
2011-07-05 16:00:00	IWM	ETF	84.04	84.22	84.0	84.14	1236162.0
2011-07-05 17:00:00	IWM	ETF	84.14	84.2	84.12	84.17	105885.0
2011-07-05 18:00:00	IWM	ETF	84.2	84.22	84.19	84.2	18953.0
2011-07-05 19:00:00	IWM	ETF	84.23	84.3	84.16	84.3	15325.0
2011-07-05 05:00:00	DIA	ETF	125.71	125.71	125.71	125.71	200.0
2011-07-05 07:00:00	DIA	ETF	125.85	125.85	125.61	125.61	7400.0
2011-07-05 08:00:00	DIA	ETF	125.53	125.61	125.47	125.61	27013.0

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

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