PREVIEW / etf_1hour / 2011-05-18

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-05-18.parquet
  size:    178 KB
  rows:    5,445

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-05-18 04:00:00	SPY	ETF	133.3	133.63	133.3	133.63	1800.0
2011-05-18 05:00:00	SPY	ETF	133.45	133.45	133.37	133.42	8550.0
2011-05-18 06:00:00	SPY	ETF	133.37	133.5	133.34	133.4	189500.0
2011-05-18 07:00:00	SPY	ETF	133.35	133.42	133.11	133.23	302615.0
2011-05-18 08:00:00	SPY	ETF	133.22	133.35	132.96	133.23	2649411.0
2011-05-18 09:00:00	SPY	ETF	133.22	133.49	132.95	133.26	16365099.0
2011-05-18 10:00:00	SPY	ETF	133.255	133.88	133.22	133.75	19868815.0
2011-05-18 11:00:00	SPY	ETF	133.75	133.93	133.65	133.78	11812883.0
2011-05-18 12:00:00	SPY	ETF	133.785	133.95	133.67	133.88	9292195.0
2011-05-18 13:00:00	SPY	ETF	133.88	134.39	133.87	134.32	13607229.0
2011-05-18 14:00:00	SPY	ETF	134.32	134.49	133.97	134.02	20347645.0
2011-05-18 15:00:00	SPY	ETF	134.02	134.5	133.99	134.37	21787261.0
2011-05-18 16:00:00	SPY	ETF	134.37	134.52	133.2073	134.4	14621343.0
2011-05-18 17:00:00	SPY	ETF	134.42	134.52	133.2073	134.49	1639022.0
2011-05-18 18:00:00	SPY	ETF	134.47	134.54	134.38	134.46	153586.0
2011-05-18 19:00:00	SPY	ETF	134.43	134.51	134.41	134.43	51156.0
2011-05-18 06:00:00	QQQ	ETF	57.64	57.64	57.6	57.6	1800.0
2011-05-18 07:00:00	QQQ	ETF	57.59	57.59	57.43	57.46	88757.0
2011-05-18 08:00:00	QQQ	ETF	57.49	57.49	57.36	57.49	364224.0
2011-05-18 09:00:00	QQQ	ETF	57.49	57.64	57.41	57.495	5017298.0
2011-05-18 10:00:00	QQQ	ETF	57.51	57.73	57.485	57.66	5616815.0
2011-05-18 11:00:00	QQQ	ETF	57.665	57.76	57.66	57.7099	2488347.0
2011-05-18 12:00:00	QQQ	ETF	57.71	57.82	57.64	57.78	3390763.0
2011-05-18 13:00:00	QQQ	ETF	57.77	58.04	57.77	58.0	3670698.0
2011-05-18 14:00:00	QQQ	ETF	58.0	58.14	57.96	58.0	4457174.0
2011-05-18 15:00:00	QQQ	ETF	58.0	58.11	57.98	58.02	5637345.0
2011-05-18 16:00:00	QQQ	ETF	58.03	58.13	57.5699	58.13	2210784.0
2011-05-18 17:00:00	QQQ	ETF	58.14	58.16	58.11	58.12	209608.0
2011-05-18 18:00:00	QQQ	ETF	58.12	58.18	58.05	58.14	60197.0
2011-05-18 19:00:00	QQQ	ETF	58.13	58.18	58.13	58.18	15561.0
2011-05-18 04:00:00	IWM	ETF	82.43	82.49	82.43	82.49	200.0
2011-05-18 07:00:00	IWM	ETF	82.22	82.3	82.03	82.14	18900.0
2011-05-18 08:00:00	IWM	ETF	82.25	82.25	81.99	82.2	432394.0
2011-05-18 09:00:00	IWM	ETF	82.17	82.6	82.0	82.26	7489951.0
2011-05-18 10:00:00	IWM	ETF	82.26	82.86	82.17	82.68	7853853.0
2011-05-18 11:00:00	IWM	ETF	82.68	82.88	82.61	82.84	3779218.0
2011-05-18 12:00:00	IWM	ETF	82.84	83.0	82.7101	82.87	4610125.0
2011-05-18 13:00:00	IWM	ETF	82.87	83.2	82.87	83.13	4252293.0
2011-05-18 14:00:00	IWM	ETF	83.14	83.3	82.97	83.04	6001152.0
2011-05-18 15:00:00	IWM	ETF	83.03	83.325	83.01	83.29	9732259.0
2011-05-18 16:00:00	IWM	ETF	83.29	83.5	82.194	83.45	5673820.0
2011-05-18 17:00:00	IWM	ETF	83.45	83.47	83.42	83.42	24930.0
2011-05-18 18:00:00	IWM	ETF	83.47	83.49	82.04	83.49	8496.0
2011-05-18 19:00:00	IWM	ETF	83.42	83.45	83.42	83.45	1200.0
2011-05-18 07:00:00	DIA	ETF	125.0	125.0	124.78	124.8	500.0
2011-05-18 08:00:00	DIA	ETF	124.92	124.92	124.74	124.88	7750.0
2011-05-18 09:00:00	DIA	ETF	124.9	124.93	124.56	124.7	699951.0
2011-05-18 10:00:00	DIA	ETF	124.73	125.2	124.69	125.1	593471.0
2011-05-18 11:00:00	DIA	ETF	125.1	125.26	125.07	125.18	649876.0
2011-05-18 12:00:00	DIA	ETF	125.2	125.33	125.08	125.27	283064.0

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

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