PREVIEW / etf_1hour / 2011-12-21

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-12-21.parquet
  size:    183 KB
  rows:    5,690

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-12-21 04:00:00	SPY	ETF	124.49	124.7	124.49	124.64	47185.0
2011-12-21 05:00:00	SPY	ETF	124.64	125.2	124.57	124.57	82234.0
2011-12-21 06:00:00	SPY	ETF	124.55	124.85	124.16	124.34	104880.0
2011-12-21 07:00:00	SPY	ETF	124.32	124.44	123.71	123.9	1694570.0
2011-12-21 08:00:00	SPY	ETF	123.87	124.8	123.32	123.89	6815084.0
2011-12-21 09:00:00	SPY	ETF	123.89	124.05	123.13	123.26	23284151.0
2011-12-21 10:00:00	SPY	ETF	123.26	123.76	123.06	123.29	32940342.0
2011-12-21 11:00:00	SPY	ETF	123.3	123.33	122.97	123.2	18094195.0
2011-12-21 12:00:00	SPY	ETF	123.2	123.38	122.75	123.33	22118542.0
2011-12-21 13:00:00	SPY	ETF	123.33	123.62	123.15	123.58	13750682.0
2011-12-21 14:00:00	SPY	ETF	123.59	123.9612	123.41	123.72	21661927.0
2011-12-21 15:00:00	SPY	ETF	123.73	124.36	123.62	124.2	40919499.0
2011-12-21 16:00:00	SPY	ETF	124.205	124.39	123.2083	123.97	9257993.0
2011-12-21 17:00:00	SPY	ETF	123.98	124.15	123.94	124.11	2108758.0
2011-12-21 18:00:00	SPY	ETF	124.12	124.17	123.96	124.07	266230.0
2011-12-21 19:00:00	SPY	ETF	124.06	124.13	124.01	124.11	79500.0
2011-12-21 04:00:00	QQQ	ETF	56.02	56.18	56.0	56.0	4585.0
2011-12-21 05:00:00	QQQ	ETF	56.15	56.15	55.9	55.9	4998.0
2011-12-21 06:00:00	QQQ	ETF	55.97	56.07	55.76	55.78	26200.0
2011-12-21 07:00:00	QQQ	ETF	55.84	55.87	55.6	55.68	582974.0
2011-12-21 08:00:00	QQQ	ETF	55.68	56.15	55.45	55.64	4327107.0
2011-12-21 09:00:00	QQQ	ETF	55.64	55.71	54.98	55.065	11517922.0
2011-12-21 10:00:00	QQQ	ETF	55.06	55.18	54.83	54.9	11689844.0
2011-12-21 11:00:00	QQQ	ETF	54.9	54.91	54.68	54.75	5625056.0
2011-12-21 12:00:00	QQQ	ETF	54.745	54.8	54.4875	54.6801	8111453.0
2011-12-21 13:00:00	QQQ	ETF	54.69	54.79	54.56	54.76	3553099.0
2011-12-21 14:00:00	QQQ	ETF	54.76	54.92	54.69	54.87	7331882.0
2011-12-21 15:00:00	QQQ	ETF	54.8601	55.21	54.8	55.14	12332506.0
2011-12-21 16:00:00	QQQ	ETF	55.14	55.18	54.97	55.04	1029428.0
2011-12-21 17:00:00	QQQ	ETF	55.03	55.12	55.01	55.12	22782.0
2011-12-21 18:00:00	QQQ	ETF	55.11	55.12	55.09	55.09	16377.0
2011-12-21 19:00:00	QQQ	ETF	55.09	55.09	55.06	55.08	18785.0
2011-12-21 04:00:00	IWM	ETF	74.45	74.6	74.45	74.6	1055.0
2011-12-21 05:00:00	IWM	ETF	74.35	74.7	74.35	74.5	52799.0
2011-12-21 06:00:00	IWM	ETF	74.35	74.4	74.16	74.3	10910.0
2011-12-21 07:00:00	IWM	ETF	74.32	74.4	73.68	73.76	761510.0
2011-12-21 08:00:00	IWM	ETF	73.74	74.05	73.19	73.61	3058136.0
2011-12-21 09:00:00	IWM	ETF	73.64	73.76	73.11	73.2999	7086184.0
2011-12-21 10:00:00	IWM	ETF	73.27	73.71	73.01	73.18	9459233.0
2011-12-21 11:00:00	IWM	ETF	73.18	73.3	72.9572	73.26	4176943.0
2011-12-21 12:00:00	IWM	ETF	73.27	73.33	72.73	73.23	4795055.0
2011-12-21 13:00:00	IWM	ETF	73.24	73.58	73.14	73.56	3176405.0
2011-12-21 14:00:00	IWM	ETF	73.56	73.8	73.4611	73.66	5654718.0
2011-12-21 15:00:00	IWM	ETF	73.671	74.39	73.59	74.15	10711419.0
2011-12-21 16:00:00	IWM	ETF	74.14	74.31	73.4685	74.2	2688474.0
2011-12-21 17:00:00	IWM	ETF	74.21	74.3	74.17	74.23	39300.0
2011-12-21 18:00:00	IWM	ETF	74.21	74.27	74.21	74.22	6500.0
2011-12-21 19:00:00	IWM	ETF	74.25	74.28	74.25	74.27	9732.0
2011-12-21 05:00:00	DIA	ETF	122.02	122.02	122.02	122.02	200.0
2011-12-21 06:00:00	DIA	ETF	121.0	121.0	121.0	121.0	100.0

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

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