PREVIEW / etf_30min / 2010-09-09

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-09-09.parquet
  size:    252 KB
  rows:    8,293

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-09-09 04:00:00	SPY	ETF	110.41	110.54	110.37	110.54	1563.0
2010-09-09 04:30:00	SPY	ETF	110.71	110.75	110.71	110.75	500.0
2010-09-09 05:00:00	SPY	ETF	110.75	110.78	110.74	110.74	10500.0
2010-09-09 05:30:00	SPY	ETF	110.8	110.86	110.8	110.85	1500.0
2010-09-09 06:00:00	SPY	ETF	110.85	110.9	110.82	110.82	3770.0
2010-09-09 06:30:00	SPY	ETF	110.82	110.89	110.82	110.89	5800.0
2010-09-09 07:00:00	SPY	ETF	110.88	110.94	110.88	110.9	44984.0
2010-09-09 07:30:00	SPY	ETF	110.89	110.93	110.76	110.78	97165.0
2010-09-09 08:00:00	SPY	ETF	110.78	110.95	110.65	110.86	1244394.0
2010-09-09 08:30:00	SPY	ETF	110.98	111.42	110.69	111.26	2634002.0
2010-09-09 09:00:00	SPY	ETF	111.27	111.73	111.27	111.65	2518286.0
2010-09-09 09:30:00	SPY	ETF	111.65	111.68	111.23	111.47	26025052.0
2010-09-09 10:00:00	SPY	ETF	111.47	111.5	111.13	111.31	10486288.0
2010-09-09 10:30:00	SPY	ETF	111.3	111.31	111.07	111.07	6806618.0
2010-09-09 11:00:00	SPY	ETF	111.08	111.43	111.04	111.42	5922433.0
2010-09-09 11:30:00	SPY	ETF	111.41	111.47	111.29	111.319	4574473.0
2010-09-09 12:00:00	SPY	ETF	111.31	111.4	111.29	111.37	3984825.0
2010-09-09 12:30:00	SPY	ETF	111.36	111.4	110.95	110.96	6132928.0
2010-09-09 13:00:00	SPY	ETF	110.96	111.06	110.73	110.73	11225644.0
2010-09-09 13:30:00	SPY	ETF	110.73	110.98	110.62	110.7201	9777347.0
2010-09-09 14:00:00	SPY	ETF	110.72	110.87	110.635	110.7242	7484519.0
2010-09-09 14:30:00	SPY	ETF	110.7239	111.03	110.71	111.0	6294249.0
2010-09-09 15:00:00	SPY	ETF	111.0	111.46	110.97	111.13	10396877.0
2010-09-09 15:30:00	SPY	ETF	111.13	111.26	110.89	110.93	18338516.0
2010-09-09 16:00:00	SPY	ETF	110.93	111.55	110.725	110.83	7364483.0
2010-09-09 16:30:00	SPY	ETF	110.83	110.91	110.74	110.74	1345113.0
2010-09-09 17:00:00	SPY	ETF	110.75	110.88	110.63	110.75	558392.0
2010-09-09 17:30:00	SPY	ETF	110.8	110.82	110.75	110.79	1138496.0
2010-09-09 18:00:00	SPY	ETF	110.78	110.94	110.71	110.77	549208.0
2010-09-09 18:30:00	SPY	ETF	110.78	110.8	110.77	110.79	7409.0
2010-09-09 19:00:00	SPY	ETF	110.8	110.82	110.75	110.75	3832.0
2010-09-09 19:30:00	SPY	ETF	110.76	110.84	110.75	110.79	22725.0
2010-09-09 04:30:00	QQQ	ETF	46.28	46.28	46.28	46.28	3800.0
2010-09-09 06:00:00	QQQ	ETF	46.37	46.37	46.37	46.37	200.0
2010-09-09 07:00:00	QQQ	ETF	46.4	46.4	46.37	46.39	36900.0
2010-09-09 07:30:00	QQQ	ETF	46.39	46.41	46.35	46.35	9952.0
2010-09-09 08:00:00	QQQ	ETF	46.33	46.37	46.31	46.31	621082.0
2010-09-09 08:30:00	QQQ	ETF	46.34	46.58	46.2	46.54	1231379.0
2010-09-09 09:00:00	QQQ	ETF	46.54	46.67	46.53	46.65	714359.0
2010-09-09 09:30:00	QQQ	ETF	46.66	46.7	46.51	46.58	8607066.0
2010-09-09 10:00:00	QQQ	ETF	46.58	46.65	46.52	46.59	6348166.0
2010-09-09 10:30:00	QQQ	ETF	46.6	46.6	46.44	46.44	3575937.0
2010-09-09 11:00:00	QQQ	ETF	46.44	46.63	46.44	46.6295	1423977.0
2010-09-09 11:30:00	QQQ	ETF	46.6201	46.67	46.58	46.62	2204379.0
2010-09-09 12:00:00	QQQ	ETF	46.62	46.66	46.6	46.64	1682482.0
2010-09-09 12:30:00	QQQ	ETF	46.64	46.68	46.53	46.53	2601570.0
2010-09-09 13:00:00	QQQ	ETF	46.53	46.5775	46.42	46.4299	4016945.0
2010-09-09 13:30:00	QQQ	ETF	46.4299	46.52	46.36	46.4	4236755.0
2010-09-09 14:00:00	QQQ	ETF	46.4	46.45	46.32	46.37	2153339.0
2010-09-09 14:30:00	QQQ	ETF	46.37	46.51	46.37	46.5	1814814.0

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

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