PREVIEW / etf_30min / 2011-04-28

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-04-28.parquet
  size:    283 KB
  rows:    9,512

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-28 04:00:00	SPY	ETF	135.75	135.75	135.75	135.75	475.0
2011-04-28 04:30:00	SPY	ETF	135.64	135.64	135.64	135.64	100.0
2011-04-28 05:00:00	SPY	ETF	135.65	135.65	135.65	135.65	100.0
2011-04-28 05:30:00	SPY	ETF	135.61	135.61	135.59	135.59	200.0
2011-04-28 06:00:00	SPY	ETF	135.58	135.59	135.58	135.59	10000.0
2011-04-28 06:30:00	SPY	ETF	135.55	135.56	135.46	135.47	8800.0
2011-04-28 07:00:00	SPY	ETF	135.53	135.54	135.42	135.5	149740.0
2011-04-28 07:30:00	SPY	ETF	135.51	135.51	135.39	135.39	45090.0
2011-04-28 08:00:00	SPY	ETF	135.43	135.46	135.34	135.42	608176.0
2011-04-28 08:30:00	SPY	ETF	135.41	135.67	135.13	135.34	2019662.0
2011-04-28 09:00:00	SPY	ETF	135.33	135.45	135.25	135.43	816933.0
2011-04-28 09:30:00	SPY	ETF	135.43	135.78	135.41	135.77	10852525.0
2011-04-28 10:00:00	SPY	ETF	135.77	135.85	135.62	135.7	7776105.0
2011-04-28 10:30:00	SPY	ETF	135.7	135.82	135.6	135.79	6151028.0
2011-04-28 11:00:00	SPY	ETF	135.79	135.97	135.7899	135.88	7094050.0
2011-04-28 11:30:00	SPY	ETF	135.875	135.93	135.57	135.675	8576996.0
2011-04-28 12:00:00	SPY	ETF	135.675	135.88	135.6	135.86	8631147.0
2011-04-28 12:30:00	SPY	ETF	135.8567	135.92	135.77	135.79	6425535.0
2011-04-28 13:00:00	SPY	ETF	135.795	135.89	135.55	135.72	11317123.0
2011-04-28 13:30:00	SPY	ETF	135.72	135.83	135.61	135.79	4522528.0
2011-04-28 14:00:00	SPY	ETF	135.79	135.88	135.73	135.79	3656531.0
2011-04-28 14:30:00	SPY	ETF	135.79	135.97	135.78	135.91	5031676.0
2011-04-28 15:00:00	SPY	ETF	135.91	136.02	135.84	136.0	7631530.0
2011-04-28 15:30:00	SPY	ETF	135.99	136.29	135.99	136.11	20279926.0
2011-04-28 16:00:00	SPY	ETF	136.12	136.1587	135.9	135.96	6807746.0
2011-04-28 16:30:00	SPY	ETF	135.96	135.98	135.6676	135.97	1680857.0
2011-04-28 17:00:00	SPY	ETF	135.97	135.99	135.9	135.94	2847986.0
2011-04-28 17:30:00	SPY	ETF	135.94	135.98	135.9	135.94	79601.0
2011-04-28 18:00:00	SPY	ETF	135.91	136.04	135.91	135.96	56252.0
2011-04-28 18:30:00	SPY	ETF	135.97	136.04	135.95	136.04	20907.0
2011-04-28 19:00:00	SPY	ETF	136.03	136.05	135.98	136.04	35757.0
2011-04-28 19:30:00	SPY	ETF	136.04	136.04	135.98	136.03	16092.0
2011-04-28 06:30:00	QQQ	ETF	59.12	59.12	59.12	59.12	100.0
2011-04-28 07:00:00	QQQ	ETF	59.13	59.13	59.08	59.09	17718.0
2011-04-28 07:30:00	QQQ	ETF	59.12	59.12	59.09	59.09	23453.0
2011-04-28 08:00:00	QQQ	ETF	59.09	59.13	59.08	59.12	57685.0
2011-04-28 08:30:00	QQQ	ETF	59.11	59.12	58.98	59.07	705763.0
2011-04-28 09:00:00	QQQ	ETF	59.07	59.09	59.03	59.06	371982.0
2011-04-28 09:30:00	QQQ	ETF	59.06	59.17	58.99	59.15	6408542.0
2011-04-28 10:00:00	QQQ	ETF	59.15	59.17	59.03	59.048	1536927.0
2011-04-28 10:30:00	QQQ	ETF	59.04	59.12	58.95	59.11	1895250.0
2011-04-28 11:00:00	QQQ	ETF	59.1064	59.19	59.1	59.1138	1956318.0
2011-04-28 11:30:00	QQQ	ETF	59.11	59.13	58.92	58.959	1990398.0
2011-04-28 12:00:00	QQQ	ETF	58.96	59.08	58.92	59.06	2319837.0
2011-04-28 12:30:00	QQQ	ETF	59.07	59.09	58.96	58.99	1655030.0
2011-04-28 13:00:00	QQQ	ETF	58.99	59.04	58.88	58.98	2928271.0
2011-04-28 13:30:00	QQQ	ETF	58.98	59.05	58.94	59.03	1419894.0
2011-04-28 14:00:00	QQQ	ETF	59.02	59.04	58.97	58.98	1063515.0
2011-04-28 14:30:00	QQQ	ETF	58.98	59.1265	58.975	59.08	2554080.0
2011-04-28 15:00:00	QQQ	ETF	59.08	59.15	59.04	59.11	2361844.0

> showing 50 of 9,512 rows — these rows as CSV

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