PREVIEW / etf_30min / 2012-02-09

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-02-09.parquet
  size:    290 KB
  rows:    9,767

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
2012-02-09 04:00:00	SPY	ETF	135.12	135.15	135.02	135.07	5789.0
2012-02-09 04:30:00	SPY	ETF	135.18	135.33	135.04	135.04	17451.0
2012-02-09 05:00:00	SPY	ETF	135.05	135.05	134.96	134.99	1000.0
2012-02-09 05:30:00	SPY	ETF	134.97	135.0	134.87	134.91	14755.0
2012-02-09 06:00:00	SPY	ETF	134.97	135.0	134.94	134.94	5350.0
2012-02-09 06:30:00	SPY	ETF	134.92	134.98	134.79	134.82	13800.0
2012-02-09 07:00:00	SPY	ETF	134.84	134.92	134.76	134.91	106605.0
2012-02-09 07:30:00	SPY	ETF	134.87	135.04	134.83	135.01	159137.0
2012-02-09 08:00:00	SPY	ETF	135.01	135.52	134.93	135.49	1757036.0
2012-02-09 08:30:00	SPY	ETF	135.51	135.71	135.08	135.3	3798841.0
2012-02-09 09:00:00	SPY	ETF	135.3	135.41	135.2	135.4	1689551.0
2012-02-09 09:30:00	SPY	ETF	135.41	135.49	135.07	135.3	20965439.0
2012-02-09 10:00:00	SPY	ETF	135.3	135.39	134.61	134.74	18401081.0
2012-02-09 10:30:00	SPY	ETF	134.7365	135.06	134.56	134.99	18132900.0
2012-02-09 11:00:00	SPY	ETF	134.99	135.13	134.93	134.97	8345360.0
2012-02-09 11:30:00	SPY	ETF	134.97	135.28	134.83	135.26	11102056.0
2012-02-09 12:00:00	SPY	ETF	135.27	135.38	135.24	135.25	5771851.0
2012-02-09 12:30:00	SPY	ETF	135.26	135.45	135.21	135.419	7224197.0
2012-02-09 13:00:00	SPY	ETF	135.41	135.59	135.3	135.52	9394136.0
2012-02-09 13:30:00	SPY	ETF	135.521	135.56	135.37	135.4603	5756127.0
2012-02-09 14:00:00	SPY	ETF	135.465	135.56	135.4	135.529	5395066.0
2012-02-09 14:30:00	SPY	ETF	135.52	135.56	135.41	135.4183	3891193.0
2012-02-09 15:00:00	SPY	ETF	135.41	135.53	135.3	135.42	5825556.0
2012-02-09 15:30:00	SPY	ETF	135.42	135.46	135.25	135.35	13189573.0
2012-02-09 16:00:00	SPY	ETF	135.35	135.42	135.1259	135.26	6811478.0
2012-02-09 16:30:00	SPY	ETF	135.26	135.26	135.1817	135.23	169053.0
2012-02-09 17:00:00	SPY	ETF	135.22	135.22	135.13	135.15	231182.0
2012-02-09 17:30:00	SPY	ETF	135.15	135.19	135.13	135.14	39670.0
2012-02-09 18:00:00	SPY	ETF	135.15	135.18	135.09	135.1	70212.0
2012-02-09 18:30:00	SPY	ETF	135.09	135.36	135.07	135.14	52656.0
2012-02-09 19:00:00	SPY	ETF	135.11	135.14	135.07	135.08	55340.0
2012-02-09 19:30:00	SPY	ETF	135.08	135.09	135.02	135.09	116709.0
2012-02-09 04:00:00	QQQ	ETF	62.45	62.45	62.45	62.45	100.0
2012-02-09 04:30:00	QQQ	ETF	62.51	62.51	62.51	62.51	500.0
2012-02-09 05:00:00	QQQ	ETF	62.4	62.4	62.4	62.4	300.0
2012-02-09 05:30:00	QQQ	ETF	62.37	62.37	62.37	62.37	5100.0
2012-02-09 06:00:00	QQQ	ETF	62.41	62.41	62.37	62.37	2100.0
2012-02-09 06:30:00	QQQ	ETF	62.4	62.4	62.35	62.36	1225.0
2012-02-09 07:00:00	QQQ	ETF	62.35	62.38	62.34	62.35	6450.0
2012-02-09 07:30:00	QQQ	ETF	62.35	62.45	62.35	62.41	49795.0
2012-02-09 08:00:00	QQQ	ETF	62.41	62.65	62.4	62.63	194068.0
2012-02-09 08:30:00	QQQ	ETF	62.63	62.67	62.48	62.56	537045.0
2012-02-09 09:00:00	QQQ	ETF	62.58	62.68	62.54	62.67	505442.0
2012-02-09 09:30:00	QQQ	ETF	62.68	62.74	62.45	62.6	6053067.0
2012-02-09 10:00:00	QQQ	ETF	62.6	62.67	62.36	62.395	6328451.0
2012-02-09 10:30:00	QQQ	ETF	62.39	62.64	62.32	62.62	4449164.0
2012-02-09 11:00:00	QQQ	ETF	62.62	62.73	62.6	62.66	2406192.0
2012-02-09 11:30:00	QQQ	ETF	62.66	62.81	62.59	62.79	3619874.0
2012-02-09 12:00:00	QQQ	ETF	62.79	62.9101	62.79	62.84	2391330.0
2012-02-09 12:30:00	QQQ	ETF	62.85	62.93	62.82	62.88	1440114.0

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

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