PREVIEW / etf_1hour / 2011-03-18

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-03-18.parquet
  size:    179 KB
  rows:    5,489

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-03-18 04:00:00	SPY	ETF	128.35	128.35	128.1	128.21	10800.0
2011-03-18 05:00:00	SPY	ETF	128.06	128.12	127.88	127.99	21326.0
2011-03-18 06:00:00	SPY	ETF	128.2	128.2	127.79	128.15	147350.0
2011-03-18 07:00:00	SPY	ETF	128.15	128.44	128.05	128.22	526337.0
2011-03-18 08:00:00	SPY	ETF	128.22	129.13	127.88	128.8	12269918.0
2011-03-18 09:00:00	SPY	ETF	128.8	129.11	127.85	128.62	33761456.0
2011-03-18 10:00:00	SPY	ETF	128.625	128.68	128.08	128.47	29614628.0
2011-03-18 11:00:00	SPY	ETF	128.47	128.72	127.91	128.17	34018842.0
2011-03-18 12:00:00	SPY	ETF	128.17	128.42	128.08	128.09	12199197.0
2011-03-18 13:00:00	SPY	ETF	128.09	128.37	128.09	128.17	9658317.0
2011-03-18 14:00:00	SPY	ETF	128.1681	128.25	127.56	127.65	24698204.0
2011-03-18 15:00:00	SPY	ETF	127.65	127.86	127.51	127.79	41063732.0
2011-03-18 16:00:00	SPY	ETF	127.8	128.64	127.2849	127.65	23448500.0
2011-03-18 17:00:00	SPY	ETF	127.66	127.98	127.6	127.67	3262882.0
2011-03-18 18:00:00	SPY	ETF	127.73	127.79	127.58	127.63	156821.0
2011-03-18 19:00:00	SPY	ETF	127.64	127.76	127.57	127.63	822728.0
2011-03-18 04:00:00	QQQ	ETF	54.93	55.06	54.93	54.97	4565.0
2011-03-18 05:00:00	QQQ	ETF	55.0	55.05	54.95	54.95	38604.0
2011-03-18 06:00:00	QQQ	ETF	54.97	55.0	54.97	55.0	20106.0
2011-03-18 07:00:00	QQQ	ETF	55.0	55.12	55.0	55.05	92099.0
2011-03-18 08:00:00	QQQ	ETF	55.04	55.26	54.99	55.13	2264373.0
2011-03-18 09:00:00	QQQ	ETF	55.13	55.35	54.66	54.95	10877502.0
2011-03-18 10:00:00	QQQ	ETF	54.95	54.97	54.57	54.77	21722672.0
2011-03-18 11:00:00	QQQ	ETF	54.7784	54.85	54.43	54.4925	11112886.0
2011-03-18 12:00:00	QQQ	ETF	54.49	54.725	54.49	54.63	9701433.0
2011-03-18 13:00:00	QQQ	ETF	54.64	54.87	54.63	54.79	5332644.0
2011-03-18 14:00:00	QQQ	ETF	54.79	54.8	54.5	54.54	9299473.0
2011-03-18 15:00:00	QQQ	ETF	54.53	54.58	54.41	54.46	12911546.0
2011-03-18 16:00:00	QQQ	ETF	54.46	54.61	54.45	54.49	4823539.0
2011-03-18 17:00:00	QQQ	ETF	54.51	54.5985	54.42	54.46	1057729.0
2011-03-18 18:00:00	QQQ	ETF	54.46	54.52	54.46	54.52	17075.0
2011-03-18 19:00:00	QQQ	ETF	54.5	54.53	54.45	54.45	10800.0
2011-03-18 04:00:00	IWM	ETF	78.6	78.7	78.6	78.7	15699.0
2011-03-18 05:00:00	IWM	ETF	78.81	78.84	78.77	78.8	17947.0
2011-03-18 06:00:00	IWM	ETF	78.8	78.93	78.66	78.93	42071.0
2011-03-18 07:00:00	IWM	ETF	78.93	79.17	78.93	79.03	104635.0
2011-03-18 08:00:00	IWM	ETF	79.02	79.4	78.92	79.22	2436883.0
2011-03-18 09:00:00	IWM	ETF	79.22	79.51	79.18	79.36	11179690.0
2011-03-18 10:00:00	IWM	ETF	79.36	79.47	79.07	79.44	11301135.0
2011-03-18 11:00:00	IWM	ETF	79.45	79.52	79.1199	79.27	6184563.0
2011-03-18 12:00:00	IWM	ETF	79.2701	79.43	79.23	79.33	3710951.0
2011-03-18 13:00:00	IWM	ETF	79.33	79.59	79.33	79.48	4308202.0
2011-03-18 14:00:00	IWM	ETF	79.48	79.53	79.19	79.3	6314060.0
2011-03-18 15:00:00	IWM	ETF	79.3	79.49	79.14	79.45	14258453.0
2011-03-18 16:00:00	IWM	ETF	79.44	79.58	79.3323	79.51	3731023.0
2011-03-18 17:00:00	IWM	ETF	79.51	79.57	79.4659	79.55	83448.0
2011-03-18 18:00:00	IWM	ETF	79.55	79.57	79.49	79.49	40217.0
2011-03-18 19:00:00	IWM	ETF	79.51	79.55	79.51	79.53	4030.0
2011-03-18 07:00:00	DIA	ETF	118.37	118.42	118.28	118.32	16300.0
2011-03-18 08:00:00	DIA	ETF	118.3	118.91	118.22	118.74	57600.0

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

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