PREVIEW / etf_30min / 2010-09-28

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-09-28.parquet
  size:    264 KB
  rows:    8,688

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-28 04:00:00	SPY	ETF	114.17	114.17	113.72	113.82	7840.0
2010-09-28 04:30:00	SPY	ETF	113.82	113.82	113.82	113.82	100.0
2010-09-28 05:00:00	SPY	ETF	113.73	113.87	113.69	113.87	3700.0
2010-09-28 05:30:00	SPY	ETF	113.97	114.6	113.97	114.55	24667.0
2010-09-28 06:00:00	SPY	ETF	114.63	114.65	114.37	114.4	16400.0
2010-09-28 06:30:00	SPY	ETF	114.43	114.43	114.25	114.28	27600.0
2010-09-28 07:00:00	SPY	ETF	114.3	114.4	114.28	114.37	57560.0
2010-09-28 07:30:00	SPY	ETF	114.33	114.34	114.19	114.24	163825.0
2010-09-28 08:00:00	SPY	ETF	114.24	114.5	114.23	114.41	387679.0
2010-09-28 08:30:00	SPY	ETF	114.4	114.58	114.38	114.43	698670.0
2010-09-28 09:00:00	SPY	ETF	114.45	114.63	114.41	114.43	1224731.0
2010-09-28 09:30:00	SPY	ETF	114.42	114.44	113.6	113.76	28076048.0
2010-09-28 10:00:00	SPY	ETF	113.73	113.9	113.18	113.77	27170267.0
2010-09-28 10:30:00	SPY	ETF	113.77	114.07	113.75	114.04	15501828.0
2010-09-28 11:00:00	SPY	ETF	114.04	114.52	113.93	114.41	15192058.0
2010-09-28 11:30:00	SPY	ETF	114.4185	114.62	114.3	114.36	13237127.0
2010-09-28 12:00:00	SPY	ETF	114.36	114.56	114.21	114.41	8575055.0
2010-09-28 12:30:00	SPY	ETF	114.42	114.5	114.33	114.485	4092900.0
2010-09-28 13:00:00	SPY	ETF	114.48	114.54	114.21	114.395	6113339.0
2010-09-28 13:30:00	SPY	ETF	114.4	114.81	114.4	114.78	8701020.0
2010-09-28 14:00:00	SPY	ETF	114.78	114.79	114.36	114.36	9003608.0
2010-09-28 14:30:00	SPY	ETF	114.36	114.45	114.1	114.225	11331841.0
2010-09-28 15:00:00	SPY	ETF	114.22	114.56	114.15	114.41	13798610.0
2010-09-28 15:30:00	SPY	ETF	114.41	115.04	114.4	114.72	29695319.0
2010-09-28 16:00:00	SPY	ETF	114.69	114.9992	114.2164	114.65	10098121.0
2010-09-28 16:30:00	SPY	ETF	114.65	114.75	114.64	114.67	2005036.0
2010-09-28 17:00:00	SPY	ETF	114.69	114.73	114.68	114.7	61868.0
2010-09-28 17:30:00	SPY	ETF	114.71	114.78	114.66	114.68	980800.0
2010-09-28 18:00:00	SPY	ETF	114.68	114.73	114.67	114.7	88782.0
2010-09-28 18:30:00	SPY	ETF	114.67	114.7	114.62	114.7	12980.0
2010-09-28 19:00:00	SPY	ETF	114.69	114.69	114.65	114.69	3380.0
2010-09-28 19:30:00	SPY	ETF	114.68	114.71	114.63	114.66	22180.0
2010-09-28 04:00:00	QQQ	ETF	49.28	49.3	49.25	49.3	500.0
2010-09-28 04:30:00	QQQ	ETF	49.27	49.29	49.27	49.29	2200.0
2010-09-28 05:00:00	QQQ	ETF	49.24	49.24	49.24	49.24	100.0
2010-09-28 05:30:00	QQQ	ETF	49.38	49.62	49.38	49.62	1500.0
2010-09-28 06:00:00	QQQ	ETF	49.56	49.57	49.54	49.54	1300.0
2010-09-28 06:30:00	QQQ	ETF	49.53	49.53	49.45	49.51	3350.0
2010-09-28 07:00:00	QQQ	ETF	49.48	49.52	49.48	49.51	5700.0
2010-09-28 07:30:00	QQQ	ETF	49.48	49.48	49.43	49.46	19118.0
2010-09-28 08:00:00	QQQ	ETF	49.47	49.55	49.47	49.52	165675.0
2010-09-28 08:30:00	QQQ	ETF	49.52	49.61	49.51	49.53	328907.0
2010-09-28 09:00:00	QQQ	ETF	49.54	49.62	49.49	49.5	730175.0
2010-09-28 09:30:00	QQQ	ETF	49.51	49.52	48.89	48.93	23253688.0
2010-09-28 10:00:00	QQQ	ETF	48.93	49.01	48.59	48.94	11157763.0
2010-09-28 10:30:00	QQQ	ETF	48.94	49.25	48.92	49.23	7280418.0
2010-09-28 11:00:00	QQQ	ETF	49.2281	49.4001	49.12	49.36	4759265.0
2010-09-28 11:30:00	QQQ	ETF	49.37	49.45	49.24	49.28	4355996.0
2010-09-28 12:00:00	QQQ	ETF	49.285	49.37	49.11	49.25	6102801.0
2010-09-28 12:30:00	QQQ	ETF	49.26	49.36	49.22	49.3425	2379869.0

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

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