PREVIEW / etf_30min / 2010-07-26

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-07-26.parquet
  size:    252 KB
  rows:    8,380

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-26 04:00:00	SPY	ETF	110.41	110.41	110.27	110.27	3800.0
2010-07-26 04:30:00	SPY	ETF	110.26	110.41	110.25	110.41	1000.0
2010-07-26 05:00:00	SPY	ETF	110.46	110.46	110.38	110.4	5070.0
2010-07-26 05:30:00	SPY	ETF	110.45	110.45	110.36	110.36	1400.0
2010-07-26 06:00:00	SPY	ETF	110.46	110.46	110.35	110.35	1700.0
2010-07-26 06:30:00	SPY	ETF	110.46	110.58	110.45	110.58	3500.0
2010-07-26 07:00:00	SPY	ETF	110.53	110.53	110.31	110.31	216955.0
2010-07-26 07:30:00	SPY	ETF	110.33	110.41	110.24	110.36	301594.0
2010-07-26 08:00:00	SPY	ETF	110.41	110.58	110.25	110.31	2424073.0
2010-07-26 08:30:00	SPY	ETF	110.31	110.5	110.31	110.49	546427.0
2010-07-26 09:00:00	SPY	ETF	110.49	110.79	110.48	110.59	3089248.0
2010-07-26 09:30:00	SPY	ETF	110.6	110.69	110.29	110.63	16991533.0
2010-07-26 10:00:00	SPY	ETF	110.63	111.2583	110.63	111.06	23477961.0
2010-07-26 10:30:00	SPY	ETF	111.06	111.12	110.81	111.1	12766544.0
2010-07-26 11:00:00	SPY	ETF	111.1	111.37	110.96	111.35	15767814.0
2010-07-26 11:30:00	SPY	ETF	111.35	111.47	111.28	111.34	10386050.0
2010-07-26 12:00:00	SPY	ETF	111.35	111.47	110.6	111.43	7113964.0
2010-07-26 12:30:00	SPY	ETF	111.42	111.44	111.19	111.33	6412675.0
2010-07-26 13:00:00	SPY	ETF	111.325	111.36	111.2	111.33	5170992.0
2010-07-26 13:30:00	SPY	ETF	111.33	111.44	111.24	111.37	6350797.0
2010-07-26 14:00:00	SPY	ETF	111.37	111.37	111.12	111.12	5327336.0
2010-07-26 14:30:00	SPY	ETF	111.12	111.35	110.95	111.09	8974936.0
2010-07-26 15:00:00	SPY	ETF	111.09	111.5	111.0	111.41	11083529.0
2010-07-26 15:30:00	SPY	ETF	111.42	111.67	111.32	111.58	22200030.0
2010-07-26 16:00:00	SPY	ETF	111.59	111.61	110.4291	111.46	11454566.0
2010-07-26 16:30:00	SPY	ETF	111.46	111.48	111.41	111.46	159349.0
2010-07-26 17:00:00	SPY	ETF	111.45	111.5	110.4291	111.46	5051975.0
2010-07-26 17:30:00	SPY	ETF	111.45	111.5	111.34	111.45	52162.0
2010-07-26 18:00:00	SPY	ETF	111.45	111.57	111.35	111.37	77053.0
2010-07-26 18:30:00	SPY	ETF	111.35	111.39	111.34	111.39	28619.0
2010-07-26 19:00:00	SPY	ETF	111.37	111.4	111.36	111.36	23017.0
2010-07-26 19:30:00	SPY	ETF	111.36	111.43	111.33	111.36	23627.0
2010-07-26 04:00:00	QQQ	ETF	46.06	46.06	46.03	46.03	1700.0
2010-07-26 05:30:00	QQQ	ETF	46.05	46.05	46.05	46.05	150.0
2010-07-26 06:00:00	QQQ	ETF	46.12	46.12	46.12	46.12	200.0
2010-07-26 06:30:00	QQQ	ETF	46.1	46.1	46.1	46.1	1600.0
2010-07-26 07:00:00	QQQ	ETF	46.13	46.13	46.01	46.02	350016.0
2010-07-26 07:30:00	QQQ	ETF	46.02	46.05	45.99	46.03	550717.0
2010-07-26 08:00:00	QQQ	ETF	46.03	46.08	45.99	46.02	2361016.0
2010-07-26 08:30:00	QQQ	ETF	46.03	46.08	46.0	46.08	220452.0
2010-07-26 09:00:00	QQQ	ETF	46.08	46.22	46.08	46.13	1517602.0
2010-07-26 09:30:00	QQQ	ETF	46.13	46.15	45.91	46.07	7221331.0
2010-07-26 10:00:00	QQQ	ETF	46.06	46.29	46.06	46.14	6728340.0
2010-07-26 10:30:00	QQQ	ETF	46.15	46.24	46.05	46.24	3797876.0
2010-07-26 11:00:00	QQQ	ETF	46.24	46.35	46.2	46.3162	3643679.0
2010-07-26 11:30:00	QQQ	ETF	46.32	46.41	46.29	46.33	4325618.0
2010-07-26 12:00:00	QQQ	ETF	46.33	46.35	46.25	46.31	6120704.0
2010-07-26 12:30:00	QQQ	ETF	46.32	46.34	46.18	46.2501	7387663.0
2010-07-26 13:00:00	QQQ	ETF	46.26	46.28	46.19	46.26	2089356.0
2010-07-26 13:30:00	QQQ	ETF	46.26	46.32	46.215	46.28	1862753.0

> showing 50 of 8,380 rows — these rows as CSV

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