PREVIEW / etf_1hour / 2015-04-10

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-04-10.parquet
  size:    240 KB
  rows:    7,631

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
2015-04-10 04:00:00	SPY	ETF	208.98	208.98	208.86	208.9	51653.0
2015-04-10 05:00:00	SPY	ETF	208.86	209.06	208.86	209.06	4326.0
2015-04-10 06:00:00	SPY	ETF	209.1	209.44	209.07	209.25	54442.0
2015-04-10 07:00:00	SPY	ETF	209.24	209.53	209.22	209.44	154078.0
2015-04-10 08:00:00	SPY	ETF	209.41	209.49	208.89	209.24	377264.0
2015-04-10 09:00:00	SPY	ETF	209.25	209.36	208.96	209.23	8857178.0
2015-04-10 10:00:00	SPY	ETF	209.22	209.82	209.2	209.67	11492168.0
2015-04-10 11:00:00	SPY	ETF	209.66	209.98	209.62	209.75	8615103.0
2015-04-10 12:00:00	SPY	ETF	209.76	209.93	209.72	209.84	6254821.0
2015-04-10 13:00:00	SPY	ETF	209.84	209.95	209.66	209.893	4012118.0
2015-04-10 14:00:00	SPY	ETF	209.895	210.09	209.74	209.96	6561790.0
2015-04-10 15:00:00	SPY	ETF	209.96	210.06	209.74	210.04	14977180.0
2015-04-10 16:00:00	SPY	ETF	210.05	210.09	209.9778	210.07	8005321.0
2015-04-10 17:00:00	SPY	ETF	210.06	210.13	209.09	210.13	2613475.0
2015-04-10 18:00:00	SPY	ETF	210.11	210.11	210.07	210.11	85739.0
2015-04-10 19:00:00	SPY	ETF	210.1	210.19	210.09	210.15	124159.0
2015-04-10 04:00:00	QQQ	ETF	107.27	107.27	107.27	107.27	220.0
2015-04-10 06:00:00	QQQ	ETF	107.3	107.48	107.29	107.35	9207.0
2015-04-10 07:00:00	QQQ	ETF	107.37	107.45	107.35	107.38	56219.0
2015-04-10 08:00:00	QQQ	ETF	107.38	107.4	107.32	107.33	114477.0
2015-04-10 09:00:00	QQQ	ETF	107.33	107.4	107.03	107.26	2891832.0
2015-04-10 10:00:00	QQQ	ETF	107.27	107.531	107.25	107.49	2815467.0
2015-04-10 11:00:00	QQQ	ETF	107.49	107.61	107.45	107.52	1449848.0
2015-04-10 12:00:00	QQQ	ETF	107.53	107.65	107.48	107.59	1322370.0
2015-04-10 13:00:00	QQQ	ETF	107.6	107.69	107.51	107.68	976212.0
2015-04-10 14:00:00	QQQ	ETF	107.671	107.76	107.61	107.707	2177939.0
2015-04-10 15:00:00	QQQ	ETF	107.71	107.751	107.59	107.74	3069693.0
2015-04-10 16:00:00	QQQ	ETF	107.74	107.75	107.64	107.73	888726.0
2015-04-10 17:00:00	QQQ	ETF	107.73	107.75	107.7	107.75	6387.0
2015-04-10 18:00:00	QQQ	ETF	107.76	107.76	107.7	107.71	1900.0
2015-04-10 19:00:00	QQQ	ETF	107.74	107.75	107.73	107.74	3868.0
2015-04-10 07:00:00	IWM	ETF	125.54	125.77	125.54	125.65	59980.0
2015-04-10 08:00:00	IWM	ETF	125.65	125.67	125.52	125.52	51443.0
2015-04-10 09:00:00	IWM	ETF	125.56	125.6	125.22	125.42	1805733.0
2015-04-10 10:00:00	IWM	ETF	125.42	125.65	125.28	125.62	2255181.0
2015-04-10 11:00:00	IWM	ETF	125.61	125.79	125.57	125.68	1304892.0
2015-04-10 12:00:00	IWM	ETF	125.69	125.76	125.54	125.58	746943.0
2015-04-10 13:00:00	IWM	ETF	125.5823	125.635	125.46	125.57	867049.0
2015-04-10 14:00:00	IWM	ETF	125.57	125.66	125.48	125.515	875616.0
2015-04-10 15:00:00	IWM	ETF	125.51	125.65	125.42	125.61	3275200.0
2015-04-10 16:00:00	IWM	ETF	125.61	125.72	125.4998	125.69	1332971.0
2015-04-10 19:00:00	IWM	ETF	125.6	125.6	125.6	125.6	1656.0
2015-04-10 07:00:00	DIA	ETF	179.74	179.95	179.74	179.95	1200.0
2015-04-10 08:00:00	DIA	ETF	179.77	179.94	179.77	179.89	1680.0
2015-04-10 09:00:00	DIA	ETF	179.65	179.79	179.18	179.51	516156.0
2015-04-10 10:00:00	DIA	ETF	179.52	180.1	179.51	179.97	763413.0
2015-04-10 11:00:00	DIA	ETF	179.97	180.33	179.93	180.08	395985.0
2015-04-10 12:00:00	DIA	ETF	180.09	180.2	180.0099	180.14	307798.0
2015-04-10 13:00:00	DIA	ETF	180.17	180.32	180.037	180.2549	321904.0
2015-04-10 14:00:00	DIA	ETF	180.25	180.44	180.11	180.3142	289729.0

> showing 50 of 7,631 rows — these rows as CSV

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