PREVIEW / etf_1hour / 2013-01-04

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-01-04.parquet
  size:    201 KB
  rows:    6,260

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-01-04 04:00:00	SPY	ETF	145.79	145.79	145.75	145.75	2700.0
2013-01-04 05:00:00	SPY	ETF	145.72	145.77	145.68	145.77	11832.0
2013-01-04 06:00:00	SPY	ETF	145.77	145.77	145.66	145.68	7350.0
2013-01-04 07:00:00	SPY	ETF	145.73	145.79	145.66	145.69	241736.0
2013-01-04 08:00:00	SPY	ETF	145.68	146.1	145.49	145.99	4791412.0
2013-01-04 09:00:00	SPY	ETF	146.0	146.16	145.67	146.13	12154759.0
2013-01-04 10:00:00	SPY	ETF	146.15	146.21	145.73	145.84	20694503.0
2013-01-04 11:00:00	SPY	ETF	145.84	146.26	145.84	146.09	11327497.0
2013-01-04 12:00:00	SPY	ETF	146.1	146.24	146.09	146.1	5934938.0
2013-01-04 13:00:00	SPY	ETF	146.1	146.29	146.07	146.2	6784751.0
2013-01-04 14:00:00	SPY	ETF	146.2	146.32	146.15	146.3199	10030302.0
2013-01-04 15:00:00	SPY	ETF	146.32	146.61	146.26	146.38	29166089.0
2013-01-04 16:00:00	SPY	ETF	146.39	146.45	145.7356	146.26	12712498.0
2013-01-04 17:00:00	SPY	ETF	146.25	146.35	146.24	146.34	71700.0
2013-01-04 18:00:00	SPY	ETF	146.35	146.37	146.2	146.27	49564.0
2013-01-04 19:00:00	SPY	ETF	146.25	146.34	146.23	146.33	14724.0
2013-01-04 04:00:00	QQQ	ETF	66.9	66.9	66.9	66.9	200.0
2013-01-04 06:00:00	QQQ	ETF	66.86	66.86	66.86	66.86	10500.0
2013-01-04 07:00:00	QQQ	ETF	66.92	66.98	66.91	66.93	44010.0
2013-01-04 08:00:00	QQQ	ETF	66.92	67.07	66.87	66.92	1374191.0
2013-01-04 09:00:00	QQQ	ETF	66.92	66.98	66.68	66.84	4432589.0
2013-01-04 10:00:00	QQQ	ETF	66.84	66.87	66.47	66.53	6904879.0
2013-01-04 11:00:00	QQQ	ETF	66.53	66.81	66.53	66.74	3704262.0
2013-01-04 12:00:00	QQQ	ETF	66.74	66.84	66.6737	66.69	2448858.0
2013-01-04 13:00:00	QQQ	ETF	66.696	66.76	66.65	66.68	1806613.0
2013-01-04 14:00:00	QQQ	ETF	66.68	66.78	66.66	66.78	2681064.0
2013-01-04 15:00:00	QQQ	ETF	66.78	66.87	66.63	66.64	6164050.0
2013-01-04 16:00:00	QQQ	ETF	66.64	66.8689	66.5	66.7976	2829126.0
2013-01-04 17:00:00	QQQ	ETF	66.57	66.57	66.55	66.55	2500.0
2013-01-04 19:00:00	QQQ	ETF	66.62	66.62	66.58	66.58	1031.0
2013-01-04 06:00:00	IWM	ETF	86.76	86.76	86.76	86.76	35000.0
2013-01-04 07:00:00	IWM	ETF	86.76	86.81	86.76	86.77	29018.0
2013-01-04 08:00:00	IWM	ETF	86.75	86.96	86.6	86.89	985805.0
2013-01-04 09:00:00	IWM	ETF	86.88	87.07	86.66	87.07	4000484.0
2013-01-04 10:00:00	IWM	ETF	87.07	87.23	86.86	87.07	5357331.0
2013-01-04 11:00:00	IWM	ETF	87.07	87.375	87.07	87.255	3325406.0
2013-01-04 12:00:00	IWM	ETF	87.26	87.34	87.12	87.13	2084656.0
2013-01-04 13:00:00	IWM	ETF	87.12	87.27	87.04	87.2201	1796323.0
2013-01-04 14:00:00	IWM	ETF	87.2299	87.32	87.18	87.32	1944514.0
2013-01-04 15:00:00	IWM	ETF	87.32	87.44	87.17	87.2	5991607.0
2013-01-04 16:00:00	IWM	ETF	87.19	87.24	86.92	87.0	1724288.0
2013-01-04 17:00:00	IWM	ETF	87.01	87.05	86.99	86.99	9150.0
2013-01-04 18:00:00	IWM	ETF	87.07	87.07	87.07	87.07	1000.0
2013-01-04 19:00:00	IWM	ETF	87.1	87.1	87.1	87.1	100.0
2013-01-04 08:00:00	DIA	ETF	133.52	133.84	133.52	133.75	25941.0
2013-01-04 09:00:00	DIA	ETF	133.75	133.86	133.49	133.85	532863.0
2013-01-04 10:00:00	DIA	ETF	133.86	133.94	133.49	133.59	723761.0
2013-01-04 11:00:00	DIA	ETF	133.59	133.9501	133.59	133.82	492300.0
2013-01-04 12:00:00	DIA	ETF	133.81	133.9	133.76	133.79	202413.0
2013-01-04 13:00:00	DIA	ETF	133.77	133.97	133.745	133.8899	272448.0

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

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