PREVIEW / etf_1hour / 2011-11-15

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-11-15.parquet
  size:    180 KB
  rows:    5,524

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-11-15 04:00:00	SPY	ETF	125.48	125.48	124.76	125.02	11648.0
2011-11-15 05:00:00	SPY	ETF	125.05	125.22	124.64	124.65	47400.0
2011-11-15 06:00:00	SPY	ETF	124.67	124.7	123.97	124.32	594920.0
2011-11-15 07:00:00	SPY	ETF	124.2	124.69	124.15	124.36	764112.0
2011-11-15 08:00:00	SPY	ETF	124.65	125.15	124.16	124.86	5517821.0
2011-11-15 09:00:00	SPY	ETF	124.85	125.87	124.83	125.62	23697464.0
2011-11-15 10:00:00	SPY	ETF	125.63	125.7	125.09	125.16	27298202.0
2011-11-15 11:00:00	SPY	ETF	125.16	125.42	124.72	125.1	21229910.0
2011-11-15 12:00:00	SPY	ETF	125.11	126.1	125.1	126.08	21570894.0
2011-11-15 13:00:00	SPY	ETF	126.075	126.5	125.96	126.34	19165632.0
2011-11-15 14:00:00	SPY	ETF	126.33	126.55	126.14	126.41	14928133.0
2011-11-15 15:00:00	SPY	ETF	126.4	126.75	126.05	126.12	33697478.0
2011-11-15 16:00:00	SPY	ETF	126.11	126.35	125.3222	126.03	14496057.0
2011-11-15 17:00:00	SPY	ETF	126.03	126.03	125.97	126.02	64902.0
2011-11-15 18:00:00	SPY	ETF	126.01	126.12	125.81	125.83	290250.0
2011-11-15 19:00:00	SPY	ETF	125.83	125.9	125.69	125.76	248380.0
2011-11-15 04:00:00	QQQ	ETF	57.28	57.28	57.22	57.22	800.0
2011-11-15 05:00:00	QQQ	ETF	57.27	57.36	57.08	57.08	19900.0
2011-11-15 06:00:00	QQQ	ETF	57.01	57.01	56.8	56.91	48164.0
2011-11-15 07:00:00	QQQ	ETF	56.91	57.12	56.91	57.03	79246.0
2011-11-15 08:00:00	QQQ	ETF	57.03	57.38	57.03	57.28	295851.0
2011-11-15 09:00:00	QQQ	ETF	57.29	57.75	57.26	57.66	6984724.0
2011-11-15 10:00:00	QQQ	ETF	57.67	57.7	57.33	57.43	7370059.0
2011-11-15 11:00:00	QQQ	ETF	57.43	57.61	57.29	57.52	5644686.0
2011-11-15 12:00:00	QQQ	ETF	57.53	58.07	57.53	58.0381	6294817.0
2011-11-15 13:00:00	QQQ	ETF	58.04	58.22	57.94	58.12	4516205.0
2011-11-15 14:00:00	QQQ	ETF	58.11	58.28	58.09	58.2215	3669669.0
2011-11-15 15:00:00	QQQ	ETF	58.22	58.36	58.1	58.12	9067419.0
2011-11-15 16:00:00	QQQ	ETF	58.12	58.14	58.01	58.09	1443072.0
2011-11-15 17:00:00	QQQ	ETF	58.09	58.13	58.07	58.13	88570.0
2011-11-15 18:00:00	QQQ	ETF	58.11	58.12	58.02	58.03	40765.0
2011-11-15 19:00:00	QQQ	ETF	58.03	58.06	57.98	58.05	24413.0
2011-11-15 04:00:00	IWM	ETF	73.18	73.18	72.71	72.71	10922.0
2011-11-15 06:00:00	IWM	ETF	72.5	72.5	72.16	72.35	6550.0
2011-11-15 07:00:00	IWM	ETF	72.32	72.56	72.32	72.38	38460.0
2011-11-15 08:00:00	IWM	ETF	72.39	73.0	72.29	72.83	903623.0
2011-11-15 09:00:00	IWM	ETF	72.83	73.54	72.75	73.31	5736529.0
2011-11-15 10:00:00	IWM	ETF	73.32	73.39	72.69	72.7	7848177.0
2011-11-15 11:00:00	IWM	ETF	72.71	72.92	72.43	72.77	6041843.0
2011-11-15 12:00:00	IWM	ETF	72.77	73.89	72.76	73.83	10148812.0
2011-11-15 13:00:00	IWM	ETF	73.83	74.34	73.76	74.228	7004379.0
2011-11-15 14:00:00	IWM	ETF	74.22	74.37	74.051	74.27	4594769.0
2011-11-15 15:00:00	IWM	ETF	74.28	74.64	74.2	74.23	11031673.0
2011-11-15 16:00:00	IWM	ETF	74.22	74.27	73.7	74.09	2488178.0
2011-11-15 17:00:00	IWM	ETF	74.1	74.15	74.07	74.15	42100.0
2011-11-15 18:00:00	IWM	ETF	74.05	74.06	74.04	74.04	2000.0
2011-11-15 19:00:00	IWM	ETF	74.05	74.05	73.99	74.01	8100.0
2011-11-15 06:00:00	DIA	ETF	120.0	120.0	119.75	119.75	600.0
2011-11-15 07:00:00	DIA	ETF	119.2	119.95	119.2	119.95	325.0
2011-11-15 08:00:00	DIA	ETF	119.76	120.38	119.76	120.06	28421.0

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

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