PREVIEW / etf_1hour / 2011-04-21

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-04-21.parquet
  size:    176 KB
  rows:    5,471

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-04-21 04:00:00	SPY	ETF	133.9	134.06	133.87	133.87	10500.0
2011-04-21 05:00:00	SPY	ETF	133.96	134.09	133.96	133.96	27620.0
2011-04-21 06:00:00	SPY	ETF	133.96	134.16	133.93	134.15	206700.0
2011-04-21 07:00:00	SPY	ETF	134.13	134.21	134.0	134.03	464126.0
2011-04-21 08:00:00	SPY	ETF	134.04	134.13	133.66	133.79	3514086.0
2011-04-21 09:00:00	SPY	ETF	133.79	133.91	133.5	133.6	20169572.0
2011-04-21 10:00:00	SPY	ETF	133.6	133.69	133.35	133.61	26378781.0
2011-04-21 11:00:00	SPY	ETF	133.6108	133.81	133.54	133.775	11996197.0
2011-04-21 12:00:00	SPY	ETF	133.775	133.84	133.7	133.77	8237093.0
2011-04-21 13:00:00	SPY	ETF	133.76	133.81	133.6	133.66	5365678.0
2011-04-21 14:00:00	SPY	ETF	133.6601	133.77	133.6	133.621	9981331.0
2011-04-21 15:00:00	SPY	ETF	133.62	133.8	133.57	133.75	20021892.0
2011-04-21 16:00:00	SPY	ETF	133.76	133.8082	133.1054	133.68	27098121.0
2011-04-21 17:00:00	SPY	ETF	133.68	133.94	133.65	133.8	455777.0
2011-04-21 18:00:00	SPY	ETF	133.81	133.81	133.74	133.81	58038.0
2011-04-21 19:00:00	SPY	ETF	133.83	133.83	133.72	133.83	19793.0
2011-04-21 04:00:00	QQQ	ETF	58.35	58.38	58.31	58.38	300.0
2011-04-21 05:00:00	QQQ	ETF	58.42	58.44	58.42	58.44	300.0
2011-04-21 06:00:00	QQQ	ETF	58.47	58.52	58.47	58.52	2126.0
2011-04-21 07:00:00	QQQ	ETF	58.53	58.56	58.47	58.5	183754.0
2011-04-21 08:00:00	QQQ	ETF	58.5	58.52	58.31	58.36	2125901.0
2011-04-21 09:00:00	QQQ	ETF	58.37	58.49	58.2	58.36	9666276.0
2011-04-21 10:00:00	QQQ	ETF	58.3598	58.38	58.16	58.33	8218680.0
2011-04-21 11:00:00	QQQ	ETF	58.33	58.44	58.27	58.43	3524745.0
2011-04-21 12:00:00	QQQ	ETF	58.43	58.44	58.35	58.3901	1970752.0
2011-04-21 13:00:00	QQQ	ETF	58.39	58.41	58.29	58.345	2309333.0
2011-04-21 14:00:00	QQQ	ETF	58.3499	58.42	58.31	58.33	1539061.0
2011-04-21 15:00:00	QQQ	ETF	58.3299	58.38	58.29	58.33	5844967.0
2011-04-21 16:00:00	QQQ	ETF	58.33	58.4267	58.328	58.38	2305835.0
2011-04-21 17:00:00	QQQ	ETF	58.38	58.42	58.36	58.36	53471.0
2011-04-21 18:00:00	QQQ	ETF	58.38	58.4	58.34	58.4	43831.0
2011-04-21 19:00:00	QQQ	ETF	58.35	58.38	58.34	58.36	10140.0
2011-04-21 04:00:00	IWM	ETF	84.34	84.42	84.34	84.42	1230.0
2011-04-21 05:00:00	IWM	ETF	84.4	84.4	84.4	84.4	700.0
2011-04-21 06:00:00	IWM	ETF	84.41	84.47	84.36	84.46	5800.0
2011-04-21 07:00:00	IWM	ETF	84.5	84.58	84.46	84.46	53430.0
2011-04-21 08:00:00	IWM	ETF	84.5	84.5	84.18	84.27	343880.0
2011-04-21 09:00:00	IWM	ETF	84.28	84.39	83.88	84.05	4376361.0
2011-04-21 10:00:00	IWM	ETF	84.05	84.12	83.73	84.07	6349001.0
2011-04-21 11:00:00	IWM	ETF	84.07	84.2	84.03	84.0999	2827054.0
2011-04-21 12:00:00	IWM	ETF	84.1	84.18	84.05	84.14	1243031.0
2011-04-21 13:00:00	IWM	ETF	84.14	84.19	84.05	84.135	2211757.0
2011-04-21 14:00:00	IWM	ETF	84.14	84.27	84.08	84.2	2035758.0
2011-04-21 15:00:00	IWM	ETF	84.1999	84.48	84.175	84.46	7710255.0
2011-04-21 16:00:00	IWM	ETF	84.45	84.47	84.13	84.25	772205.0
2011-04-21 17:00:00	IWM	ETF	84.24	84.37	84.24	84.3	13600.0
2011-04-21 18:00:00	IWM	ETF	84.29	84.31	84.27	84.29	7500.0
2011-04-21 19:00:00	IWM	ETF	84.38	84.38	84.26	84.34	4385.0
2011-04-21 04:00:00	DIA	ETF	124.86	124.86	124.69	124.69	2700.0
2011-04-21 05:00:00	DIA	ETF	124.73	124.86	124.73	124.83	1000.0

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

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