PREVIEW / etf_30min / 2010-03-22

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-03-22.parquet
  size:    253 KB
  rows:    8,385

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-22 04:00:00	SPY	ETF	115.41	115.53	115.31	115.31	14724.0
2010-03-22 04:30:00	SPY	ETF	115.4	115.52	115.4	115.49	3600.0
2010-03-22 05:00:00	SPY	ETF	115.41	115.41	115.41	115.41	3200.0
2010-03-22 05:30:00	SPY	ETF	115.41	115.41	115.2	115.2	37156.0
2010-03-22 06:00:00	SPY	ETF	115.24	115.29	115.19	115.29	2400.0
2010-03-22 06:30:00	SPY	ETF	115.3	115.32	115.21	115.31	11937.0
2010-03-22 07:00:00	SPY	ETF	115.36	115.39	115.31	115.36	101670.0
2010-03-22 07:30:00	SPY	ETF	115.35	115.39	115.21	115.25	770886.0
2010-03-22 08:00:00	SPY	ETF	115.26	116.1	115.24	115.45	764989.0
2010-03-22 08:30:00	SPY	ETF	115.43	115.6	115.28	115.28	1466878.0
2010-03-22 09:00:00	SPY	ETF	115.29	115.39	115.27	115.3	1583603.0
2010-03-22 09:30:00	SPY	ETF	115.31	116.02	115.24	115.91	26279619.0
2010-03-22 10:00:00	SPY	ETF	115.9001	116.39	115.83	116.31	21463643.0
2010-03-22 10:30:00	SPY	ETF	116.31	116.48	116.24	116.3301	16399642.0
2010-03-22 11:00:00	SPY	ETF	116.34	116.49	116.33	116.34	10401672.0
2010-03-22 11:30:00	SPY	ETF	116.34	116.41	116.23	116.39	10578868.0
2010-03-22 12:00:00	SPY	ETF	116.4	116.42	116.24	116.39	9470331.0
2010-03-22 12:30:00	SPY	ETF	116.4	116.52	116.33	116.46	8420627.0
2010-03-22 13:00:00	SPY	ETF	116.46	116.72	116.35	116.5739	9523399.0
2010-03-22 13:30:00	SPY	ETF	116.58	116.64	116.53	116.541	4619245.0
2010-03-22 14:00:00	SPY	ETF	116.535	116.58	116.42	116.55	8735079.0
2010-03-22 14:30:00	SPY	ETF	116.54	116.79	116.54	116.68	10370538.0
2010-03-22 15:00:00	SPY	ETF	116.68	116.8	116.58	116.68	10340447.0
2010-03-22 15:30:00	SPY	ETF	116.68	116.75	116.52	116.58	19781382.0
2010-03-22 16:00:00	SPY	ETF	116.57	116.66	115.843	116.63	9656425.0
2010-03-22 16:30:00	SPY	ETF	116.63	116.77	115.9854	116.71	1611400.0
2010-03-22 17:00:00	SPY	ETF	116.72	116.76	116.7	116.7	31738.0
2010-03-22 17:30:00	SPY	ETF	116.7	116.74	116.68	116.69	20870.0
2010-03-22 18:00:00	SPY	ETF	116.7	116.86	116.59	116.8	130824.0
2010-03-22 18:30:00	SPY	ETF	116.8	116.8	116.77	116.8	14906.0
2010-03-22 19:00:00	SPY	ETF	116.8	116.8	116.77	116.78	15142.0
2010-03-22 19:30:00	SPY	ETF	116.78	116.8	116.75	116.78	236695.0
2010-03-22 04:00:00	QQQ	ETF	47.33	47.33	47.31	47.31	700.0
2010-03-22 04:30:00	QQQ	ETF	47.37	47.38	47.37	47.38	1400.0
2010-03-22 05:30:00	QQQ	ETF	47.28	47.28	47.28	47.28	200.0
2010-03-22 06:00:00	QQQ	ETF	47.29	47.29	47.29	47.29	400.0
2010-03-22 06:30:00	QQQ	ETF	47.26	47.26	47.26	47.26	500.0
2010-03-22 07:00:00	QQQ	ETF	47.34	47.34	47.29	47.29	7310.0
2010-03-22 07:30:00	QQQ	ETF	47.3	47.32	47.26	47.29	30804.0
2010-03-22 08:00:00	QQQ	ETF	47.28	47.34	47.26	47.34	246866.0
2010-03-22 08:30:00	QQQ	ETF	47.33	47.36	47.29	47.29	107206.0
2010-03-22 09:00:00	QQQ	ETF	47.29	47.35	47.28	47.31	818008.0
2010-03-22 09:30:00	QQQ	ETF	47.31	47.77	47.25	47.7001	13987243.0
2010-03-22 10:00:00	QQQ	ETF	47.7001	47.85	47.63	47.82	7478995.0
2010-03-22 10:30:00	QQQ	ETF	47.83	47.88	47.78	47.8285	3945980.0
2010-03-22 11:00:00	QQQ	ETF	47.82	47.9	47.81	47.83	3141462.0
2010-03-22 11:30:00	QQQ	ETF	47.83	47.88	47.8	47.88	3340333.0
2010-03-22 12:00:00	QQQ	ETF	47.8701	47.88	47.78	47.84	3226759.0
2010-03-22 12:30:00	QQQ	ETF	47.85	47.93	47.84	47.9201	2828055.0
2010-03-22 13:00:00	QQQ	ETF	47.93	48.02	47.7743	47.95	5200123.0

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

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