PREVIEW / etf_1hour / 2012-02-13

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-02-13.parquet
  size:    184 KB
  rows:    5,690

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
2012-02-13 04:00:00	SPY	ETF	135.27	135.58	135.27	135.38	106601.0
2012-02-13 05:00:00	SPY	ETF	135.35	135.46	135.22	135.34	8200.0
2012-02-13 06:00:00	SPY	ETF	135.48	135.48	135.32	135.34	45425.0
2012-02-13 07:00:00	SPY	ETF	135.35	135.55	135.31	135.5	375827.0
2012-02-13 08:00:00	SPY	ETF	135.52	135.55	135.25	135.33	1265981.0
2012-02-13 09:00:00	SPY	ETF	135.32	135.45	134.43	135.17	17456036.0
2012-02-13 10:00:00	SPY	ETF	135.17	135.27	134.74	135.0374	22207927.0
2012-02-13 11:00:00	SPY	ETF	135.04	135.21	134.98	135.14	14309153.0
2012-02-13 12:00:00	SPY	ETF	135.14	135.22	134.955	135.17	7137051.0
2012-02-13 13:00:00	SPY	ETF	135.18	135.41	135.17	135.32	10845354.0
2012-02-13 14:00:00	SPY	ETF	135.32	135.52	135.3	135.42	9557246.0
2012-02-13 15:00:00	SPY	ETF	135.42	135.46	135.22	135.33	22055790.0
2012-02-13 16:00:00	SPY	ETF	135.35	135.44	134.4272	135.36	8234923.0
2012-02-13 17:00:00	SPY	ETF	135.36	135.4	135.26	135.28	286030.0
2012-02-13 18:00:00	SPY	ETF	135.28	135.28	135.01	135.08	495677.0
2012-02-13 19:00:00	SPY	ETF	135.07	135.23	135.06	135.21	155145.0
2012-02-13 04:00:00	QQQ	ETF	62.95	62.95	62.95	62.95	500.0
2012-02-13 05:00:00	QQQ	ETF	62.9	62.95	62.9	62.95	200.0
2012-02-13 06:00:00	QQQ	ETF	62.98	62.98	62.94	62.94	16500.0
2012-02-13 07:00:00	QQQ	ETF	62.94	63.05	62.93	63.01	66960.0
2012-02-13 08:00:00	QQQ	ETF	63.03	63.05	62.9	62.95	349930.0
2012-02-13 09:00:00	QQQ	ETF	62.94	63.0	62.84	62.961	4748445.0
2012-02-13 10:00:00	QQQ	ETF	62.97	63.04	62.65	62.78	6737270.0
2012-02-13 11:00:00	QQQ	ETF	62.785	62.98	62.77	62.93	5783239.0
2012-02-13 12:00:00	QQQ	ETF	62.92	62.99	62.78	62.89	2727494.0
2012-02-13 13:00:00	QQQ	ETF	62.9	63.02	62.9	62.989	2017787.0
2012-02-13 14:00:00	QQQ	ETF	62.9805	63.13	62.97	63.068	2989878.0
2012-02-13 15:00:00	QQQ	ETF	63.0699	63.09	62.94	63.03	4780742.0
2012-02-13 16:00:00	QQQ	ETF	63.04	63.12	62.4973	63.09	3599353.0
2012-02-13 17:00:00	QQQ	ETF	63.07	63.07	63.03	63.03	58962.0
2012-02-13 18:00:00	QQQ	ETF	63.03	63.03	62.94	62.95	30310.0
2012-02-13 19:00:00	QQQ	ETF	62.99	63.03	62.98	63.03	43600.0
2012-02-13 04:00:00	IWM	ETF	81.99	82.2	81.75	82.2	3500.0
2012-02-13 05:00:00	IWM	ETF	82.15	82.2	82.04	82.14	2300.0
2012-02-13 06:00:00	IWM	ETF	82.15	82.2	82.14	82.16	14400.0
2012-02-13 07:00:00	IWM	ETF	82.12	82.29	82.12	82.27	37244.0
2012-02-13 08:00:00	IWM	ETF	82.25	82.31	82.06	82.12	402602.0
2012-02-13 09:00:00	IWM	ETF	82.09	82.38	81.27	82.17	5328518.0
2012-02-13 10:00:00	IWM	ETF	82.1699	82.29	81.61	81.91	5568346.0
2012-02-13 11:00:00	IWM	ETF	81.91	82.24	81.89	82.151	6088537.0
2012-02-13 12:00:00	IWM	ETF	82.15	82.2301	81.98	82.12	2247261.0
2012-02-13 13:00:00	IWM	ETF	82.12	82.29	82.12	82.21	2922746.0
2012-02-13 14:00:00	IWM	ETF	82.2154	82.429	82.2154	82.3099	5568849.0
2012-02-13 15:00:00	IWM	ETF	82.305	82.355	82.15	82.31	6117139.0
2012-02-13 16:00:00	IWM	ETF	82.32	82.35	82.2586	82.3408	1095754.0
2012-02-13 17:00:00	IWM	ETF	82.34	82.36	82.25	82.25	70572.0
2012-02-13 18:00:00	IWM	ETF	82.2	82.25	82.14	82.15	17259.0
2012-02-13 19:00:00	IWM	ETF	82.18	82.25	82.18	82.25	7100.0
2012-02-13 04:00:00	DIA	ETF	128.92	128.92	128.92	128.92	100.0
2012-02-13 07:00:00	DIA	ETF	128.68	128.8	128.62	128.8	8000.0

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

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