PREVIEW / etf_30min / 2010-07-09

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-07-09.parquet
  size:    241 KB
  rows:    7,981

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
2010-07-09 04:00:00	SPY	ETF	107.29	107.29	107.29	107.29	100.0
2010-07-09 04:30:00	SPY	ETF	107.17	107.2	107.14	107.14	2200.0
2010-07-09 05:00:00	SPY	ETF	107.02	107.15	107.02	107.15	200.0
2010-07-09 05:30:00	SPY	ETF	107.15	107.16	107.15	107.16	400.0
2010-07-09 06:00:00	SPY	ETF	107.15	107.22	107.15	107.15	700.0
2010-07-09 06:30:00	SPY	ETF	107.21	107.21	107.06	107.06	7100.0
2010-07-09 07:00:00	SPY	ETF	107.06	107.38	107.06	107.29	140479.0
2010-07-09 07:30:00	SPY	ETF	107.27	107.36	107.13	107.16	316649.0
2010-07-09 08:00:00	SPY	ETF	107.17	107.32	106.93	107.08	528220.0
2010-07-09 08:30:00	SPY	ETF	107.06	107.08	106.85	107.04	821160.0
2010-07-09 09:00:00	SPY	ETF	107.03	107.17	107.0	107.14	1136036.0
2010-07-09 09:30:00	SPY	ETF	107.13	107.35	106.93	107.1725	19719957.0
2010-07-09 10:00:00	SPY	ETF	107.17	107.58	107.145	107.42	15388506.0
2010-07-09 10:30:00	SPY	ETF	107.41	107.69	107.2685	107.33	11181041.0
2010-07-09 11:00:00	SPY	ETF	107.32	107.43	107.07	107.24	7458979.0
2010-07-09 11:30:00	SPY	ETF	107.23	107.44	107.19	107.25	6521433.0
2010-07-09 12:00:00	SPY	ETF	107.23	107.43	107.22	107.37	3471737.0
2010-07-09 12:30:00	SPY	ETF	107.37	107.44	107.18	107.33	5227292.0
2010-07-09 13:00:00	SPY	ETF	107.33	107.46	107.25	107.32	5562228.0
2010-07-09 13:30:00	SPY	ETF	107.31	107.52	107.26	107.48	5739164.0
2010-07-09 14:00:00	SPY	ETF	107.47	107.56	107.3	107.39	6723155.0
2010-07-09 14:30:00	SPY	ETF	107.39	107.86	107.35	107.79	8764899.0
2010-07-09 15:00:00	SPY	ETF	107.79	107.9	107.58	107.62	10367439.0
2010-07-09 15:30:00	SPY	ETF	107.63	107.97	107.56	107.92	21905536.0
2010-07-09 16:00:00	SPY	ETF	107.94	107.99	107.035	107.71	6867225.0
2010-07-09 16:30:00	SPY	ETF	107.69	107.923	107.63	107.7	1431226.0
2010-07-09 17:00:00	SPY	ETF	107.69	107.71	107.61	107.62	114858.0
2010-07-09 17:30:00	SPY	ETF	107.63	107.7	107.62	107.7	29940.0
2010-07-09 18:00:00	SPY	ETF	107.7	107.93	107.61	107.61	30697.0
2010-07-09 18:30:00	SPY	ETF	107.67	107.71	107.65	107.7	5597.0
2010-07-09 19:00:00	SPY	ETF	107.7	107.74	107.66	107.72	12396.0
2010-07-09 19:30:00	SPY	ETF	107.68	107.72	107.6	107.7	20610.0
2010-07-09 05:00:00	QQQ	ETF	44.19	44.19	44.19	44.19	100.0
2010-07-09 05:30:00	QQQ	ETF	44.2	44.2	44.2	44.2	200.0
2010-07-09 06:00:00	QQQ	ETF	44.23	44.23	44.21	44.21	3700.0
2010-07-09 07:00:00	QQQ	ETF	44.24	44.28	44.24	44.25	80866.0
2010-07-09 07:30:00	QQQ	ETF	44.27	44.28	44.21	44.21	8880.0
2010-07-09 08:00:00	QQQ	ETF	44.2	44.26	44.14	44.16	301569.0
2010-07-09 08:30:00	QQQ	ETF	44.14	44.14	44.04	44.11	149700.0
2010-07-09 09:00:00	QQQ	ETF	44.11	44.2	44.1	44.18	208617.0
2010-07-09 09:30:00	QQQ	ETF	44.18	44.36	44.08	44.2604	5948298.0
2010-07-09 10:00:00	QQQ	ETF	44.26	44.43	44.2066	44.34	5297775.0
2010-07-09 10:30:00	QQQ	ETF	44.34	44.48	44.3	44.34	4899306.0
2010-07-09 11:00:00	QQQ	ETF	44.34	44.39	44.26	44.31	2833766.0
2010-07-09 11:30:00	QQQ	ETF	44.31	44.45	44.31	44.3201	2498334.0
2010-07-09 12:00:00	QQQ	ETF	44.33	44.41	44.3	44.39	1351532.0
2010-07-09 12:30:00	QQQ	ETF	44.39	44.4	44.28	44.34	1543105.0
2010-07-09 13:00:00	QQQ	ETF	44.33	44.4	44.29	44.31	2187065.0
2010-07-09 13:30:00	QQQ	ETF	44.3	44.4	44.28	44.38	1812059.0
2010-07-09 14:00:00	QQQ	ETF	44.38	44.4	44.3	44.33	1835270.0

> showing 50 of 7,981 rows — these rows as CSV

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