PREVIEW / etf_30min / 2010-03-09

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-03-09.parquet
  size:    248 KB
  rows:    8,307

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-09 04:00:00	SPY	ETF	113.82	113.93	113.82	113.86	3700.0
2010-03-09 04:30:00	SPY	ETF	113.87	113.87	113.79	113.79	900.0
2010-03-09 05:00:00	SPY	ETF	113.86	113.86	113.86	113.86	100.0
2010-03-09 05:30:00	SPY	ETF	113.84	113.84	113.74	113.74	8700.0
2010-03-09 06:00:00	SPY	ETF	113.75	113.8	113.7	113.77	20500.0
2010-03-09 06:30:00	SPY	ETF	113.71	113.76	113.64	113.7	62900.0
2010-03-09 07:00:00	SPY	ETF	113.71	113.76	113.67	113.7	80336.0
2010-03-09 07:30:00	SPY	ETF	113.68	113.92	113.68	113.83	226395.0
2010-03-09 08:00:00	SPY	ETF	113.83	113.89	113.65	113.76	804612.0
2010-03-09 08:30:00	SPY	ETF	113.77	113.87	113.7	113.85	624890.0
2010-03-09 09:00:00	SPY	ETF	113.84	114.29	113.77	113.91	536085.0
2010-03-09 09:30:00	SPY	ETF	113.93	114.23	113.87	114.1983	14142249.0
2010-03-09 10:00:00	SPY	ETF	114.2	114.41	114.08	114.3	12394134.0
2010-03-09 10:30:00	SPY	ETF	114.2999	114.6	114.28	114.54	12026746.0
2010-03-09 11:00:00	SPY	ETF	114.54	114.5499	114.3	114.4974	9136850.0
2010-03-09 11:30:00	SPY	ETF	114.49	114.7	114.43	114.67	8693344.0
2010-03-09 12:00:00	SPY	ETF	114.66	114.86	114.59	114.8317	6799151.0
2010-03-09 12:30:00	SPY	ETF	114.83	114.93	114.72	114.92	4914358.0
2010-03-09 13:00:00	SPY	ETF	114.92	114.95	114.84	114.91	5525550.0
2010-03-09 13:30:00	SPY	ETF	114.92	114.99	114.75	114.8	7637007.0
2010-03-09 14:00:00	SPY	ETF	114.8099	114.95	114.79	114.92	4267182.0
2010-03-09 14:30:00	SPY	ETF	114.92	114.95	114.51	114.57	13916488.0
2010-03-09 15:00:00	SPY	ETF	114.5699	114.64	114.08	114.26	21661463.0
2010-03-09 15:30:00	SPY	ETF	114.27	114.55	114.23	114.45	20083530.0
2010-03-09 16:00:00	SPY	ETF	114.44	114.84	114.07	114.5	9296092.0
2010-03-09 16:30:00	SPY	ETF	114.49	114.51	114.47	114.51	872157.0
2010-03-09 17:00:00	SPY	ETF	114.51	114.51	114.41	114.45	316435.0
2010-03-09 17:30:00	SPY	ETF	114.45	114.5	114.44	114.49	102156.0
2010-03-09 18:00:00	SPY	ETF	114.48	114.53	114.44	114.49	75569.0
2010-03-09 18:30:00	SPY	ETF	114.48	114.49	114.44	114.44	4929.0
2010-03-09 19:00:00	SPY	ETF	114.45	114.45	114.37	114.39	37197.0
2010-03-09 19:30:00	SPY	ETF	114.39	114.44	114.38	114.44	62211.0
2010-03-09 05:00:00	QQQ	ETF	46.41	46.41	46.41	46.41	100.0
2010-03-09 06:00:00	QQQ	ETF	46.33	46.33	46.33	46.33	5000.0
2010-03-09 06:30:00	QQQ	ETF	46.33	46.33	46.32	46.32	400.0
2010-03-09 07:00:00	QQQ	ETF	46.35	46.35	46.33	46.33	7765.0
2010-03-09 07:30:00	QQQ	ETF	46.36	46.39	46.36	46.38	13700.0
2010-03-09 08:00:00	QQQ	ETF	46.38	46.4	46.32	46.37	190998.0
2010-03-09 08:30:00	QQQ	ETF	46.37	46.39	46.35	46.38	77852.0
2010-03-09 09:00:00	QQQ	ETF	46.38	46.41	46.36	46.4	714792.0
2010-03-09 09:30:00	QQQ	ETF	46.4	46.63	46.4	46.61	9493034.0
2010-03-09 10:00:00	QQQ	ETF	46.61	46.72	46.57	46.69	7084406.0
2010-03-09 10:30:00	QQQ	ETF	46.7	46.92	46.69	46.89	7779509.0
2010-03-09 11:00:00	QQQ	ETF	46.885	46.885	46.73	46.865	6840988.0
2010-03-09 11:30:00	QQQ	ETF	46.86	46.92	46.8	46.889	5256866.0
2010-03-09 12:00:00	QQQ	ETF	46.88	46.99	46.84	46.98	3432226.0
2010-03-09 12:30:00	QQQ	ETF	46.98	47.03	46.93	47.02	3103888.0
2010-03-09 13:00:00	QQQ	ETF	47.025	47.05	46.97	47.015	2786564.0
2010-03-09 13:30:00	QQQ	ETF	47.015	47.05	46.925	46.9817	7084661.0
2010-03-09 14:00:00	QQQ	ETF	46.9801	47.03	46.96	47.02	2093680.0

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

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