PREVIEW / etf_30min / 2010-03-01

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-03-01.parquet
  size:    242 KB
  rows:    8,271

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-03-01 04:00:00	SPY	ETF	111.49	111.49	111.46	111.46	1675.0
2010-03-01 04:30:00	SPY	ETF	111.37	111.44	111.33	111.41	4747.0
2010-03-01 05:00:00	SPY	ETF	111.46	111.48	111.36	111.36	30000.0
2010-03-01 05:30:00	SPY	ETF	111.4	111.45	111.29	111.29	5500.0
2010-03-01 06:00:00	SPY	ETF	111.27	111.29	111.21	111.28	13250.0
2010-03-01 06:30:00	SPY	ETF	111.19	111.19	110.93	111.1	151700.0
2010-03-01 07:00:00	SPY	ETF	111.06	111.18	111.01	111.15	144211.0
2010-03-01 07:30:00	SPY	ETF	111.17	111.24	110.91	110.91	773765.0
2010-03-01 08:00:00	SPY	ETF	110.94	111.45	110.93	111.09	2093552.0
2010-03-01 08:30:00	SPY	ETF	111.11	111.2	111.02	111.19	614425.0
2010-03-01 09:00:00	SPY	ETF	111.19	111.24	111.16	111.2	474266.0
2010-03-01 09:30:00	SPY	ETF	111.2	111.57	111.17	111.35	17949930.0
2010-03-01 10:00:00	SPY	ETF	111.34	111.81	111.21	111.505	19982132.0
2010-03-01 10:30:00	SPY	ETF	111.51	111.72	111.36	111.6	13257980.0
2010-03-01 11:00:00	SPY	ETF	111.6	111.92	111.6	111.8	12062895.0
2010-03-01 11:30:00	SPY	ETF	111.8	111.88	111.68	111.81	9403938.0
2010-03-01 12:00:00	SPY	ETF	111.809	111.96	111.73	111.82	7694403.0
2010-03-01 12:30:00	SPY	ETF	111.83	111.88	111.68	111.75	4929914.0
2010-03-01 13:00:00	SPY	ETF	111.74	111.785	111.6182	111.72	6377880.0
2010-03-01 13:30:00	SPY	ETF	111.72	111.905	111.71	111.875	5738959.0
2010-03-01 14:00:00	SPY	ETF	111.87	112.0	111.8	111.89	7143368.0
2010-03-01 14:30:00	SPY	ETF	111.89	111.9	111.75	111.805	6510618.0
2010-03-01 15:00:00	SPY	ETF	111.81	111.9	111.67	111.82	9837244.0
2010-03-01 15:30:00	SPY	ETF	111.83	111.94	111.75	111.895	15504769.0
2010-03-01 16:00:00	SPY	ETF	111.89	111.95	111.82	111.91	5155567.0
2010-03-01 16:30:00	SPY	ETF	111.91	111.95	111.82	111.95	218277.0
2010-03-01 17:00:00	SPY	ETF	111.92	111.96	111.9	111.94	118158.0
2010-03-01 17:30:00	SPY	ETF	111.93	112.01	111.93	111.93	173665.0
2010-03-01 18:00:00	SPY	ETF	111.93	111.96	111.86	111.94	53708.0
2010-03-01 18:30:00	SPY	ETF	111.92	111.95	111.9	111.9	32297.0
2010-03-01 19:00:00	SPY	ETF	111.9	111.93	111.9	111.93	7340.0
2010-03-01 19:30:00	SPY	ETF	111.93	111.96	111.91	111.92	108980.0
2010-03-01 04:00:00	QQQ	ETF	45.05	45.06	45.05	45.06	200.0
2010-03-01 05:30:00	QQQ	ETF	45.0	45.0	45.0	45.0	1800.0
2010-03-01 06:30:00	QQQ	ETF	44.88	44.88	44.88	44.88	2000.0
2010-03-01 07:00:00	QQQ	ETF	44.89	44.96	44.88	44.92	9056.0
2010-03-01 07:30:00	QQQ	ETF	44.95	44.96	44.85	44.85	65656.0
2010-03-01 08:00:00	QQQ	ETF	44.87	44.9	44.76	44.87	2361071.0
2010-03-01 08:30:00	QQQ	ETF	44.9	44.91	44.87	44.9	848395.0
2010-03-01 09:00:00	QQQ	ETF	44.9	44.97	44.9	44.94	672716.0
2010-03-01 09:30:00	QQQ	ETF	44.95	45.13	44.95	45.05	9274532.0
2010-03-01 10:00:00	QQQ	ETF	45.05	45.31	44.99	45.2	7577857.0
2010-03-01 10:30:00	QQQ	ETF	45.2	45.35	45.16	45.315	8329488.0
2010-03-01 11:00:00	QQQ	ETF	45.3105	45.42	45.31	45.35	4332076.0
2010-03-01 11:30:00	QQQ	ETF	45.35	45.39	45.32	45.37	5767615.0
2010-03-01 12:00:00	QQQ	ETF	45.37	45.45	45.36	45.4	3403350.0
2010-03-01 12:30:00	QQQ	ETF	45.39	45.42	45.34	45.37	1820648.0
2010-03-01 13:00:00	QQQ	ETF	45.37	45.39	45.34	45.38	2050919.0
2010-03-01 13:30:00	QQQ	ETF	45.38	45.45	45.37	45.43	2181859.0
2010-03-01 14:00:00	QQQ	ETF	45.43	45.49	45.4	45.45	2770042.0

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

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