PREVIEW / etf_1hour / 2011-10-11

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-10-11.parquet
  size:    177 KB
  rows:    5,511

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-10-11 04:00:00	SPY	ETF	119.19	119.19	118.71	118.84	41430.0
2011-10-11 05:00:00	SPY	ETF	118.89	119.03	118.77	118.97	26249.0
2011-10-11 06:00:00	SPY	ETF	119.06	119.25	118.77	119.12	73063.0
2011-10-11 07:00:00	SPY	ETF	119.14	119.45	118.98	119.02	634868.0
2011-10-11 08:00:00	SPY	ETF	119.02	119.23	118.62	118.88	3922851.0
2011-10-11 09:00:00	SPY	ETF	118.88	119.41	118.65	119.19	27213338.0
2011-10-11 10:00:00	SPY	ETF	119.18	120.04	118.91	119.66	39676219.0
2011-10-11 11:00:00	SPY	ETF	119.67	119.89	119.2922	119.81	24005090.0
2011-10-11 12:00:00	SPY	ETF	119.81	119.96	119.23	119.52	16122900.0
2011-10-11 13:00:00	SPY	ETF	119.52	119.9	119.16	119.89	19658426.0
2011-10-11 14:00:00	SPY	ETF	119.89	119.92	119.23	119.51	19340691.0
2011-10-11 15:00:00	SPY	ETF	119.51	119.93	119.43	119.65	41151535.0
2011-10-11 16:00:00	SPY	ETF	119.64	119.8	119.1	119.15	13777086.0
2011-10-11 17:00:00	SPY	ETF	119.15	119.34	119.06	119.21	1693515.0
2011-10-11 18:00:00	SPY	ETF	119.21	119.68	119.11	119.16	191428.0
2011-10-11 19:00:00	SPY	ETF	119.14	119.24	119.05	119.1	122978.0
2011-10-11 04:00:00	QQQ	ETF	55.75	55.75	55.69	55.73	4406.0
2011-10-11 06:00:00	QQQ	ETF	55.87	55.89	55.66	55.66	18000.0
2011-10-11 07:00:00	QQQ	ETF	55.85	55.97	55.8	55.8	126655.0
2011-10-11 08:00:00	QQQ	ETF	55.84	55.94	55.68	55.79	441688.0
2011-10-11 09:00:00	QQQ	ETF	55.81	56.09	55.7	55.98	7592926.0
2011-10-11 10:00:00	QQQ	ETF	55.98	56.46	55.85	56.28	13196075.0
2011-10-11 11:00:00	QQQ	ETF	56.28	56.42	56.16	56.35	6821828.0
2011-10-11 12:00:00	QQQ	ETF	56.356	56.42	56.095	56.22	4147584.0
2011-10-11 13:00:00	QQQ	ETF	56.22	56.43	56.06	56.42	7575118.0
2011-10-11 14:00:00	QQQ	ETF	56.41	56.44	56.12	56.2902	7700030.0
2011-10-11 15:00:00	QQQ	ETF	56.3	56.46	56.155	56.29	11629095.0
2011-10-11 16:00:00	QQQ	ETF	56.3	56.36	56.07	56.14	2039162.0
2011-10-11 17:00:00	QQQ	ETF	56.13	56.2	56.08	56.17	190209.0
2011-10-11 18:00:00	QQQ	ETF	56.17	56.17	56.12	56.14	55141.0
2011-10-11 19:00:00	QQQ	ETF	56.13	56.17	56.1	56.11	49813.0
2011-10-11 04:00:00	IWM	ETF	68.21	68.21	68.2	68.2	1200.0
2011-10-11 05:00:00	IWM	ETF	68.02	68.02	68.02	68.02	5000.0
2011-10-11 07:00:00	IWM	ETF	68.39	68.4	68.1	68.11	213500.0
2011-10-11 08:00:00	IWM	ETF	68.12	68.25	67.83	68.02	1153389.0
2011-10-11 09:00:00	IWM	ETF	68.02	68.2	67.54	68.03	7835722.0
2011-10-11 10:00:00	IWM	ETF	68.02	68.9	67.87	68.58	12370476.0
2011-10-11 11:00:00	IWM	ETF	68.61	68.7	68.15	68.54	4943153.0
2011-10-11 12:00:00	IWM	ETF	68.54	68.71	68.06	68.32	3066456.0
2011-10-11 13:00:00	IWM	ETF	68.31	68.78	67.95	68.76	6599790.0
2011-10-11 14:00:00	IWM	ETF	68.77	68.79	68.2	68.46	4745834.0
2011-10-11 15:00:00	IWM	ETF	68.45	69.12	68.43	68.8	12589703.0
2011-10-11 16:00:00	IWM	ETF	68.81	68.88	68.37	68.37	2018871.0
2011-10-11 17:00:00	IWM	ETF	68.4	68.57	68.34	68.37	113462.0
2011-10-11 18:00:00	IWM	ETF	68.37	68.42	68.37	68.41	4000.0
2011-10-11 19:00:00	IWM	ETF	68.35	68.4	68.31	68.31	7000.0
2011-10-11 04:00:00	DIA	ETF	113.92	113.92	113.68	113.68	1400.0
2011-10-11 06:00:00	DIA	ETF	113.78	113.78	113.78	113.78	100.0
2011-10-11 07:00:00	DIA	ETF	113.9	114.05	113.86	113.86	2475.0
2011-10-11 08:00:00	DIA	ETF	113.86	113.95	113.48	113.66	15000.0

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

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