PREVIEW / etf_30min / 2010-11-05

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-11-05.parquet
  size:    271 KB
  rows:    9,172

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-11-05 04:00:00	SPY	ETF	122.24	122.34	122.22	122.27	1800.0
2010-11-05 04:30:00	SPY	ETF	122.21	122.21	122.02	122.02	800.0
2010-11-05 05:00:00	SPY	ETF	122.09	122.09	122.09	122.09	2000.0
2010-11-05 05:30:00	SPY	ETF	122.13	122.13	122.01	122.03	5700.0
2010-11-05 06:00:00	SPY	ETF	122.02	122.02	121.9	121.99	14400.0
2010-11-05 06:30:00	SPY	ETF	121.99	122.03	121.74	121.76	77870.0
2010-11-05 07:00:00	SPY	ETF	121.75	121.97	121.75	121.97	806765.0
2010-11-05 07:30:00	SPY	ETF	121.91	122.05	121.91	121.99	102530.0
2010-11-05 08:00:00	SPY	ETF	121.99	122.18	121.91	122.0	1127342.0
2010-11-05 08:30:00	SPY	ETF	122.25	122.7	122.16	122.39	5902190.0
2010-11-05 09:00:00	SPY	ETF	122.38	122.5	122.28	122.34	1639378.0
2010-11-05 09:30:00	SPY	ETF	122.34	122.605	122.18	122.45	23092915.0
2010-11-05 10:00:00	SPY	ETF	122.45	122.74	122.33	122.72	14230912.0
2010-11-05 10:30:00	SPY	ETF	122.71	122.92	122.6801	122.8	13504298.0
2010-11-05 11:00:00	SPY	ETF	122.79	122.86	122.68	122.729	10022217.0
2010-11-05 11:30:00	SPY	ETF	122.725	122.77	122.27	122.29	14716487.0
2010-11-05 12:00:00	SPY	ETF	122.29	122.46	122.21	122.35	11325851.0
2010-11-05 12:30:00	SPY	ETF	122.34	122.55	122.26	122.49	8133008.0
2010-11-05 13:00:00	SPY	ETF	122.49	122.64	122.48	122.59	5060346.0
2010-11-05 13:30:00	SPY	ETF	122.59	122.59	122.49	122.57	5708480.0
2010-11-05 14:00:00	SPY	ETF	122.57	122.58	122.2	122.28	9476523.0
2010-11-05 14:30:00	SPY	ETF	122.29	122.44	122.27	122.34	7695770.0
2010-11-05 15:00:00	SPY	ETF	122.35	122.43	122.24	122.418	9489763.0
2010-11-05 15:30:00	SPY	ETF	122.415	122.81	122.28	122.74	27555270.0
2010-11-05 16:00:00	SPY	ETF	122.74	122.82	122.4	122.71	7755067.0
2010-11-05 16:30:00	SPY	ETF	122.72	122.85	122.7	122.84	2675568.0
2010-11-05 17:00:00	SPY	ETF	122.84	122.85	122.7	122.72	200608.0
2010-11-05 17:30:00	SPY	ETF	122.72	122.74	122.7	122.71	102323.0
2010-11-05 18:00:00	SPY	ETF	122.72	122.76	122.72	122.75	13327.0
2010-11-05 18:30:00	SPY	ETF	122.77	122.8	122.71	122.77	34984.0
2010-11-05 19:00:00	SPY	ETF	122.78	122.79	122.78	122.78	500.0
2010-11-05 19:30:00	SPY	ETF	122.79	122.85	122.73	122.85	14043.0
2010-11-05 04:00:00	QQQ	ETF	53.71	53.71	53.69	53.69	4654.0
2010-11-05 04:30:00	QQQ	ETF	53.62	53.62	53.59	53.6	1300.0
2010-11-05 05:30:00	QQQ	ETF	53.62	53.62	53.62	53.62	2000.0
2010-11-05 06:00:00	QQQ	ETF	53.6	53.6	53.56	53.59	4700.0
2010-11-05 06:30:00	QQQ	ETF	53.53	53.55	53.53	53.55	4971.0
2010-11-05 07:00:00	QQQ	ETF	53.55	53.61	53.54	53.6	31685.0
2010-11-05 07:30:00	QQQ	ETF	53.6	53.65	53.6	53.63	8683.0
2010-11-05 08:00:00	QQQ	ETF	53.63	53.67	53.53	53.53	837058.0
2010-11-05 08:30:00	QQQ	ETF	53.7	53.86	53.62	53.67	2118084.0
2010-11-05 09:00:00	QQQ	ETF	53.67	53.7	53.65	53.69	350831.0
2010-11-05 09:30:00	QQQ	ETF	53.7	53.77	53.56	53.66	15325839.0
2010-11-05 10:00:00	QQQ	ETF	53.66	53.72	53.61	53.68	5365260.0
2010-11-05 10:30:00	QQQ	ETF	53.67	53.81	53.66	53.72	4377520.0
2010-11-05 11:00:00	QQQ	ETF	53.72	53.74	53.63	53.672	2912822.0
2010-11-05 11:30:00	QQQ	ETF	53.6799	53.72	53.54	53.545	4049739.0
2010-11-05 12:00:00	QQQ	ETF	53.54	53.61	53.52	53.56	2663141.0
2010-11-05 12:30:00	QQQ	ETF	53.56	53.68	53.53	53.655	2375649.0
2010-11-05 13:00:00	QQQ	ETF	53.66	53.73	53.6501	53.7181	2300146.0

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

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