PREVIEW / etf_30min / 2010-03-18

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-03-18.parquet
  size:    241 KB
  rows:    8,107

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-18 04:00:00	SPY	ETF	116.76	116.76	116.74	116.74	1800.0
2010-03-18 04:30:00	SPY	ETF	116.87	116.88	116.87	116.88	200.0
2010-03-18 05:00:00	SPY	ETF	116.76	116.76	116.76	116.76	100.0
2010-03-18 05:30:00	SPY	ETF	116.8	116.9	116.8	116.9	4000.0
2010-03-18 06:00:00	SPY	ETF	116.9	116.9	116.82	116.87	13200.0
2010-03-18 06:30:00	SPY	ETF	116.87	116.95	116.87	116.93	14500.0
2010-03-18 07:00:00	SPY	ETF	116.93	116.95	116.89	116.93	43082.0
2010-03-18 07:30:00	SPY	ETF	116.96	116.98	116.89	116.95	217597.0
2010-03-18 08:00:00	SPY	ETF	116.96	117.06	116.9	117.05	627528.0
2010-03-18 08:30:00	SPY	ETF	117.03	117.18	116.95	117.04	1115195.0
2010-03-18 09:00:00	SPY	ETF	117.05	117.13	116.99	117.1	823011.0
2010-03-18 09:30:00	SPY	ETF	117.11	117.2	116.97	117.13	16807989.0
2010-03-18 10:00:00	SPY	ETF	117.13	117.27	116.97	116.99	14901735.0
2010-03-18 10:30:00	SPY	ETF	116.99	117.08	116.82	117.0501	13241986.0
2010-03-18 11:00:00	SPY	ETF	117.06	117.1706	117.0	117.0684	11825031.0
2010-03-18 11:30:00	SPY	ETF	117.06	117.1	116.71	116.76	14905789.0
2010-03-18 12:00:00	SPY	ETF	116.765	116.78	116.58	116.75	11513157.0
2010-03-18 12:30:00	SPY	ETF	116.74	116.75	116.57	116.7	12075335.0
2010-03-18 13:00:00	SPY	ETF	116.71	116.93	116.7	116.87	8885394.0
2010-03-18 13:30:00	SPY	ETF	116.87	116.99	116.8	116.9	5795923.0
2010-03-18 14:00:00	SPY	ETF	116.9	116.965	116.83	116.92	5865459.0
2010-03-18 14:30:00	SPY	ETF	116.92	117.08	116.78	116.9	19242322.0
2010-03-18 15:00:00	SPY	ETF	116.9	117.03	116.83	116.995	9915690.0
2010-03-18 15:30:00	SPY	ETF	116.9901	117.13	116.95	117.03	22306368.0
2010-03-18 16:00:00	SPY	ETF	117.03	117.14	116.61	117.09	14258360.0
2010-03-18 16:30:00	SPY	ETF	117.09	117.13	117.022	117.11	516148.0
2010-03-18 17:00:00	SPY	ETF	117.1	117.13	117.07	117.09	7190987.0
2010-03-18 17:30:00	SPY	ETF	117.08	117.08	117.05	117.05	22468.0
2010-03-18 18:00:00	SPY	ETF	117.06	117.11	117.05	117.07	46938.0
2010-03-18 18:30:00	SPY	ETF	117.06	117.1	117.06	117.06	7300.0
2010-03-18 19:00:00	SPY	ETF	117.06	117.12	117.03	117.04	55978.0
2010-03-18 19:30:00	SPY	ETF	117.04	117.05	117.0	117.0	99605.0
2010-03-18 04:00:00	QQQ	ETF	47.56	47.56	47.56	47.56	1000.0
2010-03-18 06:00:00	QQQ	ETF	47.6	47.62	47.59	47.62	1800.0
2010-03-18 06:30:00	QQQ	ETF	47.64	47.65	47.64	47.65	4105.0
2010-03-18 07:00:00	QQQ	ETF	47.64	47.64	47.64	47.64	16200.0
2010-03-18 07:30:00	QQQ	ETF	47.64	47.66	47.64	47.66	5000.0
2010-03-18 08:00:00	QQQ	ETF	47.65	47.68	47.55	47.67	227625.0
2010-03-18 08:30:00	QQQ	ETF	47.67	47.74	47.65	47.69	217958.0
2010-03-18 09:00:00	QQQ	ETF	47.69	47.72	47.45	47.72	144099.0
2010-03-18 09:30:00	QQQ	ETF	47.72	47.76	47.65	47.71	8402894.0
2010-03-18 10:00:00	QQQ	ETF	47.7	47.77	47.64	47.67	5167682.0
2010-03-18 10:30:00	QQQ	ETF	47.67	47.76	47.62	47.75	3591955.0
2010-03-18 11:00:00	QQQ	ETF	47.75	47.83	47.6319	47.7781	6646191.0
2010-03-18 11:30:00	QQQ	ETF	47.78	47.79	47.67	47.69	4201610.0
2010-03-18 12:00:00	QQQ	ETF	47.69	47.705	47.6	47.7	4130408.0
2010-03-18 12:30:00	QQQ	ETF	47.7	47.725	47.66	47.715	1604617.0
2010-03-18 13:00:00	QQQ	ETF	47.72	47.79	47.71	47.76	4173347.0
2010-03-18 13:30:00	QQQ	ETF	47.76	47.82	47.75	47.7899	3362321.0
2010-03-18 14:00:00	QQQ	ETF	47.78	47.8	47.75	47.79	2723703.0

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

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