PREVIEW / etf_1hour / 2015-04-06

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-04-06.parquet
  size:    243 KB
  rows:    7,723

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-06 04:00:00	SPY	ETF	205.5	205.5	204.71	205.03	7575.0
2015-04-06 05:00:00	SPY	ETF	205.08	205.08	204.95	204.95	966.0
2015-04-06 06:00:00	SPY	ETF	204.95	205.1	204.92	205.04	37750.0
2015-04-06 07:00:00	SPY	ETF	205.09	205.21	204.86	204.88	340473.0
2015-04-06 08:00:00	SPY	ETF	204.92	205.2	204.76	205.08	466133.0
2015-04-06 09:00:00	SPY	ETF	205.08	206.71	205.06	206.51	15953283.0
2015-04-06 10:00:00	SPY	ETF	206.51	207.73	206.49	207.59	16930065.0
2015-04-06 11:00:00	SPY	ETF	207.6	208.03	207.57	207.925	10828999.0
2015-04-06 12:00:00	SPY	ETF	207.925	208.27	207.905	208.23	11830202.0
2015-04-06 13:00:00	SPY	ETF	208.23	208.45	208.22	208.3	10007002.0
2015-04-06 14:00:00	SPY	ETF	208.295	208.42	208.12	208.32	11081897.0
2015-04-06 15:00:00	SPY	ETF	208.33	208.4	207.75	207.84	18737977.0
2015-04-06 16:00:00	SPY	ETF	207.83	207.9024	207.28	207.72	16770811.0
2015-04-06 17:00:00	SPY	ETF	207.71	207.71	207.62	207.65	622112.0
2015-04-06 18:00:00	SPY	ETF	207.65	207.72	207.59	207.62	141803.0
2015-04-06 19:00:00	SPY	ETF	207.62	207.66	207.58	207.63	238527.0
2015-04-06 04:00:00	QQQ	ETF	104.36	104.36	104.12	104.3	1675.0
2015-04-06 05:00:00	QQQ	ETF	104.3	104.3	104.3	104.3	200.0
2015-04-06 06:00:00	QQQ	ETF	104.33	104.33	104.33	104.33	3400.0
2015-04-06 07:00:00	QQQ	ETF	104.37	104.42	104.28	104.34	30125.0
2015-04-06 08:00:00	QQQ	ETF	104.38	104.48	104.34	104.44	171797.0
2015-04-06 09:00:00	QQQ	ETF	104.44	105.41	104.34	105.17	5126931.0
2015-04-06 10:00:00	QQQ	ETF	105.18	105.861	105.14	105.76	3979323.0
2015-04-06 11:00:00	QQQ	ETF	105.76	105.94	105.72	105.9051	2087492.0
2015-04-06 12:00:00	QQQ	ETF	105.9	106.09	105.89	106.061	2074615.0
2015-04-06 13:00:00	QQQ	ETF	106.08	106.27	106.08	106.1801	1587601.0
2015-04-06 14:00:00	QQQ	ETF	106.18	106.21	106.04	106.15	1455898.0
2015-04-06 15:00:00	QQQ	ETF	106.1499	106.2	105.95	105.97	3658093.0
2015-04-06 16:00:00	QQQ	ETF	105.97	106.0	105.9	105.93	322546.0
2015-04-06 17:00:00	QQQ	ETF	105.9	105.98	105.875	105.89	19580.0
2015-04-06 18:00:00	QQQ	ETF	105.88	105.92	105.88	105.9	11200.0
2015-04-06 19:00:00	QQQ	ETF	105.91	105.93	105.88	105.92	3900.0
2015-04-06 04:00:00	IWM	ETF	123.7	123.7	123.44	123.44	350.0
2015-04-06 06:00:00	IWM	ETF	123.45	123.45	123.45	123.45	1250.0
2015-04-06 07:00:00	IWM	ETF	123.55	123.62	123.47	123.47	42550.0
2015-04-06 08:00:00	IWM	ETF	123.53	123.67	123.53	123.64	70954.0
2015-04-06 09:00:00	IWM	ETF	123.64	125.19	123.64	125.0001	3403342.0
2015-04-06 10:00:00	IWM	ETF	125.02	125.32	124.76	125.11	2849665.0
2015-04-06 11:00:00	IWM	ETF	125.12	125.3	125.06	125.19	1662919.0
2015-04-06 12:00:00	IWM	ETF	125.19	125.38	125.15	125.31	1393451.0
2015-04-06 13:00:00	IWM	ETF	125.32	125.48	125.23	125.37	1267574.0
2015-04-06 14:00:00	IWM	ETF	125.375	125.4	125.16	125.17	1133092.0
2015-04-06 15:00:00	IWM	ETF	125.16	125.26	124.98	125.2	3861714.0
2015-04-06 16:00:00	IWM	ETF	125.19	125.23	124.6788	125.07	1612554.0
2015-04-06 17:00:00	IWM	ETF	125.05	125.05	125.04	125.04	1692.0
2015-04-06 18:00:00	IWM	ETF	125.12	125.12	125.12	125.12	100.0
2015-04-06 07:00:00	DIA	ETF	176.2	176.2	176.05	176.05	1600.0
2015-04-06 08:00:00	DIA	ETF	176.09	176.19	176.06	176.19	29105.0
2015-04-06 09:00:00	DIA	ETF	176.22	177.51	176.085	177.38	1213085.0
2015-04-06 10:00:00	DIA	ETF	177.39	178.42	177.39	178.29	1525543.0

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

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